// GET: Admin/DocGia
public ActionResult Index()
{
db = new TRUONGHOCDbContext();
var sinhvien = db.tblSinhViens.Where(x => x.TINH_TRANG == 1).ToList();
var giangvien = db.tblNhanViens.Where(x => x.MA_CHUCVU.Contains("CV001")).ToList();
var loai = db.tblLoaiDocGias.Where(x => x.TRANG_THAI == 1);
Session["loai"] = loai;
List <tblDocGia> list = new List <tblDocGia>();
foreach (var item in sinhvien)
{
tblDocGia docGia = new tblDocGia();
docGia.MA_DOCGIA = item.MA_SINHVIEN;
docGia.MA_LOAI = "SV";
docGia.MA_THE = item.MA_SINHVIEN;
docGia.NGAY_SINH = item.NGAY_SINH;
docGia.SO_DTHOAI = item.SO_DTHOAI;
docGia.TEN_DOCGIA = item.HO_TEN;
docGia.TRANG_THAI = 1;
docGia.GIOI_TINH = item.GIOI_TINH;
docGia.GHI_CHU = item.GHI_CHU;
list.Add(docGia);
}
foreach (var item1 in giangvien)
{
tblDocGia docGia2 = new tblDocGia();
docGia2.MA_DOCGIA = item1.MA_NHANVIEN;
docGia2.MA_LOAI = "GV";
docGia2.MA_THE = item1.MA_NHANVIEN;
docGia2.NGAY_SINH = item1.NGAY_SINH;
docGia2.GIOI_TINH = item1.GIOI_TINH;
docGia2.TEN_DOCGIA = item1.HO_TEN;
docGia2.SO_DTHOAI = item1.SO_DIENTHOAI;
docGia2.TRANG_THAI = 1;
docGia2.GHI_CHU = item1.GHI_CHU;
list.Add(docGia2);
}
return(View(list));
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (CheckData())
{
tblDocGia Sach = new tblDocGia();
Sach.MADOCGIA = int.Parse(txtMaDoCGia.Text);
if (bllDocGia.DeleteDocGia(Sach))
{
this.ShowAllDocGia();
this.ResetText();
MessageBox.Show("Bạn đã xóa đọc giả thành công!", "Thông Báo!");
}
else
{
MessageBox.Show("Đã có lỗi sảy ra xin thử lại sau", " Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
}
// xóa sách
public bool DeleteDocGia(tblDocGia item)
{
string sql = "Delete DOCGIAS Where MADOCGIA= @MADOCGIA";
SqlConnection con = dc.GetConnection();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MADOCGIA", SqlDbType.Int).Value = item.MADOCGIA;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
private void btnSua_Click(object sender, EventArgs e)
{
if (CheckData())
{
tblDocGia Sach = new tblDocGia();
Sach.MADOCGIA = int.Parse(txtMaDoCGia.Text);
Sach.HOTEN = txtHoTen.Text;
Sach.SDT = txtSDT.Text;
Sach.EMAIL = TXTEmail.Text;
if (bllDocGia.UpdateDocGia(Sach))
{
this.ShowAllDocGia();
this.ResetText();
MessageBox.Show("Bạn đã sửa đọc giả thành công!", "Thông Báo!");
}
else
{
MessageBox.Show("Đã có lỗi sảy ra xin thử lại sau", " Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
}
// thêm đọc giả
public bool InsertDocGia(tblDocGia item)
{
string sql = "insert into DOCGIAS(MADOCGIA, HOTEN, SDT, EMAIL) " +
"VALUES(@MADOCGIA, @HOTEN, @SDT, @EMAIL)";
SqlConnection con = dc.GetConnection();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MADOCGIA", SqlDbType.Int).Value = item.MADOCGIA;
cmd.Parameters.Add("@HOTEN", SqlDbType.NVarChar).Value = item.HOTEN;
cmd.Parameters.Add("@SDT", SqlDbType.NVarChar).Value = item.SDT;
cmd.Parameters.Add("@EMAIL", SqlDbType.NVarChar).Value = item.EMAIL;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
// chỉnh sửa DocGia
public bool UpdateDocGia(tblDocGia item)
{
string sql = "Update DOCGIAS " +
"set MADOCGIA = @MADOCGIA, HOTEN= @HOTEN, SDT=@SDT, EMAIL=@EMAIL" +
" WHERE MADOCGIA = @MADOCGIA ";
SqlConnection con = dc.GetConnection();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MADOCGIA", SqlDbType.Int).Value = item.MADOCGIA;
cmd.Parameters.Add("@HOTEN", SqlDbType.NVarChar).Value = item.HOTEN;
cmd.Parameters.Add("@SDT", SqlDbType.NVarChar).Value = item.SDT;
cmd.Parameters.Add("@EMAIL", SqlDbType.NVarChar).Value = item.EMAIL;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public bool DeleteDocGia(tblDocGia DocGia)
{
return(daBLL.DeleteDocGia(DocGia));
}
public bool UpdateDocGia(tblDocGia DocGia)
{
return(daBLL.UpdateDocGia(DocGia));
}
public bool InsertDocGia(tblDocGia DocGia)
{
return(daBLL.InsertDocGia(DocGia));
}
