public HttpResponseMessage insertPersonel(DTOpersonel request) { using (var db = new KOCSAMADLSEntities()) { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var p = new adsl_personel { personelname = request.personelname, category = (int)request.category, mobile = request.mobile, email = request.email, password = request.password, notes = request.notes, roles = (int)request.category, relatedpersonelid = request.relatedpersonelid != 0 ? request.relatedpersonelid : null, kurulumpersonelid = request.kurulumpersonelid, ilceKimlikNo = request.ilceKimlikNo, ilKimlikNo = request.ilKimlikNo, creationdate = DateTime.Now, lastupdated = DateTime.Now, deleted = false, updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId }; db.personel.Add(p); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage getPersonel() { using (var db = new KOCSAMADLSEntities(false)) { var atanmamis = new adsl_personel { personelid = 0, personelname = "Atanmamış" }; var res = db.personel.Include(p => p.il).Include(p => p.ilce) .Where(p => p.deleted == false).OrderBy(p => p.personelname).ToList(); res.Insert(0, atanmamis); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json")); } }