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