public static string Insert_QuickEnquiry(QuickEnquiryVM model, string dealerCode) { string msg = ""; try { if (sysfunc.IsExist("Name", model.Name, "CRM_Prospect", dealerCode, "and Mobile = '" + model.Mobile + "'")) { msg = "Enquiry for this Customer is already generated"; //return Json(new { Success = false, Message = "Enquiry for this Customer is already generated" }); return(msg); } else { strAutoCode = sysfunc.AutoGen("CRM_EnquiryMaster", "Enquiry_ID", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); autoProspect_ID = sysfunc.AutoGen("CRM_Prospect", "ProspectID", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@Enquiry_ID", strAutoCode), //1 new SqlParameter("@EnqDate", General.CurrentDate), //2 new SqlParameter("@ProspectID", autoProspect_ID), //3 new SqlParameter("@EmpCode", model.EmpCode), //4 new SqlParameter("@CashFinanced", model.CashFinanced), //5 new SqlParameter("@IsFinanced", model.IsFinanced), //6 new SqlParameter("@CreatedBy", model.CreatedBy), //7 new SqlParameter("@UpdUser", AuthBase.UserId), //8 new SqlParameter("@UpdTerm", General.CurrentIP), //9 new SqlParameter("@BrandCode", model.BrandCode), //10 new SqlParameter("@ProdCode", model.ProdCode), //11 new SqlParameter("@ColorCode", model.ColorCode), //12 new SqlParameter("@Qty", model.Qty), //13 new SqlParameter("@Name", model.Name), //14 new SqlParameter("@Mobile", model.Mobile), //15 new SqlParameter("@Title", model.ProspectTitle), //16 new SqlParameter("@VersionCode", model.VersionCode) //17 }; dt = DataAccess.getDataTable("Insert_QuickEnquiryMaster", param, General.GetBMSConString()); if (dt.Rows.Count > 0) { //mailMsg = sysfunc.GetData("Select EmpName from DealerEmp where DealerCode = '" + dealerCode + "' and EmpCode = '" + model.EmpCode + "'"); } msg = "Done"; } } catch (Exception ex) { msg = ex.Message; return(msg); //throw; } return(msg); }
public JsonResult Insert_QuickEnquiry(QuickEnquiryVM requestModel) { bool result = false; string msg = "Failed to save record.."; msg = EnquiryMethods.Insert_QuickEnquiry(requestModel, Session["DealerCode"].ToString()); if (msg == "Done") { msg = "Successfully Added"; result = true; } return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet)); }