//Telefon noya göre müşteri bilgisi çeker.
public JsonResult GetPhoneData(string PNumber)
{
OrderWithDetail orderWithDetail = new OrderWithDetail();
ReturnValue ret = new ReturnValue();
if (Shared.CheckSession() == false)
{
ret.requiredLogin = true;
ret.message = "Lütfen giriş yapınız.";
ret.success = false;
return(Json(ret));
}
using (TransactionScope scope = new TransactionScope())
{
try
{
using (var db = new KTOtomasyonEntities())
{
var phonedata = db.Orders.Where(x => x.PhoneNumber == PNumber).FirstOrDefault();
if (phonedata != null)
{
orderWithDetail.Order_Id = phonedata.Order_Id;
orderWithDetail.CustomerName = phonedata.CustomerName;
orderWithDetail.PhoneNumber = phonedata.PhoneNumber;
orderWithDetail.Debt = phonedata.Debt;
orderWithDetail.Discount = phonedata.Discount;
orderWithDetail.OrderDate = DateTime.Now;
ret.message = "Müşteri Bulundu.";
ret.success = true;
ret.retObject = orderWithDetail;
scope.Complete();
}
else
{
ret.message = "Müşteri Bulunamadı.";
ret.success = false;
}
}
}
catch (Exception ex)
{
scope.Dispose();
ret.success = false;
ret.message = ex.Message;
ex.AddToDBLog("HomeController.GetPhoneData");
}
}
return(Json(ret));
}
//Sipariş kaydet işlemini gerçekleştirir.
public JsonResult OrderSave(OrderWithDetail orderWithDetail)
{
Orders orderadd = new Orders();
ReturnValue ret = new ReturnValue();
if (Shared.CheckSession() == false)
{
ret.requiredLogin = true;
ret.message = "Lütfen giriş yapınız.";
ret.success = false;
return(Json(ret));
}
using (TransactionScope scope = new TransactionScope())
{
try
{
ret.success = false;
//Sipariş id'sine göre kayıtları databaseden çeker
using (var db = new KTOtomasyonEntities())
{
if (orderWithDetail.OrderDetails == null || orderWithDetail.OrderDetails.Count == 0)
{
ret.requiredLogin = false;
ret.message = "Lütfen işlem giriniz.";
ret.success = false;
return(Json(ret));
}
if (orderWithDetail.Order_Id != 0)
{
orderadd = db.Orders.Where(x => x.Order_Id == orderWithDetail.Order_Id).FirstOrDefault();
}
orderadd.CustomerName = orderWithDetail.CustomerName;
orderadd.PhoneNumber = orderWithDetail.PhoneNumber;
orderadd.Debt = orderWithDetail.Debt;
orderadd.Addition = orderWithDetail.Addition;
orderadd.Discount = orderWithDetail.Discount;
orderadd.OrderDate = orderWithDetail.OrderDate;
orderadd.CreatedDate = DateTime.Now;
orderadd.CreatedUser = Convert.ToInt32(Session["UserId"]);
orderadd.IsPaid = orderWithDetail.IsPaid;
orderadd.IsDelivered = orderWithDetail.IsDelivered;
orderadd.IsDeleted = orderWithDetail.IsDeleted;
if (orderWithDetail.Order_Id == 0)
{
db.Orders.Add(orderadd);
}
db.SaveChanges();
int id = orderadd.Order_Id;
foreach (var item in orderadd.OrderDetail.ToList())
{
db.OrderDetail.Remove(item);
}
db.SaveChanges();
foreach (var item in orderWithDetail.OrderDetails)
{
OrderDetail odetail = new OrderDetail();
odetail.Order_Id = id;
odetail.Operation_Id = item.Operation_Id;
odetail.Quantity = item.Quantity;
odetail.Price = item.Price;
odetail.TotalPrice = item.TotalPrice;
db.OrderDetail.Add(odetail);
}
db.SaveChanges();
scope.Complete();
ret.retObject = orderWithDetail;
}
ret.message = "Başarıyla kaydedildi.";
ret.success = true;
}
catch (Exception ex)
{
ex.AddToDBLog("HomeController.OrderSave");
ret.success = false;
ret.message = ex.Message;
scope.Dispose();
}
}
return(Json(ret));
}
//Tıklanılan siparişin detaylarını getirir.
public JsonResult GetOrderData(int Order_Id)
{
OrderWithDetail orderWithDetail = new OrderWithDetail();
ReturnValue ret = new ReturnValue();
if (Shared.CheckSession() == false)
{
ret.requiredLogin = true;
ret.message = "Lütfen giriş yapınız.";
ret.success = false;
return(Json(ret));
}
using (TransactionScope scope = new TransactionScope())
{
try
{
using (var db = new KTOtomasyonEntities())
{
var orderdata = db.Orders.Where(x => x.Order_Id == Order_Id).FirstOrDefault();
orderWithDetail.Order_Id = orderdata.Order_Id;
orderWithDetail.CreatedUser = orderdata.CreatedUser;
orderWithDetail.CreatedUserText = orderdata.Users.Name;
orderWithDetail.CustomerName = orderdata.CustomerName;
orderWithDetail.PhoneNumber = orderdata.PhoneNumber;
orderWithDetail.Debt = orderdata.Debt;
orderWithDetail.Discount = orderdata.Discount;
orderWithDetail.Addition = orderdata.Addition;
orderWithDetail.OrderDate = orderdata.OrderDate;
orderWithDetail.CreatedDate = orderdata.CreatedDate;
orderWithDetail.IsPaid = orderdata.IsPaid;
orderWithDetail.IsDelivered = orderdata.IsDelivered;
orderWithDetail.IsDeleted = orderdata.IsDeleted;
orderWithDetail.OrderDetails = new List <OrderDetails>();
foreach (var item in orderdata.OrderDetail)
{
orderWithDetail.OrderDetails.Add(new OrderDetails
{
Order_Id = item.Order_Id,
Operation_Id = item.Operation_Id,
Quantity = item.Quantity,
Price = item.Price,
TotalPrice = item.TotalPrice,
OrderDetail_Id = item.OrderDetail_Id,
OperationText = item.Operations.Name
});
}
scope.Complete();
return(Json(orderWithDetail));
}
}
catch (Exception ex)
{
ex.AddToDBLog("HomeController.GetOrderData");
ret.success = false;
ret.message = ex.Message;
scope.Dispose();
}
}
return(Json(ret));
}
