public HttpResponseMessage savePersonel(DTOpersonel request) { using (var db = new KOCSAMADLSEntities()) { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var dp = db.personel.Where(t => t.personelid == request.personelid).FirstOrDefault(); dp.personelname = request.personelname; dp.category = (int)request.category; dp.roles = dp.category = (int)request.category; dp.relatedpersonelid = request.relatedpersonelid; dp.kurulumpersonelid = request.kurulumpersonelid; dp.ilceKimlikNo = request.ilceKimlikNo; dp.ilKimlikNo = request.ilKimlikNo; dp.mobile = request.mobile; dp.email = request.email; dp.password = request.password; dp.notes = request.notes; dp.responseregions = request.responseregions; dp.lastupdated = DateTime.Now; dp.updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage getCampaigns(DTOFiterGetCampaignRequst request) { using (var db = new KOCSAMADLSEntities()) { var filter = request.getFilter(); filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "deleted", value = 0, op = 2 }); var countSql = filter.getCountSQL(); var rowCount = db.Database.SqlQuery <int>(countSql).First(); var querySql = filter.getPagingSQL(request.pageNo, request.rowsPerPage); var res = db.campaigns.SqlQuery(querySql).ToList(); DTOResponsePagingInfo paginginfo = new DTOResponsePagingInfo { pageCount = (int)Math.Ceiling(rowCount * 1.0 / request.rowsPerPage), pageNo = request.pageNo, rowsPerPage = request.rowsPerPage, totalRowCount = rowCount }; return(Request.CreateResponse(HttpStatusCode.OK, new DTOPagedResponse(DTOResponseError.NoError(), res.Where(r => r.deleted == false).Select(r => r.toDTO()).ToList(), paginginfo, querySql) , "application/json")); } }
public HttpResponseMessage getCampaignInfo(DTOFiterGetCampaignRequst request) { var filter = request.getFilter(); using (var db = new KOCSAMADLSEntities(false)) { if (request.isCategoryFilter()) { return(Request.CreateResponse(HttpStatusCode.OK, db.campaigns.SqlQuery(filter.getFilterSQL()).Select(tt => new { tt.category }).Distinct().OrderBy(t => t.category).ToList(), "application/json")); } else if (request.isSubcategoryFilter()) { return(Request.CreateResponse(HttpStatusCode.OK, db.campaigns.SqlQuery(filter.getFilterSQL()).Select(tt => new { tt.subcategory }).Distinct().OrderBy(t => t.subcategory).ToList(), "application/json")); } else if (request.isCampaignFilter()) { return(Request.CreateResponse(HttpStatusCode.OK, db.campaigns.SqlQuery(filter.getFilterSQL()).Select(tt => new { tt.name, tt.id }).OrderBy(t => t.name).ToList(), "application/json")); } else { var cids = db.campaigns.SqlQuery(filter.getFilterSQL()).Select(s => s.id).ToList(); var pids = db.vcampaignproducts.Where(v => cids.Contains(v.cid)).Select(s => s.pid).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, db.product_service.Where(pp => pids.Contains(pp.productid)).OrderBy(s => s.category).ToList().GroupBy(g => g.category, g => g.toDTO()).Select(g => new { category = g.Key, products = g }) , "application/json")); // return Request.CreateResponse(HttpStatusCode.OK, db.campaigns.SqlQuery(filter.getFilterSQL()).Select(tt => new { tt.name, tt.id }).OrderBy(t => t.name).ToList(), "application/json");//silinecek } } }
public DTOFilter getFilter() { using (var db = new KOCSAMADLSEntities()) { DTOFilter filter = new DTOFilter("campaigns", "id"); if (hasCategoryFilter()) { filter.fieldFilters.Add(category); } if (hasSubcategoryFilter()) { filter.fieldFilters.Add(subcategory); } if (hasCampaignFilter()) { filter.fieldFilters.Add(campaign); } if (deleted != null) { filter.fieldFilters.Add(deleted); } if (hasProductsFilter()) { var subFilter = new DTOFilter("vcampaignproducts", "cid"); var psubFilter = new DTOFilter("product_service", "productid"); psubFilter.fieldFilters.Add(products); subFilter.subTables.Add("pid", psubFilter); filter.subTables.Add("id", subFilter); } return(filter); } }
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")); } }
private void movement(DTOstockmovement r) { var userID = KOCAuthorizeAttribute.getCurrentUser().userId; using (var db = new KOCSAMADLSEntities()) { adsl_stockmovement sm = new adsl_stockmovement(); sm.serialno = r.serialno; sm.lastupdated = DateTime.Now; sm.updatedby = userID; sm.creationdate = DateTime.Now; sm.toobjecttype = r.toobjecttype; sm.stockcardid = r.stockcardid; sm.toobject = r.toobject; sm.deleted = false; sm.amount = r.amount; sm.fromobjecttype = r.fromobjecttype; sm.fromobject = r.fromobject; sm.movementdate = DateTime.Now; if (r.fromobjecttype == 16777217 || r.toobjecttype == 16777217 || r.fromobjecttype == 33554433) { sm.confirmationdate = DateTime.Now; // hareket müşteridense onaylı olmalı } sm.updatedby = userID; db.stockmovement.Add(sm); db.SaveChanges(); } }
public HttpResponseMessage updatePersonelAtama(DTOatama request) { using (var db = new KOCSAMADLSEntities()) using (var tran = db.Database.BeginTransaction()) try { var upa = db.atama.Where(r => r.id == request.id).FirstOrDefault(); upa.closedtasktype = request.closedtasktype; upa.closedtask = request.closedtask; upa.offpersonel = request.offpersonel; upa.formedtasktype = request.formedtasktype; upa.formedtask = request.formedtask; upa.appointedpersonel = request.appointedpersonel; db.SaveChanges(); tran.Commit(); var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "Atama Düzenleme Tamamlandı." }; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } catch (Exception) { tran.Rollback(); var errormessage = new DTOResponseError { errorCode = 2, errorMessage = "Atama Düzenleme Tamamlanamadı!" }; return(Request.CreateResponse(HttpStatusCode.NotModified, errormessage, "application/json")); } }
public HttpResponseMessage insertTaskState(DTOtaskstatematches request) { using (var db = new KOCSAMADLSEntities()) { var tsm = new adsl_taskstatematches { taskid = request.task.taskid, stateid = request.taskstatepool.taskstateid, automandatorytasks = request.automandatorytasks, autooptionaltasks = request.autooptionaltasks, stockcards = request.stockcards, documents = request.documents, creationdate = DateTime.Now, lastupdated = DateTime.Now, updatedby = KOCAuthorizeAttribute.getCurrentUser().userId, deleted = false }; db.taskstatematches.Add(tsm); db.SaveChanges(); var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage getTaskStateMatches(DTOGetTSMFilter request) { using (var db = new KOCSAMADLSEntities()) { var filter = request.getFilter(); var querySql = filter.getPagingSQL(request.pageNo, request.rowsPerPage); var countSql = filter.getCountSQL(); var rowCount = db.Database.SqlQuery <int>(countSql).First(); DTOResponsePagingInfo paginginfo = new DTOResponsePagingInfo { pageCount = (int)Math.Ceiling(rowCount * 1.0 / request.rowsPerPage), pageNo = request.pageNo, rowsPerPage = request.rowsPerPage, totalRowCount = rowCount }; var res = db.taskstatematches.SqlQuery(querySql).ToList(); var taskids = res.Select(s => s.taskid).Distinct().ToList(); var tasks = db.task.Where(t => taskids.Contains(t.taskid)).ToList(); var stateids = res.Select(s => s.stateid).Distinct().ToList(); var states = db.taskstatepool.Where(tsp => stateids.Contains(tsp.taskstateid)).ToList(); res.ForEach(r => { r.task = tasks.Where(t => t.taskid == r.taskid).FirstOrDefault(); r.taskstatepool = states.Where(t => t.taskstateid == r.stateid).FirstOrDefault(); }); return(Request.CreateResponse(HttpStatusCode.OK, new DTOPagedResponse(DTOResponseError.NoError(), res.Where(r => r.deleted == false).Select(r => r.toDTO()).ToList(), paginginfo) , "application/json")); } }
public async Task <HttpResponseMessage> Adres(AddressContent content) { var mail = HttpContext.Current.Request.Headers[userHeader]; var pass = HttpContext.Current.Request.Headers[passHeader]; using (var db = new KOCSAMADLSEntities()) { var user = db.personel.Where(r => r.email == mail && r.password == pass).FirstOrDefault(); if (user == null) { return(Request.CreateResponse(HttpStatusCode.OK, new { code = 1, message = "Personel Bilgileri Hatalıdır." }, "application/json")); } Request.Headers.Add(userNameHeader, mail); Request.Headers.Add(passwordHeader, pass); Request.Headers.Add(userTypeHeader, "ADSL"); ADSLAddressController adres = new ADSLAddressController(); adres.Request = new HttpRequestMessage(); adres.Request.Headers.Add(userNameHeader, mail); adres.Request.Headers.Add(passwordHeader, pass); adres.Request.Headers.Add(userTypeHeader, "ADSL"); adres.RequestContext = RequestContext; adres.Request.Method = Request.Method; adres.Request.Content = Request.Content; return(await adres.getAdress(new DTOGetAdressFilter { adres = new DTOFieldFilter { fieldName = content.fieldName, op = content.op, value = content.value } })); } }
public HttpResponseMessage deleteSL(int SLID) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new KOCSAMADLSEntities()) using (var tran = db.Database.BeginTransaction()) try { var upa = db.SL.Where(r => r.SLID == SLID).FirstOrDefault(); //upa.deleted = true; //delete işlemi sayfadan yapılacaksa aktif edilip işlem burdan sağlanacak (Hüseyin KOZ) upa.lastupdated = DateTime.Now; upa.updatedby = user.userId; db.SaveChanges(); tran.Commit(); var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "işlem Gerçekleştirildi." }; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } catch (Exception) { tran.Rollback(); var errormessage = new DTOResponseError { errorCode = 2, errorMessage = "işlem Tamamlanamadı!" }; return(Request.CreateResponse(HttpStatusCode.NotModified, errormessage, "application/json")); } }
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 getTaskList(DTOFilterGetTasksRequest request) { using (var db = new KOCSAMADLSEntities()) { var filter = request.getFilter(); filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "deleted", value = 0, op = 2 }); var querySql = filter.subTables["taskid"].getPagingSQL(request.pageNo, request.rowsPerPage); var res = db.task.SqlQuery(querySql).ToList(); var ptypeids = res.Select(r => r.attachablepersoneltype).Distinct().ToList(); var personels = db.objecttypes.Where(p => ptypeids.Contains(p.typeid)).ToList(); var obtpyeids = res.Select(r => r.attachableobjecttype).Distinct().ToList(); var objects = db.objecttypes.Where(o => obtpyeids.Contains(o.typeid)).ToList(); var ttypeids = res.Select(s => s.tasktype).Distinct().ToList(); var tasktypess = db.tasktypes.Where(t => ttypeids.Contains(t.TaskTypeId)).ToList(); res.ForEach(r => { r.objecttypes = objects.Where(t => t.typeid == r.attachableobjecttype).FirstOrDefault(); r.personeltypes = personels.Where(p => p.typeid == r.attachablepersoneltype).FirstOrDefault(); r.tasktypes = tasktypess.Where(t => t.TaskTypeId == r.tasktype).FirstOrDefault(); }); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json")); } }
public HttpResponseMessage getStocksOnPersonel(DTOGetPersonelStock request) { // Personellerin Üzerlerindeki serileri görebilmeleri için oluşturuldu (Stok-seri kontrolü) ArrayList list = new ArrayList(); var user = KOCAuthorizeAttribute.getCurrentUser(); var personel = request.personelid != null ? request.personelid.Value : user.userId; using (var db = new KOCSAMADLSEntities()) { var type = db.stockcard.ToList(); for (int i = 0; i < type.Count; i++) { var serials = db.getSerialsOnPersonelAdsl(personel, type[i].stockid).ToList(); for (int j = 0; j < serials.Count; j++) { DTOStockReturn res = new DTOStockReturn(); res.stockid = type[i].stockid; res.stockname = type[i].productname; res.personelid = personel; res.serials = serials[j]; list.Add(res); } } return(Request.CreateResponse(HttpStatusCode.OK, list, "application/json")); } }
public HttpResponseMessage insertTask(DTOtask request) { using (var db = new KOCSAMADLSEntities()) { var errormessage = new DTOResponseError(); var t = new adsl_task { taskname = request.taskname, attachableobjecttype = request.objecttypes.typeid, attachablepersoneltype = request.personeltypes.typeid, performancescore = request.performancescore, tasktype = request.tasktypes.TaskTypeId, deleted = false, creationdate = DateTime.Now, lastupdated = DateTime.Now, updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId, description = request.description, }; db.task.Add(t); db.SaveChanges(); errormessage.errorCode = 1; errormessage.errorMessage = "İşlem Başarılı"; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage getSerialsOnPersonel(DTOGetSerialOnPersonel request) { using (var db = new KOCSAMADLSEntities()) { var res = db.getSerialsOnPersonelAdsl(request.personelid, request.stockcardid).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res, "application/json")); } }
public HttpResponseMessage getGsmStatus() { using (var db = new KOCSAMADLSEntities()) { var res = db.gsmKullanımıStatus.Where(i => i.deleted == 0).OrderBy(i => i.gsmText).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()), "application/json")); } }
public HttpResponseMessage getPersonelStock(DTOGetPersonelStock request) { using (var db = new KOCSAMADLSEntities()) { var res = db.getPersonelStockAdsl(request.personelid).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => new { r.productname, r.stockid, r.amount }), "application/json")); } }
public HttpResponseMessage getTaskType() { using (var db = new KOCSAMADLSEntities()) { var res = db.tasktypes.Select(p => new { p.TaskTypeId, p.TaskTypeName }).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res, "application/json")); } }
public HttpResponseMessage getObjectType() { using (var db = new KOCSAMADLSEntities()) { var res = db.objecttypes.Select(s => new { s.typeid, s.typname }).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res, "application/json")); } }
public HttpResponseMessage getProduct() { using (var db = new KOCSAMADLSEntities()) { var res = db.product_service.Where(p => p.deleted == false).OrderBy(o => o.productname).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json")); } }
public HttpResponseMessage getCustomerStatus() { using (var db = new KOCSAMADLSEntities()) { var res = db.customer_status.Where(c => c.deleted == 0).OrderBy(c => c.Text).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()), "application/json")); } }
public HttpResponseMessage getTasks(DTOFilterGetTasksRequest request) { using (var db = new KOCSAMADLSEntities(false)) { var filter = request.getFilter(); filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "deleted", value = 0, op = 2 }); if (request.isTaskFilter()) { return(Request.CreateResponse(HttpStatusCode.OK, db.task.SqlQuery(filter.subTables["taskid"].getFilterSQL()) .OrderBy(t => t.taskname) .Select(t => new { t.taskid, t.taskname, t.tasktype }).ToList(), "application/json")); } if (request.isTaskstateFilter()) { var acik = new adsl_taskstatepool { taskstate = "AÇIK", taskstateid = 0 }; var query = filter.getFilterSQL(); var tspIds = db.taskstatematches.SqlQuery(query) .Select(t => t.stateid).ToList(); var res = db.taskstatepool.Where(tsp => tspIds.Contains(tsp.taskstateid)).OrderBy(tsp => tsp.taskstate).ToList(); res.Insert(0, acik); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()).ToList(), "application/json")); } if (request.isObjecttypeFilter()) { var objids = db.task.SqlQuery(filter.subTables["taskid"].getFilterSQL()).Select(s => s.attachableobjecttype).Distinct().ToList(); var res = db.objecttypes.Where(o => objids.Contains(o.typeid)) .OrderBy(t => t.typname) .ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => new { s.typeid, s.typname }).ToList(), "application/json")); } if (request.isPersonelTypeFilter()) { var pids = db.task.SqlQuery(filter.subTables["taskid"].getFilterSQL()).Select(s => s.attachablepersoneltype).Distinct().ToList(); var res = db.objecttypes.Where(p => pids.Contains(p.typeid)).OrderBy(p => p.typname).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(t => new { t.typeid, t.typname }).ToList(), "application/json")); } return(Request.CreateResponse(HttpStatusCode.OK, db.tasktypes.SqlQuery(filter.subTables["tasktype"].getFilterSQL()) .Select(tt => new { tt.TaskTypeId, tt.TaskTypeName }) .OrderBy(tt => tt.TaskTypeName).ToList(), "application/json" )); } }
public HttpResponseMessage getPersonel(DTOTest request) { using (var db = new KOCSAMADLSEntities()) { var task = db.taskqueue.Where(t => t.taskorderno == request.taskorderno).Select(s => s.taskid).FirstOrDefault(); var objects = db.task.Where(s => s.taskid == task).Select(s => s.attachablepersoneltype).FirstOrDefault(); var res = db.personel.Include(s => s.il).Include(i => i.ilce).Where(p => ((p.roles & objects) == objects) && (p.deleted == false)).OrderBy(o => o.personelname).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json")); } }
public HttpResponseMessage getSerialOnCustomer(adsl_stockmovement request) { // gönderilen filtre sorgusu sonucu bulunan müşteriye stok hareketlerinden halen müşteride bulunan stoklardan movemenid'si küçük olanı döndürür (lazım olursa liste yapılıp döndürülebilir) var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new KOCSAMADLSEntities()) { var ret = db.getSerialsOnCustomerAdsl(request.fromobject, request.stockcardid).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, ret, "application/json")); } }
public HttpResponseMessage getSerialOnPersonel(adsl_stockmovement request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new KOCSAMADLSEntities()) { var ret = db.getSerialsOnPersonelAdsl(request.fromobject, request.stockcardid).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, ret, "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")); } }
public HttpResponseMessage getObject(DTOGetObjectRequest request) { using (var db = new KOCSAMADLSEntities()) { var filter = request.getFilter(); var querySql = filter.getFilterSQL(); var res = new List <idName>(); res.AddRange(db.personel.SqlQuery(querySql).Select(p => new idName { id = p.personelid, name = p.personelname })); return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()), "application/json")); } }
public HttpResponseMessage confirmSM(int[] movementIds) { var user = KOCAuthorizeAttribute.getCurrentUser(); DTOResponseError errormessage = new DTOResponseError(); if (movementIds.Length > 0) { using (var db = new KOCSAMADLSEntities()) using (var tran = db.Database.BeginTransaction()) try { //yalnızca kendine çıkılan stoklar onaylanabilir if (db.stockmovement.Where(s => movementIds.Contains(s.movementid)).Any(a => a.toobject == user.userId)) { foreach (var item in movementIds) { var sm = db.stockmovement.Where(s => s.movementid == item && s.confirmationdate == null).FirstOrDefault(); sm.confirmationdate = DateTime.Now; sm.updatedby = user.userId; sm.lastupdated = DateTime.Now; } db.SaveChanges(); tran.Commit(); errormessage.errorMessage = "Onaylama işlemi başarılı"; errormessage.errorCode = 1; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } else { errormessage.errorMessage = "Sadece Üzerinize Atanmış Stokları Onaylayabilirsiniz"; errormessage.errorCode = -1; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } } catch (Exception) { tran.Rollback(); errormessage = new DTOResponseError { errorCode = 2, errorMessage = "işlem Tamamlanamadı!" }; return(Request.CreateResponse(HttpStatusCode.NotModified, errormessage, "application/json")); } } else { errormessage.errorMessage = "Onaylamak İçin En Az 1 Stok Hareketi Seçmelisiniz!"; errormessage.errorCode = -1; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage getTaskPersonelAtama(DTOFilterGetAtamaRequest request) { using (var db = new KOCSAMADLSEntities()) { var filter = request.getFilter(); //filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "deleted", value = 0, op = 2 }); var countSql = filter.getCountSQL(); var rowCount = db.Database.SqlQuery <int>(countSql).First(); var querySql = filter.getPagingSQL(request.pageNo, request.rowsPerPage); var res = db.atama.SqlQuery(querySql).ToList(); var offpersonelcall = res.Select(s => s.offpersonel).Distinct().ToList(); var offpersonels = db.personel.Where(s => offpersonelcall.Contains(s.personelid)).ToList(); var appointpersonelcall = res.Select(s => s.appointedpersonel).Distinct().ToList(); var appointpersonels = db.personel.Where(s => appointpersonelcall.Contains(s.personelid)).ToList(); var closedtaskcall = res.Select(s => s.closedtask).Distinct().ToList(); var closedtasks = db.task.Where(s => closedtaskcall.Contains(s.taskid)).ToList(); var formedtaskcall = res.Select(s => s.formedtask).Distinct().ToList(); var formedtasks = db.task.Where(s => formedtaskcall.Contains(s.taskid)).ToList(); var closedtasktypecall = res.Select(s => s.closedtasktype).Distinct().ToList(); var closedtasktypes = db.tasktypes.Where(s => closedtasktypecall.Contains(s.TaskTypeId)).ToList(); var formedtasktypecall = res.Select(s => s.formedtasktype).Distinct().ToList(); var formedtasktypes = db.tasktypes.Where(s => formedtasktypecall.Contains(s.TaskTypeId)).ToList(); res.ForEach(s => { s.adsl_personeloff = offpersonels.Where(i => i.personelid == s.offpersonel).FirstOrDefault(); s.adsl_personelappoint = appointpersonels.Where(i => i.personelid == s.appointedpersonel).FirstOrDefault(); s.adsl_taskclosed = closedtasks.Where(p => p.taskid == s.closedtask).FirstOrDefault(); s.adsl_taskformed = formedtasks.Where(p => p.taskid == s.formedtask).FirstOrDefault(); s.adsl_tasktypesclosed = closedtasktypes.Where(p => p.TaskTypeId == s.closedtasktype).FirstOrDefault(); s.adsl_tasktypesformed = formedtasktypes.Where(p => p.TaskTypeId == s.formedtasktype).FirstOrDefault(); }); DTOResponsePagingInfo paginginfo = new DTOResponsePagingInfo { pageCount = (int)Math.Ceiling(rowCount * 1.0 / request.rowsPerPage), pageNo = request.pageNo, rowsPerPage = request.rowsPerPage, totalRowCount = rowCount }; return(Request.CreateResponse(HttpStatusCode.OK, new DTOPagedResponse(DTOResponseError.NoError(), res.Select(r => r.toDTO()).ToList(), paginginfo, querySql) , "application/json")); //denenecek } }