public HttpResponseMessage updateSL(DTOSL request) { // SL hesaplamaları için gerekli olan bilgilerin güncellenmesi (Hüseyin KOZ) var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new KOCSAMADLSEntities()) using (var tran = db.Database.BeginTransaction()) try { var upa = db.SL.Where(r => r.SLID == request.SLID).FirstOrDefault(); upa.SLName = request.SLName; upa.KocSTask = request.KocSTask; upa.KocETask = request.KocETask; upa.KocMaxTime = request.KocMaxTime; upa.BayiSTask = request.BayiSTask; upa.BayiETask = request.BayiETask; upa.BayiMaxTime = request.BayiMaxTime; upa.lastupdated = DateTime.Now; upa.updatedby = user.userId; db.SaveChanges(); tran.Commit(); var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "SL Düzenleme Tamamlandı." }; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } catch (Exception) { tran.Rollback(); var errormessage = new DTOResponseError { errorCode = 2, errorMessage = "SL Düzenleme Tamamlanamadı!" }; return(Request.CreateResponse(HttpStatusCode.NotModified, errormessage, "application/json")); } }
public HttpResponseMessage insertSL(DTOSL request) { // SL hesaplamaları için gerekli olan bilgilerin kaydı (Hüseyin KOZ) var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new KOCSAMADLSEntities()) using (var tran = db.Database.BeginTransaction()) try { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var p = new SL { SLName = request.SLName, KocSTask = request.KocSTask, KocETask = request.KocETask, KocMaxTime = request.KocMaxTime, BayiSTask = request.BayiSTask, BayiETask = request.BayiETask, BayiMaxTime = request.BayiMaxTime, lastupdated = DateTime.Now, updatedby = user.userId, deleted = false, }; db.SL.Add(p); db.SaveChanges(); tran.Commit(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } catch (Exception) { tran.Rollback(); var errormessage = new DTOResponseError { errorCode = 2, errorMessage = "Hata Oluştu" }; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }