public bool insertPasscode(userMasterBO UserMasterBO)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
query = "insertUpdatePasscode";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@passcode", UserMasterBO.passcode);
cmd.Parameters.AddWithValue("@email", UserMasterBO.email);
SqlParameter result = cmd.Parameters.Add("@res", SqlDbType.Bit);
result.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return(bool.Parse(result.Value.ToString()));
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public Int64 getGuid(userMasterBO userMasterBO)
{
try
{
query = "returnGuid";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", userMasterBO.email);
return(Int64.Parse(cmd.ExecuteScalar().ToString()));
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public bool checkValidEmailToResetPassword(userMasterBO userMasterBO)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
query = "checkEmailToResetPassword";
cmd = new SqlCommand(query,con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", userMasterBO.email);
SqlParameter result = cmd.Parameters.Add("@res", SqlDbType.Bit);
result.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return (bool.Parse(result.Value.ToString()));
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public string[] checkUser(userMasterBO userMasterBO)
{
try
{
query = "localUserLogin";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(query,con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email",userMasterBO.email);
cmd.Parameters.AddWithValue("@password", userMasterBO.password);
SqlParameter returnEmail = cmd.Parameters.Add("@returnEmail", SqlDbType.NVarChar,50);
returnEmail.Direction = ParameterDirection.Output;
SqlParameter returnGuid = cmd.Parameters.Add("@returnGuid", SqlDbType.BigInt);
returnGuid.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
str[0] = returnEmail.Value.ToString();
str[1] = returnGuid.Value.ToString();
return str;
}
catch
{
throw;
}
finally
{
if(con.State==ConnectionState.Open)
{
con.Close();
}
}
}
public bool updateMpDetails(userMasterBO userMasterBO, mpDetailsBO mpDetailsBO)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
query = "updateMpDetails";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@guId", userMasterBO.guid);
cmd.Parameters.AddWithValue("@email", userMasterBO.email);
cmd.Parameters.AddWithValue("@password", userMasterBO.password);
cmd.Parameters.AddWithValue("@firstName", userMasterBO.firstName);
cmd.Parameters.AddWithValue("@middleName", userMasterBO.middleName);
cmd.Parameters.AddWithValue("@lastName", userMasterBO.lastName);
cmd.Parameters.AddWithValue("@socialNetwork", userMasterBO.socialNetwork);
cmd.Parameters.AddWithValue("@snTypeId", userMasterBO.snTypeId);
cmd.Parameters.AddWithValue("@status", userMasterBO.status);
cmd.Parameters.AddWithValue("@profilepic", userMasterBO.profilePicPath);
// now the part of mpdetails table
cmd.Parameters.AddWithValue("@mpId", mpDetailsBO.mpId);
cmd.Parameters.AddWithValue("@countryId", mpDetailsBO.countryId);
cmd.Parameters.AddWithValue("@constituencyId", mpDetailsBO.constituencyId);
cmd.Parameters.AddWithValue("@electedYear", mpDetailsBO.electedYear);
cmd.Parameters.AddWithValue("@partyId", mpDetailsBO.partyId);
cmd.Parameters.AddWithValue("@phone", mpDetailsBO.phone);
cmd.Parameters.AddWithValue("@mobile", mpDetailsBO.mobile);
cmd.Parameters.AddWithValue("@qualification", mpDetailsBO.qualification);
cmd.Parameters.AddWithValue("@professioin", mpDetailsBO.profession);
cmd.Parameters.AddWithValue("@permanentAddress", mpDetailsBO.permenantAddress);
cmd.Parameters.AddWithValue("@permanentDistrictId", mpDetailsBO.permanentDistrict);
cmd.Parameters.AddWithValue("@permanentStateId", mpDetailsBO.permanentState);
cmd.Parameters.AddWithValue("@currentAddress", mpDetailsBO.currentAddress);
cmd.Parameters.AddWithValue("@currentDistrictId", mpDetailsBO.currentDistrictId);
cmd.Parameters.AddWithValue("@currentStateId", mpDetailsBO.currentStateId);
SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.Bit);
message.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return(bool.Parse(message.Value.ToString()));
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public string registerMp(mpDetailsBO MpDetailsBO,userMasterBO UserMasterBO)
{
try
{
return MpDetailsDAL.registerMp(MpDetailsBO, UserMasterBO);
}
catch
{
throw;
}
finally
{ }
}
public bool updatePassword(userMasterBO userMasterBO)
{
try
{
return(userMasterDAL.updatePassword(userMasterBO));
}
catch
{
throw;
}
finally
{
}
}
public string insertUser(userMasterBO userMasterBO)
{
try
{
return(userMasterDAL.insertUser(userMasterBO));
}
catch
{
throw;
}
finally
{
}
}
public bool insertPasscode(userMasterBO UserMasterBO)
{
try
{
return(userMasterDAL.insertPasscode(UserMasterBO));
}
catch
{
throw;
}
finally
{
}
}
public string[] checkUser(userMasterBO userMasterBO)
{
try
{
return (userMasterDAL.checkUser(userMasterBO));
}
catch
{
throw;
}
finally{
}
}
public bool saveMpDetails(userMasterBO userMasterBO, mpDetailsBO mpDetailsBO)
{
try
{
return(mpDetailsDAL.saveMpDetails(userMasterBO, mpDetailsBO));
}
catch
{
throw;
}
finally
{
}
}
public bool checkPasscode(userMasterBO userMasterBO)
{
try
{
return(userMasterDAL.checkPasscode(userMasterBO));
}
catch
{
throw;
}
finally
{
}
}
public string[] checkUser(userMasterBO userMasterBO)
{
try
{
return(userMasterDAL.checkUser(userMasterBO));
}
catch
{
throw;
}
finally
{
}
}
public Int64 getGuid(userMasterBO userMasterBO)
{
try
{
return(userMasterDAL.getGuid(userMasterBO));
}
catch
{
throw;
}
finally
{
}
}
public bool checkValidEmailToResetPassword(userMasterBO userMasterBO)
{
try
{
return(userMasterDAL.checkValidEmailToResetPassword(userMasterBO));
// return true;
}
catch
{
throw;
}
finally
{
}
}
public bool insertPasscode(userMasterBO UserMasterBO)
{
try
{
return userMasterDAL.insertPasscode(UserMasterBO);
}
catch
{
throw;
}
finally
{
}
}
public Int64 getGuid(userMasterBO userMasterBO)
{
try
{
return (userMasterDAL.getGuid(userMasterBO));
}
catch
{
throw;
}
finally
{
}
}
public bool checkPasscode(userMasterBO userMasterBO)
{
try
{
return userMasterDAL.checkPasscode(userMasterBO);
}
catch
{
throw;
}
finally
{
}
}
private bool userCreateAndSession()
{ //+ email + "&name=" + name + "&social=" + social + "&socialType=" + socialtype + "&image=" + picture
if (Request["email"] != null && Request["name"] != null && Request["social"] != null && Request["socialType"] != null && Request["image"] != null)
{
String QEmail = Request["email"];
String Qname = Request["name"];
String Qsocial = Request["social"];
String QsocialType = Request["socialType"];
String Qpicture = Request["image"];
String[] SplitName = new String[3];
userMasterBO userMasterBO = new userMasterBO();
userMasterBAL userMasterBAL = new userMasterBAL();
SplitName = Qname.Split(' ');
//give the code to insert data into the usermaster table.
userMasterBO.email = QEmail;
userMasterBO.firstName = SplitName[0];
userMasterBO.lastName = (SplitName.Count() > 1) ? SplitName[1] : "NULL";
userMasterBO.middleName = (SplitName.Count() > 2) ? SplitName[2] : "NULL";
userMasterBO.password = "";
userMasterBO.socialNetwork = true;
userMasterBO.status = true;
userMasterBO.roleId = 3; //3 for user , 2 for mp,1 for admin, 4 for moderator
userMasterBO.snTypeId = userMasterBAL.getSocialNetworkId(QsocialType); //fetch the corresponding id of socialnetwork
userMasterBO.profilePicPath = (Qpicture.Length > 1) ? Qpicture : "NULL";
//insert data into the database.
string msg = userMasterBAL.insertUser(userMasterBO).ToString();
userMasterBO.guid = Convert.ToInt64(userMasterBAL.getGuid(userMasterBO));
guId = userMasterBO.guid;
name = userMasterBO.firstName;
Email = userMasterBO.email;
CreateSession();
return(true);
}
else
{
return(false);
}
}
public string registerMp(mpDetailsBO MpDetailsBO,userMasterBO UserMasterBO)
{
try
{
cmd = new SqlCommand("regMp", care);
cmd.CommandType = CommandType.StoredProcedure;
if (care.State == ConnectionState.Closed)
{
care.Open();
}
cmd.Parameters.AddWithValue("@email", UserMasterBO.email);
cmd.Parameters.AddWithValue("@pasword",UserMasterBO.password);
cmd.Parameters.AddWithValue("@roleId",UserMasterBO.roleId);
cmd.Parameters.AddWithValue("@firstName",UserMasterBO.firstName);
cmd.Parameters.AddWithValue("@middleName",UserMasterBO.middleName);
cmd.Parameters.AddWithValue("@lastName",UserMasterBO.lastName);
cmd.Parameters.AddWithValue("@socialNetwork",UserMasterBO.socialNetwork);
cmd.Parameters.AddWithValue("@sntypeId",UserMasterBO.snTypeId);
cmd.Parameters.AddWithValue("@status",UserMasterBO.status);
cmd.Parameters.AddWithValue("@passcode",UserMasterBO.passcode);
cmd.Parameters.AddWithValue("@profilePic",UserMasterBO.profilePic);
cmd.Parameters.AddWithValue("@countryId", MpDetailsBO.countryId);
cmd.Parameters.AddWithValue("@constituencyId", MpDetailsBO.constituencyId);
cmd.Parameters.AddWithValue("@electedYear", MpDetailsBO.electedYear);
cmd.Parameters.AddWithValue("@partyId", MpDetailsBO.partyId);
cmd.Parameters.AddWithValue("@phone", MpDetailsBO.phone);
cmd.Parameters.AddWithValue("@mobile", MpDetailsBO.mobile);
cmd.Parameters.AddWithValue("@qualification", MpDetailsBO.qualification);
cmd.Parameters.AddWithValue("@profession", MpDetailsBO.profession);
cmd.Parameters.AddWithValue("@permenantAddr", MpDetailsBO.permenantAddress);
cmd.Parameters.AddWithValue("@permenantDistId", MpDetailsBO.permenantDist);
cmd.Parameters.AddWithValue("@permenantStateId", MpDetailsBO.permanentState);
cmd.Parameters.AddWithValue("@CurrentAddr", MpDetailsBO.currentAddress);
cmd.Parameters.AddWithValue("@currentDistId", MpDetailsBO.currentDistrictId);
cmd.Parameters.AddWithValue("@currentStateId", MpDetailsBO.currentStateId);
cmd.ExecuteNonQuery();
return "done";
}
catch {
throw;
}
finally {
care.Close();
}
}
public bool checkValidEmailToResetPassword(userMasterBO userMasterBO)
{
try
{
return userMasterDAL.checkValidEmailToResetPassword(userMasterBO);
// return true;
}
catch
{
throw;
}
finally
{
}
}
private bool userCreateAndSession()
{
//+ email + "&name=" + name + "&social=" + social + "&socialType=" + socialtype + "&image=" + picture
if (Request["email"] != null && Request["name"] != null && Request["social"] != null && Request["socialType"] != null && Request["image"] != null)
{
String QEmail = Request["email"];
String Qname = Request["name"];
String Qsocial = Request["social"];
String QsocialType = Request["socialType"];
String Qpicture = Request["image"];
String[] SplitName = new String[3];
userMasterBO userMasterBO = new userMasterBO();
userMasterBAL userMasterBAL = new userMasterBAL();
SplitName = Qname.Split(' ');
//give the code to insert data into the usermaster table.
userMasterBO.email = QEmail;
userMasterBO.firstName = SplitName[0];
userMasterBO.lastName = (SplitName.Count() > 1) ? SplitName[1] : "NULL";
userMasterBO.middleName = (SplitName.Count() > 2) ? SplitName[2] : "NULL";
userMasterBO.password = "";
userMasterBO.socialNetwork = true;
userMasterBO.status = true;
userMasterBO.roleId = 3; //3 for user , 2 for mp,1 for admin, 4 for moderator
userMasterBO.snTypeId = userMasterBAL.getSocialNetworkId(QsocialType); //fetch the corresponding id of socialnetwork
userMasterBO.profilePicPath = (Qpicture.Length > 1) ? Qpicture : "NULL";
//insert data into the database.
string msg = userMasterBAL.insertUser(userMasterBO).ToString();
userMasterBO.guid = Convert.ToInt64(userMasterBAL.getGuid(userMasterBO));
guId = userMasterBO.guid;
name = userMasterBO.firstName;
Email = userMasterBO.email;
CreateSession();
return true;
}
else
return false;
}
public string insertUser(userMasterBO userMasterBO)
{
try
{
query = "userMasterEntry";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@email", userMasterBO.email);
cmd.Parameters.AddWithValue("@password", userMasterBO.password);
cmd.Parameters.AddWithValue("@fk_roleId", userMasterBO.roleId);
cmd.Parameters.AddWithValue("@firstName", userMasterBO.firstName);
cmd.Parameters.AddWithValue("@middleName", userMasterBO.middleName);
cmd.Parameters.AddWithValue("@lastName", userMasterBO.lastName);
cmd.Parameters.AddWithValue("@socialNetwork", userMasterBO.socialNetwork);
cmd.Parameters.AddWithValue("@snTypeId", userMasterBO.snTypeId);
cmd.Parameters.AddWithValue("@status", userMasterBO.status);
cmd.Parameters.AddWithValue("@profilePicPath", userMasterBO.profilePicPath);
SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.VarChar, 500);
message.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return(message.Value.ToString());
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public string[] checkUser(userMasterBO userMasterBO)
{
try
{
query = "localUserLogin";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", userMasterBO.email);
cmd.Parameters.AddWithValue("@password", userMasterBO.password);
SqlParameter returnEmail = cmd.Parameters.Add("@returnEmail", SqlDbType.NVarChar, 50);
returnEmail.Direction = ParameterDirection.Output;
SqlParameter returnGuid = cmd.Parameters.Add("@returnGuid", SqlDbType.BigInt);
returnGuid.Direction = ParameterDirection.Output;
SqlParameter returnFname = cmd.Parameters.Add("@returnFirstName", SqlDbType.NVarChar, 50);
returnFname.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
str[0] = returnEmail.Value.ToString();
str[1] = returnGuid.Value.ToString();
str[2] = returnFname.Value.ToString();
return(str);
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public bool updateMpDetails(userMasterBO userMasterBO, mpDetailsBO mpDetailsBO)
{
try
{
return mpDetailsDAL.updateMpDetails(userMasterBO, mpDetailsBO);
}
catch
{
throw;
}
finally
{
}
}
public Int64 getGuid(userMasterBO userMasterBO)
{
try
{
query = "returnGuid";
if(con.State==ConnectionState.Closed)
{
con.Open();
}
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", userMasterBO.email);
return (Int64 .Parse( cmd.ExecuteScalar().ToString()));
}
catch
{
throw;
}
finally
{
if(con.State==ConnectionState.Open)
{
con.Close();
}
}
}
public bool updateMpDetails(userMasterBO userMasterBO, mpDetailsBO mpDetailsBO)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
query = "updateMpDetails";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@guId", userMasterBO.guid);
cmd.Parameters.AddWithValue("@email", userMasterBO.email);
cmd.Parameters.AddWithValue("@password", userMasterBO.password);
cmd.Parameters.AddWithValue("@firstName", userMasterBO.firstName);
cmd.Parameters.AddWithValue("@middleName", userMasterBO.middleName);
cmd.Parameters.AddWithValue("@lastName", userMasterBO.lastName);
cmd.Parameters.AddWithValue("@socialNetwork", userMasterBO.socialNetwork);
cmd.Parameters.AddWithValue("@snTypeId", userMasterBO.snTypeId);
cmd.Parameters.AddWithValue("@status", userMasterBO.status);
cmd.Parameters.AddWithValue("@profilepic", userMasterBO.profilePicPath);
// now the part of mpdetails table
cmd.Parameters.AddWithValue("@mpId", mpDetailsBO.mpId);
cmd.Parameters.AddWithValue("@countryId", mpDetailsBO.countryId);
cmd.Parameters.AddWithValue("@constituencyId", mpDetailsBO.constituencyId);
cmd.Parameters.AddWithValue("@electedYear", mpDetailsBO.electedYear);
cmd.Parameters.AddWithValue("@partyId", mpDetailsBO.partyId);
cmd.Parameters.AddWithValue("@phone", mpDetailsBO.phone);
cmd.Parameters.AddWithValue("@mobile", mpDetailsBO.mobile);
cmd.Parameters.AddWithValue("@qualification", mpDetailsBO.qualification);
cmd.Parameters.AddWithValue("@professioin", mpDetailsBO.profession);
cmd.Parameters.AddWithValue("@permanentAddress", mpDetailsBO.permenantAddress);
cmd.Parameters.AddWithValue("@permanentDistrictId", mpDetailsBO.permanentDistrict);
cmd.Parameters.AddWithValue("@permanentStateId", mpDetailsBO.permanentState);
cmd.Parameters.AddWithValue("@currentAddress", mpDetailsBO.currentAddress);
cmd.Parameters.AddWithValue("@currentDistrictId", mpDetailsBO.currentDistrictId);
cmd.Parameters.AddWithValue("@currentStateId", mpDetailsBO.currentStateId);
SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.Bit);
message.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return (bool.Parse(message.Value.ToString()));
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public string insertUser(userMasterBO userMasterBO)
{
try
{
query = "userMasterEntry";
cmd = new SqlCommand(query,con);
cmd.CommandType = CommandType.StoredProcedure;
if(con.State==ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@email",userMasterBO.email);
cmd.Parameters.AddWithValue("@password", userMasterBO.password);
cmd.Parameters.AddWithValue("@fk_roleId", userMasterBO.roleId);
cmd.Parameters.AddWithValue("@firstName", userMasterBO.firstName);
cmd.Parameters.AddWithValue("@middleName", userMasterBO.middleName);
cmd.Parameters.AddWithValue("@lastName", userMasterBO.lastName);
cmd.Parameters.AddWithValue("@socialNetwork", userMasterBO.socialNetwork);
cmd.Parameters.AddWithValue("@snTypeId", userMasterBO.snTypeId);
cmd.Parameters.AddWithValue("@status", userMasterBO.status);
SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.VarChar, 500);
message.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return message.Value.ToString();
}
catch
{
throw;
}
finally
{
if(con.State==ConnectionState.Open)
{
con.Close();
}
}
}
public static string generatePasscode(string emailidval)
{
userMasterBO x = new userMasterBO();
userMasterBAL y = new userMasterBAL();
Page CurPage = HttpContext.Current.Handler as Page;
//TextBox tx= (TextBox)CurPage.FindControl("signinemail");
// string ss= tx.Text;
// HiddenField hf = (HiddenField)CurPage.FindControl("HiddenField2");
if (emailidval != "")
{
//check email first
x.email = emailidval;
bool valid = y.checkValidEmailToResetPassword(x);
if (valid == true)
{
//here we will check passcode is null or not. if null we will create the passcode and save into database and email passcode to users.
bool passnull = y.checkPasscode(x);
if ( true) // if (passnull == true)
{
// first create the passcode here. to generate passcode i have to write the storedprocedure
Random rnd = new Random();
int passcode = rnd.Next(00000000, 99999999);
x.passcode = passcode;
//code to send email
MailMessage vMsg = new MailMessage();
MailAddress vFrom = new MailAddress("*****@*****.**", "RATEmymp");
vMsg.From = vFrom;
vMsg.To.Add(x.email); //This is a string which contains delimited :semicolons for multiple
vMsg.Subject = "Passcode to reset Password in rateMyMp"; //This is the subject;
vMsg.Body = passcode.ToString(); //This is the message that needs to be passed.
//Create an object SMTPclient for relaying
// SmtpClient vSmtp = new SmtpClient();
SmtpClient vSmtp = new SmtpClient("smtp.gmail.com", 587);
vSmtp.Host = ConfigurationManager.AppSettings["SMTP"];
vSmtp.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["FROMEMAIL"], ConfigurationManager.AppSettings["FROMPWD"]);
//vSmtp.Credentials = new System.Net.NetworkCredential("lovelybatch", ConfigurationManager.AppSettings["FROMPWD"]);
vSmtp.EnableSsl = true;
vSmtp.Send(vMsg);
//now store same passcode in database under corresponding email address
bool success = y.insertPasscode(x);
if (success == true)
{
//HiddenField2.Value = "true";
// CurPage. ClientScript.RegisterStartupScript(CurPage.GetType(), "myfunction", "showdiv()", true);
// CurPage.ClientScript.RegisterStartupScript( CurPage.GetType(), "myfunction", "showdiv()", true);
// ScriptManager.RegisterClientScriptBlock(CurPage,typeof(System.Web.UI.Page),"myfunction","showdiv()",true);
return "showdivs";
}
else
{
return "xyz"; ;
}
}
//else
//{
// //HiddenField2.Value = "true";
// // CurPage. ClientScript.RegisterStartupScript(CurPage.GetType(), "myfunction", "showdiv()", true);
// return "showdivs";
//}
}
else
{
// CurPage.ClientScript.RegisterStartupScript(CurPage.GetType(), "myfunction", "invalidEmail()", true);
return "invalidEmails";
}
}
else
{
// CurPage.ClientScript.RegisterStartupScript(CurPage.GetType(), "myfunction", "enterEmail()", true);
return "enterEmails";
}
}
public static string generatePasscode(string emailidval)
{
userMasterBO x = new userMasterBO();
userMasterBAL y = new userMasterBAL();
Page CurPage = HttpContext.Current.Handler as Page;
//TextBox tx= (TextBox)CurPage.FindControl("signinemail");
// string ss= tx.Text;
// HiddenField hf = (HiddenField)CurPage.FindControl("HiddenField2");
if (emailidval != "")
{
//check email first
x.email = emailidval;
bool valid = y.checkValidEmailToResetPassword(x);
if (valid == true)
{
//here we will check passcode is null or not. if null we will create the passcode and save into database and email passcode to users.
bool passnull = y.checkPasscode(x);
if (true) // if (passnull == true)
{
// first create the passcode here. to generate passcode i have to write the storedprocedure
Random rnd = new Random();
int passcode = rnd.Next(00000000, 99999999);
x.passcode = passcode;
//code to send email
MailMessage vMsg = new MailMessage();
MailAddress vFrom = new MailAddress("*****@*****.**", "RATEmymp");
vMsg.From = vFrom;
vMsg.To.Add(x.email); //This is a string which contains delimited :semicolons for multiple
vMsg.Subject = "Passcode to reset Password in rateMyMp"; //This is the subject;
vMsg.Body = passcode.ToString(); //This is the message that needs to be passed.
//Create an object SMTPclient for relaying
// SmtpClient vSmtp = new SmtpClient();
SmtpClient vSmtp = new SmtpClient("smtp.gmail.com", 587);
vSmtp.Host = ConfigurationManager.AppSettings["SMTP"];
vSmtp.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["FROMEMAIL"], ConfigurationManager.AppSettings["FROMPWD"]);
//vSmtp.Credentials = new System.Net.NetworkCredential("lovelybatch", ConfigurationManager.AppSettings["FROMPWD"]);
vSmtp.EnableSsl = true;
vSmtp.Send(vMsg);
//now store same passcode in database under corresponding email address
bool success = y.insertPasscode(x);
if (success == true)
{
//HiddenField2.Value = "true";
// CurPage. ClientScript.RegisterStartupScript(CurPage.GetType(), "myfunction", "showdiv()", true);
// CurPage.ClientScript.RegisterStartupScript( CurPage.GetType(), "myfunction", "showdiv()", true);
// ScriptManager.RegisterClientScriptBlock(CurPage,typeof(System.Web.UI.Page),"myfunction","showdiv()",true);
return("showdivs");
}
else
{
return("xyz");;
}
}
//else
//{
// //HiddenField2.Value = "true";
// // CurPage. ClientScript.RegisterStartupScript(CurPage.GetType(), "myfunction", "showdiv()", true);
// return "showdivs";
//}
}
else
{
// CurPage.ClientScript.RegisterStartupScript(CurPage.GetType(), "myfunction", "invalidEmail()", true);
return("invalidEmails");
}
}
else
{
// CurPage.ClientScript.RegisterStartupScript(CurPage.GetType(), "myfunction", "enterEmail()", true);
return("enterEmails");
}
}
public string insertUser(userMasterBO userMasterBO)
{
try
{
return (userMasterDAL.insertUser(userMasterBO));
}
catch
{
throw;
}
finally
{
}
}
public bool updatePassword(userMasterBO userMasterBO)
{
try
{
return (userMasterDAL.updatePassword(userMasterBO));
}
catch
{
throw;
}
finally
{
}
}
