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 insertPersonel(DTOpersonel request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var p = new personel { personelname = request.personelname, category = (int)request.category, mobile = request.mobile, email = request.email, password = request.password, notes = request.notes, roles = (int)request.category, creationdate = DateTime.Now, lastupdated = DateTime.Now, deleted = false, updatedby = user.userId }; db.personel.Add(p); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage insertTaskState(DTOtaskstatematches request) { using (var db = new CRMEntities()) { var tsm = new 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 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 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 insertStockCard(DTOstockcard request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var s = new stockcard { productname = request.productname, category = request.category, hasserial = request.hasserial, unit = request.unit, description = request.description, creationdate = DateTime.Now, lastupdated = DateTime.Now, deleted = false, updatedby = user.userId }; db.stockcard.Add(s); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
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 updatePersonelAtama(DTOAtama request) { using (var db = new CRMEntities()) 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 insertSite(DTOsite request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { var errormessage = new DTOResponseError(); var dsite = new site { sitename = request.sitename, sitedistrict = request.sitedistrict, siteaddress = request.siteaddress, description = request.description, creationdate = DateTime.Now, lastupdated = DateTime.Now, deleted = false, updatedby = user.userId, siteregioncode = request.siteregioncode, region = request.region }; db.site.Add(dsite); db.SaveChanges(); errormessage.errorMessage = "İşlem Başarılı"; errormessage.errorCode = 1; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage insertCampaigns(DTOcampaigns request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var c = new campaigns { name = request.name, category = request.category, subcategory = request.subcategory, products = request.products, documents = request.documents, creationdate = DateTime.Now, lastupdated = DateTime.Now, deleted = false, updatedby = user.userId }; db.campaigns.Add(c); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage getTaskStateMatches(DTOGetTSMFilter request) { using (var db = new CRMEntities()) { 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 HttpResponseMessage editBlock(DTOblock request) { using (var db = new CRMEntities()) { var dblock = db.block.Where(r => r.blockid == request.blockid).FirstOrDefault(); var errormessage = new DTOResponseError(); dblock.blockname = request.blockname; dblock.binakodu = request.binakodu; dblock.cocierge = request.cocierge; dblock.cociergecontact = request.cociergecontact; dblock.groupid = request.groupid; dblock.hp = request.hp; dblock.kocsaledate = request.kocsaledate; dblock.locationid = request.locationid; dblock.objid = request.objid; dblock.projectno = request.projectno; dblock.readytosaledate = request.readytosaledate; // dblock.salesrepresentative = request.salespersonel.personelid; // dblock.siteid = request.site.siteid; dblock.sosaledate = request.sosaledate; dblock.superintendent = request.superintendent; dblock.superintendentcontact = request.superintendentcontact; dblock.telocadia = request.telocadia; dblock.updatedby = 7; dblock.lastupdated = DateTime.Now; dblock.verticalproductionline = request.verticalproductionline; db.SaveChanges(); errormessage.errorMessage = "İşlem Başarılı"; errormessage.errorCode = 1; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "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 SaveStockMovementMultiple(adsl_stockmovement[] sms) { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; foreach (var sm in sms) { if (sm.movementid == 0) { if (sm.amount > 0 || sm.serialno != null) { InsertStockMovement(sm, sm.relatedtaskqueue, sm.serialno ?? ""); } } else { if (sm.amount == 0) { //silinecek } else { SaveStockMovement(sm, sm.relatedtaskqueue, sm.serialno ?? ""); } } } return(Request.CreateResponse(HttpStatusCode.OK, errormessage , "application/json")); }
public HttpResponseMessage getStockCads(DTOFilterGetStockCardRequest request) { using (var db = new CRMEntities()) { 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.stockcard.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 editSite(DTOsite request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { var dsite = db.site.Where(r => r.siteid == request.siteid).FirstOrDefault(); var errormessage = new DTOResponseError(); dsite.sitename = request.sitename; dsite.siteaddress = request.siteaddress; dsite.sitedistrict = request.sitedistrict; dsite.description = request.description; dsite.lastupdated = DateTime.Now; dsite.updatedby = user.userId; dsite.siteregioncode = request.siteregioncode; dsite.region = request.region; dsite.siteregioncode = request.siteregioncode; db.SaveChanges(); errormessage.errorMessage = "İşlem Başarılı"; errormessage.errorCode = 1; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage getSL(DTOFilterGetSLRequest request) { // SL hesaplama sayfasının doldurulması (Hüseyin KOZ) 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.SL.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.Select(r => r.toDTO()).ToList(), paginginfo, querySql) , "application/json")); } }
public HttpResponseMessage insertBlock(DTOblock requst) { using (var db = new CRMEntities()) { var errormessage = new DTOResponseError(); var user = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser(); var block = new block { blockname = requst.blockname, siteid = requst.site.siteid, hp = requst.hp, telocadia = requst.telocadia, projectno = requst.projectno, readytosaledate = requst.readytosaledate, sosaledate = requst.sosaledate, kocsaledate = requst.kocsaledate, salesrepresentative = requst.salespersonel.personelid, superintendent = requst.superintendent, superintendentcontact = requst.superintendentcontact, cocierge = requst.cocierge, cociergecontact = requst.cociergecontact, verticalproductionline = requst.verticalproductionline, creationdate = DateTime.Now, lastupdated = DateTime.Now, updatedby = user.userId, deleted = false, binakodu = requst.binakodu, locationid = requst.locationid, objid = requst.objid }; db.block.Add(block); for (int i = 0; i < (block.hp ?? 0); i++) { var hp = new customer { blockid = block.blockid, creationdate = DateTime.Now, lastupdated = DateTime.Now, updatedby = user.userId, deleted = false, flat = (i + 1).ToString() }; db.customer.Add(hp); } db.SaveChanges(); errormessage.errorMessage = "İşlem Başarılı"; errormessage.errorCode = 1; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage getCustomers(DTOFilterGetCustomerRequest request) { using (var db = new CRMEntities()) { var filter = request.getFilter(); //filter.fieldFilters.Add(new DTOFieldFilter { fieldName = "deleted", value = 0, op = 2 }); var countSql = filter.getCountSQL(); var querySql = filter.getFilterSQL(); var res = db.customer.SqlQuery(querySql).ToList(); var blockIds = res.Select(b => b.blockid).Distinct().ToList(); var blocks = db.block.Where(b => blockIds.Contains(b.blockid)).ToList(); var issIds = res.Where(i => i.iss != null).Select(i => i.iss).Distinct().ToList(); var isss = db.issStatus.Where(i => issIds.Contains(i.id)).ToList(); var cststatusIds = res.Where(c => c.customerstatus != null).Select(c => c.customerstatus).Distinct().ToList(); var cststatus = db.customer_status.Where(c => cststatusIds.Contains(c.ID)).ToList(); var netstatusIds = res.Where(c => c.netstatu != null).Select(c => c.netstatu).Distinct().ToList(); var netstatus = db.netStatus.Where(c => netstatusIds.Contains(c.id)).ToList(); var tvStatusIds = res.Where(c => c.tvstatu != null).Select(c => c.tvstatu).Distinct().ToList(); var tvstatus = db.TvKullanımıStatus.Where(c => tvStatusIds.Contains(c.id)).ToList(); var telStatusIds = res.Where(c => c.telstatu != null).Select(c => c.telstatu).Distinct().ToList(); var telstatus = db.telStatus.Where(c => telStatusIds.Contains(c.id)).ToList(); var ttvStatusIds = res.Where(c => c.turkcellTv != null).Select(c => c.turkcellTv).Distinct().ToList(); var ttvstatus = db.TurkcellTVStatus.Where(c => ttvStatusIds.Contains(c.id)).ToList(); var gsmStatusIds = res.Where(c => c.gsmstatu != null).Select(c => c.gsmstatu).Distinct().ToList(); var gsmstatus = db.gsmKullanımıStatus.Where(c => gsmStatusIds.Contains(c.id)).ToList(); res.ForEach(r => { r.block = blocks.Where(b => b.blockid == r.blockid).FirstOrDefault(); r.issStatus = isss.Where(b => b.id == r.iss).FirstOrDefault(); r.customer_status = cststatus.Where(b => b.ID == r.customerstatus).FirstOrDefault(); r.netStatus = netstatus.Where(b => b.id == r.netstatu).FirstOrDefault(); r.telStatus = telstatus.Where(b => b.id == r.telstatu).FirstOrDefault(); r.TvKullanımıStatus = tvstatus.Where(b => b.id == r.tvstatu).FirstOrDefault(); r.TurkcellTVStatus = ttvstatus.Where(b => b.id == r.turkcellTv).FirstOrDefault(); r.gsmKullanımıStatus = gsmstatus.Where(b => b.id == r.gsmstatu).FirstOrDefault(); }); return(Request.CreateResponse(HttpStatusCode.OK, new DTOResponse(DTOResponseError.NoError(), res.Where(r => r.deleted != true).OrderByDescending(r => r.deleted).Select(r => r.toDTO()).ToList()) , "application/json")); } }
public HttpResponseMessage saveDocument(DTOdocument request) { using (var db = new KOCSAMADLSEntities()) { var ddoc = db.document.Where(d => d.documentid == request.documentid).FirstOrDefault(); ddoc.documentname = request.documentname; ddoc.documentdescription = request.documentdescription; ddoc.lastupdated = DateTime.Now; ddoc.updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, DTOResponseError.NoError(), "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 } }
public HttpResponseMessage insertCustomer(DTOcustomer request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) using (var tran = db.Database.BeginTransaction()) try { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var p = new customer { blockid = request.block.blockid, tckimlikno = request.tckimlikno, customername = request.customername, flat = request.flat, gsm = request.gsm, phone = request.phone, birthdate = request.birthdate, creationdate = DateTime.Now, lastupdated = DateTime.Now, updatedby = user.userId, deleted = false, customerstatus = request.customer_status.ID, telstatu = request.telStatus.id, tvstatu = request.TvKullanımıStatus.id, turkcellTv = request.TurkcellTVStatus.id, netstatu = request.netStatus.id, description = request.description, gsmstatu = request.gsmKullanımıStatus.id, iss = request.issStatus.id, emptorcustomernum = request.emptorcustomernum, superonlineCustNo = request.superonlineCustNo, }; db.customer.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")); } }
public HttpResponseMessage saveTaskstate(DTOtaskstatepool request) { using (var db = new KOCSAMADLSEntities()) { var dtsp = db.taskstatepool.Where(t => t.taskstateid == request.taskstateid).FirstOrDefault(); dtsp.taskstate = request.taskstate; dtsp.statetype = request.statetype; dtsp.lastupdated = DateTime.Now; dtsp.updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId; db.SaveChanges(); var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage insertCustomer(customer ct) { using (var db = new KOCSAMADLSEntities()) using (var tran = db.Database.BeginTransaction()) try { var item = new customer(); item.customername = ct.customername.ToUpper(); item.superonlineCustNo = ct.superonlineCustNo; item.gsm = ct.gsm; item.tc = ct.tc; item.phone = ct.phone; item.birthdate = ct.birthdate; item.ilKimlikNo = ct.ilKimlikNo; item.ilceKimlikNo = ct.ilceKimlikNo; item.bucakKimlikNo = ct.bucakKimlikNo; item.mahalleKimlikNo = ct.mahalleKimlikNo; item.yolKimlikNo = 61; item.binaKimlikNo = 61; item.daire = 61; item.creationdate = DateTime.Now; item.lastupdated = DateTime.Now; item.updatedby = KOCAuthorizeAttribute.getCurrentUser().userId; item.email = ct.email; item.deleted = false; item.description = ct.description; db.customer.Add(item); db.SaveChanges(); tran.Commit(); var customer = db.customer.First(r => r.tc == ct.tc); var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Tamamlandı." }; return(Request.CreateResponse(HttpStatusCode.OK, new { errormessage, customer }, "application/json")); } catch (Exception) { tran.Rollback(); var errormessage = new DTOResponseError { errorCode = 2, errorMessage = "İşlem Tamamlanamadı!" }; return(Request.CreateResponse(HttpStatusCode.NotModified, new { errormessage }, "application/json")); } }
public HttpResponseMessage insertPersonelAtama(DTOAtama request) { // yeni otomatik taska personel atama kuralı using (var db = new CRMEntities()) using (var tran = db.Database.BeginTransaction()) try { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; int arrayLenght; if (request.formedtaskarray != null) { arrayLenght = request.formedtaskarray.Length; } else { arrayLenght = 1; } for (int i = 0; i < arrayLenght; i++) { var p = new atama { closedtasktype = request.closedtasktype, closedtask = request.closedtask, offpersonel = request.offpersonel, formedtasktype = request.formedtasktype, formedtask = request.formedtaskarray != null ? request.formedtaskarray[i] : null, appointedpersonel = request.appointedpersonel, }; db.atama.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")); } }
public HttpResponseMessage getPersonels(DTOFilterGetPersonelRequest 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.personel.SqlQuery(querySql).ToList(); var ilIds = res.Select(s => s.ilKimlikNo).Distinct().ToList(); var ils = db.il.Where(s => ilIds.Contains(s.kimlikNo)).ToList(); var ilceIds = res.Select(s => s.ilceKimlikNo).Distinct().ToList(); var ilces = db.ilce.Where(s => ilceIds.Contains(s.kimlikNo)).ToList(); var relatedPersonelIds = res.Select(s => s.relatedpersonelid).Distinct().ToList(); var relatedPersonels = db.personel.Where(s => relatedPersonelIds.Contains(s.personelid)).ToList(); var kurulumPersonelIds = res.Select(s => s.kurulumpersonelid).Distinct().ToList(); var kurulumPersonels = db.personel.Where(s => kurulumPersonelIds.Contains(s.personelid)).ToList(); res.ForEach(s => { s.ilce = ilces.Where(i => i.kimlikNo == s.ilceKimlikNo).FirstOrDefault(); s.il = ils.Where(i => i.kimlikNo == s.ilKimlikNo).FirstOrDefault(); s.relatedpersonel = relatedPersonels.Where(p => p.personelid == s.relatedpersonelid).FirstOrDefault(); s.kurulumpersonel = kurulumPersonels.Where(p => p.personelid == s.kurulumpersonelid).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.Where(r => r.deleted == false).Select(r => r.toDTO()).ToList(), paginginfo, querySql) , "application/json")); } }
public HttpResponseMessage saveProduct(DTOProduct_service request) { using (var db = new KOCSAMADLSEntities()) { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var dpro = db.product_service.Where(t => t.productid == request.productid).FirstOrDefault(); dpro.productname = request.productname; dpro.category = request.category; dpro.maxduration = request.maxduration; dpro.automandatorytasks = request.automandatorytasks; dpro.documents = request.documents; dpro.lastupdated = DateTime.Now; dpro.updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage saveTaskStateMatches(DTOtaskstatematches request) { using (var db = new CRMEntities()) { var dtsm = db.taskstatematches.Where(t => t.id == request.id).FirstOrDefault(); dtsm.taskid = request.task.taskid; dtsm.stateid = request.taskstatepool.taskstateid; dtsm.automandatorytasks = request.automandatorytasks; dtsm.autooptionaltasks = request.autooptionaltasks; dtsm.stockcards = request.stockcards; dtsm.documents = request.documents; dtsm.lastupdated = DateTime.Now; dtsm.updatedby = KOCAuthorizeAttribute.getCurrentUser().userId; db.SaveChanges(); var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage saveCampaigns(DTOcampaigns request) { using (var db = new KOCSAMADLSEntities()) { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var dcamp = db.campaigns.Where(t => t.id == request.id).FirstOrDefault(); dcamp.name = request.name; dcamp.category = request.category; dcamp.subcategory = request.subcategory; dcamp.products = request.products; dcamp.documents = request.documents; dcamp.lastupdated = DateTime.Now; dcamp.updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }