public ActionResult AddOrEditDetail(VT_GetDetailById_Result con)
{
TransactionDetail td = db.TransactionDetails.Where(x => x.ID == con.ID).FirstOrDefault();
if (td.Quantity != con.Quantity)
{
if (td.Quantity < con.Quantity)
{
db.VT_ExtraDetail(td.ID, td.FeeName, con.Quantity, td.FeeAmount, DateTime.Now);
return(Json(new { success = true, message = "Added Successfully" }, JsonRequestBehavior.AllowGet));
}
if (td.Quantity > con.Quantity)
{
if (con.Quantity == 0)
{
db.TransactionDetails.Remove(td);
db.SaveChanges();
return(Json(new { success = true, message = "Removed Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
if (!con.FeeName.Contains("VanChuyen"))
{
db.VT_RemoveDetail(td.ID, td.FeeName, con.Quantity, td.FeeAmount, DateTime.Now);
return(Json(new { success = true, message = "Removed Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
var count = db.TransportOrders
.Where(o => o.TransactionID == con.ID && o.TripID != null)
.Count();
if (count < (td.Quantity - con.Quantity))
{
return(Json(new { success = true, message = "Lỗi: số lệnh cần xóa lớn hơn số lệnh đã tạo chuyến" }, JsonRequestBehavior.AllowGet));
}
else
{
db.VT_RemoveDetail(td.ID, td.FeeName, con.Quantity, td.FeeAmount, DateTime.Now);
return(Json(new { success = true, message = "Removed Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
}
}
TransactionDetail tran = db.TransactionDetails.Where(x => x.ID == con.ID).FirstOrDefault();
tran.FeeAmount = con.FeeAmount;
tran.Total = tran.FeeAmount * tran.Quantity;
db.Entry(tran).State = EntityState.Modified;
db.SaveChanges();
int? total = db.TransactionDetails.Where(x => x.TransactionID == tran.TransactionID).Sum(x => x.Total);
Transaction tr = db.Transactions.Where(x => x.ID == tran.TransactionID).FirstOrDefault();
tr.Total = total;
db.Entry(tr).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddOrEdit(VT_GetFeeByConsignee_Result fee)
{
if (fee.ID == 0)
{
FeeByConsignee f = new FeeByConsignee();
f.ConsigneeID = fee.cid;
f.Name = fee.Name;
f.Price = fee.Price;
f.ShortName = fee.ShortName;
f.Unit = fee.Unit;
db.FeeByConsignees.Add(f);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
FeeByConsignee f = db.FeeByConsignees.Where(x => x.ID == fee.ID).FirstOrDefault();
f.ConsigneeID = fee.cid;
f.Name = fee.Name;
f.Price = fee.Price;
f.ShortName = fee.ShortName;
f.Unit = fee.Unit;
db.Entry(f).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(VT_GetTruckInFo_Result con)
{
if (con.ID == 0)
{
Truck truck = new Truck();
truck.DriverID = con.DriverID;
truck.TruckNo = con.TruckNo;
truck.Status = con.Status;
truck.TrailerID = con.TrailerID;
truck.Expire = con.Expire;
truck.Transit = con.Transit;
truck.OwnRent = con.OwnRent;
db.Trucks.Add(truck);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
Truck truck = db.Trucks.Where(c => c.ID == con.ID).FirstOrDefault();
truck.DriverID = con.DriverID;
truck.TruckNo = con.TruckNo;
truck.Status = con.Status;
truck.TrailerID = con.TrailerID;
truck.Expire = con.Expire;
truck.Transit = con.Transit;
truck.OwnRent = con.OwnRent;
db.Entry(truck).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEditConsignee(VT_GetConsigneeWithArea_Result con)
{
if (con.ID == 0)
{
Consignee c = new Consignee();
c.Address = con.Address;
c.Name = con.Name;
c.AreaID = con.aid;
c.ShortName = con.ShortName;
db.Consignees.Add(c);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
Consignee c = db.Consignees.Where(x => x.ID == con.ID).FirstOrDefault();
c.Address = con.Address;
c.Name = con.Name;
c.TaxCode = con.TaxCode;
c.AreaID = con.aid;
c.ShortName = con.ShortName;
db.Entry(c).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Driver con)
{
if (con.ID == 0)
{
db.Drivers.Add(con);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
var local = db.Set <Driver>()
.Local
.FirstOrDefault(f => f.ID == con.ID);
if (local != null)
{
db.Entry(local).State = EntityState.Detached;
}
db.Entry(con).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Unit con)
{
if (con.ID == 0)
{
db.Units.Add(con);
db.SaveChanges();
return(Json(new { success = true, message = "Lưu đơn vị tính thành công" }, JsonRequestBehavior.AllowGet));
}
else
{
var local = db.Set <Unit>()
.Local
.FirstOrDefault(f => f.ID == con.ID);
if (local != null)
{
db.Entry(local).State = EntityState.Detached;
}
db.Entry(con).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Cập nhật thành công" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(Truck con)
{
if (con.ID == 0)
{
db.Trucks.Add(con);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(con).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEditInfo(TruckInfo ti)
{
if (ti.ID == 0)
{
ti.Ngay = DateTime.Now.Date;
db.TruckInfoes.Add(ti);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
ti.Ngay = DateTime.Now.Date;
db.Entry(ti).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEditDetail(VT_GetDetailById_Result con)
{
try
{
TransactionDetail td = db.TransactionDetails.Where(x => x.ID == con.ID).FirstOrDefault();
if (td.Quantity != con.Quantity)
{
//neu tang so cont
if (td.Quantity < con.Quantity)
{
db.VT_ExtraDetail(td.ID, td.FeeName, con.Quantity, td.FeeAmount, DateTime.Now, con.CntrSize);
return(Json(new { success = true, message = "Thêm chi tiết thành công!" }, JsonRequestBehavior.AllowGet));
}
//neu giam so cont
if (td.Quantity > con.Quantity)
{
if (con.Quantity == 0)
{
db.TransactionDetails.Remove(td);
db.SaveChanges();
return(Json(new { success = true, message = "Xóa chi tiết thành công!" }, JsonRequestBehavior.AllowGet));
}
else
{
if (!con.FeeName.Contains("VanChuyen"))
{
db.VT_RemoveDetail(td.ID, td.FeeName, con.Quantity, td.FeeAmount, DateTime.Now);
return(Json(new { success = true, message = "Xóa chi tiết thành công!" }, JsonRequestBehavior.AllowGet));
}
else
{
var count = db.TransportOrders
.Where(o => o.TransactionID == con.ID && o.TripID == null)
.Count();
if (count < (td.Quantity - con.Quantity))
{
return(Json(new { success = true, message = "Lỗi: số lệnh cần xóa lớn hơn số lệnh chưa tạo chuyến" }, JsonRequestBehavior.AllowGet));
}
else
{
db.VT_RemoveDetail(td.ID, td.FeeName, con.Quantity, td.FeeAmount, DateTime.Now);
return(Json(new { success = true, message = "Xóa chi tiết thành công!" }, JsonRequestBehavior.AllowGet));
}
}
}
}
}
TransactionDetail tran = db.TransactionDetails.Where(x => x.ID == con.ID).FirstOrDefault();
tran.FeeAmount = con.FeeAmount;
tran.Total = tran.FeeAmount * tran.Quantity;
db.Entry(tran).State = EntityState.Modified;
db.SaveChanges();
int? total = db.TransactionDetails.Where(x => x.TransactionID == tran.TransactionID).Sum(x => x.Total);
Transaction tr = db.Transactions.Where(x => x.ID == tran.TransactionID).FirstOrDefault();
tr.Total = total;
db.Entry(tr).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Cập nhật thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
help.LogError(ex);
return(Json(new { success = false, message = "Cập nhật thất bại!" }, JsonRequestBehavior.AllowGet));
}
}