public static bool Insert_DOMaster(VehicleDeliveryMasterVM model, string dealerCode) { try { if (model.DeliveryNo == "" || model.DeliveryNo == null) { strAutoCode = sysfun.AutoGen("VehicleDeliveryMaster", "DeliveryNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); } else { strAutoCode = model.DeliveryNo; } SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@DeliveryNo", strAutoCode), //1 new SqlParameter("@DeliveryDate", sysfun.SaveDate(model.DeliveryDate)), //2 new SqlParameter("@BookRefNo", model.BookRefNo), //3 new SqlParameter("@UpdUser", AuthBase.UserId), //4 new SqlParameter("@UpdTerm", General.CurrentIP), //5 new SqlParameter("@Type", model.Type), //6 new SqlParameter("@ReceiverCode", model.ReceiverCode), //7 new SqlParameter("@Remarks", model.Remarks), //8 new SqlParameter("@Segment", model.Segment), //9 new SqlParameter("@Usage", model.Usage), //10 new SqlParameter("@CusCode", model.CusCode), //11 new SqlParameter("@VehTypeCode", model.VehTypeCode), //12 new SqlParameter("@CusContNo", model.CusContNo), //13 new SqlParameter("@EmpCode", model.EmpCode) }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param, Trans); IsSaved = true; } //if (sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param)) //{ // IsSaved = true; //} } catch (Exception) { //ObjTrans.RollBackTransaction(ref Trans); throw; } return(IsSaved); }
public JsonResult Insert_DOMaster(VehicleDeliveryMasterVM DOMasterVM) { bool result = false; string msg = "Failed to save record.."; result = DeliveryOrderMethods.Insert_DOMaster(DOMasterVM, Session["DealerCode"].ToString()); if (result) { msg = "Successfully Added"; } return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet)); }
public JsonResult Insert_DOMaster(VehicleDeliveryMasterVM DOMasterVM) { bool result = false; string msg = "Failed to save record.."; if (DOMasterVM.DeliveryNo != "" && DOMasterVM.DeliveryNo != "0") { if (Core.CRM.ADO.SecurityBll.UserRights("2017", "003")) { result = DeliveryOrderMethods.Insert_DOMaster(DOMasterVM, Session["DealerCode"].ToString()); if (result) { msg = "Successfully Added"; } } else { msg = "You dn't have a right! Please Contact to Administrator"; result = false; } } else { result = DeliveryOrderMethods.Insert_DOMaster(DOMasterVM, Session["DealerCode"].ToString()); if (result) { msg = "Successfully Added"; } } return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet)); }