public static int insertusermaster(usermasterentity objm)
{
DbCommand dbcom = BaseDb.CreateStrCommand();
try
{
string abc = objm.Getfrom_dt.ToString();
string def = objm.Getto_dt.ToString();
if (objm.Getto_dt.ToString() != "Null" && objm.Getfrom_dt.ToString() != "Null")
{
dbcom.CommandText = "insert into usermaster(userid,username,password,start_dt,close_dt,status,created_by,created_dt) values('" + objm.Getuserid + "','" + objm.Getusername + "','" + objm.Getpassword + "','" + Convert.ToDateTime(objm.Getfrom_dt.ToString()).Date + "','" + dateconvert.Convertdt(objm.Getto_dt.ToString()) + "','" + objm.Getstatus + "','" + objm.Getcreated_by + "','" + dateconvert.Convertdt(objm.Getcreated_dt.ToString()) + "')";
}
else if (objm.Getto_dt.ToString() == "Null")
{
dbcom.CommandText = "insert into usermaster(userid,username,password,start_dt,status,created_by,created_dt) values('" + objm.Getuserid + "','" + objm.Getusername + "','" + objm.Getpassword + "','" + dateconvert.Convertdt(objm.Getfrom_dt.ToString()) + "','" + objm.Getstatus + "','" + objm.Getcreated_by + "','" + dateconvert.Convertdt(objm.Getcreated_dt.ToString()) + "')";
}
BaseDb.ExecuteNonQuery(dbcom);
return(1);
}
catch (Exception ex)
{
throw (ex);
}
}
public static void updatepassword(usermasterentity objm)
{
try
{
DbCommand cmd = BaseDb.CreateStrCommand();
cmd.CommandText = "update usermaster set password='******'where userid='" + objm.Getuserid + "'";
BaseDb.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw (ex);
}
}
public static void updateusermaster(usermasterentity objm)
{
try
{
DbCommand dbcom = BaseDb.CreateStrCommand();
if (objm.Getto_dt.ToString() != "Null")
{
dbcom.CommandText = "update usermaster set close_dt='" + objm.Getto_dt + "',status='" + objm.Getstatus + "',updated_by='" + objm.Getupdated_by + "',updated_dt='" + objm.Getupdated_dt + "' where srno=" + objm.Getsrno;
}
else if (objm.Getto_dt.ToString() == "Null")
{
dbcom.CommandText = "update usermaster set status='" + objm.Getstatus + "',updated_by='" + objm.Getupdated_by + "',updated_dt='" + objm.Getupdated_dt + "' where srno=" + objm.Getsrno;
}
BaseDb.ExecuteNonQuery(dbcom);
}
catch (Exception ex)
{
throw (ex);
}
}
protected void btnupdate_Click(object sender, EventArgs e)
{
if (Session["uname"] == null || Session["password"] == null)
{
Response.Redirect("adminlogin.aspx");
}
else
{
try
{
usermasterentity objm = new usermasterentity();
objm.Getsrno = Convert.ToInt16(Session["useridusermaster"].ToString());
if (txtclosedt.Text == "")
{
SqlDateTime date1 = SqlDateTime.Null;
objm.Getto_dt = date1;
}
else
{
//objm.Getto_dt = Convert.ToDateTime(txtclosedt.Text.ToString());
objm.Getto_dt = (SqlDateTime)(DateTime.Parse(txtclosedt.Text, System.Globalization.CultureInfo.CreateSpecificCulture("en-AU").DateTimeFormat));
}
objm.Getupdated_by = username1;
objm.Getupdated_dt = SqlDateTime.Parse(dat);
objm.Getstatus = ddstatus.SelectedValue;
usermasterbl.updateusermaster(objm);
lblmsg.Visible = true;
lblmsg.Text = "Data Updated successfully";
Session["savebtn"] = 1;
Session["backbtn"] = 0;
Session["searchbtn"] = 0;
txtclosedt.Enabled = false;
}
catch (Exception ex)
{
throw (ex);
}
lblmsgvalid.Visible = false;
}
}
protected void btnchangepwd_Click(object sender, EventArgs e)
{
if (Session["uname"] == null || Session["password"] == null)
{
Response.Redirect("adminlogin.aspx");
}
else
{
if (txtoldpwd.Text == "")
{
lblmsg.Text = "Enter Required fields";
lblmsg.Visible = true;
}
else if (txtnewpwd.Text == "" || txtconfirmnewpwd.Text == "")
{
lblmsg.Text = "Enter Required fields";
lblmsg.Visible = true;
jscall("Enter required fields...");
}
else if (txtconfirmnewpwd.Text == "" && txtnewpwd.Text == "")
{
lblmsg.Text = "Enter Required fields";
lblmsg.Visible = true;
jscall("Enter required fields...");
}
else
{
DataTable dt = changepasswordbl.GetPassword(Session["uname"].ToString());
if (dt.Rows.Count > 0)
{
oldpwd = dt.Rows[0]["password"].ToString();
}
string enteredpwd = changepasswordbl.computehash(txtoldpwd.Text);
if (oldpwd == enteredpwd)
{
if (txtnewpwd.Text != txtconfirmnewpwd.Text)
{
lblmsg.Text = "New Password and Confirm New Password should be same";
lblmsg.Visible = true;
}
else
{
lblmsg.Text = "";
lblmsg.Visible = false;
usermasterentity objm = new usermasterentity();
string newpswd = changepasswordbl.computehash(txtnewpwd.Text);
objm.Getpassword = newpswd;
objm.Getuserid = Session["uname"].ToString();
changepasswordbl.updatepassword(objm);
jscall1("Password changed successfully");
}
}
else
{
lblmsg.Text = "Old Password does not match.Re-enter";
lblmsg.Visible = true;
// jscall("Old Password doesn't match");
//return;
// txtoldpwd.Text = "";
// txtoldpwd.Focus();
}
}
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
if (Session["uname"] == null || Session["password"] == null)
{
Response.Redirect("adminlogin.aspx");
}
else
{
if (txtuserid.Text == "" || txtusername.Text == "" || txtpassword.Text == "" || txtstartdt.Text == "")
{
lblreqfldmsg.Visible = true;
jscall("Enter required fields...");
return;
}
else if (txtuserid.Text == "" && txtusername.Text == "" && txtpassword.Text == "" && txtstartdt.Text == "")
{
lblreqfldmsg.Visible = true;
jscall("Enter required fields...");
return;
}
else
{
Page.Validate();
if (Page.IsValid == true)
{
try
{
usermasterentity objm = new usermasterentity();
objm.Getuserid = txtuserid.Text;
objm.Getusername = txtusername.Text;
objm.Getpassword = usermasterbl.computehash(txtpassword.Text);
objm.Getstatus = ddstatus.SelectedValue;
if (txtclosedt.Text == "")
{
SqlDateTime date1 = SqlDateTime.Null;
objm.Getto_dt = date1;
}
else
{
objm.Getto_dt = (SqlDateTime)(DateTime.Parse(txtclosedt.Text, System.Globalization.CultureInfo.CreateSpecificCulture("en-AU").DateTimeFormat));
}
if (txtstartdt.Text == "")
{
SqlDateTime date1 = SqlDateTime.Null;
objm.Getfrom_dt = date1;
}
else
{
objm.Getfrom_dt = (SqlDateTime)(DateTime.Parse(txtstartdt.Text, System.Globalization.CultureInfo.CreateSpecificCulture("en-AU").DateTimeFormat));
}
objm.Getcreated_by = username1;
objm.Getcreated_dt = SqlDateTime.Parse(dat);
int i = usermasterbl.insertusermaster(objm);
if (i == 1)
{
lblmsg.Visible = true;
lblmsg.Text = "User created successfully";
Session["savebtn"] = 1;
Session["backbtn"] = 0;
Session["searchbtn"] = 0;
}
else
{
lblmsg.Text = "";
}
}
catch (Exception ex)
{
//throw (ex);
lblmsg.Visible = true;
lblmsg.Text = "User ID already exists...";
txtuserid.Text = "";
txtuserid.Focus();
return;
}
clearall();
txtuserid.Focus();
lblmsgvalid.Visible = false;
}
else
{
lblmsgvalid.Text = "Check Validations!";
return;
}
}
}
}
