/// <summary> /// S.A.Kiran /// Date : 06/08/2017 /// </summary> /// <param name="CustID">Customer login ID</param> /// <param name="PaidStatus">Login member Payment status</param> /// <param name="Startindex">Pagging starting index</param> /// <param name="EndIndex">Pagging Ending index</param> /// <param name="spName">[dbo].[usp_LandingPage_MobileApp]</param> /// <returns>Array List</returns> /// public ArrayList getMobileAppLandingDisplay(int?CustID, int?PaidStatus, int?Startindex, int?EndIndex, string spName) { ArrayList arrayList = new ArrayList(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); DataSet dtAppLanding = new DataSet(); SqlDataAdapter daMobileLanding = new SqlDataAdapter(); try { SqlCommand cmd = new SqlCommand(spName, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_CustID", CustID); cmd.Parameters.AddWithValue("@PaidStatus", PaidStatus); cmd.Parameters.AddWithValue("@iStartindex", Startindex); cmd.Parameters.AddWithValue("@iEndIndex", EndIndex); daMobileLanding.SelectCommand = cmd; daMobileLanding.Fill(dtAppLanding); } catch (Exception Ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(Ex.Message), null, null, null); } finally { connection.Close(); } return(Commonclass.convertdataTableToArrayListTable(dtAppLanding)); }
public string CustomerPaymentStatus(long?CustomerCustID, string spName) { DataSet ds = new DataSet(); string status = null; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); SqlParameter[] parm = new SqlParameter[5]; try { parm[0] = new SqlParameter("@CustID", SqlDbType.BigInt); parm[0].Value = CustomerCustID; parm[1] = new SqlParameter("@Status", SqlDbType.VarChar, 8000); parm[1].Direction = ParameterDirection.Output; ds = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, parm); status = parm[1].Value.ToString(); } catch (Exception Ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(Ex.Message), Convert.ToInt32(CustomerCustID), null, null); } finally { connection.Close(); } return(status); }
/// <summary> /// S.A.Kiran /// Date : 08/08/2017 /// </summary> /// <param name="CustID">Login customerID</param> /// <param name="Startindex">Pagging Starting index</param> /// <param name="EndIndex">Pagging Ending index</param> /// <param name="spName">[dbo].[usp_LandingOrderDisplay_MobileApp]</param> /// <returns></returns> /// public ArrayList MobileLandingOrderDisplay(long?CustID, int?Startindex, int?EndIndex, string spName) { ArrayList arrayList = new ArrayList(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); DataSet dtAssignSettings = new DataSet(); SqlDataAdapter daParentDetails = new SqlDataAdapter(); try { SqlCommand cmd = new SqlCommand(spName, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_CustID", CustID); cmd.Parameters.AddWithValue("@ipagefrom", Startindex); cmd.Parameters.AddWithValue("@ipageto", EndIndex); daParentDetails.SelectCommand = cmd; daParentDetails.Fill(dtAssignSettings); } catch (Exception Ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(Ex.Message), null, null, null); } finally { connection.Close(); } return(Commonclass.convertdataTableToArrayListTable(dtAssignSettings)); }
public ArrayList MatchFollowup_linq(string iflag, string ID, string RelationShipID, string spName) { DataSet dset = new DataSet(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { SqlParameter[] parm = new SqlParameter[5]; parm[0] = new SqlParameter("@v_dflag", SqlDbType.VarChar); parm[0].Value = iflag; parm[1] = new SqlParameter("@ID", SqlDbType.VarChar); parm[1].Value = ID; parm[2] = new SqlParameter("@RelationShipID", SqlDbType.VarChar); parm[2].Value = RelationShipID; dset = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, parm); } catch (Exception ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), Convert.ToInt32(ID), null, null); } finally { connection.Close(); } return(Commonclass.convertdataTableToArrayListTable(dset)); }
public ArrayList CustomermissindDatagetting(long?CustomerCustID, string strSpname) { DataSet dsMissingfields = new DataSet(); SqlDataAdapter daParentDetails = new SqlDataAdapter(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { SqlCommand cmd = new SqlCommand(strSpname, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CustomerCustID", CustomerCustID); daParentDetails.SelectCommand = cmd; daParentDetails.Fill(dsMissingfields); } catch (Exception Ex) { Commonclass.ApplicationErrorLog(strSpname, Convert.ToString(Ex.Message), @CustomerCustID, null, null); } finally { connection.Close(); } return(Commonclass.convertdataTableToArrayList(dsMissingfields)); }
public DataSet ExpressInterest_SendSms(string FromProfileID, string ToProfileIDs, string spName) { DataSet ds = new DataSet(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); DataTable dt = new DataTable(); try { SqlParameter[] parm = new SqlParameter[4]; parm[0] = new SqlParameter("@v_FromProfileID", SqlDbType.VarChar, 8000); parm[0].Value = FromProfileID; parm[1] = new SqlParameter("@v_ToProfileIDs", SqlDbType.VarChar, 8000); parm[1].Value = ToProfileIDs; ds = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, parm); } catch (Exception ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), Convert.ToInt32(FromProfileID), null, null); } finally { connection.Close(); } return(ds); }
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 List <PartnerProfilesLatest> ExpressInterestSelectDal(DashboardRequest Dreq) { List <PartnerProfilesLatest> PartnerLi = new List <PartnerProfilesLatest>(); SqlDataReader reader; SqlConnection connection = null; try { SqlParameter[] parm = new SqlParameter[6]; parm[0] = new SqlParameter("@custId", SqlDbType.Int); parm[0].Value = Dreq.IntCustID; parm[1] = new SqlParameter("@typeofData", SqlDbType.VarChar); parm[1].Value = Dreq.TypeOfReport; parm[2] = new SqlParameter("@yourFilter", SqlDbType.VarChar); parm[2].Value = Dreq.yourFilter; parm[3] = new SqlParameter("@oppfilter", SqlDbType.VarChar); parm[3].Value = Dreq.oppfilter; parm[4] = new SqlParameter("@pagefrom", SqlDbType.Int); parm[4].Value = Dreq.pagefrom; parm[5] = new SqlParameter("@pageto", SqlDbType.Int); parm[5].Value = Dreq.pageto; using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString())) { connection.Open(); reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, "[dbo].[usp_select_customerDashboard_ExpressInterest]", parm); if (reader.HasRows) { while (reader.Read()) { PartnerProfilesLatest Partnercls = ReturnPartnerProfilesClass(reader, "ExpressInterest"); PartnerLi.Add(Partnercls); } } reader.Close(); } } catch (Exception ex) { Commonclass.ApplicationErrorLog("[dbo].[usp_select_customerDashboard_ExpressInterest]", Convert.ToString(ex.Message), Dreq.IntCustID, null, null); } finally { connection.Close(); //SqlConnection.ClearPool(connection); //SqlConnection.ClearAllPools(); } return(PartnerLi); }
public VerifiedContactInformationML DgetMobileEmailVerification(long?CustID) { VerifiedContactInformationML verification = null; SqlDataReader reader; bool? bnull = null; int? iNull = null; Int64? iNull64 = null; SqlConnection con = null; try { SqlParameter[] parm = new SqlParameter[6]; parm[0] = new SqlParameter("@CustID", SqlDbType.BigInt); parm[0].Value = CustID; parm[1] = new SqlParameter("@Status", SqlDbType.Int); parm[1].Direction = ParameterDirection.Output; using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString())) { con.Open(); reader = SQLHelper.ExecuteReader(con, CommandType.StoredProcedure, "[dbo].[Usp_GetContactVerificationForCustomer]", parm); if (reader.HasRows) { while (reader.Read()) { verification = new VerifiedContactInformationML(); { verification.Number = reader["Number"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Number")) : null; verification.Email = reader["Email"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Email")) : null; verification.ismobileverf = reader["ismobileverf"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("ismobileverf")) : bnull; verification.isEmailverf = reader["isEmailverf"] != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("isEmailverf")) : bnull; verification.CountryCodeID = reader["CountryCodeID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("CountryCodeID")) : iNull; verification.CountryCodes = reader["CountryCodes"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("CountryCodes")) : null; verification.Cust_ContactNumbers_ID = reader["Cust_ContactNumbers_ID"] != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_ContactNumbers_ID")) : iNull64; verification.NumberVerificationcode = reader["NumberVerificationcode"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("NumberVerificationcode")) : null; } } } reader.Close(); } } catch (Exception ex) { Commonclass.ApplicationErrorLog("[dbo].[Usp_GetContactVerificationForCustomer]", Convert.ToString(ex.Message), Convert.ToInt32(CustID), null, null); } finally { con.Close(); } return(verification); }
public static void SendMailSmtpMethod(List <Smtpemailsending> list, string fromemail) { try { string Password = string.Empty; string StrFromMail = ConfigurationManager.AppSettings["SendTutoringHoursFromMails"].ToString(); string StrFromInfoMail = ConfigurationManager.AppSettings["StrFromInfoMail"].ToString(); string StrPassword = ConfigurationManager.AppSettings["Password"].ToString(); string StrInfoPassword = ConfigurationManager.AppSettings["infoPassword"].ToString(); for (int i = 0; i < list.Count; i++) { string[] toemails = list[i].recipients.Split(';'); MailMessage mailmessage = new MailMessage(); foreach (string str in toemails) { if (!string.IsNullOrEmpty(str) && str.Length > 0) { mailmessage.To.Add(str); } } if (fromemail == "exp") { mailmessage.From = new MailAddress(StrFromMail); Password = StrPassword; } else { mailmessage.From = new MailAddress(StrFromInfoMail); Password = StrInfoPassword; } mailmessage.Subject = list[i].subject; mailmessage.Body = list[i].body; mailmessage.IsBodyHtml = true; SendMail(mailmessage, Password); } } catch (Exception EX) { Commonclass.ApplicationErrorLog("SendMailSmtpMethod", Convert.ToString(EX.Message), null, null, null); } finally { // SqlConnection.ClearAllPools(); } }
public DashboardClass GetPartnerProfilesDal(int?CustID, string TypeOfReport, int pagefrom, int pageto, string spName) { DashboardClass land = new DashboardClass(); List <PartnerProfilesLatest> PartnerLi = new List <PartnerProfilesLatest>(); SqlDataReader reader; SqlConnection con = null; try { SqlParameter[] parm = new SqlParameter[6]; parm[0] = new SqlParameter("@custID", SqlDbType.Int); parm[0].Value = CustID; parm[1] = new SqlParameter("@TypeOfReport", SqlDbType.VarChar); parm[1].Value = TypeOfReport; parm[2] = new SqlParameter("@pagefrom", SqlDbType.Int); parm[2].Value = pagefrom; parm[3] = new SqlParameter("@pageto", SqlDbType.Int); parm[3].Value = pageto; using (con = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString())) { con.Open(); reader = SQLHelper.ExecuteReader(con, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { PartnerProfilesLatest Partnercls = ReturnPartnerProfilesClass(reader, "Partner"); PartnerLi.Add(Partnercls); } land.PartnerProfilesnew = PartnerLi; } reader.Close(); } } catch (Exception ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), CustID, null, null); } finally { con.Close(); //SqlConnection.ClearPool(con); //SqlConnection.ClearAllPools(); } return(land); }
public ArrayList DgetProfilePaymentDetails(long?intProfileID, int?Isonline, int?flag, int?intMembershipID, string taxpaid) { int? intStatus = 0; DataSet dsPayment = new DataSet(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); SqlParameter[] parm = new SqlParameter[7]; try { parm[0] = new SqlParameter("@ProfileID", SqlDbType.BigInt); parm[0].Value = intProfileID; parm[1] = new SqlParameter("@flag", SqlDbType.Int); parm[1].Value = flag; parm[2] = new SqlParameter("@MemberShipID", SqlDbType.Int); parm[2].Value = intMembershipID; parm[3] = new SqlParameter("@Isonline", SqlDbType.Int); parm[3].Value = Isonline; parm[4] = new SqlParameter("@Status", SqlDbType.Int); parm[4].Direction = ParameterDirection.Output; parm[5] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000); parm[5].Direction = ParameterDirection.Output; parm[6] = new SqlParameter("@taxpaid", SqlDbType.VarChar, 1000); parm[6].Value = taxpaid; dsPayment = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "usp_Payment_getProfilePaymentDetails", parm); if (string.Compare(System.DBNull.Value.ToString(), parm[4].Value.ToString()) == 0) { intStatus = 0; } else { intStatus = Convert.ToInt32(parm[4].Value); } } catch (Exception EX) { Commonclass.ApplicationErrorLog("usp_Payment_getProfilePaymentDetails", Convert.ToString(EX.Message), Convert.ToInt32(intProfileID), null, null); } finally { connection.Close(); } if (dsPayment.Tables.Count == 0) { dsPayment = null; } return(Commonclass.convertdataTableToArrayList(dsPayment)); }
public int InsertPaymentDetails(PaymentMasterMl Mobj, string spName) { int intStatus = 0; DataSet dset = new DataSet(); SqlParameter[] parm = new SqlParameter[8]; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { parm[0] = new SqlParameter("@custID", SqlDbType.BigInt); parm[0].Value = Mobj.intCustID; parm[1] = new SqlParameter("@MembershipID", SqlDbType.BigInt); parm[1].Value = Mobj.intMembershipID; parm[2] = new SqlParameter("@MembershipDiscountID", SqlDbType.BigInt); parm[2].Value = Mobj.DiscountID; parm[3] = new SqlParameter("@Points", SqlDbType.Int); parm[3].Value = Mobj.Points; parm[4] = new SqlParameter("@MembershipName", SqlDbType.VarChar, 100); parm[4].Value = Mobj.MembershipName; parm[5] = new SqlParameter("@Duration", SqlDbType.Int); parm[5].Value = Mobj.Duration; parm[6] = new SqlParameter("@Amount", SqlDbType.VarChar, 100); parm[6].Value = Mobj.MembershipAmount; parm[7] = new SqlParameter("@Status", SqlDbType.Int); parm[7].Direction = ParameterDirection.Output; dset = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, parm); if (string.Compare(System.DBNull.Value.ToString(), parm[7].Value.ToString()) == 0) { intStatus = 0; } else { intStatus = Convert.ToInt32(parm[7].Value); } } catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Convert.ToInt32(Mobj.intCustID), null, null); } finally { connection.Close(); } return(intStatus); }
//Logged as Customers public string BgetPassword(string Username) { DataSet dsSet = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter(); string strResult = null; string strPassword = null; string DecPassword = null; int status = 0; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { SqlCommand cmd = new SqlCommand("[dbo].[Usp_GetPasswordforlogged]", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@profileid", Username); SqlParameter outputParamStatus = cmd.Parameters.Add("@status", SqlDbType.Int); outputParamStatus.Direction = ParameterDirection.Output; dataAdapter.SelectCommand = cmd; dataAdapter.Fill(dsSet); if (Convert.ToInt32(cmd.Parameters[1].Value) == 0) { status = 0; } else { status = Convert.ToInt32(cmd.Parameters[1].Value); } if (dsSet != null && dsSet.Tables.Count > 0) { strPassword = !string.IsNullOrEmpty(dsSet.Tables[0].Rows[0]["Password"].ToString()) ? dsSet.Tables[0].Rows[0]["Password"].ToString() : null; DecPassword = !string.IsNullOrEmpty(strPassword) ? Commonclass.Decrypt(strPassword) : null; } } catch (Exception Ex) { Commonclass.ApplicationErrorLog("Usp_GetPasswordforlogged", Convert.ToString(Ex.Message), null, null, null); } finally { connection.Close(); } // return Commonclass.convertdataTableToArrayList(dsSet); strResult = "Password :"******";" + "DecPassword :" + DecPassword; SqlConnection.ClearAllPools(); return(strResult); }
public List <CountryDependency> getDropdownValues_dependency_injection(string dependencyName, string dependencyValue, string dependencyflagID, string Spname) { List <CountryDependency> Dependency = new List <CountryDependency>(); SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString()); connection.Open(); try { SqlCommand command = new SqlCommand(Spname, connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@v_dflag", dependencyName); command.Parameters.AddWithValue("@dependencyID", dependencyValue); command.Parameters.AddWithValue("@dependencyflagID", dependencyflagID); SqlDataReader reader; reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { CountryDependency CD = new CountryDependency { ID = (reader["ID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ID")) : 0, Name = (reader["Name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Name")) : null, }; Dependency.Add(CD); } } reader.Close(); } catch (Exception EX) { Commonclass.ApplicationErrorLog(Spname, Convert.ToString(EX.Message), null, null, null); } finally { connection.Close(); //SqlConnection.ClearPool(connection); //SqlConnection.ClearAllPools(); } return(Dependency); }
public Servicedates getServiceInfoDal(string FromProfileID, string ToProfileID, string spName) { DataSet ds = new DataSet(); SqlDataReader reader; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); Servicedates servicedate = new Servicedates(); connection.Open(); int status = 0; try { SqlParameter[] parm = new SqlParameter[3]; parm[0] = new SqlParameter("@FromProfileID", SqlDbType.VarChar, 8000); parm[0].Value = FromProfileID; parm[1] = new SqlParameter("@ToProfileID", SqlDbType.VarChar, 8000); parm[1].Value = ToProfileID; parm[2] = new SqlParameter("@Status", SqlDbType.Int); parm[2].Direction = ParameterDirection.Output; reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { servicedate.Servicedate = (reader["ServiceDate"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ServiceDate")) : string.Empty; servicedate.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : status; } } } catch (Exception ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(ex.Message), Convert.ToInt32(FromProfileID), null, null); } finally { connection.Close(); } return(servicedate); }
public ArrayList DgetProfilePaymentDetails_NewDesigns(string intProfileID, int intPaymentHistID, string spName) { int? intStatus = 0; DataSet dsPayment = new DataSet(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); SqlParameter[] parm = new SqlParameter[4]; try { parm[0] = new SqlParameter("@ProfileID", SqlDbType.BigInt); parm[0].Value = !string.IsNullOrEmpty(intProfileID) ? Convert.ToInt64(intProfileID) : 0; parm[1] = new SqlParameter("@intPaymentHistID", SqlDbType.Int); parm[1].Value = intPaymentHistID; parm[2] = new SqlParameter("@Status", SqlDbType.Int); parm[2].Direction = ParameterDirection.Output; parm[3] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000); parm[3].Direction = ParameterDirection.Output; dsPayment = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, parm); if (string.Compare(System.DBNull.Value.ToString(), parm[1].Value.ToString()) == 0) { intStatus = 0; } else { intStatus = Convert.ToInt32(parm[1].Value); } } catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Convert.ToInt32(intProfileID), null, null); } finally { connection.Close(); } if (dsPayment.Tables.Count == 0) { dsPayment = null; } return(Commonclass.convertdataTableToArrayList(dsPayment)); }
public int UpdateEmplogintoCustomersiteDal(int empid, string ProfileID, string Narration, string spname) { ArrayList arrayList = new ArrayList(); SqlParameter[] parm = new SqlParameter[4]; SqlDataReader reader = null; int intStatus = 0; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { parm[0] = new SqlParameter("@EmpID", SqlDbType.Int); parm[0].Value = empid; parm[1] = new SqlParameter("@ProfileID", SqlDbType.VarChar); parm[1].Value = ProfileID; parm[2] = new SqlParameter("@Narration", SqlDbType.VarChar); parm[2].Value = Narration; parm[3] = new SqlParameter("@Status", SqlDbType.Int); parm[3].Direction = ParameterDirection.Output; reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spname, parm); reader.Close(); if (string.Compare(parm[3].Value.ToString(), System.DBNull.Value.ToString()) != 0) { intStatus = Convert.ToInt32(parm[3].Value); } else { intStatus = 0; } } catch (Exception EX) { Commonclass.ApplicationErrorLog(spname, Convert.ToString(EX.Message), Convert.ToInt64(ProfileID), null, null); } finally { connection.Close(); } return(intStatus); }
public int DgetCustomerRegProfileDetails_Myprofile(UpdatePersonaldetails Mobj, string spName) { ArrayList arrayList = new ArrayList(); SqlParameter[] parm = new SqlParameter[5]; SqlDataReader reader = null; int intStatus = 0; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { parm[0] = new SqlParameter("@CustomerID", SqlDbType.Int); parm[0].Value = Mobj.intCusID; parm[1] = new SqlParameter("@t_CustProfileDetails", SqlDbType.Structured); parm[1].Value = Mobj.dtTableValues; parm[2] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000); parm[2].Direction = ParameterDirection.Output; parm[3] = new SqlParameter("@i_Status", SqlDbType.Int); parm[3].Direction = ParameterDirection.Output; reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); reader.Close(); if (string.Compare(parm[3].Value.ToString(), System.DBNull.Value.ToString()) != 0) { intStatus = Convert.ToInt32(parm[3].Value); } else { intStatus = 0; } } catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Mobj.intCusID, null, null); } finally { connection.Close(); } return(intStatus); }
//internal int setPaymentAuthorizationDal(DataTable dt, string spname) //{ // int intStatus = 0; // DataSet dsPayment = new DataSet(); // SqlConnection connection = new SqlConnection(); // connection = SQLHelper.GetSQLConnection(); // connection.Open(); // SqlParameter[] parm = new SqlParameter[7]; // try // { // parm[0] = new SqlParameter("@dtPaymentAuthDetails", SqlDbType.Structured); // parm[0].Value = dt; // parm[1] = new SqlParameter("@Status", SqlDbType.Int); // parm[1].Direction = ParameterDirection.Output; // parm[2] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000); // parm[2].Direction = ParameterDirection.Output; // dsPayment = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spname, parm); // if (Convert.ToInt32(parm[1].Value) == 1) // { intStatus = 1; } // else // { intStatus = 2; } // } // catch (Exception EX) { Commonclass.ApplicationErrorLog(spname, Convert.ToString(EX.Message), null, null, null); } // finally // { // connection.Close(); // SqlConnection.ClearPool(connection); // SqlConnection.ClearAllPools(); // } // if (dsPayment.Tables.Count == 0) // dsPayment = null; // return intStatus; //} public int setPaymentAuthorizationDal(DataTable dt, string spname) { int intStatus = 0; DataSet dsPayment = new DataSet(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); SqlParameter[] parm = new SqlParameter[7]; try { parm[0] = new SqlParameter("@dtPaymentAuthDetails", SqlDbType.Structured); parm[0].Value = dt; parm[1] = new SqlParameter("@Status", SqlDbType.Int); parm[1].Direction = ParameterDirection.Output; parm[2] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000); parm[2].Direction = ParameterDirection.Output; dsPayment = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spname, parm); if (Convert.ToInt32(parm[1].Value) == 1) { intStatus = 1; } else { intStatus = 2; } } catch (Exception EX) { Commonclass.ApplicationErrorLog(spname, Convert.ToString(EX.Message), null, null, null); } finally { connection.Close(); } if (dsPayment.Tables.Count == 0) { dsPayment = null; } return(intStatus); }
public ArrayList DGetloginCustinformation(string Username, string Password, int?iflag) { DataSet dataSet = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); int status = 0; try { SqlCommand cmd = new SqlCommand("[dbo].[Usp_CheckCustLogin]", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Username", Username); cmd.Parameters.AddWithValue("@Password", Password); cmd.Parameters.AddWithValue("@iflag", iflag); SqlParameter outputParamStatus = cmd.Parameters.Add("@Status", SqlDbType.Int); outputParamStatus.Direction = ParameterDirection.Output; dataAdapter.SelectCommand = cmd; dataAdapter.Fill(dataSet); if (Convert.ToInt32(cmd.Parameters[2].Value) == 1) { status = 1; } else { status = 0; } } catch (Exception EX) { Commonclass.ApplicationErrorLog("Usp_CheckCustLogin", Convert.ToString(EX.Message), null, null, null); } finally { connection.Close(); } return(Commonclass.convertdataTableToArrayList(dataSet)); }
public int CheckUserPwd(string Username, string Password) { DataSet ds = new DataSet(); int intstatus = 0; SqlDataAdapter da = new SqlDataAdapter(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { SqlCommand cmd = new SqlCommand("[dbo].[usp_checkuserpwd]", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userid", Username); cmd.Parameters.AddWithValue("@Password", Commonclass.Encrypt(Password)); SqlParameter outputParamStatus = cmd.Parameters.Add("@Status", SqlDbType.Int); outputParamStatus.Direction = ParameterDirection.Output; da.SelectCommand = cmd; da.Fill(ds); if (Convert.ToInt32(cmd.Parameters[2].Value) == 1) { intstatus = 1; } else { intstatus = 0; } } catch (Exception EX) { Commonclass.ApplicationErrorLog("[dbo].[usp_checkuserpwd]", Convert.ToString(EX.Message), null, null, null); } finally { connection.Close(); } return(intstatus); }
public static int?GetProfileIDCustID(int?iflagEmailmobile, string EmailMobile) { int? iStatus = 0; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { DataSet ds = new DataSet(); SqlParameter[] parm = new SqlParameter[5]; parm[0] = new SqlParameter("@i_flag", SqlDbType.Int); parm[0].Value = iflagEmailmobile; parm[1] = new SqlParameter("@v_EmailMobile", SqlDbType.VarChar); parm[1].Value = EmailMobile; parm[2] = new SqlParameter("@i_Status", SqlDbType.Int); parm[2].Direction = ParameterDirection.Output; ds = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "[dbo].[usp_EmailMobilenumberexists_NewDesign]", parm); if (string.Compare(parm[2].Value.ToString(), System.DBNull.Value.ToString()) == 0) { iStatus = 0; } else { iStatus = Convert.ToInt32(parm[2].Value); } } catch (Exception ex) { Commonclass.ApplicationErrorLog("[dbo].[usp_EmailMobilenumberexists_NewDesign]", Convert.ToString(ex.Message), null, null, null); } finally { connection.Close(); //SqlConnection.ClearPool(connection); //SqlConnection.ClearAllPools(); } return(iStatus); }
public DataTable Bgepay_RegionProfileID(string strProfileID) { DataTable dset = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); SqlCommand cmd = new SqlCommand("[dbo].[usp_pay_Region]", connection); cmd.CommandType = CommandType.StoredProcedure; try { cmd.Parameters.AddWithValue("@ProfileID", strProfileID); da.SelectCommand = cmd; da.Fill(dset); } catch (Exception EX) { Commonclass.ApplicationErrorLog("usp_pay_Region", Convert.ToString(EX.Message), null, null, null); } finally { connection.Close(); } return(dset); }
/// <summary> /// S.A.Kiran /// Date : 07/08/2017 /// </summary> /// <param name="Mobj">Obj for Mobj.CustID Customer Loginid </param> /// Mobj.Email Update Customer Email /// Mobj.MobileNumber Mobile Number /// Mobj.VerificationCode Mobile Code /// Mobj.isVerified 0 or 1 /// <param name="spName">[dbo].[usp_EmailmobileUpdate_MobileApp]</param> /// <returns>Array List </returns> public ArrayList UpdateCustomerEmailMobileNumber_Verification(MobileEmailVerf Mobj, string spName) { ArrayList arrayList = new ArrayList(); SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); DataSet dtAssignSettings = new DataSet(); SqlDataAdapter daParentDetails = new SqlDataAdapter(); try { SqlCommand cmd = new SqlCommand(spName, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_CustID", Mobj.CustID); cmd.Parameters.AddWithValue("@v_Email", Mobj.Email); cmd.Parameters.AddWithValue("@v_MobileNumber", Mobj.MobileNumber); cmd.Parameters.AddWithValue("@i_CountryCode", Mobj.CountryCode); cmd.Parameters.AddWithValue("@v_VerificationCode", Mobj.VerificationCode); cmd.Parameters.AddWithValue("@isVerified", Mobj.isVerified); daParentDetails.SelectCommand = cmd; daParentDetails.Fill(dtAssignSettings); } catch (Exception Ex) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(Ex.Message), null, null, null); } finally { connection.Close(); } return(Commonclass.convertdataTableToArrayListTable(dtAssignSettings)); }
public ArrayList ProfilePaymentDetails_Gridview(string intProfileID, string spName) { ArrayList arrayList = new ArrayList(); SqlParameter[] parm = new SqlParameter[10]; SqlDataReader reader; int? iNull = null; decimal?idecimal = null; Int64? lNull = null; ProfilePaymentGridView MobjpaymentGridview = null; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { parm[0] = new SqlParameter("@ProfileID", SqlDbType.VarChar); parm[0].Value = intProfileID; parm[1] = new SqlParameter("@Status", SqlDbType.Int); parm[1].Direction = ParameterDirection.Output; parm[2] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000); parm[2].Direction = ParameterDirection.Output; reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { MobjpaymentGridview = new ProfilePaymentGridView(); MobjpaymentGridview.ProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null; MobjpaymentGridview.Type = (reader["Type"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Type")) : null; MobjpaymentGridview.membershiptype = (reader["membershiptype"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("membershiptype")) : null; MobjpaymentGridview.AgreedAmount = (reader["AgreedAmount"]) != DBNull.Value ? reader.GetDecimal(reader.GetOrdinal("AgreedAmount")) : idecimal; MobjpaymentGridview.PaidAmount = (reader["PaidAmount"]) != DBNull.Value ? reader.GetDecimal(reader.GetOrdinal("PaidAmount")) : idecimal; MobjpaymentGridview.PaymentDate = (reader["PaymentDate"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("PaymentDate")) : null; MobjpaymentGridview.ExpiryDate = (reader["ExpiryDate"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ExpiryDate")) : null; MobjpaymentGridview.Allowed = (reader["Allowed"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Allowed")) : iNull; MobjpaymentGridview.Used = (reader["Used"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Used")) : iNull; MobjpaymentGridview.CreatedByEmpID = (reader["CreatedByEmpID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("CreatedByEmpID")) : null; MobjpaymentGridview.Description = (reader["Description"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Description")) : null; MobjpaymentGridview.Status = (reader["Status"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Status")) : null; MobjpaymentGridview.StatusBy = (reader["StatusBy"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("StatusBy")) : null; MobjpaymentGridview.PaymentID = (reader["Payment_ID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Payment_ID")) : iNull; MobjpaymentGridview.CustName = (reader["CustName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("CustName")) : null; MobjpaymentGridview.ProfileOwner = (reader["ProfileOwner"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileOwner")) : null; MobjpaymentGridview.TaxPaid_Status = (reader["TaxPaid_Status"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("TaxPaid_Status")) : null; MobjpaymentGridview.RenewalStatus = (reader["RenewalStatus"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("RenewalStatus")) : iNull; MobjpaymentGridview.PaymentHist_ID = (reader["PaymentHist_ID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PaymentHist_ID")) : iNull; MobjpaymentGridview.CustId = (reader["Cust_ID"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("Cust_ID")) : lNull; MobjpaymentGridview.PaidStatus = (reader["PaidStatus"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PaidStatus")) : iNull; // MobjpaymentGridview.SAForm = (reader["SAForm"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("SAForm")) : null; MobjpaymentGridview.SettlementAmt = (reader["SettlementAmt"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("SettlementAmt")) : null; arrayList.Add(MobjpaymentGridview); } } reader.Close(); } catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), null, null, null); } finally { connection.Close(); } return(arrayList); }
//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 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); }
public List <Paymentselect> GetPaymentDetails(long?CustID, string spName) { SqlParameter[] parm = new SqlParameter[3]; SqlDataReader reader = null; List <Paymentselect> arrayList = new List <Paymentselect>(); int? intnull = null; double? floatnull = null; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { parm[0] = new SqlParameter("@i_FromCustID", SqlDbType.BigInt); parm[0].Value = CustID; reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm); if (reader.HasRows) { while (reader.Read()) { Paymentselect payment = new Paymentselect(); { payment.MembershipName = reader["MembershipName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MembershipName")) : null; payment.Emp_Membership_ID = reader["Emp_Membership_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Emp_Membership_ID")) : intnull; payment.MemberShipDuration = reader["MemberShipDuration"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MemberShipDuration")) : intnull; payment.Cust_MemberShip_Discount_ID = reader["Cust_MemberShip_Discount_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Cust_MemberShip_Discount_ID")) : intnull; payment.DiscountAmount = reader["DiscountAmount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("DiscountAmount")) : intnull; payment.AllottedServicePoints = reader["AllottedServicePoints"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AllottedServicePoints")) : intnull; payment.MembershipAmount = reader["MembershipAmount"] != DBNull.Value ? reader.GetDouble(reader.GetOrdinal("MembershipAmount")) : floatnull; payment.onlineaccess = reader["onlineaccess"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("onlineaccess")) : null; payment.offlineaccess = reader["offlineaccess"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("offlineaccess")) : null; payment.Ppluspath = reader["Ppluspath"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Ppluspath")) : null; payment.Ppath = reader["Ppath"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("Ppath")) : null; } arrayList.Add(payment); } } reader.NextResult(); if (reader.HasRows) { while (reader.Read()) { Paymentselect payment = new Paymentselect(); { payment.MembershipName = reader["MembershipName"] != DBNull.Value ? reader.GetString(reader.GetOrdinal("MembershipName")) : null; payment.Emp_Membership_ID = reader["Emp_Membership_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Emp_Membership_ID")) : intnull; payment.MemberShipDuration = reader["MemberShipDuration"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MemberShipDuration")) : intnull; payment.Cust_MemberShip_Discount_ID = reader["Cust_MemberShip_Discount_ID"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Cust_MemberShip_Discount_ID")) : intnull; payment.DiscountAmount = reader["DiscountAmount"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("DiscountAmount")) : intnull; payment.AllottedServicePoints = reader["AllottedServicePoints"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AllottedServicePoints")) : intnull; payment.AccessFeature = reader["AccessFeature"] != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("AccessFeature")) : intnull; payment.MembershipAmount = reader["MembershipAmount"] != DBNull.Value ? reader.GetDouble(reader.GetOrdinal("MembershipAmount")) : floatnull; } arrayList.Add(payment); } } reader.Close(); } catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), CustID, null, null); } finally { connection.Close(); } return(arrayList); }