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"));
}
}
