public static void insert(Areas.Models.PhongBan tin)
{
openConnect();
SqlCommand cmd = new SqlCommand("sp_insert_PhongBan", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ten", tin.IdDM);
cmd.Parameters.AddWithValue("@DanhMucCha", tin.IdQL);
cmd.Parameters.AddWithValue("@MetaTitle", XuLiChuoi.xoaKhoangTrang(tin.Email.Trim()));
cmd.ExecuteNonQuery();
closeConnect();
}
public static List <Areas.Models.PhongBan> select()
{
openConnect();
List <Areas.Models.PhongBan> list = new List <Areas.Models.PhongBan>();
SqlCommand cmd = new SqlCommand("select PhongBan.id,PhongBan.IdDanhMuc,DanhMuc.Ten,PhongBan.QuanLi,NhanVien.Ten as 'tenql',PhongBan.Email from PhongBan,DanhMuc,NhanVien where PhongBan.IdDanhMuc = DanhMuc.Id and PhongBan.QuanLi = NhanVien.id", con);
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
Areas.Models.PhongBan tt = new Areas.Models.PhongBan();
tt.Id = rd["id"] is DBNull ? 0 : rd.GetInt32(0);
tt.IdDM = rd["IdDanhMuc"] is DBNull ? 1 : rd.GetInt32(1);
tt.TenDM = rd["Ten"] is DBNull ? "" : rd.GetString(2).Trim();
tt.IdQL = rd["QuanLi"] is DBNull ? 0 : rd.GetInt32(3);
tt.TenQL = rd["tenql"] is DBNull ? "" : rd.GetString(4).Trim();
tt.Email = rd["Email"] is DBNull ? "" : rd.GetString(5).Trim();
list.Add(tt);
}
rd.Close();
closeConnect();
return(list);
}