public List <QuicksearchResultML> CustomerGeneralandAdvancedSavedSearch([FromBody] JObject Savesearch)
{
Newsavedserach Searchsaved = Savesearch["GetDetails"].ToObject <Newsavedserach>();
PrimaryInformationMl primaryInfo = Savesearch["customerpersonaldetails"].ToObject <PrimaryInformationMl>();
List <Newsavedserach> lstSave = new List <Newsavedserach>();
lstSave.Add(Searchsaved);
DataTable dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtCustomerGeneralandAdvancedSavedSearch(), lstSave);
return(this.ICustomerSearch.CustomerAdvanceGeneralandSavedSearch(primaryInfo, dtTableValues));
}
public ArrayList EmployeeRegisterCustomerHomepagesBrokerProfiles(PrimaryInformationMl CustomerHome)
{
return(this.IRegistration.EmployeeRegisterCustomerHomepagesBrokerProfiles(CustomerHome));
}
public int?RegisterCustomerHomepages(PrimaryInformationMl CustomerHome)
{
return(this.IRegistration.RegisterCustomerHomepages(CustomerHome));
}
public ArrayList EmployeeRegisterCustomerHomepages_Brokerentry(PrimaryInformationMl Mobj, string spName)
{
SqlParameter[] parm = new SqlParameter[30];
int status = 0;
ArrayList arrayList = new ArrayList();
SqlDataReader reader;
List <Smtpemailsending> li = new List <Smtpemailsending>();
Smtpemailsending smtp = new Smtpemailsending();
int? intStatus = 0;
DateTime dtTime = DateTime.ParseExact(Mobj.dtDOB, "dd-MM-yyyy", null);
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
string strMobileVerificationCode = (new Random()).Next(10000, 99999).ToString();
try
{
parm[0] = new SqlParameter("@CasteID", SqlDbType.Int);
parm[0].Value = Mobj.intCasteID;
parm[1] = new SqlParameter("@CountryID", SqlDbType.Int);
parm[1].Value = Mobj.intCountryLivingID;
parm[2] = new SqlParameter("@GenderID", SqlDbType.Int);
parm[2].Value = Mobj.intGenderID;
parm[3] = new SqlParameter("@MobileCode", SqlDbType.Int);
parm[3].Value = Mobj.intMobileCode;
parm[4] = new SqlParameter("@LandCode", SqlDbType.Int);
parm[4].Value = Mobj.intLandCode;
parm[5] = new SqlParameter("@MotherTongueID", SqlDbType.Int);
parm[5].Value = Mobj.intMotherTongueID;
parm[6] = new SqlParameter("@ReligionID", SqlDbType.Int);
parm[6].Value = Mobj.intReligionID;
parm[7] = new SqlParameter("@AreaCode", SqlDbType.VarChar);
parm[7].Value = Mobj.strAreaCode;
parm[8] = new SqlParameter("@Email", SqlDbType.VarChar);
parm[8].Value = Mobj.strEmail;
parm[9] = new SqlParameter("@FirstName", SqlDbType.VarChar);
parm[9].Value = Mobj.strFirstName;
parm[10] = new SqlParameter("@LandNo", SqlDbType.VarChar);
parm[10].Value = Mobj.strLandNo;
parm[11] = new SqlParameter("@LastName", SqlDbType.VarChar);
parm[11].Value = Mobj.strLastName;
parm[12] = new SqlParameter("@MobileNo", SqlDbType.VarChar);
parm[12].Value = Mobj.strMobileNo;
parm[13] = new SqlParameter("@Password", SqlDbType.VarChar);
parm[13].Value = Commonclass.Encrypt(Mobj.strPassword);
parm[14] = new SqlParameter("@DateOfBirth", SqlDbType.DateTime);
// parm[14].Value = Mobj.dtDOB;
parm[14].Value = dtTime;
parm[15] = new SqlParameter("@Status", SqlDbType.Int);
parm[15].Direction = ParameterDirection.Output;
parm[16] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000);
parm[16].Direction = ParameterDirection.Output;
parm[17] = new SqlParameter("@Rowcount", SqlDbType.Int);
parm[17].Direction = ParameterDirection.Output;
parm[18] = new SqlParameter("@ProfileRegisteredBy", SqlDbType.Int);
parm[18].Value = Mobj.intProfileRegisteredBy;
parm[19] = new SqlParameter("@KMPLID", SqlDbType.VarChar);
parm[19].Value = Mobj.strKMPLID;
parm[20] = new SqlParameter("@MobileVerificationCode", SqlDbType.VarChar);
parm[20].Value = strMobileVerificationCode;
parm[21] = new SqlParameter("@EmpID", SqlDbType.BigInt);
parm[21].Value = Mobj.intEmpID;
parm[22] = new SqlParameter("@ID", SqlDbType.Int);
parm[22].Value = Mobj.ID;
parm[23] = new SqlParameter("@IsCustomer", SqlDbType.Int);
parm[23].Value = Mobj.IsCustomer;
parm[24] = new SqlParameter("@IsCustomerPostedBY", SqlDbType.Int);
parm[24].Value = Mobj.intCustPostedBY;
parm[25] = new SqlParameter("@intSubCasteID", SqlDbType.Int);
parm[25].Value = Mobj.intSubCasteID;
parm[26] = new SqlParameter("@BrokerNameID", SqlDbType.Int);
parm[26].Value = Mobj.BrokerNameID;
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
if (reader.Read())
{
smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
smtp.recipients = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
smtp.body = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
smtp.subject = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
smtp.body_format = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
smtp.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : status;
smtp.CustID = (reader["Cust"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Cust")) : 0;
smtp.ProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : string.Empty;
li.Add(smtp);
arrayList.Add(smtp);
}
}
if (Mobj.intEmpID == null)
{
Commonclass.SendMailSmtpMethod(li, "info");
}
intStatus = smtp.Status;
reader.Close();
if (intStatus.Equals(1))
{
ServiceSoapClient cc = new ServiceSoapClient();
try
{
string result = cc.SendTextSMS("ykrishna", "summary$1", Mobj.strMobileNo.ToString().Trim(), "Hi " + Mobj.strFirstName + ", Your verification code with www.kaakateeya.com is " + strMobileVerificationCode + " Please enter this code to confirm your Registration.", "smscntry");
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, (Convert.ToString(EX.Message) + "send Sms Error"), Mobj.intCusID, null, null);
}
}
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Mobj.intCusID, null, null);
}
finally
{
connection.Close();
}
return(arrayList);
}
public List <QuicksearchResultML> CustomerAdvanceGeneralandSavedSearch(PrimaryInformationMl primaryInfo, DataTable dtTableValues)
{
return(new CustomerSearch().CustomerGeneralandAdvancedSavedSearch(primaryInfo, dtTableValues, "[dbo].[usp_AdvSearch_Customer]", "@dtAdvsearch", "[dbo].[usp_Customers_GeneralSearch_Perfor]"));
}
public List <QuicksearchResultML> GeneralandAdvancedSearch(PrimaryInformationMl search)
{
return(new CustomerSearch().GeneralandAdvancedSearch(search, "[dbo].[usp_Customers_GeneralSearch_Perfor]"));
}
public ArrayList EmployeeRegisterCustomerHomepagesBrokerProfiles(PrimaryInformationMl Mobj)
{
return(new RegistrationDAL().EmployeeRegisterCustomerHomepages_Brokerentry(Mobj, "[dbo].[usp_Cust_QuickRegistration_BrokerProfileReg]"));
}
public ArrayList EmployeeRegisterCustomerHomepages(PrimaryInformationMl Mobj)
{
return(new RegistrationDAL().EmployeeRegisterCustomerHomepages(Mobj, "[dbo].[usp_Cust_QuickRegistration_Customer_New]"));
}
public int?RegisterCustomerHomepages(PrimaryInformationMl Mobj)
{
return(new RegistrationDAL().DRegisterCustomerHomepages(Mobj, "[dbo].[usp_Cust_QuickRegistration_Customer]"));
}
public List <QuicksearchResultML> CustomerGeneralandAdvancedSearch(PrimaryInformationMl search)
{
return(this.ICustomerSearch.GeneralandAdvancedSearch(search));
}
