Разработка и исследование системы автоматизации процесса "Подготовка к новому учебному году"

<wsdl:input wsaw:Action="http://tempuri.org/IDataService/GetRup" message="tns:IDataService_GetRup_InputMessage"/>

<wsdl:output wsaw:Action="http://tempuri.org/IDataService/GetRupResponse" message="tns:IDataService_GetRup_OutputMessage"/>

</wsdl:operation>

<wsdl:operation name="CreateRup">

<wsdl:input wsaw:Action="http://tempuri.org/IDataService/CreateRup" message="tns:IDataService_CreateRup_InputMessage"/>

<wsdl:output wsaw:Action="http://tempuri.org/IDataService/CreateRupResponse" message="tns:IDataService_CreateRup_OutputMessage"/>

</wsdl:operation>

</wsdl:portType>

<wsdl:binding name="BasicHttpBinding_IDataService" type="tns:IDataService">

<soap:binding transport="http://schemas.xmlsoap.org/soap/http"/>

<wsdl:operation name="CreateSubject">

<soap:operation soapAction="http://tempuri.org/IDataService/CreateSubject" style="document"/>

<wsdl:input>

<soap:body use="literal"/>

</wsdl:input>

<wsdl:output>

<soap:body use="literal"/>

</wsdl:output>

</wsdl:operation>

<wsdl:operation name="GetSubject">

<soap:operation soapAction="http://tempuri.org/IDataService/GetSubject" style="document"/>

<wsdl:input>

<soap:body use="literal"/>

</wsdl:input>

<wsdl:output>

<soap:body use="literal"/>

</wsdl:output>

</wsdl:operation>

<wsdl:operation name="CreateSyllabus">

<soap:operation soapAction="http://tempuri.org/IDataService/CreateSyllabus" style="document"/>

<wsdl:input>

<soap:body use="literal"/>

</wsdl:input>

<wsdl:output>

<soap:body use="literal"/>

</wsdl:output>

</wsdl:operation>

<wsdl:operation name="GetSyllabus">

<soap:operation soapAction="http://tempuri.org/IDataService/GetSyllabus" style="document"/>

<wsdl:input>

<soap:body use="literal"/>

</wsdl:input>

<wsdl:output>

<soap:body use="literal"/>

</wsdl:output>

</wsdl:operation>

<wsdl:operation name="Login">

<soap:operation soapAction="http://tempuri.org/IDataService/Login" style="document"/>

<wsdl:input>

<soap:body use="literal"/>

</wsdl:input>

<wsdl:output>

<soap:body use="literal"/>

</wsdl:output>

</wsdl:operation>

<wsdl:operation name="GetRup">

<soap:operation soapAction="http://tempuri.org/IDataService/GetRup" style="document"/>

<wsdl:input>

<soap:body use="literal"/>

</wsdl:input>

<wsdl:output>

<soap:body use="literal"/>

</wsdl:output>

</wsdl:operation>

<wsdl:operation name="CreateRup">

<soap:operation soapAction="http://tempuri.org/IDataService/CreateRup" style="document"/>

<wsdl:input>

<soap:body use="literal"/>

</wsdl:input>

<wsdl:output>

<soap:body use="literal"/>

</wsdl:output>

</wsdl:operation>

</wsdl:binding>

<wsdl:service name="DataService">

<wsdl:port name="BasicHttpBinding_IDataService" binding="tns:BasicHttpBinding_IDataService">

<soap:address location="http://localhost:54099/DataService.svc"/>

</wsdl:port>

</wsdl:service>

</wsdl:definitions>



Приложение Б

WCF service interface:

using DataService.Entity;

using DataService.WSEntity;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

namespace DataService

{

[ServiceContract]

public interface IDataService

{

[OperationContract]

void CreateSubject(WSSubject subject);

[OperationContract]

List<WSSubject> GetSubject();

[OperationContract]

void CreateSyllabus(WSSyllabus syllabus);

[OperationContract]

List<WSSyllabus> GetSyllabus();

[OperationContract]

WSUser Login(WSUser user);

[OperationContract]

List<WSRup> GetRup();

[OperationContract]

void CreateRup(WSRup wsrup);

}

}

WCF service:

using DataService.Entity;

using DataService.WSEntity;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

namespace DataService

