public static bool Insert_ProdMaster(ProdReceiptVM model, string dealerCode, ref string msg) { try { if (model.RecNo == "0" || model.RecNo == "" || model.RecNo == null) { strAutoCode = sysfun.AutoGen("ProdRecMaster", "RecNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode); //strAutoCode = sysfun.GetNewMaxID("ProdRecMaster", "RecNo", 8, "00166"); //recDate = DateTime.Parse( model.RecDate); } else { strAutoCode = model.RecNo; //string rec = model.RecDate; //recDate = DateTime.Parse(rec); } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@RecNo", strAutoCode), //1 new SqlParameter("@RecDate", sysfun.SaveDate(model.RecDate)), //2 new SqlParameter("@DocumentNo", model.DocumentNo), //3 new SqlParameter("@UpdUser", AuthBase.UserId), //4 new SqlParameter("@UpdTerm", General.CurrentIP), //5 new SqlParameter("@VehTypeCode", model.VehTypeCode), //6 new SqlParameter("@VehRecCode", model.VehRecCode), //7 new SqlParameter("@Segment", model.Segment.Trim()), //8 new SqlParameter("@Category", model.Category.Trim()), //9 new SqlParameter("@Usage", model.Usage.Trim()), //10 new SqlParameter("@VendorCode", model.VendorCode.Trim()), //11 new SqlParameter("@Remarks", model.Remarks), //12 new SqlParameter("@OEMAnnounceDate", sysfun.SaveDate(model.OEMAnnounceDate)), //12 new SqlParameter("@TransportID", model.TransportID), //12 new SqlParameter("@TotalVehicleAmount", model.TotalVehicleAmount) //12 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("SP_ProdRecMaster_Insert", param, Trans); IsSaved = true; } } catch (Exception ex) { msg = ex.Message; return(false); } return(IsSaved); }
public JsonResult Insert_ProdRecMaster(ProdReceiptVM ProdReceiptVM) { bool result = false; DealerCode = Session["DealerCode"].ToString(); string msg = "Failed to save record.."; result = VehReceiptMethods.Insert_ProdMaster(ProdReceiptVM, DealerCode, ref msg); if (result) { msg = "Successfully Added"; } return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet)); }
public JsonResult Insert_ProdRecMaster(ProdReceiptVM ProdReceipt) { bool result = false; DealerCode = Session["DealerCode"].ToString(); string msg = "Failed to save record.."; if (ProdReceipt.RecNo != null && ProdReceipt.RecNo != "0") { if (Core.CRM.ADO.SecurityBll.UserRights("2015", "003")) { result = VehReceiptMethods.Insert_ProdMaster(ProdReceipt, DealerCode, ref msg); if (result) { msg = "Successfully Added"; } } else { msg = "You dn't have a right! Please Contact to Administrator"; result = false; } } else { result = VehReceiptMethods.Insert_ProdMaster(ProdReceipt, DealerCode, ref msg); if (result) { msg = "Successfully Added"; } } return Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet); }