public void Login()
{
if (!string.IsNullOrWhiteSpace(txtEMAIL.Text.Trim()))
{
modalLogin.Show();
lblMAIL.Text = txtEMAIL.Text.Trim();
MAYAVI_USERS_C user = dbop.GetMayaviUserByMail(lblMAIL.Text.Trim());
if (!string.IsNullOrWhiteSpace(user.EMAIL))
{
lblLoginHead.Text = "Login";
txtUSER_NAME.Text = user.USER_NAME;
txtUSER_NAME.Enabled = false;
txtConfirm.Visible = false;
btnSubmit.Text = "Login";
txtPWD.Focus();
}
else
{
lblLoginHead.Text = "Sign Up";
btnSubmit.Text = "Sign Up";
txtUSER_NAME.Enabled = true;
txtConfirm.Visible = true;
txtUSER_NAME.Focus();
}
}
}
public MAYAVI_USERS_C GetMayaviUserByMailPwd(string EMAIL, string PWD)
{
bool IsValid = false;
MD5Encryption md5 = new MD5Encryption();
PWD = md5.Encryption(PWD);
MAYAVI_USERS_C mayavi_users_details = new MAYAVI_USERS_C();
Query = @"SELECT UID,USER_NAME,EMAIL,MOBILENO,ORGANIZATION,PWD,PRIVILEGE FROM MAYAVI_USERS WHERE EMAIL=@EMAIL AND PWD=@PWD";
DataTable DataTable_MAYAVI_USERS = db.ExecuteSelect(Query, new MySqlParameter("@EMAIL", EMAIL), new MySqlParameter("@PWD", PWD));
if (DataTable_MAYAVI_USERS.Rows.Count > 0)
{
foreach (DataRow item in DataTable_MAYAVI_USERS.Rows)
{
mayavi_users_details.UID = item["UID"].ToString();
mayavi_users_details.USER_NAME = item["USER_NAME"].ToString();
mayavi_users_details.EMAIL = item["EMAIL"].ToString();
mayavi_users_details.MOBILENO = item["MOBILENO"].ToString();
mayavi_users_details.ORGANIZATION = item["ORGANIZATION"].ToString();
mayavi_users_details.PWD = item["PWD"].ToString();
mayavi_users_details.PRIVILEGE = item["PRIVILEGE"].ToString();
IsValid = true;
}
}
return(mayavi_users_details);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USER"] != null)
{
if (!Page.IsPostBack)
{
MAYAVI_USERS_C user = (MAYAVI_USERS_C)Session["USER"];
HF_UID.Value = user.UID;
}
}
else
{
Response.Redirect("~/Login.aspx", false);
}
}
public MAYAVI_USERS_C GetMayaviUser(string UserID)
{
MAYAVI_USERS_C mayavi_users_details = new MAYAVI_USERS_C();
Query = @"SELECT UID,USER_NAME,EMAIL,MOBILENO,ORGANIZATION,PWD,PRIVILEGE FROM MAYAVI_USERS WHERE UID=@UID";
DataTable DataTable_MAYAVI_USERS = db.ExecuteSelect(Query, new MySqlParameter("@UID", UserID));
if (DataTable_MAYAVI_USERS.Rows.Count > 0)
{
foreach (DataRow item in DataTable_MAYAVI_USERS.Rows)
{
mayavi_users_details.UID = item["UID"].ToString();
mayavi_users_details.USER_NAME = item["USER_NAME"].ToString();
mayavi_users_details.EMAIL = item["EMAIL"].ToString();
mayavi_users_details.MOBILENO = item["MOBILENO"].ToString();
mayavi_users_details.ORGANIZATION = item["ORGANIZATION"].ToString();
mayavi_users_details.PWD = item["PWD"].ToString();
mayavi_users_details.PRIVILEGE = item["PRIVILEGE"].ToString();
}
}
return(mayavi_users_details);
}
public List <MAYAVI_USERS_C> GetAllMayaviUser()
{
List <MAYAVI_USERS_C> list_mayavi_users_details = new List <MAYAVI_USERS_C>();
Query = @"SELECT UID,USER_NAME,EMAIL,MOBILENO,ORGANIZATION,PWD,PRIVILEGE FROM MAYAVI_USERS";
DataTable DataTable_MAYAVI_USERS = db.ExecuteSelect(Query);
if (DataTable_MAYAVI_USERS.Rows.Count > 0)
{
foreach (DataRow item in DataTable_MAYAVI_USERS.Rows)
{
MAYAVI_USERS_C mayavi_users_details = new MAYAVI_USERS_C();
mayavi_users_details.UID = item["UID"].ToString();
mayavi_users_details.USER_NAME = item["USER_NAME"].ToString();
mayavi_users_details.EMAIL = item["EMAIL"].ToString();
mayavi_users_details.MOBILENO = item["MOBILENO"].ToString();
mayavi_users_details.ORGANIZATION = item["ORGANIZATION"].ToString();
mayavi_users_details.PWD = item["PWD"].ToString();
mayavi_users_details.PRIVILEGE = item["PRIVILEGE"].ToString();
list_mayavi_users_details.Add(mayavi_users_details);
}
}
return(list_mayavi_users_details);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string ErrorMsg = "";
int ErrorCnt = 0;
MD5Encryption md5 = new MD5Encryption();
if (lblLoginHead.Text == "Login")
{
if (string.IsNullOrWhiteSpace(txtEMAIL.Text.Trim()))
{
ErrorMsg += "Enter e-mail<br/>";
ErrorCnt++;
}
if (string.IsNullOrWhiteSpace(txtPWD.Text.Trim()))
{
ErrorMsg += "Enter password<br/>";
ErrorCnt++;
}
if (ErrorCnt > 0)
{
lblMessage.Text = ErrorMsg;
}
else
{
string PWD = md5.ClientDecrypt(txtPWD.Text.Trim());
MAYAVI_USERS_C user = dbop.GetMayaviUserByMailPwd(txtEMAIL.Text.Trim(), PWD);
if (!string.IsNullOrWhiteSpace(user.UID))
{
Session["USER"] = user;
Response.Redirect("~/HomeUser.aspx", false);
}
else
{
lblMessage.Text = "<h2>Failed...</h2>Invalid User";
}
}
}
else
{
if (string.IsNullOrWhiteSpace(txtUSER_NAME.Text.Trim()))
{
ErrorMsg += "Enter Full Name<br/>";
ErrorCnt++;
}
if (string.IsNullOrWhiteSpace(lblMAIL.Text.Trim()))
{
ErrorMsg += "Enter e-mail<br/>";
ErrorCnt++;
}
if (string.IsNullOrWhiteSpace(txtPWD.Text.Trim()))
{
ErrorMsg += "Enter password<br/>";
ErrorCnt++;
}
if (string.IsNullOrWhiteSpace(txtConfirm.Text.Trim()))
{
ErrorMsg += "Enter confirm password<br/>";
ErrorCnt++;
}
if (!string.IsNullOrWhiteSpace(txtConfirm.Text.Trim()))
{
string PWD = md5.ClientDecrypt(txtPWD.Text.Trim());
if (PWD != txtConfirm.Text.Trim())
{
ErrorMsg += "password and confirm password should be same<br/>";
ErrorCnt++;
}
}
if (ErrorCnt > 0)
{
lblMessage.Text = ErrorMsg;
}
else
{
MAYAVI_USERS_C user = dbop.GetMayaviUserByMail(txtEMAIL.Text.Trim());
if (string.IsNullOrWhiteSpace(user.UID))
{
int AffectedRow = dbop.InsertMayavi_Users(txtUSER_NAME.Text.Trim(), txtEMAIL.Text.Trim(), txtConfirm.Text.Trim());
if (AffectedRow > 0)
{
string PWD = md5.ClientDecrypt(txtPWD.Text.Trim());
MAYAVI_USERS_C user1 = dbop.GetMayaviUserByMailPwd(txtEMAIL.Text.Trim(), PWD);
if (!string.IsNullOrWhiteSpace(user1.UID))
{
Session["USER"] = user1;
Response.Redirect("~/HomeUser.aspx", false);
}
else
{
lblMessage.Text = "<h2>Failed...</h2>Invalid User";
}
}
}
else
{
lblMessage.Text = "<h2>Failed...</h2>User already exists";
}
}
}
modalLogin.Show();
}