{

public class DataService : IDataService

{

public void CreateSubject(WSSubject subject)

{

using (DBEntities entities = new DBEntities())

{

entities.Subjects.Add(new Subject() { SubjectName = subject.Name });

entities.SaveChanges();

}

}

public void CreateSyllabus(WSSyllabus syllabus)

{

using (DBEntities entities = new DBEntities())

{

entities.Syllabuses.Add(new Syllabus()

{

AcademicYear = syllabus.AcademicYear,

Credits = syllabus.Credits,

Category = syllabus.Category,

Language = syllabus.Language,

Major = syllabus.Major,

Semester = syllabus.Semester,

Subject = syllabus.Subject.Id,

Status = 1,

Years = syllabus.Years

});

entities.SaveChanges();

}

}

public List<WSSubject> GetSubject()

{

List<WSSubject> result = new List<WSSubject>();

using (DBEntities entities = new DBEntities())

{

foreach(Subject s in entities.Subjects)

{

result.Add(new WSSubject()

{

Id = s.Id,

Name = s.SubjectName

});

}

}

return result;

}

public List<WSSyllabus> GetSyllabus()

{

using(DBEntities entities = new DBEntities())

{

List<WSSyllabus> result = new List<WSSyllabus>();

foreach(Syllabus s in entities.Syllabuses)

{

result.Add(new WSSyllabus()

{

Id = s.Id,

AcademicYear = s.AcademicYear,

Credits = s.Credits,

Category = s.Category,

Language = s.Language,

Major = s.Major,

Semester = s.Semester,

Status = getStatusById(s.Status),

Subject = getSubjectById(s.Subject),

Years = s.Years

});

}

return result;

}

}

private WSSubject getSubjectById(Int32 sid)

{

WSSubject wssubject = new WSSubject();

using (DBEntities entities = new DBEntities())

{

if (entities.Subjects.Where(x => x.Id == sid).ToList().Count > 0)

{

Subject subject = entities.Subjects.Where(x => x.Id == sid).First();

wssubject = new WSSubject()

{

Id = subject.Id,

Name = subject.SubjectName

};

}

}

return wssubject;

}

private WSStatus getStatusById(Int32 sid)

{

WSStatus wsstatus = new WSStatus();

using (DBEntities entities = new DBEntities())

{

if (entities.Status.Where(x => x.Id == sid).ToList().Count > 0)

{

Status status = entities.Status.Where(x => x.Id == sid).First();

wsstatus = new WSStatus()

{

Id = status.Id,

Name = status.Name

};

}

}

return wsstatus;

}

public WSUser Login(WSUser wsuser)

{

wsuser.IsLoggedIn = 0;

using(DBEntities entities = new DBEntities())

{

var users =

entities.Users.Where(x => x.Login.Equals(wsuser.Login) &&

x.Password.Equals(wsuser.Password)).ToList();

if(users.Count > 0)

{

var user = users.First();

wsuser.Id = user.Id;

wsuser.FirstName = user.FName;

wsuser.LastName = user.LName;

wsuser.IsActive = user.IsActive;

wsuser.IsLoggedIn = 1;

var role = entities.Roles.Where(x => x.Id == user.Role).First();

WSRole wsrole = new WSRole(){

Id = role.Id,

Name = role.Name

};

wsuser.Role = wsrole;

}

}

return wsuser;

}

public List<WSRup> GetRup()

{

List<WSRup> rups = new List<WSRup>();

using(DBEntities entities = new DBEntities())

{

foreach(Rup cr in entities.Rups)

{

rups.Add(new WSRup(){

Laboratory = cr.Laboratory,

Lectures = cr.Lectures,

Practical = cr.Practical,

Srop = cr.Srop,

SroTotal = cr.SroTotal,

TotalHours = cr.TotalHours,

Syllabus = getSyllabusById(cr.Syllabus)

});

}

}

return rups;

}

public void CreateRup(WSRup wsrup)

{

using(DBEntities entities = new DBEntities())

{

entities.Rups.Add(new Rup()

{

Laboratory = wsrup.Laboratory,

Lectures = wsrup.Lectures,

Practical = wsrup.Practical,

Srop = wsrup.Srop,

SroTotal = wsrup.SroTotal,

TotalHours = wsrup.TotalHours,

Syllabus = wsrup.Syllabus.Id

});

entities.SaveChanges();

}

}

public WSSyllabus getSyllabusById(Int32 sid)

{

WSSyllabus syllabus = new WSSyllabus();

using(DBEntities entities = new DBEntities())

{

Int32 count = entities.Syllabuses.Where(x => x.Id == sid).Count();

if(count> 0)

{

Syllabus wsyllabus = entities.Syllabuses.Where(x => x.Id == sid).First();

syllabus = new WSSyllabus()

{

Id = wsyllabus.Id,

AcademicYear = wsyllabus.AcademicYear,

Category = wsyllabus.Category,

Credits = wsyllabus.Credits,

Language = wsyllabus.Language,

Major = wsyllabus.Major,

Semester = wsyllabus.Semester,

Status = getStatusById(wsyllabus.Status),

Subject = getSubjectById(wsyllabus.Subject),

Years = wsyllabus.Years

};

}

}

return syllabus;

}

}

}

Размещено на Allbest.ru

...