public int InsertCustomerExpressinterest(int?fromcustid, int?tocustid, long?logID, string interstTYpe, int?empid, string spName)
{
SqlParameter[] parm = new SqlParameter[12];
Smtpemailsending smtp = new Smtpemailsending();
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlDataReader reader;
int status = 0;
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
parm[0] = new SqlParameter("@fromcustid", SqlDbType.Int);
parm[0].Value = fromcustid;
parm[1] = new SqlParameter("@tocustid", SqlDbType.Int);
parm[1].Value = tocustid;
parm[2] = new SqlParameter("@logID", SqlDbType.BigInt);
parm[2].Value = logID;
parm[3] = new SqlParameter("@interstTYpe", SqlDbType.VarChar);
parm[3].Value = interstTYpe;
parm[4] = new SqlParameter("@status", SqlDbType.Int);
parm[4].Direction = ParameterDirection.Output;
parm[5] = new SqlParameter("@empid", SqlDbType.Int);
parm[5].Value = empid;
DataSet dsMessages = new DataSet();
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
smtp.recipients = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
smtp.body = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
smtp.subject = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
smtp.body_format = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
smtp.Statusint = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : 0;
li.Add(smtp);
}
}
status = reader.HasRows == true ? smtp.Statusint : 1;
Commonclass.SendMailSmtpMethod(li, "exp");
reader.Close();
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), fromcustid, null, null);
}
finally
{
connection.Close();
//SqlConnection.ClearPool(connection);
//SqlConnection.ClearAllPools();
}
return(status);
}
public ArrayList EmployeeRegisterCustomerHomepages_Brokerentry(PrimaryInformationMl Mobj, string spName)
{
SqlParameter[] parm = new SqlParameter[30];
int status = 0;
ArrayList arrayList = new ArrayList();
SqlDataReader reader;
List <Smtpemailsending> li = new List <Smtpemailsending>();
Smtpemailsending smtp = new Smtpemailsending();
int? intStatus = 0;
DateTime dtTime = DateTime.ParseExact(Mobj.dtDOB, "dd-MM-yyyy", null);
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
string strMobileVerificationCode = (new Random()).Next(10000, 99999).ToString();
try
{
parm[0] = new SqlParameter("@CasteID", SqlDbType.Int);
parm[0].Value = Mobj.intCasteID;
parm[1] = new SqlParameter("@CountryID", SqlDbType.Int);
parm[1].Value = Mobj.intCountryLivingID;
parm[2] = new SqlParameter("@GenderID", SqlDbType.Int);
parm[2].Value = Mobj.intGenderID;
parm[3] = new SqlParameter("@MobileCode", SqlDbType.Int);
parm[3].Value = Mobj.intMobileCode;
parm[4] = new SqlParameter("@LandCode", SqlDbType.Int);
parm[4].Value = Mobj.intLandCode;
parm[5] = new SqlParameter("@MotherTongueID", SqlDbType.Int);
parm[5].Value = Mobj.intMotherTongueID;
parm[6] = new SqlParameter("@ReligionID", SqlDbType.Int);
parm[6].Value = Mobj.intReligionID;
parm[7] = new SqlParameter("@AreaCode", SqlDbType.VarChar);
parm[7].Value = Mobj.strAreaCode;
parm[8] = new SqlParameter("@Email", SqlDbType.VarChar);
parm[8].Value = Mobj.strEmail;
parm[9] = new SqlParameter("@FirstName", SqlDbType.VarChar);
parm[9].Value = Mobj.strFirstName;
parm[10] = new SqlParameter("@LandNo", SqlDbType.VarChar);
parm[10].Value = Mobj.strLandNo;
parm[11] = new SqlParameter("@LastName", SqlDbType.VarChar);
parm[11].Value = Mobj.strLastName;
parm[12] = new SqlParameter("@MobileNo", SqlDbType.VarChar);
parm[12].Value = Mobj.strMobileNo;
parm[13] = new SqlParameter("@Password", SqlDbType.VarChar);
parm[13].Value = Commonclass.Encrypt(Mobj.strPassword);
parm[14] = new SqlParameter("@DateOfBirth", SqlDbType.DateTime);
// parm[14].Value = Mobj.dtDOB;
parm[14].Value = dtTime;
parm[15] = new SqlParameter("@Status", SqlDbType.Int);
parm[15].Direction = ParameterDirection.Output;
parm[16] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000);
parm[16].Direction = ParameterDirection.Output;
parm[17] = new SqlParameter("@Rowcount", SqlDbType.Int);
parm[17].Direction = ParameterDirection.Output;
parm[18] = new SqlParameter("@ProfileRegisteredBy", SqlDbType.Int);
parm[18].Value = Mobj.intProfileRegisteredBy;
parm[19] = new SqlParameter("@KMPLID", SqlDbType.VarChar);
parm[19].Value = Mobj.strKMPLID;
parm[20] = new SqlParameter("@MobileVerificationCode", SqlDbType.VarChar);
parm[20].Value = strMobileVerificationCode;
parm[21] = new SqlParameter("@EmpID", SqlDbType.BigInt);
parm[21].Value = Mobj.intEmpID;
parm[22] = new SqlParameter("@ID", SqlDbType.Int);
parm[22].Value = Mobj.ID;
parm[23] = new SqlParameter("@IsCustomer", SqlDbType.Int);
parm[23].Value = Mobj.IsCustomer;
parm[24] = new SqlParameter("@IsCustomerPostedBY", SqlDbType.Int);
parm[24].Value = Mobj.intCustPostedBY;
parm[25] = new SqlParameter("@intSubCasteID", SqlDbType.Int);
parm[25].Value = Mobj.intSubCasteID;
parm[26] = new SqlParameter("@BrokerNameID", SqlDbType.Int);
parm[26].Value = Mobj.BrokerNameID;
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
if (reader.Read())
{
smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
smtp.recipients = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
smtp.body = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
smtp.subject = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
smtp.body_format = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
smtp.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : status;
smtp.CustID = (reader["Cust"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Cust")) : 0;
smtp.ProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : string.Empty;
li.Add(smtp);
arrayList.Add(smtp);
}
}
if (Mobj.intEmpID == null)
{
Commonclass.SendMailSmtpMethod(li, "info");
}
intStatus = smtp.Status;
reader.Close();
if (intStatus.Equals(1))
{
ServiceSoapClient cc = new ServiceSoapClient();
try
{
string result = cc.SendTextSMS("ykrishna", "summary$1", Mobj.strMobileNo.ToString().Trim(), "Hi " + Mobj.strFirstName + ", Your verification code with www.kaakateeya.com is " + strMobileVerificationCode + " Please enter this code to confirm your Registration.", "smscntry");
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, (Convert.ToString(EX.Message) + "send Sms Error"), Mobj.intCusID, null, null);
}
}
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Mobj.intCusID, null, null);
}
finally
{
connection.Close();
}
return(arrayList);
}
public int getCustomerServiceDal(CustSearchMl MobjViewprofile, string spName)
{
SqlParameter[] parm = new SqlParameter[14];
int istatus = 0;
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlDataReader reader;
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
parm[0] = new SqlParameter("@fromcustid", SqlDbType.Int);
parm[0].Value = MobjViewprofile.IFromCustID;
parm[1] = new SqlParameter("@toCustID", SqlDbType.Int);
parm[1].Value = MobjViewprofile.IToCustID;
parm[2] = new SqlParameter("@TypeofInsert", SqlDbType.VarChar);
parm[2].Value = MobjViewprofile.TypeofInsert;
parm[3] = new SqlParameter("@i_Acceptlink", SqlDbType.VarChar);
parm[3].Value = MobjViewprofile.EncriptedText;
parm[4] = new SqlParameter("@i_Rejectlink", SqlDbType.VarChar);
parm[4].Value = MobjViewprofile.EncryptedRejectFlagText;
parm[5] = new SqlParameter("@i_RVRAcceptlink", SqlDbType.VarChar);
parm[5].Value = MobjViewprofile.EncriptedTextrvr;
parm[6] = new SqlParameter("@i_RVRRejectlink", SqlDbType.VarChar);
parm[6].Value = MobjViewprofile.EncryptedRejectFlagTextrvr;
parm[7] = new SqlParameter("@vc_Message", SqlDbType.VarChar);
parm[7].Value = MobjViewprofile.StrHtmlText;
parm[8] = new SqlParameter("@i_MessagelinkID", SqlDbType.BigInt);
parm[8].Value = MobjViewprofile.MessageLinkId;
parm[9] = new SqlParameter("@i_Cust_MessageHistory_Id", SqlDbType.BigInt);
parm[9].Value = MobjViewprofile.MessageHistoryId;
parm[10] = new SqlParameter("@i_LogId", SqlDbType.BigInt);
parm[10].Value = MobjViewprofile.Logid;
parm[11] = new SqlParameter("@i_status", SqlDbType.Int);
parm[11].Direction = ParameterDirection.Output;
DataSet dsMessages = new DataSet();
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
Smtpemailsending smtp = new Smtpemailsending();
{
smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
smtp.recipients = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
smtp.body = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
smtp.subject = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
smtp.body_format = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
istatus = smtp.Statusint = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : 0;
}
li.Add(smtp);
}
}
reader.Close();
if (MobjViewprofile.TypeofInsert == "I" || MobjViewprofile.TypeofInsert == "RP" || MobjViewprofile.TypeofInsert == "TH")
{
if (string.Compare(parm[11].Value.ToString(), System.DBNull.Value.ToString()) == 0)
{
istatus = 0;
}
else
{
istatus = Convert.ToInt32(parm[11].Value);
}
}
if (MobjViewprofile.TypeofInsert == "M" || MobjViewprofile.TypeofInsert == "B")
{
Commonclass.SendMailSmtpMethod(li, "info");
}
else
{
Commonclass.SendMailSmtpMethod(li, "exp");
}
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), MobjViewprofile.IFromCustID, null, null);
}
finally
{
connection.Close();
//SqlConnection.ClearPool(connection);
//SqlConnection.ClearAllPools();
}
return(istatus);
}
//New Payment Table Design Test API
public int CustomerInsertPaymentDetilsInfo_New(PaymentInsertML Mobj, string spName)
{
int IntStatus = 0;
DataSet dsPaymentDetails = new DataSet();
int? Istatus = null;
int? inull = null;
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlDataAdapter daPaymentDetails = new SqlDataAdapter();
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
SqlCommand cmd = new SqlCommand(spName, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dtPaymentDetails", Mobj.dtPaymentDetails);
cmd.Parameters.AddWithValue("@PaysmsID", Mobj.PaysmsID);
SqlParameter outputParamStatus = cmd.Parameters.Add("@Status", SqlDbType.Int);
outputParamStatus.Direction = ParameterDirection.Output;
SqlParameter outputParamErrorLog = cmd.Parameters.Add("@ErrorMsg", SqlDbType.VarChar, 1000);
outputParamErrorLog.Direction = ParameterDirection.Output;
daPaymentDetails.SelectCommand = cmd;
daPaymentDetails.Fill(dsPaymentDetails);
if (dsPaymentDetails != null && dsPaymentDetails.Tables.Count > 0 && dsPaymentDetails != null)
{
for (int i = 0; i < dsPaymentDetails.Tables[0].Rows.Count; i++)
{
Smtpemailsending smtp = new Smtpemailsending();
{
smtp.profile_name = dsPaymentDetails.Tables[0].Columns.Contains("profile_name") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["profile_name"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["profile_name"].ToString() : string.Empty;
smtp.recipients = dsPaymentDetails.Tables[0].Columns.Contains("recipients") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["recipients"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["recipients"].ToString() : string.Empty;
smtp.body = dsPaymentDetails.Tables[0].Columns.Contains("body") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["body"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["body"].ToString() : string.Empty;
smtp.subject = dsPaymentDetails.Tables[0].Columns.Contains("subject") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["subject"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["subject"].ToString() : string.Empty;
smtp.body_format = dsPaymentDetails.Tables[0].Columns.Contains("body_format") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["body_format"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["body_format"].ToString() : string.Empty;
Istatus = smtp.Status = dsPaymentDetails.Tables[0].Columns.Contains("Status") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["Status"].ToString()) ? Convert.ToInt32(dsPaymentDetails.Tables[0].Rows[i]["Status"]) : inull;
}
li.Add(smtp);
}
IntStatus = (Istatus != null && Istatus != 0) ? 1 : 0;
if (Mobj.PaysmsID == 1)
{
Commonclass.SendMailSmtpMethod(li, "info");
Commonclass.PaymentinsertSMS(dsPaymentDetails, Mobj);
}
}
else
{
if (Convert.ToInt32(cmd.Parameters[0].Value) == 1)
{
IntStatus = 1;
}
else
{
IntStatus = 0;
}
}
}
catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), null, null, null); }
finally
{
connection.Close();
}
if (dsPaymentDetails.Tables.Count == 0)
{
dsPaymentDetails = null;
}
return(IntStatus);
}
public Tuple <List <Smtpemailsending>, int?> ExpressInterest(ExpressInterestInsert ExpML, string spName)
{
int?status = null;
SqlDataReader reader;
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
SqlParameter[] parm = new SqlParameter[5];
parm[0] = new SqlParameter("@cust_Id", SqlDbType.Int);
parm[0].Value = ExpML.FromCustID;
parm[1] = new SqlParameter("@empid", SqlDbType.BigInt);
parm[1].Value = ExpML.EmpID;
parm[2] = new SqlParameter("@TblDetails", SqlDbType.Structured);
parm[2].Value = ExpML.dtExpInt;
parm[3] = new SqlParameter("@emailaddress", SqlDbType.VarChar);
parm[3].Value = ExpML.emailaddress;
parm[4] = new SqlParameter("@Status", SqlDbType.Int);
parm[4].Direction = ParameterDirection.Output;
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
li.Clear();
Smtpemailsending smtp = new Smtpemailsending();
{
smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
smtp.recipients = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
smtp.body = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
smtp.subject = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
smtp.body_format = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
smtp.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : status;
}
li.Add(smtp);
Commonclass.SendMailSmtpMethod(li, "exp");
}
}
Commonclass.ExpressInterestSMS(ExpML.dtExpInt, " ");
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(new Tuple <List <Smtpemailsending>, int?>(li, status));
}
public int InsertExpressViewTicket(long?FromCustID, long?ToCustID, string EncriptedText, string strtypeOfReport, string spName)
{
int? Istatus = null;
int? inull = null;
SqlDataReader reader = null;
int status = 0;
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
SqlParameter[] parm = new SqlParameter[6];
try
{
parm[0] = new SqlParameter("@fromcust_id", SqlDbType.BigInt);
parm[0].Value = FromCustID;
parm[1] = new SqlParameter("@tocust_id", SqlDbType.BigInt);
parm[1].Value = ToCustID;
parm[2] = new SqlParameter("@EncriptedTextAccept", SqlDbType.VarChar);
parm[2].Value = EncriptedText;
parm[3] = new SqlParameter("@Typeofaction", SqlDbType.VarChar);
parm[3].Value = strtypeOfReport;
parm[4] = new SqlParameter("@Status", SqlDbType.Int);
parm[4].Direction = ParameterDirection.Output;
DataSet dsMessages = new DataSet();
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
while (reader.Read())
{
Smtpemailsending smtp = new Smtpemailsending();
{
smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
smtp.recipients = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
smtp.body = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
smtp.subject = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
smtp.body_format = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
Istatus = smtp.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : inull;
}
li.Add(smtp);
}
status = Istatus != null?Convert.ToInt32(Istatus) : 0;
Commonclass.SendMailSmtpMethod(li, "info");
}
else
{
if (string.Compare(System.DBNull.Value.ToString(), parm[4].Value.ToString()) == 0)
{
status = 0;
}
else
{
status = Convert.ToInt32(parm[4].Value);
}
}
reader.Close();
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), FromCustID, null, null);
}
finally
{
connection.Close();
//SqlConnection.ClearPool(connection);
//SqlConnection.ClearAllPools();
}
return(status);
}
