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 ArrayList EmployeeRegisterCustomerHomepages_Brokerentry(PrimaryInformationMl Mobj, string spName)
{
SqlParameter[] parm = new SqlParameter[30];
int status = 0;
ArrayList arrayList = new ArrayList();
SqlDataReader reader;
List <Smtpemailsending> li = new List <Smtpemailsending>();
Smtpemailsending smtp = new Smtpemailsending();
int? intStatus = 0;
DateTime dtTime = DateTime.ParseExact(Mobj.dtDOB, "dd-MM-yyyy", null);
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
string strMobileVerificationCode = (new Random()).Next(10000, 99999).ToString();
try
{
parm[0] = new SqlParameter("@CasteID", SqlDbType.Int);
parm[0].Value = Mobj.intCasteID;
parm[1] = new SqlParameter("@CountryID", SqlDbType.Int);
parm[1].Value = Mobj.intCountryLivingID;
parm[2] = new SqlParameter("@GenderID", SqlDbType.Int);
parm[2].Value = Mobj.intGenderID;
parm[3] = new SqlParameter("@MobileCode", SqlDbType.Int);
parm[3].Value = Mobj.intMobileCode;
parm[4] = new SqlParameter("@LandCode", SqlDbType.Int);
parm[4].Value = Mobj.intLandCode;
parm[5] = new SqlParameter("@MotherTongueID", SqlDbType.Int);
parm[5].Value = Mobj.intMotherTongueID;
parm[6] = new SqlParameter("@ReligionID", SqlDbType.Int);
parm[6].Value = Mobj.intReligionID;
parm[7] = new SqlParameter("@AreaCode", SqlDbType.VarChar);
parm[7].Value = Mobj.strAreaCode;
parm[8] = new SqlParameter("@Email", SqlDbType.VarChar);
parm[8].Value = Mobj.strEmail;
parm[9] = new SqlParameter("@FirstName", SqlDbType.VarChar);
parm[9].Value = Mobj.strFirstName;
parm[10] = new SqlParameter("@LandNo", SqlDbType.VarChar);
parm[10].Value = Mobj.strLandNo;
parm[11] = new SqlParameter("@LastName", SqlDbType.VarChar);
parm[11].Value = Mobj.strLastName;
parm[12] = new SqlParameter("@MobileNo", SqlDbType.VarChar);
parm[12].Value = Mobj.strMobileNo;
parm[13] = new SqlParameter("@Password", SqlDbType.VarChar);
parm[13].Value = Commonclass.Encrypt(Mobj.strPassword);
parm[14] = new SqlParameter("@DateOfBirth", SqlDbType.DateTime);
// parm[14].Value = Mobj.dtDOB;
parm[14].Value = dtTime;
parm[15] = new SqlParameter("@Status", SqlDbType.Int);
parm[15].Direction = ParameterDirection.Output;
parm[16] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000);
parm[16].Direction = ParameterDirection.Output;
parm[17] = new SqlParameter("@Rowcount", SqlDbType.Int);
parm[17].Direction = ParameterDirection.Output;
parm[18] = new SqlParameter("@ProfileRegisteredBy", SqlDbType.Int);
parm[18].Value = Mobj.intProfileRegisteredBy;
parm[19] = new SqlParameter("@KMPLID", SqlDbType.VarChar);
parm[19].Value = Mobj.strKMPLID;
parm[20] = new SqlParameter("@MobileVerificationCode", SqlDbType.VarChar);
parm[20].Value = strMobileVerificationCode;
parm[21] = new SqlParameter("@EmpID", SqlDbType.BigInt);
parm[21].Value = Mobj.intEmpID;
parm[22] = new SqlParameter("@ID", SqlDbType.Int);
parm[22].Value = Mobj.ID;
parm[23] = new SqlParameter("@IsCustomer", SqlDbType.Int);
parm[23].Value = Mobj.IsCustomer;
parm[24] = new SqlParameter("@IsCustomerPostedBY", SqlDbType.Int);
parm[24].Value = Mobj.intCustPostedBY;
parm[25] = new SqlParameter("@intSubCasteID", SqlDbType.Int);
parm[25].Value = Mobj.intSubCasteID;
parm[26] = new SqlParameter("@BrokerNameID", SqlDbType.Int);
parm[26].Value = Mobj.BrokerNameID;
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
if (reader.HasRows)
{
if (reader.Read())
{
smtp.profile_name = (reader["profile_name"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("profile_name")) : string.Empty;
smtp.recipients = (reader["recipients"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("recipients")) : string.Empty;
smtp.body = (reader["body"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body")) : string.Empty;
smtp.subject = (reader["subject"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("subject")) : string.Empty;
smtp.body_format = (reader["body_format"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("body_format")) : string.Empty;
smtp.Status = (reader["Status"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Status")) : status;
smtp.CustID = (reader["Cust"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Cust")) : 0;
smtp.ProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : string.Empty;
li.Add(smtp);
arrayList.Add(smtp);
}
}
if (Mobj.intEmpID == null)
{
Commonclass.SendMailSmtpMethod(li, "info");
}
intStatus = smtp.Status;
reader.Close();
if (intStatus.Equals(1))
{
ServiceSoapClient cc = new ServiceSoapClient();
try
{
string result = cc.SendTextSMS("ykrishna", "summary$1", Mobj.strMobileNo.ToString().Trim(), "Hi " + Mobj.strFirstName + ", Your verification code with www.kaakateeya.com is " + strMobileVerificationCode + " Please enter this code to confirm your Registration.", "smscntry");
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, (Convert.ToString(EX.Message) + "send Sms Error"), Mobj.intCusID, null, null);
}
}
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Mobj.intCusID, null, null);
}
finally
{
connection.Close();
}
return(arrayList);
}
public List <userLoginML> DGetLogininformationdetails(CustLoginMl Mobj)
{
int status = 0;
List <userLoginML> userLogin = null;
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["KakConnection"].ToString());
connection.Open();
try
{
SqlCommand command = new SqlCommand("Usp_CheckCustLogin", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Username", Mobj.Username);
command.Parameters.AddWithValue("@Password", Commonclass.Encrypt(Mobj.Password));
SqlParameter outputParamStatus = command.Parameters.Add("@Status", SqlDbType.Int);
outputParamStatus.Direction = ParameterDirection.Output;
SqlDataReader reader;
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
userLogin = new List <userLoginML>
{
new userLoginML
{
CustID = (reader["CustID"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("CustID")) : 0,
FirstName = (reader["FirstName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("FirstName")) : null,
LastName = (reader["LastName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("LastName")) : null,
ReligionName = (reader["ReligionName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ReligionName")) : null,
CasteName = (reader["CasteName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("CasteName")) : null,
CasteID = (reader["CasteID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("CasteID")) : 0,
MotherTongueName = (reader["MotherTongueName"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("MotherTongueName")) : null,
GenderID = (reader["GenderID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("GenderID")) : 0,
Email = (reader["Email"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("Email")) : null,
MotherTongueID = (reader["MotherTongueID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("MotherTongueID")) : 0,
ReligionID = (reader["ReligionID"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ReligionID")) : 0,
ProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null,
VerificationCode = (reader["VerificationCode"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("VerificationCode")) : null,
FamilyID = (reader["FamilyID"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("FamilyID")) : 0,
PaidStatus = (reader["PaidStatus"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PaidStatus")) : 0,
PartnerCastedata = (reader["PartnerCastedata"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("PartnerCastedata")) : null,
PhotoStatus = (reader["PhotoStatus"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoStatus")) : 0,
PhotoCount = (reader["PhotoCount"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("PhotoCount")) : 0,
ViewProfileFlag = (reader["ViewProfileFlag"]) != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("ViewProfileFlag")) : false,
ResigNophotoFlgPaid = (reader["ResigNophotoFlgPaid"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("ResigNophotoFlgPaid")) : 0,
SuccessStoryFlag = (reader["SuccessStoryFlag"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("SuccessStoryFlag")) : 0,
Emailverified = (reader["Emailverified"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Emailverified")) : 0,
strProfileID = (reader["ProfileID"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfileID")) : null,
Flag = (reader["Flag"]) != DBNull.Value ? reader.GetInt32(reader.GetOrdinal("Flag")) : 0,
cust_emailid = (reader["cust_emailid"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("cust_emailid")) : 0,
email = (reader["email"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("email")) : null,
isemailverified = (reader["isemailverified"]) != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("isemailverified")) : false,
cust_contant_id = (reader["cust_contant_id"]) != DBNull.Value ? reader.GetInt64(reader.GetOrdinal("cust_contant_id")) : 0,
number = (reader["number"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("number")) : null,
isnumberverifed = (reader["isnumberverifed"]) != DBNull.Value ? reader.GetBoolean(reader.GetOrdinal("isnumberverifed")) : false,
MObileverficationcode = (reader["MObileverficationcode"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("MObileverficationcode")) : null,
ProfilePic = (reader["ProfilePic"]) != DBNull.Value ? reader.GetString(reader.GetOrdinal("ProfilePic")) : null
},
};
}
}
reader.Close();
status = (int)command.Parameters["@Status"].Value;
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog("Usp_CheckCustLogin", Convert.ToString(EX.Message), null, null, null);
}
finally
{
connection.Close();
}
return(userLogin);
}
