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