private void btnOk_Click(object sender, EventArgs e)
{
objSD = new frmSDAlarm();
try
{
bool sLogin = false;
sUName = txtUsrName.Text.Trim().ToString();
suPassword = txtPassword.Text.Trim().ToString();
string uID = "";
checkPassword = PublicClass.CheckForSpecialCharacter(suPassword);
if (sUName == "" || suPassword == "")
{
MessageBox.Show("User Name & Password can not be blank", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (checkPassword == false)
{
MessageBox.Show("Special character is mondetory");
return;
}
else if (suPassword.Length < 6)
{
MessageBox.Show("Password must be of minimum 6 character");
return;
}
else
{
if (sLogin == true)
{
LoginStatus = 1;
}
else
{
LoginStatus = 0;
}
DataTable dtu = new DataTable();
dtu = DbClass.getdata(CommandType.Text, "Select distinct ID, UserName,Password,Password,Login from userdetail where UserName= '******' ");
foreach (DataRow dr in dtu.Rows)
{
uID = Convert.ToString(dr["ID"]);
}
if (ADD_Edit == "Insert")
{
if (Convert.ToString(uID).Trim() != "")
{
MessageBox.Show(this, "This name is already exist", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
DbClass.executequery(CommandType.Text, "insert into userdetail(UserName,Password,Login,LastloginDate,DatabaseName) values('" + sUName.Trim() + "' , '" + suPassword.Trim() + "' , " + LoginStatus + ", '" + PublicClass.GetDatetime() + "' , '" + PublicClass.databasename + "')");
DbClass.executequery(CommandType.Text, "Insert into login_data(User_ID,uPassword,Upload,Download) values('" + sUName.Trim() + "' , '" + suPassword.Trim() + "' ," + 0 + ", " + 0 + " )");
}
}
else if (ADD_Edit == "Edit")
{
if (PublicClass.uName.Trim() != sUName || PublicClass.uPassword.Trim() != suPassword)
{
DbClass.executequery(CommandType.Text, "Update userdetail set UserName = '******' , Password = '******' , Login = '******' where ID = '" + PublicClass.uID.Trim() + "' ");
DbClass.executequery(CommandType.Text, "Update usersettings set UserName = '******' where UserDetailID = '" + PublicClass.uID.Trim() + "' ");
DbClass.executequery(CommandType.Text, "Update login_data set User_ID = '" + sUName + "' , uPassword = '******' where User_ID = '" + PublicClass.uName.Trim() + "' and uPassword = '******'");
MessageBox.Show("Update Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
this.Close();
}
}
catch
{
}
}