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