public List<clsAdmin> GetAll()
{
try
{
List<clsAdmin> list = new List<clsAdmin>();
string str = "select * from tblAdmin";
SqlCommand com = new SqlCommand(str, con.getCon());
con.openCon();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
clsAdmin obj = new clsAdmin();
if (dr["ten"] != DBNull.Value)
{
obj.Ten = dr["ten"].ToString();
}
if (dr["tendangnhap"] != DBNull.Value)
{
obj.TenDangNhap = dr["tendangnhap"].ToString();
}
if (dr["matkhau"] != DBNull.Value)
{
obj.MatKhau = dr["matkhau"].ToString();
}
if (dr["id"] != DBNull.Value)
{
obj.Id = Convert.ToInt32(dr["id"].ToString());
}
list.Add(obj);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminID"] == null || Session["AdminID"].ToString() == "")
{
Response.Redirect("~/Admin/Login/Login.aspx");
}
else
{
clsBSAdmin obj = new clsBSAdmin();
clsAdmin clss = new clsAdmin();
clss = obj.GetById(Convert.ToInt32(Session["AdminID"]));
lblMessage.Visible = true;
lblMessage.Text = "Xin chào: " + clss.Ten + " - <a href=\"Login\\Logout.aspx\">Logout</a>";
}
//this.MenuMain.LoadContentFile("~/Admin/File/menu_vn.xml");
//this.MenuMain.DataBind();
if (!Page.IsPostBack)
{
Session["Status"] = null;
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
clsBSAdmin obj = new clsBSAdmin();
clsAdmin clss = new clsAdmin();
clss = obj.GetByUserPassword(this.txtUserName.Text, this.txtPassword.Text);
if (clss != null)
{
Session["AdminID"] = clss.Id;
Response.Redirect("~/Admin/Default.aspx");
}
else
{
this.lblMessage.Text = "Đăng nhập không thành công";
}
}
catch (Exception)
{
throw;
}
}
public clsAdmin GetById(int id)
{
try
{
clsAdmin obj = new clsAdmin();
string str = "select * from tblAdmin where id=@id";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@id", id);
con.openCon();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
obj.Id = id;
if (dr["ten"] != DBNull.Value)
{
obj.Ten = dr["ten"].ToString();
}
if (dr["tendangnhap"] != DBNull.Value)
{
obj.TenDangNhap = dr["tendangnhap"].ToString();
}
if (dr["matkhau"] != DBNull.Value)
{
obj.MatKhau = dr["matkhau"].ToString();
}
}
return obj;
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
public void Update(clsAdmin obj)
{
try
{
string str = "Update tblAdmin set ten=@ten,tendangnhap=@tendangnhap,matkhau=@matkhau where id=@id";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@ten", obj.Ten);
com.Parameters.AddWithValue("@tendangnhap", obj.TenDangNhap);
com.Parameters.AddWithValue("@id", obj.Id);
com.Parameters.AddWithValue("@matkhau", obj.MatKhau);
con.openCon();
com.ExecuteNonQuery();
con.closeCon();
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
public int Insert(clsAdmin obj)
{
try
{
string str = "insert into tblAdmin(ten,tendangnhap,matkhau) values(@ten,@tendangnhap,@matkhau)";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@ten", obj.Ten);
com.Parameters.AddWithValue("@tendangnhap", obj.TenDangNhap);
com.Parameters.AddWithValue("@matkhau", obj.MatKhau);
con.openCon();
com.ExecuteNonQuery();
con.closeCon();
return clsDAStaticMethod.getIDIdentity("tblAdmin");
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
public clsAdmin GetByUserPassword(string username,string password)
{
try
{
clsAdmin obj = new clsAdmin();
string str = "select * from tblAdmin where tendangnhap=@tendangnhap and matkhau=@matkhau";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@tendangnhap", username);
com.Parameters.AddWithValue("@matkhau", password);
con.openCon();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
if (dr["ten"] != DBNull.Value)
{
obj.Ten = dr["ten"].ToString();
}
if (dr["tendangnhap"] != DBNull.Value)
{
obj.TenDangNhap = dr["tendangnhap"].ToString();
}
if (dr["matkhau"] != DBNull.Value)
{
obj.MatKhau = dr["matkhau"].ToString();
}
if (dr["id"] != DBNull.Value)
{
obj.Id = Convert.ToInt32(dr["id"].ToString());
}
}
return obj;
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}