public ActionResult Edit(int id)
{
ViewBag.ID = id;
VT_GetTransacstionById_Result model = db.VT_GetTransacstionById(id).FirstOrDefault();
List <FeeByConsignee> clist = db.FeeByConsignees.Where(x => x.ConsigneeID == model.ConsigneeID).ToList();
ViewBag.odata = clist;
return(View(model));
}
public ActionResult AddOrEdit(VT_GetTransacstionById_Result con)
{
try
{
DateTime end = new DateTime();
if (!DateTime.TryParseExact(con.TransportDate, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.None, out end))
{
return(Json(new { success = false, message = "Định dạng ngày vận chuyển sai!" }, JsonRequestBehavior.AllowGet));
}
if (!DateTime.TryParseExact(con.ExpireDate, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.None, out end))
{
return(Json(new { success = false, message = "Định dạng ngày tàu chạy sai!" }, JsonRequestBehavior.AllowGet));
}
Transaction tran = db.Transactions.Where(x => x.ID == con.ID).FirstOrDefault();
tran.TransportDate = DateTime.ParseExact(con.TransportDate, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
tran.ExpireDate = DateTime.ParseExact(con.ExpireDate, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
tran.Note = con.Note;
tran.Bill = con.Bill;
tran.Booking = con.Booking;
tran.Type = con.Type;
tran.Shipping = con.Shipping;
tran.Inquiry = con.Inquiry;
tran.StuffingWarehouse = con.StuffingWarehouse;
tran.PickupYard = con.PickupYard;
tran.ConsigneeID = con.ConsigneeID;
tran.ChangePlan = con.ChangePlan;
tran.Commodity = con.Commodity;
tran.ReturnYard = con.ReturnYard;
tran.Payer = con.Payer;
tran.Caller = con.Caller;
tran.Weight = con.Weight;
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 = "Lỗi cập nhật giao dịch!" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(VT_GetTransacstionById_Result con)
{
DateTime end = new DateTime();
if (con.ExpireDate.Length < 12)
{
end = DateTime.ParseExact(con.ExpireDate + " 23:59", "MM/dd/yyyy HH:mm", CultureInfo.InvariantCulture);
}
Transaction tran = db.Transactions.Where(x => x.ID == con.ID).FirstOrDefault();
tran.TransportDate = con.TransportDate;
tran.Note = con.Note;
if (con.Type.Contains("Xuat") || con.Type.Contains("Xuất"))
{
tran.Booking = con.Bill;
}
else
{
tran.Bill = con.Bill;
}
tran.Commodity = con.Commodity;
tran.Caller = con.Caller;
tran.Inquiry = con.Inquiry;
tran.Payer = con.Payer;
tran.Weight = con.Weight;
tran.Type = con.Type;
tran.Shipping = con.Shipping;
tran.PickupYard = con.PickupYard;
tran.ConsigneeID = con.ConsigneeID;
tran.ChangePlan = con.ChangePlan;
if (con.ExpireDate.Length < 12)
{
tran.ExpireDate = end;
}
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
