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