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