public int InsertCustomerExpressinterest(int?fromcustid, int?tocustid, long?logID, string interstTYpe, int?empid, string spName) { SqlParameter[] parm = new SqlParameter[12]; Smtpemailsending smtp = new Smtpemailsending(); List <Smtpemailsending> li = new List <Smtpemailsending>(); SqlDataReader reader; int status = 0; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { parm[0] = new SqlParameter("@fromcustid", SqlDbType.Int); parm[0].Value = fromcustid; parm[1] = new SqlParameter("@tocustid", SqlDbType.Int); parm[1].Value = tocustid; parm[2] = new SqlParameter("@logID", SqlDbType.BigInt); parm[2].Value = logID; parm[3] = new SqlParameter("@interstTYpe", SqlDbType.VarChar); parm[3].Value = interstTYpe; parm[4] = new SqlParameter("@status", SqlDbType.Int); parm[4].Direction = ParameterDirection.Output; parm[5] = new SqlParameter("@empid", SqlDbType.Int); parm[5].Value = empid; DataSet dsMessages = new DataSet(); reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (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.Statusint = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : 0; li.Add(smtp); } } status = reader.HasRows == true ? smtp.Statusint : 1; Commonclass.SendMailSmtpMethod(li, "exp"); reader.Close(); } catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), fromcustid, null, null); } finally { connection.Close(); //SqlConnection.ClearPool(connection); //SqlConnection.ClearAllPools(); } return(status); }
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 int getCustomerServiceDal(CustSearchMl MobjViewprofile, string spName) { SqlParameter[] parm = new SqlParameter[14]; int istatus = 0; List <Smtpemailsending> li = new List <Smtpemailsending>(); SqlDataReader reader; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { parm[0] = new SqlParameter("@fromcustid", SqlDbType.Int); parm[0].Value = MobjViewprofile.IFromCustID; parm[1] = new SqlParameter("@toCustID", SqlDbType.Int); parm[1].Value = MobjViewprofile.IToCustID; parm[2] = new SqlParameter("@TypeofInsert", SqlDbType.VarChar); parm[2].Value = MobjViewprofile.TypeofInsert; parm[3] = new SqlParameter("@i_Acceptlink", SqlDbType.VarChar); parm[3].Value = MobjViewprofile.EncriptedText; parm[4] = new SqlParameter("@i_Rejectlink", SqlDbType.VarChar); parm[4].Value = MobjViewprofile.EncryptedRejectFlagText; parm[5] = new SqlParameter("@i_RVRAcceptlink", SqlDbType.VarChar); parm[5].Value = MobjViewprofile.EncriptedTextrvr; parm[6] = new SqlParameter("@i_RVRRejectlink", SqlDbType.VarChar); parm[6].Value = MobjViewprofile.EncryptedRejectFlagTextrvr; parm[7] = new SqlParameter("@vc_Message", SqlDbType.VarChar); parm[7].Value = MobjViewprofile.StrHtmlText; parm[8] = new SqlParameter("@i_MessagelinkID", SqlDbType.BigInt); parm[8].Value = MobjViewprofile.MessageLinkId; parm[9] = new SqlParameter("@i_Cust_MessageHistory_Id", SqlDbType.BigInt); parm[9].Value = MobjViewprofile.MessageHistoryId; parm[10] = new SqlParameter("@i_LogId", SqlDbType.BigInt); parm[10].Value = MobjViewprofile.Logid; parm[11] = new SqlParameter("@i_status", SqlDbType.Int); parm[11].Direction = ParameterDirection.Output; DataSet dsMessages = new DataSet(); reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { Smtpemailsending smtp = new Smtpemailsending(); { 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; istatus = smtp.Statusint = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : 0; } li.Add(smtp); } } reader.Close(); if (MobjViewprofile.TypeofInsert == "I" || MobjViewprofile.TypeofInsert == "RP" || MobjViewprofile.TypeofInsert == "TH") { if (string.Compare(parm[11].Value.ToString(), System.DBNull.Value.ToString()) == 0) { istatus = 0; } else { istatus = Convert.ToInt32(parm[11].Value); } } if (MobjViewprofile.TypeofInsert == "M" || MobjViewprofile.TypeofInsert == "B") { Commonclass.SendMailSmtpMethod(li, "info"); } else { Commonclass.SendMailSmtpMethod(li, "exp"); } } catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), MobjViewprofile.IFromCustID, null, null); } finally { connection.Close(); //SqlConnection.ClearPool(connection); //SqlConnection.ClearAllPools(); } return(istatus); }
//New Payment Table Design Test API public int CustomerInsertPaymentDetilsInfo_New(PaymentInsertML Mobj, string spName) { int IntStatus = 0; DataSet dsPaymentDetails = new DataSet(); int? Istatus = null; int? inull = null; List <Smtpemailsending> li = new List <Smtpemailsending>(); SqlDataAdapter daPaymentDetails = new SqlDataAdapter(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { SqlCommand cmd = new SqlCommand(spName, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@dtPaymentDetails", Mobj.dtPaymentDetails); cmd.Parameters.AddWithValue("@PaysmsID", Mobj.PaysmsID); SqlParameter outputParamStatus = cmd.Parameters.Add("@Status", SqlDbType.Int); outputParamStatus.Direction = ParameterDirection.Output; SqlParameter outputParamErrorLog = cmd.Parameters.Add("@ErrorMsg", SqlDbType.VarChar, 1000); outputParamErrorLog.Direction = ParameterDirection.Output; daPaymentDetails.SelectCommand = cmd; daPaymentDetails.Fill(dsPaymentDetails); if (dsPaymentDetails != null && dsPaymentDetails.Tables.Count > 0 && dsPaymentDetails != null) { for (int i = 0; i < dsPaymentDetails.Tables[0].Rows.Count; i++) { Smtpemailsending smtp = new Smtpemailsending(); { smtp.profile_name = dsPaymentDetails.Tables[0].Columns.Contains("profile_name") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["profile_name"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["profile_name"].ToString() : string.Empty; smtp.recipients = dsPaymentDetails.Tables[0].Columns.Contains("recipients") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["recipients"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["recipients"].ToString() : string.Empty; smtp.body = dsPaymentDetails.Tables[0].Columns.Contains("body") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["body"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["body"].ToString() : string.Empty; smtp.subject = dsPaymentDetails.Tables[0].Columns.Contains("subject") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["subject"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["subject"].ToString() : string.Empty; smtp.body_format = dsPaymentDetails.Tables[0].Columns.Contains("body_format") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["body_format"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["body_format"].ToString() : string.Empty; Istatus = smtp.Status = dsPaymentDetails.Tables[0].Columns.Contains("Status") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["Status"].ToString()) ? Convert.ToInt32(dsPaymentDetails.Tables[0].Rows[i]["Status"]) : inull; } li.Add(smtp); } IntStatus = (Istatus != null && Istatus != 0) ? 1 : 0; if (Mobj.PaysmsID == 1) { Commonclass.SendMailSmtpMethod(li, "info"); Commonclass.PaymentinsertSMS(dsPaymentDetails, Mobj); } } else { if (Convert.ToInt32(cmd.Parameters[0].Value) == 1) { IntStatus = 1; } else { IntStatus = 0; } } } catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), null, null, null); } finally { connection.Close(); } if (dsPaymentDetails.Tables.Count == 0) { dsPaymentDetails = null; } return(IntStatus); }
public Tuple <List <Smtpemailsending>, int?> ExpressInterest(ExpressInterestInsert ExpML, string spName) { int?status = null; SqlDataReader reader; List <Smtpemailsending> li = new List <Smtpemailsending>(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { SqlParameter[] parm = new SqlParameter[5]; parm[0] = new SqlParameter("@cust_Id", SqlDbType.Int); parm[0].Value = ExpML.FromCustID; parm[1] = new SqlParameter("@empid", SqlDbType.BigInt); parm[1].Value = ExpML.EmpID; parm[2] = new SqlParameter("@TblDetails", SqlDbType.Structured); parm[2].Value = ExpML.dtExpInt; parm[3] = new SqlParameter("@emailaddress", SqlDbType.VarChar); parm[3].Value = ExpML.emailaddress; parm[4] = new SqlParameter("@Status", SqlDbType.Int); parm[4].Direction = ParameterDirection.Output; reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { li.Clear(); Smtpemailsending smtp = new Smtpemailsending(); { 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; } li.Add(smtp); Commonclass.SendMailSmtpMethod(li, "exp"); } } Commonclass.ExpressInterestSMS(ExpML.dtExpInt, " "); reader.Close(); } catch (Exception ex) { throw ex; } finally { connection.Close(); } return(new Tuple <List <Smtpemailsending>, int?>(li, status)); }
public int InsertExpressViewTicket(long?FromCustID, long?ToCustID, string EncriptedText, string strtypeOfReport, string spName) { int? Istatus = null; int? inull = null; SqlDataReader reader = null; int status = 0; List <Smtpemailsending> li = new List <Smtpemailsending>(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); SqlParameter[] parm = new SqlParameter[6]; try { parm[0] = new SqlParameter("@fromcust_id", SqlDbType.BigInt); parm[0].Value = FromCustID; parm[1] = new SqlParameter("@tocust_id", SqlDbType.BigInt); parm[1].Value = ToCustID; parm[2] = new SqlParameter("@EncriptedTextAccept", SqlDbType.VarChar); parm[2].Value = EncriptedText; parm[3] = new SqlParameter("@Typeofaction", SqlDbType.VarChar); parm[3].Value = strtypeOfReport; parm[4] = new SqlParameter("@Status", SqlDbType.Int); parm[4].Direction = ParameterDirection.Output; DataSet dsMessages = new DataSet(); reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { Smtpemailsending smtp = new Smtpemailsending(); { 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; Istatus = smtp.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : inull; } li.Add(smtp); } status = Istatus != null?Convert.ToInt32(Istatus) : 0; Commonclass.SendMailSmtpMethod(li, "info"); } else { if (string.Compare(System.DBNull.Value.ToString(), parm[4].Value.ToString()) == 0) { status = 0; } else { status = Convert.ToInt32(parm[4].Value); } } reader.Close(); } catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), FromCustID, null, null); } finally { connection.Close(); //SqlConnection.ClearPool(connection); //SqlConnection.ClearAllPools(); } return(status); }