public ActionResult Index(string username, string pass)
{
int kq;
if (Int32.TryParse(username, out kq))
{
kq = DAL.Login.login(username, pass);
}
else
{
kq = 0;
}
if (kq != 0)
{
Areas.Models.NhanVien nv = new Areas.Models.NhanVien();
nv = DAL.Login.getauthority(username);
Session["login"] = username;
//return RedirectToAction("Index", "Home", new { id = "100" });
return(RedirectToAction("Index", "Home", new { id = nv.Id }));
}
else
{
ModelState.AddModelError("", "Đăng nhập không thành công");
}
return(View());
}
public ActionResult Edit(int id)
{
ViewBag.listDM = DAL.DanhMuc.select();
Areas.Models.NhanVien nv = DAL.NhanVien.selectNV(id);
nv.Id = id;
return(View(nv));
}
public ActionResult InsertNV(Areas.Models.NhanVien nv, string selectDM)
{
ViewBag.listDM = DAL.DanhMuc.select();
nv.IdDM = Int32.Parse(selectDM);
DAL.NhanVien.insert(nv);
return(RedirectToAction("Index"));
}
public ActionResult Edit(Areas.Models.NhanVien nv, int id)
{
ViewBag.listDM = DAL.DanhMuc.select();
nv.Id = id;
DAL.NhanVien.update(nv);
return(RedirectToAction("Index"));
}
public static List <Areas.Models.NhanVien> selectDSTongBT()
{
openConnect();
List <Areas.Models.NhanVien> list = new List <Areas.Models.NhanVien>();
SqlCommand cmd = new SqlCommand("select NhanVien as mnv,NhanVien.Ten,NhanVien.Email,NgayThem from TongBienTap,NhanVien where NhanVien.Id = TongBienTap.NhanVien ", con);
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
Areas.Models.NhanVien tt = new Areas.Models.NhanVien();
tt.Id = rd["mnv"] is DBNull ? 0 : rd.GetInt32(0);
tt.Ten = rd["Ten"] is DBNull ? "" : rd.GetString(1);
tt.Email = rd["Email"] is DBNull ? "" : rd.GetString(2).Trim();
tt.NgayThem = rd.GetDateTime(3);
list.Add(tt);
}
rd.Close();
closeConnect();
return(list);
}
public static List <Areas.Models.NhanVien> selectDSNV()
{
openConnect();
List <Areas.Models.NhanVien> list = new List <Areas.Models.NhanVien>();
SqlCommand cmd = new SqlCommand("select id,ten,email from nhanvien", con);
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
Areas.Models.NhanVien tt = new Areas.Models.NhanVien();
tt.Id = rd["id"] is DBNull ? 0 : rd.GetInt32(0);
tt.Ten = rd["ten"] is DBNull ? "" : rd.GetString(1);
tt.Email = rd["email"] is DBNull ? "" : rd.GetString(2).Trim();
list.Add(tt);
}
rd.Close();
closeConnect();
return(list);
}
public static void update(Areas.Models.NhanVien nv)
{
con.Open();
SqlCommand cmd = new SqlCommand("sp_update_NhanVien", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", nv.Id);
cmd.Parameters.AddWithValue("@Ten", nv.Ten);
cmd.Parameters.AddWithValue("@NgaySinh", nv.NgaySinh);
cmd.Parameters.AddWithValue("@Email", nv.Email);
cmd.Parameters.AddWithValue("@Admin", nv.Admin);
if (nv.IdDM != 0)
{
cmd.Parameters.AddWithValue("@DanhMuc", nv.IdDM);
}
else
{
cmd.Parameters.AddWithValue("@DanhMuc", DBNull.Value);
}
cmd.ExecuteNonQuery();
con.Close();
}
public static List <Areas.Models.NhanVien> selectDSMod(string idPB)
{
openConnect();
List <Areas.Models.NhanVien> list = new List <Areas.Models.NhanVien>();
SqlCommand cmd = new SqlCommand("select NhanVien as mnv,NhanVien.Ten,NhanVien.Email,NgayThem from Mod,PhongBan,NhanVien where NhanVien.Id = mod.NhanVien and PhongBan.Id = @idPB", con);
cmd.Parameters.AddWithValue("@idPB", idPB);
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
Areas.Models.NhanVien tt = new Areas.Models.NhanVien();
tt.Id = rd["mnv"] is DBNull ? 0 : rd.GetInt32(0);
tt.Ten = rd["Ten"] is DBNull ? "" : rd.GetString(1);
tt.Email = rd["Email"] is DBNull ? "" : rd.GetString(2).Trim();
tt.NgayThem = rd.GetDateTime(3);
list.Add(tt);
}
rd.Close();
closeConnect();
return(list);
}
public static Areas.Models.NhanVien selectNV(int id)
{
Areas.Models.NhanVien nv = new Areas.Models.NhanVien();
SqlCommand cmd = new SqlCommand(" select nhanvien.ID,nhanvien.Ten,NgaySinh,email,admin,DanhMuc,DanhMuc.Ten as TenDM from NhanVien LEFT JOIN DanhMuc on NhanVien.DanhMuc = DanhMuc.Id where nhanvien.id = @id", con);
cmd.Parameters.AddWithValue("@id", id);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
nv.Id = dr["Id"] is DBNull ? 0 : dr.GetInt32(0);
nv.Ten = dr["Ten"] is DBNull ? "" : dr.GetString(1);
nv.NgaySinh = dr["NgaySinh"] is DBNull ? d : dr.GetDateTime(2).Date;
nv.Email = dr["Email"] is DBNull ? "" : dr.GetString(3);
nv.Admin = dr["Admin"] is DBNull ? false : dr.GetBoolean(4);
nv.IdDM = dr["DanhMuc"] is DBNull ? 0 : dr.GetInt32(5);
nv.TenDM = dr["TenDM"] is DBNull ? "Không" : dr.GetString(6);
}
dr.Close();
con.Close();
return(nv);
}
public static List <Areas.Models.NhanVien> selectList()
{
List <Areas.Models.NhanVien> l = new List <Areas.Models.NhanVien>();
SqlCommand cmd = new SqlCommand("select * from NhanVien", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Areas.Models.NhanVien nv = new Areas.Models.NhanVien();
nv.Id = dr["Id"] is DBNull ? 0 : dr.GetInt32(0);
nv.Ten = dr["Ten"] is DBNull ? "" : dr.GetString(1);
nv.NgaySinh = dr["NgaySinh"] is DBNull ? d : dr.GetDateTime(2);
nv.Email = dr["Email"] is DBNull ? "" : dr.GetString(3);
nv.Admin = dr["Admin"] is DBNull ? false : dr.GetBoolean(5);
l.Add(nv);
}
dr.Close();
con.Close();
return(l);
}
