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 insertTask(DTOtask request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { var errormessage = new DTOResponseError(); var t = new 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 = user.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 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 savePE(DTOSavePenetrasyon request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { var taskqueue = new taskqueue { attachedobjectid = request.blockid, attachedpersonelid = request.attachedpersonelid, creationdate = request.date != null ? request.date : DateTime.Now, deleted = false, description = "İnternet Penetrasyon Taskı", lastupdated = DateTime.Now, status = null, taskid = 8164, updatedby = user.userId }; db.taskqueue.Add(taskqueue); db.SaveChanges(); taskqueue.relatedtaskorderid = taskqueue.taskorderno; // başlangıç tasklarının relatedtaskorderid kendi taskorderno tutacak (Hüseyin KOZ) 13.03.2017 db.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.OK, "İşlem Başarılı", "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 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 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 saveCustomerCard(DTOKatZiyareti ct) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { if (db.customer.Any(c => c.customerid == ct.customerid)) { var item = db.customer.Where(c => c.customerid == ct.customerid).First(); item.customername = ct.customername; //item.customersurname = ct.customersurname; item.gsm = ct.gsm; item.netstatu = ct.netStatus.id; item.telstatu = ct.telStatus.id; item.gsmstatu = ct.gsmKullanımıStatus.id; item.iss = ct.issStatus.id; item.tvstatu = ct.TvKullanımıStatus.id; item.description = ct.description; item.lastupdated = DateTime.Now; item.updatedby = user.userId; item.superonlineCustNo = ct.superonlineCustNo; } if (ct.closedKatZiyareti == true) { var res = db.taskqueue.Where(tq => tq.attachedobjectid == ct.customerid && tq.taskid == 86 && tq.status == null).FirstOrDefault(); res.status = 1079; res.consummationdate = DateTime.Now; res.lastupdated = DateTime.Now; } db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "ok", "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 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 multiEditBlock(DTOMultiEditBlockDate request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { try { var dblocks = db.block.Where(r => request.BIDS.Contains(r.blockid)).ToList(); foreach (var b in dblocks) { b.updatedby = user.userId; b.lastupdated = DateTime.Now; b.sosaledate = request.FSD; if (request.SSC) { b.readytosaledate = request.SOSR; } if (request.KSC) { b.kocsaledate = request.KSR; } } db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Tamamlandı", "application/json")); } catch (Exception) { return(Request.CreateResponse(HttpStatusCode.OK, "Tamamlanmadı", "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 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 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 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 saveTtvTask(DTONewTTVTask request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { var c = db.customer.First(r => r.customerid == request.customerid); var cs = new customer { superonlineCustNo = request.customer.superonlineCustNo, tckimlikno = request.customer.tckimlikno, customername = request.customer.customername, gsm = request.customer.gsm, phone = request.customer.phone, customerstatus = request.customer.customerstatus, iss = request.customer.iss, netstatu = request.customer.netstatu, telstatu = request.customer.telstatu, tvstatu = request.customer.tvstatu, turkcellTv = request.customer.turkcellTv, gsmstatu = request.customer.gsmstatu, description = request.customer.description, blockid = c.blockid, flat = c.flat, creationdate = DateTime.Now, lastupdated = DateTime.Now, updatedby = user.userId, deleted = false }; db.customer.Add(cs); c.deleted = null; db.SaveChanges(); var taskqueue = new taskqueue { taskid = request.taskid, creationdate = request.creationdate != null ? request.creationdate : DateTime.Now, attachedobjectid = cs.customerid, attachmentdate = request.attachedpersonelid != null ? DateTime.Now : (DateTime?)null, attachedpersonelid = request.attachedpersonelid, description = request.description, lastupdated = DateTime.Now, deleted = false, updatedby = user.userId }; db.taskqueue.Add(taskqueue); db.SaveChanges(); taskqueue.relatedtaskorderid = taskqueue.taskorderno; // başlangıç tasklarının relatedtaskorderid kendi taskorderno tutacak (Hüseyin KOZ) 13.03.2017 db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, taskqueue.taskorderno, "application/json")); } }
public HttpResponseMessage SaveStockMovement(stockmovement r, int?tqid, string serinos) { var userID = KOCAuthorizeAttribute.getCurrentUser().userId; if (r.movementid <= 0) { return(InsertStockMovement(r, tqid, serinos)); } else { using (var db = new CRMEntities()) { var Records = db.stockmovement.Include(s => s.stockcard).Where(s => s.movementid == r.movementid); if (Records.Count() > 0) { //var confirmationroles = (new KocCRMRoles[]{ // KocCRMRoles.kscrProductionStaff, // KocCRMRoles.kscrSalesStaff, // KocCRMRoles.kscrStockStaff, // KocCRMRoles.kscrTechnicalStaff, // KocCRMRoles.kscrBackOfficeStaff, // KocCRMRoles.kscrCallCenterStaff // }).Select(role => (long)role).ToList(); var Record = Records.First(); if (r.toobject == userID && r.confirmationdate != null && Record.confirmationdate == null) //confirmationroles.Contains(r.toobjecttype) && if şartlarına eklenecek yetkilendirmeden sonra { Record.confirmationdate = DateTime.Now; } else { if (Record.stockcard.hasserial == true && string.IsNullOrWhiteSpace(r.serialno)) { return(Request.CreateResponse(HttpStatusCode.OK, tqid, "application/json"));//seri numarası girilmesi gerekirken girilmemişse veya boşluk gibi bir karakter girilmişse } Record.amount = string.IsNullOrWhiteSpace(r.serialno) ? r.amount : 1; Record.relatedtaskqueue = r.relatedtaskqueue; Record.serialno = r.serialno; Record.stockcardid = r.stockcardid; Record.toobject = r.toobject; Record.toobjecttype = r.toobjecttype; } Record.updatedby = userID; Record.lastupdated = DateTime.Now; db.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.OK, tqid, "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 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 saveDocument(DTOdocument request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { 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 = user.userId; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, DTOResponseError.NoError(), "application/json")); } }
public HttpResponseMessage editSiteMultiple(DTORequestSBEditMultiple request) { if ((request.siteIds == null && request.blockIds == null) || request.personelid == 0) { return(Request.CreateResponse(HttpStatusCode.OK, "Seçimleri Yapınız !", "application/json")); } var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) using (var tran = db.Database.BeginTransaction()) { try { if (request.blockIds != null && request.blockIds.Count > 0) { var k = db.block.Where(r => request.blockIds.Contains(r.blockid)).ToList(); k.ForEach(r => { r.salesrepresentative = request.personelid; r.lastupdated = DateTime.Now; r.updatedby = user.userId; }); } else { var k = db.block.Where(r => request.siteIds.Contains(r.siteid)).ToList(); k.ForEach(r => { r.salesrepresentative = request.personelid; r.lastupdated = DateTime.Now; r.updatedby = user.userId; }); } db.SaveChanges(); tran.Commit(); return(Request.CreateResponse(HttpStatusCode.OK, "Tamamlandı", "application/json")); } catch (Exception) { tran.Rollback(); return(Request.CreateResponse(HttpStatusCode.OK, "Tamamlanmadı", "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 savetask(DTOSaveGlobalTask request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { if (request.newcustomer) { // işlem eğer sadece mobil satış işlemi ise var c = db.customer.First(r => r.customerid == request.customerid); var cs = new customer { blockid = c.blockid, customername = request.customername, creationdate = DateTime.Now, description = "Hat Satışı için Oluşturuldu", flat = c.flat, gsm = request.gsm, lastupdated = DateTime.Now, tckimlikno = request.tc, updatedby = user.userId }; db.customer.Add(cs); db.SaveChanges(); request.customerid = cs.customerid; } var taskqueue = new taskqueue { taskid = request.taskid, creationdate = request.creationdate != null ? request.creationdate : DateTime.Now, attachedobjectid = request.customerid != null ? request.customerid : request.blockid, attachmentdate = request.attachedpersonelid != null ? DateTime.Now : (DateTime?)null, attachedpersonelid = request.attachedpersonelid, description = request.description, lastupdated = DateTime.Now, deleted = false, fault = request.fault, updatedby = user.userId }; db.taskqueue.Add(taskqueue); db.SaveChanges(); taskqueue.relatedtaskorderid = taskqueue.taskorderno; // başlangıç tasklarının relatedtaskorderid kendi taskorderno tutacak (Hüseyin KOZ) 13.03.2017 db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, taskqueue.taskorderno, "application/json")); } }
public HttpResponseMessage saveTaskstate(DTOtaskstatepool request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { 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 = user.userId; db.SaveChanges(); var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; 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 saveProduct(DTOProduct_service request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { 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.lastupdated = DateTime.Now; dpro.updatedby = user.userId; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage saveCustomerCard(DTOcustomer ct) { using (var db = new KOCSAMADLSEntities()) using (var transaction = db.Database.BeginTransaction()) try { var oldCust = db.customer.Where(c => c.tc == ct.tc && c.deleted == false).ToList(); if (oldCust.Count == 0 || oldCust.Where(r => r.customerid == ct.customerid).FirstOrDefault() != null) { if (db.customer.Any(c => c.customerid == ct.customerid)) { var item = db.customer.Where(c => c.customerid == ct.customerid).First(); item.customername = ct.customername; item.gsm = ct.gsm; item.tc = ct.tc; item.ilKimlikNo = ct.ilKimlikNo; item.ilceKimlikNo = ct.ilceKimlikNo; item.bucakKimlikNo = ct.bucakKimlikNo; item.mahalleKimlikNo = ct.mahalleKimlikNo; item.phone = ct.phone; item.birthdate = ct.birthdate; item.lastupdated = DateTime.Now; item.updatedby = KOCAuthorizeAttribute.getCurrentUser().userId; item.email = ct.email; item.superonlineCustNo = ct.superonlineCustNo; item.xdslno = ct.xdslno; item.description = ct.description; } db.SaveChanges(); transaction.Commit(); return(Request.CreateResponse(HttpStatusCode.OK, "ok", "application/json")); } return(Request.CreateResponse(HttpStatusCode.OK, "Girilen TC Numarası Başkasına Aittir", "application/json")); } catch { transaction.Rollback(); return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "error", "application/json")); } }
public HttpResponseMessage saveStockCard(DTOstockcard request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { var errormessage = new DTOResponseError { errorCode = 1, errorMessage = "İşlem Başarılı" }; var ds = db.stockcard.Where(t => t.stockid == request.stockid).FirstOrDefault(); ds.productname = request.productname; ds.category = request.category; ds.hasserial = request.hasserial; ds.unit = request.unit; ds.description = request.description; ds.lastupdated = DateTime.Now; ds.updatedby = user.userId; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }
public HttpResponseMessage saveCampaigns(DTOcampaigns request) { var user = KOCAuthorizeAttribute.getCurrentUser(); using (var db = new CRMEntities()) { 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 = user.userId; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json")); } }