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