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