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 getCampaigns(DTOFiterGetCampaignRequst 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.campaigns.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 getCampaignInfo(DTOFiterGetCampaignRequst request)
{
var filter = request.getFilter();
using (var db = new KOCSAMADLSEntities(false))
{
if (request.isCategoryFilter())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.campaigns.SqlQuery(filter.getFilterSQL()).Select(tt => new { tt.category }).Distinct().OrderBy(t => t.category).ToList(), "application/json"));
}
else if (request.isSubcategoryFilter())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.campaigns.SqlQuery(filter.getFilterSQL()).Select(tt => new { tt.subcategory }).Distinct().OrderBy(t => t.subcategory).ToList(), "application/json"));
}
else if (request.isCampaignFilter())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.campaigns.SqlQuery(filter.getFilterSQL()).Select(tt => new { tt.name, tt.id }).OrderBy(t => t.name).ToList(), "application/json"));
}
else
{
var cids = db.campaigns.SqlQuery(filter.getFilterSQL()).Select(s => s.id).ToList();
var pids = db.vcampaignproducts.Where(v => cids.Contains(v.cid)).Select(s => s.pid).ToList();
return(Request.CreateResponse(HttpStatusCode.OK,
db.product_service.Where(pp => pids.Contains(pp.productid)).OrderBy(s => s.category).ToList().GroupBy(g => g.category, g => g.toDTO()).Select(g => new { category = g.Key, products = g })
, "application/json"));
// return Request.CreateResponse(HttpStatusCode.OK, db.campaigns.SqlQuery(filter.getFilterSQL()).Select(tt => new { tt.name, tt.id }).OrderBy(t => t.name).ToList(), "application/json");//silinecek
}
}
}
public DTOFilter getFilter()
{
using (var db = new KOCSAMADLSEntities())
{
DTOFilter filter = new DTOFilter("campaigns", "id");
if (hasCategoryFilter())
{
filter.fieldFilters.Add(category);
}
if (hasSubcategoryFilter())
{
filter.fieldFilters.Add(subcategory);
}
if (hasCampaignFilter())
{
filter.fieldFilters.Add(campaign);
}
if (deleted != null)
{
filter.fieldFilters.Add(deleted);
}
if (hasProductsFilter())
{
var subFilter = new DTOFilter("vcampaignproducts", "cid");
var psubFilter = new DTOFilter("product_service", "productid");
psubFilter.fieldFilters.Add(products);
subFilter.subTables.Add("pid", psubFilter);
filter.subTables.Add("id", subFilter);
}
return(filter);
}
}
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"));
}
}
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 updatePersonelAtama(DTOatama request)
{
using (var db = new KOCSAMADLSEntities())
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 insertTaskState(DTOtaskstatematches request)
{
using (var db = new KOCSAMADLSEntities())
{
var tsm = new adsl_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 getTaskStateMatches(DTOGetTSMFilter request)
{
using (var db = new KOCSAMADLSEntities())
{
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 async Task <HttpResponseMessage> Adres(AddressContent content)
{
var mail = HttpContext.Current.Request.Headers[userHeader];
var pass = HttpContext.Current.Request.Headers[passHeader];
using (var db = new KOCSAMADLSEntities())
{
var user = db.personel.Where(r => r.email == mail && r.password == pass).FirstOrDefault();
if (user == null)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { code = 1, message = "Personel Bilgileri Hatalıdır." }, "application/json"));
}
Request.Headers.Add(userNameHeader, mail);
Request.Headers.Add(passwordHeader, pass);
Request.Headers.Add(userTypeHeader, "ADSL");
ADSLAddressController adres = new ADSLAddressController();
adres.Request = new HttpRequestMessage();
adres.Request.Headers.Add(userNameHeader, mail);
adres.Request.Headers.Add(passwordHeader, pass);
adres.Request.Headers.Add(userTypeHeader, "ADSL");
adres.RequestContext = RequestContext;
adres.Request.Method = Request.Method;
adres.Request.Content = Request.Content;
return(await adres.getAdress(new DTOGetAdressFilter { adres = new DTOFieldFilter {
fieldName = content.fieldName, op = content.op, value = content.value
} }));
}
}
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 getTaskList(DTOFilterGetTasksRequest request)
{
using (var db = new KOCSAMADLSEntities())
{
var filter = request.getFilter();
filter.fieldFilters.Add(new DTOFieldFilter {
fieldName = "deleted", value = 0, op = 2
});
var querySql = filter.subTables["taskid"].getPagingSQL(request.pageNo, request.rowsPerPage);
var res = db.task.SqlQuery(querySql).ToList();
var ptypeids = res.Select(r => r.attachablepersoneltype).Distinct().ToList();
var personels = db.objecttypes.Where(p => ptypeids.Contains(p.typeid)).ToList();
var obtpyeids = res.Select(r => r.attachableobjecttype).Distinct().ToList();
var objects = db.objecttypes.Where(o => obtpyeids.Contains(o.typeid)).ToList();
var ttypeids = res.Select(s => s.tasktype).Distinct().ToList();
var tasktypess = db.tasktypes.Where(t => ttypeids.Contains(t.TaskTypeId)).ToList();
res.ForEach(r =>
{
r.objecttypes = objects.Where(t => t.typeid == r.attachableobjecttype).FirstOrDefault();
r.personeltypes = personels.Where(p => p.typeid == r.attachablepersoneltype).FirstOrDefault();
r.tasktypes = tasktypess.Where(t => t.TaskTypeId == r.tasktype).FirstOrDefault();
});
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "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 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 getSerialsOnPersonel(DTOGetSerialOnPersonel request)
{
using (var db = new KOCSAMADLSEntities())
{
var res = db.getSerialsOnPersonelAdsl(request.personelid, request.stockcardid).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res, "application/json"));
}
}
public HttpResponseMessage getGsmStatus()
{
using (var db = new KOCSAMADLSEntities())
{
var res = db.gsmKullanımıStatus.Where(i => i.deleted == 0).OrderBy(i => i.gsmText).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()), "application/json"));
}
}
public HttpResponseMessage getPersonelStock(DTOGetPersonelStock request)
{
using (var db = new KOCSAMADLSEntities())
{
var res = db.getPersonelStockAdsl(request.personelid).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => new { r.productname, r.stockid, r.amount }), "application/json"));
}
}
public HttpResponseMessage getTaskType()
{
using (var db = new KOCSAMADLSEntities())
{
var res = db.tasktypes.Select(p => new { p.TaskTypeId, p.TaskTypeName }).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res, "application/json"));
}
}
public HttpResponseMessage getObjectType()
{
using (var db = new KOCSAMADLSEntities())
{
var res = db.objecttypes.Select(s => new { s.typeid, s.typname }).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res, "application/json"));
}
}
public HttpResponseMessage getProduct()
{
using (var db = new KOCSAMADLSEntities())
{
var res = db.product_service.Where(p => p.deleted == false).OrderBy(o => o.productname).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json"));
}
}
public HttpResponseMessage getCustomerStatus()
{
using (var db = new KOCSAMADLSEntities())
{
var res = db.customer_status.Where(c => c.deleted == 0).OrderBy(c => c.Text).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()), "application/json"));
}
}
public HttpResponseMessage getTasks(DTOFilterGetTasksRequest request)
{
using (var db = new KOCSAMADLSEntities(false))
{
var filter = request.getFilter();
filter.fieldFilters.Add(new DTOFieldFilter {
fieldName = "deleted", value = 0, op = 2
});
if (request.isTaskFilter())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.task.SqlQuery(filter.subTables["taskid"].getFilterSQL())
.OrderBy(t => t.taskname)
.Select(t => new
{
t.taskid,
t.taskname,
t.tasktype
}).ToList(), "application/json"));
}
if (request.isTaskstateFilter())
{
var acik = new adsl_taskstatepool {
taskstate = "AÇIK", taskstateid = 0
};
var query = filter.getFilterSQL();
var tspIds = db.taskstatematches.SqlQuery(query)
.Select(t => t.stateid).ToList();
var res = db.taskstatepool.Where(tsp => tspIds.Contains(tsp.taskstateid)).OrderBy(tsp => tsp.taskstate).ToList();
res.Insert(0, acik);
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()).ToList(), "application/json"));
}
if (request.isObjecttypeFilter())
{
var objids = db.task.SqlQuery(filter.subTables["taskid"].getFilterSQL()).Select(s => s.attachableobjecttype).Distinct().ToList();
var res = db.objecttypes.Where(o => objids.Contains(o.typeid))
.OrderBy(t => t.typname)
.ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => new { s.typeid, s.typname }).ToList(), "application/json"));
}
if (request.isPersonelTypeFilter())
{
var pids = db.task.SqlQuery(filter.subTables["taskid"].getFilterSQL()).Select(s => s.attachablepersoneltype).Distinct().ToList();
var res = db.objecttypes.Where(p => pids.Contains(p.typeid)).OrderBy(p => p.typname).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(t => new
{
t.typeid,
t.typname
}).ToList(), "application/json"));
}
return(Request.CreateResponse(HttpStatusCode.OK,
db.tasktypes.SqlQuery(filter.subTables["tasktype"].getFilterSQL())
.Select(tt => new { tt.TaskTypeId, tt.TaskTypeName })
.OrderBy(tt => tt.TaskTypeName).ToList(),
"application/json"
));
}
}
public HttpResponseMessage getPersonel(DTOTest request)
{
using (var db = new KOCSAMADLSEntities())
{
var task = db.taskqueue.Where(t => t.taskorderno == request.taskorderno).Select(s => s.taskid).FirstOrDefault();
var objects = db.task.Where(s => s.taskid == task).Select(s => s.attachablepersoneltype).FirstOrDefault();
var res = db.personel.Include(s => s.il).Include(i => i.ilce).Where(p => ((p.roles & objects) == objects) && (p.deleted == false)).OrderBy(o => o.personelname).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "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 getPersonel()
{
using (var db = new KOCSAMADLSEntities(false))
{
var atanmamis = new adsl_personel {
personelid = 0, personelname = "Atanmamış"
};
var res = db.personel.Include(p => p.il).Include(p => p.ilce)
.Where(p => p.deleted == false).OrderBy(p => p.personelname).ToList();
res.Insert(0, atanmamis);
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json"));
}
}
public HttpResponseMessage getObject(DTOGetObjectRequest request)
{
using (var db = new KOCSAMADLSEntities())
{
var filter = request.getFilter();
var querySql = filter.getFilterSQL();
var res = new List <idName>();
res.AddRange(db.personel.SqlQuery(querySql).Select(p => new idName {
id = p.personelid, name = p.personelname
}));
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()), "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
}
}
