public static bool Update_BookingNo(BookOrdMasterVM model, string dealerCode) { try { SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@BookRefNo", model.BookRefNo), //1 new SqlParameter("@BookingNo", model.BookingNo), //2 new SqlParameter("@BookingDate", sysfun.SaveDate(model.BookingDate)), //3 new SqlParameter("@TentativeDate", sysfun.SaveDate(model.TentativeDate)), //4 }; if (sysfun.ExecuteSP_NonQuery("SP_Update_BookingNo", param)) { IsSaved = true; } } catch (Exception) { throw; } return(IsSaved); }
public JsonResult Insert_BOMaster(BookOrdMasterVM DOMasterVM) { bool result = false; string msg = "Failed to save record.."; if (DOMasterVM.BookRefNo != "" && DOMasterVM.BookRefNo != "0") { if (Core.CRM.ADO.SecurityBll.UserRights("2014", "003")) { result = BookingOrderMethods.Insert_BOMaster(DOMasterVM, ref msg); if (result) { msg = "Successfully Added"; } } else { msg = "You dn't have a right! Please Contact to Administrator"; result = false; } } else { result = BookingOrderMethods.Insert_BOMaster(DOMasterVM, ref msg); if (result) { msg = "Successfully Added"; } } return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet)); }
public JsonResult Update_BookingNo(BookOrdMasterVM VehStockVM) { bool result = false; string msg = "Failed to save record.."; result = BookingOrderMethods.Update_BookingNo(VehStockVM, Session["DealerCode"].ToString()); if (result) { msg = "Successfully Added"; } return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet)); }
public JsonResult Insert_BOMaster(BookOrdMasterVM DOMasterVM) { bool result = false; string msg = "Failed to save record.."; result = BookingOrderMethods.Insert_BOMaster(DOMasterVM, ref msg); if (result) { msg = "Successfully Added"; } return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet)); }
public static bool Insert_BOMaster(BookOrdMasterVM model, ref string msg) { IsSaved = false; try { if (model.BookRefNo == null || model.BookRefNo == "" || model.BookRefNo == "0") { strAutoCode = sysfun.AutoGen("BookOrdMaster", "BookRefNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode); } else { strAutoCode = model.BookRefNo; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@BookRefNo", strAutoCode), //1 new SqlParameter("@BookRefDate", sysfun.SaveDate(model.BookRefDate)), //2 new SqlParameter("@InvTypeCode", model.InvTypeCode), //3 new SqlParameter("@InvSubTypeCode", model.InvSubTypeCode), //4 new SqlParameter("@PriceTypeCode", model.PriceTypeCode), //5 new SqlParameter("@CusCode", model.CusCode), //6 new SqlParameter("@UpdUser", AuthBase.UserId), //7 new SqlParameter("@UpdTerm", General.CurrentIP), //8 new SqlParameter("@FHName", model.FHName), //9 new SqlParameter("@Address1", model.Address1), //10 new SqlParameter("@NIC", model.NIC), //11 new SqlParameter("@NTN", model.NTN), //12 new SqlParameter("@CellNo", model.CellNo), //13 new SqlParameter("@Email", model.Email), //14 new SqlParameter("@PhoneNo", model.PhoneNo), //15 new SqlParameter("@SalesPerson", model.SalesPerson), //16 new SqlParameter("@BookMode", model.BookMode), //17 new SqlParameter("@Segment", model.Segment), //18 new SqlParameter("@TaxType", model.TaxType), //19 new SqlParameter("@CusTypeCode", model.CusTypeCode), //20 new SqlParameter("@StockType", model.StockType), //21 new SqlParameter("@DeliveryLocation", model.DeliveryLocation), //22 new SqlParameter("@PaymentTerms", model.PaymentTerms), //23 new SqlParameter("@AccountOf", model.AccountOf), //24 new SqlParameter("@VehicleTotal", model.VehicleTotal), //25 new SqlParameter("@City", model.City), //26 new SqlParameter("@State", model.State), //27 new SqlParameter("@Country", model.Country), //28 new SqlParameter("@VehicleQty", model.VehicleQty), //28 new SqlParameter("@EnquiryNo", model.EnquiryNo), //28 new SqlParameter("@RemainingTotal", model.RemainingTotal), //15 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { if (sysfun.ExecuteSP_NonQuery("SP_Insert_BookOrdMaster", param, Trans)) { IsSaved = true; } else { return(IsSaved); } } //if (sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param)) //{ // IsSaved = true; //} } catch (Exception ex) { //ObjTrans.RollBackTransaction(ref Trans); msg = ex.Message; } return(IsSaved); }