public JsonResult Insert_Prospect(ProspectDetailVM requestModel)
{
bool result = false;
string msg = "Failed to save record..";
result = EnquiryMethods.Insert_ProspectDetail(requestModel, Session["DealerCode"].ToString());
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public static bool Insert_ProspectDetail(ProspectDetailVM model, string dealerCode)
{
DateTime dob = new DateTime();
try
{
//if(model.DOB != null)
//dob = DateTime.ParseExact(model.DOB, "MM/dd/yyyy", CultureInfo.InvariantCulture);
SqlParameter[] sqlParam =
{
new SqlParameter("@ProspectID", autoProspect_ID), //0
new SqlParameter("@DealerCode", dealerCode), //1
new SqlParameter("@ProspectTitle", model.ProspectTitle), //2
new SqlParameter("@Name", model.Name), //3
new SqlParameter("@FatherName", model.FatherName), //4
new SqlParameter("@ProspectType", model.ProspectType), //5
new SqlParameter("@NIC", (object)DBNull.Value), //6
new SqlParameter("@NTN", model.NTN), //7
new SqlParameter("@ResAddress", model.ResAddress), //8
new SqlParameter("@ResCityCode", model.ResCityCode), //9
new SqlParameter("@ResPhone", model.ResPhone), //10
new SqlParameter("@Mobile", model.Mobile), //11
new SqlParameter("@OfficeAddress", model.OfficeAddress), //12
new SqlParameter("@OffCityCode", model.OffCityCode), //13
new SqlParameter("@OffPhone", model.OffPhone), //14
new SqlParameter("@Fax", (object)DBNull.Value), //15
new SqlParameter("@Gender", (object)DBNull.Value), //16
new SqlParameter("@DOB", (model.DOB == null ? (object)DBNull.Value :sysfunc.SaveDate(model.DOB))), //17
new SqlParameter("@WeddingAnniversary", (object)DBNull.Value), //18
new SqlParameter("@Profession", model.Profession), //19
new SqlParameter("@Designation", model.Designation), //20
new SqlParameter("@Hobbies", (object)DBNull.Value), //21
new SqlParameter("@Remarks", (object)DBNull.Value), //22
new SqlParameter("@Education", model.Education), //23
new SqlParameter("@Income", (object)DBNull.Value), //24
new SqlParameter("@Email", model.Email), //25
new SqlParameter("@Createdby", model.Createdby), //26
new SqlParameter("@IsDeleted", false), //27
new SqlParameter("@CusCode", (object)DBNull.Value), //28
new SqlParameter("@CompanyDetail", model.CompanyDetail), //29
new SqlParameter("@ContactPerson", model.ContactPerson), //30
new SqlParameter("@UpdUser", AuthBase.UserId), //31
new SqlParameter("@UpdTerm", General.CurrentIP), //32
};
if (sysfunc.ExecuteSP_NonQuery("SP_Insert_Prospect", sqlParam, Trans) == true)
{
mailMsg.AppendLine("<tr><td>Customer Name : </td><td>" + model.Name + "</td></tr>");
//mailMsg.Append(Environment.NewLine);
IsSaved = true;
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
IsSaved = false;
}
//dt = DataAccess.getDataTable("SP_Insert_Prospect", sqlParam, General.GetBMSConString());
//if (dt.Rows.Count > 0)
//{
//}
//IsSaved = true;
}
catch (Exception)
{
ObjTrans.RollBackTransaction(ref Trans);
throw;
}
return(IsSaved);
}
