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 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 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 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 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 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 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 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 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 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 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 saveFiles()
{
try
{
var request = HttpContext.Current.Request;
var custid = Convert.ToInt32(request.Form["img_key"].Split('-')[0]);
var il = request.Form["il"].ToString();
var ilce = request.Form["ilce"].ToString();
var tqid = Convert.ToInt32(request.Form["tqid"]);
var userid = Convert.ToInt32(request.Form["updatedby"]);
var docid = Convert.ToInt32(request.Form["docid"]);
string subPath = "E:\\CRMADSLWEB\\Files\\" + il + '\\' + ilce + '\\' + request.Form["img_key"] + "\\";
System.IO.Directory.CreateDirectory(subPath);
var filePath = subPath + ((request.Files["file_data"])).FileName;
using (var fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create))
{
(request.Files["file_data"]).InputStream.CopyTo(fs);
}
using (var db = new KOCSAMADLSEntities())
{
var cdoc = new adsl_customerdocument
{
customerid = custid,
attachedobjecttype = 3000,
taskqueueid = tqid,
documentid = docid,
documenturl = filePath,
receiptdate = DateTime.Now,
creationdate = DateTime.Now,
lastupdated = DateTime.Now,
updatedby = userid,
deleted = false
};
db.customerdocument.Add(cdoc);
db.SaveChanges();
}
var req = JsonConvert.DeserializeObject <DTOtaskqueue>(request.Form["tq"]);
return(Request.CreateResponse(HttpStatusCode.OK, "uploaded", "application/json"));;
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.OK, "error", "application/json"));;
}
}
public HttpResponseMessage insertPersonelAtama(DTOatama request)
{
using (var db = new KOCSAMADLSEntities())
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 SaveStockMovement(adsl_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 KOCSAMADLSEntities())
{
var Records = db.stockmovement.Include(s => s.stockcard).Where(s => s.movementid == r.movementid);
if (Records.Count() > 0)
{
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 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"));
}
}
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 saveStockCard(DTOstockcard request)
{
using (var db = new KOCSAMADLSEntities())
{
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 = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage saveTaskStateMatches(DTOtaskstatematches request)
{
using (var db = new KOCSAMADLSEntities())
{
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 saveTask(DTOtask request)
{
using (var db = new KOCSAMADLSEntities())
{
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 = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().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 insertTaskState(DTOtaskstatepool request)
{
using (var db = new KOCSAMADLSEntities())
{
var tsp = new adsl_taskstatepool
{
taskstate = request.taskstate,
statetype = request.statetype,
creationdate = DateTime.Now,
lastupdated = DateTime.Now,
updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().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)
{
using (var db = new KOCSAMADLSEntities())
{
var d = new adsl_document
{
documentname = request.documentname,
documentdescription = request.documentdescription,
creationdate = DateTime.Now,
lastupdated = DateTime.Now,
deleted = false,
updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().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 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 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 deletePersonelAtama(int id)
{
using (var db = new KOCSAMADLSEntities())
using (var tran = db.Database.BeginTransaction())
try
{
var upa = db.atama.Where(r => r.id == id).FirstOrDefault();
//delete
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 insertProduct(DTOProduct_service request)
{
using (var db = new KOCSAMADLSEntities())
{
var errormessage = new DTOResponseError {
errorCode = 1, errorMessage = "İşlem Başarılı"
};
var p = new adsl_product_service
{
productname = request.productname,
category = request.category,
automandatorytasks = request.automandatorytasks,
maxduration = request.maxduration,
documents = request.documents,
creationdate = DateTime.Now,
lastupdated = DateTime.Now,
deleted = false,
updatedby = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId,
};
db.product_service.Add(p);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage insertStockCard(DTOstockcard request)
{
using (var db = new KOCSAMADLSEntities())
{
var errormessage = new DTOResponseError {
errorCode = 1, errorMessage = "İşlem Başarılı"
};
var s = new adsl_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 = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId
};
db.stockcard.Add(s);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage insertCampaigns(DTOcampaigns request)
{
using (var db = new KOCSAMADLSEntities())
{
var errormessage = new DTOResponseError {
errorCode = 1, errorMessage = "İşlem Başarılı"
};
var c = new adsl_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 = KOCAuthorization.KOCAuthorizeAttribute.getCurrentUser().userId
};
db.campaigns.Add(c);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public HttpResponseMessage InsertStockMovement(adsl_stockmovement r, int?tqid, string serinos)
{
// var serinos = Request.Params.AllKeys;
HashSet <int> perids = new HashSet <int>()
{
4672, 4673
};
var serials = serinos.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList();
var errormessage = new DTOResponseError();
if (!serials.Any())
{
serials.Add(null);
}
if (ModelState.IsValid)
{
var userID = KOCAuthorizeAttribute.getCurrentUser().userId;//depocu
var userType = KOCAuthorizeAttribute.getCurrentUser().userRole;
using (var db = new KOCSAMADLSEntities())
{
foreach (var seri in serials)
{
//serino kontrolü yap. varsa ekleme.
var userControl = db.stockmovement.Where(s => s.serialno == seri && s.deleted == false).OrderByDescending(s => s.movementid).Select(s => s.toobject).FirstOrDefault();
if (seri != null && (userControl != userID) && ((r.toobjecttype & (int)KOCUserTypes.StockRoomStuff) != (int)KOCUserTypes.StockRoomStuff))//satınalmadan depoya çıkış için özel durum
{
errormessage.errorCode = -1;
errormessage.errorMessage = "Yalnızca Kendinize Ait Ürünleri Başkasına Çıkabilirsiniz";
}
#region hareket uygunsa
else
{
var count = db.stockmovement.Where(s => s.serialno == seri).Count();
//satınalmadan depoya ürün girerken seri numarası kontrolü yap
if (r.fromobjecttype == 33554433 && (r.toobjecttype & (int)KOCUserTypes.StockRoomStuff) == (int)KOCUserTypes.StockRoomStuff && (int)count > 0)
{
errormessage.errorCode = -1;
errormessage.errorMessage = seri + " Seri numarası daha önce girilmiş! Lütfen Kontrol Ediniz!";
}
else
{
var stm = db.stockmovement.Where(s => s.serialno == seri && s.deleted == false && s.confirmationdate == null).ToList();
stm.ForEach(s =>
{
s.updatedby = userID;
s.lastupdated = DateTime.Now;
s.deleted = true;
}); // bir seri onaylanmadan başka birisine çıkıldığında onaylanmayan hareketi sil (Hüseyin KOZ) 27.10.2016
adsl_stockmovement sm = new adsl_stockmovement();
sm.serialno = seri;
sm.lastupdated = DateTime.Now;
sm.creationdate = DateTime.Now;
sm.toobjecttype = r.toobjecttype;
sm.stockcardid = r.stockcardid;
sm.toobject = r.toobject;
sm.deleted = false;
sm.amount = seri == null ? r.amount : 1;
sm.relatedtaskqueue = tqid;
if (KOCAuthorizeAttribute.getCurrentUser().userRole == (int)KOCUserTypes.StockRoomStuff) // (long)KocCRMRoles.kscrStockStaff
{
if (r.toobjecttype == (int)KOCUserTypes.StockRoomStuff) // ise bu bir satınalma işlemidir.
{
sm.fromobjecttype = (int)KOCUserTypes.ADSLProcurementAssosiation;
sm.fromobject = (int)KOCUserTypes.ADSLProcurementAssosiation;
sm.confirmationdate = DateTime.Now;
}
else
{
sm.fromobjecttype = (int)KOCUserTypes.StockRoomStuff;
sm.fromobject = KOCAuthorizeAttribute.getCurrentUser().userId;
}
}
else
{
sm.fromobjecttype = userType;// Convert.ToInt32(User.Identity.TitleCode);
sm.fromobject = userID;
}
if (r.relatedtaskqueue != null)
{
sm.confirmationdate = DateTime.Now;
}
if (perids.Contains(r.toobject.Value))
{
sm.confirmationdate = DateTime.Now; // listedeki personellere modem atıldığında işlem otomatik onaylanacak (28.04.2017) Hüseyin KOZ
}
sm.movementdate = DateTime.Now;
sm.updatedby = userID;
db.stockmovement.Add(sm);
db.SaveChanges();
}
}
#endregion
}
}
}
return(Request.CreateResponse(HttpStatusCode.OK, tqid, "application/json"));
}
public async Task <HttpResponseMessage> getAdress(DTOGetAdressFilter request)
{
using (var db = new KOCSAMADLSEntities())
{
//var il = TeknarProxyService.DeserializeJSON<il>();
var filter = request.getFilter();
var querySql = filter.getFilterSQL();
if (filter.tableName == "ilce")
{
var res = db.ilce.SqlQuery(querySql).ToList();
if (res.Count < 2)
{
var ilData = $"lnaj1hV9YSL2LjqEADiS9aLNc2015111912awiAQeCo723cW7/IyM3kk045ditq+ESdsbTdVfgMbN5Anwk3lx6H/cc9QTTadbSJA==&t=ce&u={request.adres.value}";
var url = "http://adreskodu.dask.gov.tr/site-element/control/load.ashx";
try
{
var dres = (await TeknarProxyService.DeserializeJSON <daskResponseJSON>(url, ilData));
db.ilce.AddRange(dres.Result.yt.Skip(1).Where(s => !(new int[] { 2097 }).Contains(s.value.Value)).Select(s => new ilce
{
ad = s.text,
ilKimlikNo = Convert.ToInt32(request.adres.value),
kimlikNo = s.value.Value
}));
db.SaveChanges();
}
catch (Exception)
{
throw;
}
res = db.ilce.SqlQuery(querySql).ToList();
}
var t = res.Select(s => s.toDTO()).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, t, "application/json"));
}
else if (filter.tableName == "bucak")
{
var res = db.bucak.SqlQuery(querySql).ToList();
if (res.Count < 1)
{
var bucakData = $"lnaj1hV9YSL2LjqEADiS9aLNc2015111912awiAQeCo723cW7/IyM3kk045ditq+ESdsbTdVfgMbN5Anwk3lx6H/cc9QTTadbSJA==&t=vl&u={request.adres.value}";
var url = "http://adreskodu.dask.gov.tr/site-element/control/load.ashx";
int error = 1;
while (error == 1)
{
try
{
var dres = (await TeknarProxyService.DeserializeJSON <daskResponseJSON>(url, bucakData));
db.bucak.AddRange(dres.Result.yt.Skip(1).Where(s => !(new int[] { 0 }).Contains(s.value.Value)).Select(s => new bucak
{
ad = s.text,
ilceKimlikNo = Convert.ToInt32(request.adres.value),
kimlikNo = s.value.Value
}));
db.SaveChanges();
error = 0;
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.OK, "-1", "application/json"));
}
}
res = db.bucak.SqlQuery(querySql).ToList();
}
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json"));
}
else if (filter.tableName == "mahalleKoy")
{
var res = db.mahalleKoy.SqlQuery(querySql).ToList();
if (res.Count < 1)
{
var bucakData = $"lnaj1hV9YSL2LjqEADiS9aLNc2015111912awiAQeCo723cW7/IyM3kk045ditq+ESdsbTdVfgMbN5Anwk3lx6H/cc9QTTadbSJA==&t=mh&u={request.adres.value}";
var url = "http://adreskodu.dask.gov.tr/site-element/control/load.ashx";
int error = 1;
while (error == 1)
{
try
{
var dres = (await TeknarProxyService.DeserializeJSON <daskResponseJSON>(url, bucakData));
db.mahalleKoy.AddRange(dres.Result.yt.Skip(1).Where(s => !(new int[] { 0 }).Contains(s.value.Value)).Select(s => new mahalleKoy
{
ad = s.text,
bucakKimlikNo = Convert.ToInt32(request.adres.value),
kimlikNo = s.value.Value
}));
db.SaveChanges();
error = 0;
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.OK, "-1", "application/json"));
}
}
res = db.mahalleKoy.SqlQuery(querySql).ToList();
}
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json"));
}
else if (filter.tableName == "cadde")
{
var res = db.cadde.SqlQuery(querySql).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.ToList(), "application/json"));
}
else if (filter.tableName == "bina")
{
var res = db.bina.SqlQuery(querySql).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.ToList(), "application/json"));
}
else if (filter.tableName == "daire")
{
var res = db.daire.SqlQuery(querySql).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res.ToList(), "application/json"));
}
else
{
var res = db.il.SqlQuery(querySql).ToList();
if (res.Count == 0)
{
var ilData = "xMf1xgor4FG+LM9PJdCPruS0m2015111822y3yj7YxRo232eFmoz/WNhy11S9YjcSvl8NMI1rT2WwjdmPRLtK6lxgOEhjoQr+ezQ==&t=il&u=0";
var url = "http://adreskodu.dask.gov.tr/site-element/control/load.ashx";
db.il.AddRange((await TeknarProxyService.DeserializeJSON <daskResponseJSON>(url, ilData)).Result.yt.Skip(1).Where(s => !(new int[] { 34, 61 }).Contains(s.value.Value)).Select(s => new il
{
ad = s.text,
kimlikNo = s.value.Value
}));
try
{
db.SaveChanges();
}
catch (Exception)
{
throw;
}
res = db.il.SqlQuery(querySql).ToList();
}
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json"));
}
}
}
