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