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 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 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 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 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 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 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 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 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 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 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"));
}
}
public HttpResponseMessage saveTask(DTOtask request)
{
var user = KOCAuthorizeAttribute.getCurrentUser();
using (var db = new CRMEntities())
{
var dt = db.task.Where(t => t.taskid == request.taskid).FirstOrDefault();
var errormessage = new DTOResponseError();
dt.description = request.description;
dt.taskname = request.taskname;
dt.performancescore = request.performancescore;
dt.tasktype = request.tasktypes.TaskTypeId;
dt.attachableobjecttype = request.objecttypes.typeid;
dt.attachablepersoneltype = request.personeltypes.typeid;
dt.updatedby = user.userId;
dt.lastupdated = DateTime.Now;
db.SaveChanges();
errormessage.errorCode = 1;
errormessage.errorMessage = "İşlem Başarılı";
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage insertSL(DTOSL request)
{ // SL hesaplamaları için gerekli olan bilgilerin kaydı (Hüseyin KOZ)
var user = KOCAuthorizeAttribute.getCurrentUser();
using (var db = new KOCSAMADLSEntities())
using (var tran = db.Database.BeginTransaction())
try
{
var errormessage = new DTOResponseError {
errorCode = 1, errorMessage = "İşlem Başarılı"
};
var p = new SL
{
SLName = request.SLName,
KocSTask = request.KocSTask,
KocETask = request.KocETask,
KocMaxTime = request.KocMaxTime,
BayiSTask = request.BayiSTask,
BayiETask = request.BayiETask,
BayiMaxTime = request.BayiMaxTime,
lastupdated = DateTime.Now,
updatedby = user.userId,
deleted = false,
};
db.SL.Add(p);
db.SaveChanges();
tran.Commit();
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
catch (Exception)
{
tran.Rollback();
var errormessage = new DTOResponseError {
errorCode = 2, errorMessage = "Hata Oluştu"
};
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage insertTaskState(DTOtaskstatepool request)
{
var user = KOCAuthorizeAttribute.getCurrentUser();
using (var db = new CRMEntities())
{
var tsp = new taskstatepool
{
taskstate = request.taskstate,
statetype = request.statetype,
creationdate = DateTime.Now,
lastupdated = DateTime.Now,
updatedby = user.userId,
deleted = false
};
db.taskstatepool.Add(tsp);
db.SaveChanges();
var errormessage = new DTOResponseError {
errorCode = 1, errorMessage = "İşlem Başarılı"
};
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage insertDocument(DTOdocument request)
{
var user = KOCAuthorizeAttribute.getCurrentUser();
using (var db = new CRMEntities())
{
var d = new document
{
documentname = request.documentname,
documentdescription = request.documentdescription,
creationdate = DateTime.Now,
lastupdated = DateTime.Now,
deleted = false,
updatedby = user.userId
};
db.document.Add(d);
db.SaveChanges();
DTOResponseError errormessage = new DTOResponseError {
errorCode = 1, errorMessage = "İşlem Başarılı"
};
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage editBlock(DTOblock request)
{
var user = KOCAuthorizeAttribute.getCurrentUser();
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 = user.userId;
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 savePersonel(DTOpersonel request)
{
var user = KOCAuthorizeAttribute.getCurrentUser();
using (var db = new CRMEntities())
{
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 = (int)request.category;
dp.mobile = request.mobile;
dp.email = request.email;
dp.password = request.password;
dp.notes = request.notes;
dp.lastupdated = DateTime.Now;
dp.updatedby = user.userId;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage insertProduct(DTOProduct_service request)
{
using (var db = new CRMEntities())
{
var user = KOCAuthorizeAttribute.getCurrentUser();
var errormessage = new DTOResponseError {
errorCode = 1, errorMessage = "İşlem Başarılı"
};
var p = new product_service
{
productname = request.productname,
category = request.category,
automandatorytasks = request.automandatorytasks,
maxduration = request.maxduration,
creationdate = DateTime.Now,
lastupdated = DateTime.Now,
deleted = false,
updatedby = user.userId
};
db.product_service.Add(p);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage getStock(DTOGetStockMovementRequest request)
{ // getStockMovements --> fromobject (id) ve toobject (id) olarak geldiğinde isim kontrolü ile çakışma olduğu için oluşturuldu
var user = KOCAuthorizeAttribute.getCurrentUser();
using (var db = new KOCSAMADLSEntities())
{
if (request.fromobject != null && request.fromobject.value == null && request.toobject.value == null)
{
request.fromobject.value = "";
}
var filter = request.getFilter();
var querySql = filter.getPagingSQL(request.pageNo, request.rowsPerPage);
var countSql = filter.getCountSQL();
var performance = new DTOQueryPerformance();
var perf = Stopwatch.StartNew();
var rowCount = db.Database.SqlQuery <int>(countSql).First();
performance.CountSQLDuration = perf.Elapsed;
perf.Restart();
var res = db.stockmovement.SqlQuery(querySql).ToList();
performance.QuerSQLyDuration = perf.Elapsed;
perf.Restart();
var fromObjectIds = res.Select(s => s.fromobject).Distinct().ToList();
var fromPersonels = db.personel.Where(p => fromObjectIds.Contains(p.personelid)).ToList();
var fromCustomers = db.customer.Where(c => fromObjectIds.Contains(c.customerid)).ToList();
var toObjectIds = res.Select(s => s.toobject).Distinct().ToList();
var toPersonels = db.personel.Where(p => toObjectIds.Contains(p.personelid)).ToList();
var toCustomers = db.customer.Where(c => toObjectIds.Contains(c.customerid)).ToList();
var stockcardids = res.Select(s => s.stockcardid).Distinct().ToList();
var stockcards = db.stockcard.Where(s => stockcardids.Contains(s.stockid)).ToList();
res.ForEach(r =>
{
r.frompersonel = fromPersonels.Where(p => p.personelid == r.fromobject).FirstOrDefault();
if (r.frompersonel == null)
{
r.fromcustomer = fromCustomers.Where(c => c.customerid == r.fromobject).FirstOrDefault();
}
r.topersonel = toPersonels.Where(p => p.personelid == r.toobject).FirstOrDefault();
if (r.topersonel == null)
{
r.tocustomer = toCustomers.Where(c => c.customerid == r.toobject).FirstOrDefault();
}
r.stockcard = stockcards.Where(s => s.stockid == r.stockcardid).FirstOrDefault();
});
performance.LookupDuration = perf.Elapsed;
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(s => s.toDTO()).ToList(), paginginfo, querySql, performance)
, "application/json"));
}
}