public void CalenGiaoVienThem()
{
if (txtghichu.Text == "")
{
ToastNotification.Show(this, "Vui lòng điền đủ thông tin!", null, 2000, (eToastGlowColor)eToastGlowColor.Blue, (eToastPosition)eToastPosition.BottomCenter);
return;
}
DataTable numberr;
dtoGiaoVien = new DTO_GiaoVien()
{
ID_TEACHER = Convert.ToInt32(cbGiaoVien.SelectedValue),
ID_CLASS = Convert.ToInt32(cbPhongHoc.SelectedValue),
_Date = dtngaysua.Value.ToString("yyyy-MM-dd"),
IM = txtghichu.Text
};
numberr = _gv.GiaoVienCalenThem(ref err, dtoGiaoVien);
if (numberr.Rows.Count > 0)
{
cbGiaoVien.SelectedIndex = -1;
cbPhongHoc.SelectedIndex = -1;
cbtruonghoc.SelectedIndex = -1;
txtghichu.Clear();
ToastNotification.Show(this, numberr.Rows[0]["ErrMsg"].ToString(), null, 2000, (eToastGlowColor)eToastGlowColor.Blue, (eToastPosition)eToastPosition.BottomCenter);
}
}
public List <DTO_GiaoVien> load_GV()
{
string query = "select * from GiaoVien";
conn.Open();
DataTable data = base.GetDataTable(query);
if (data.Rows.Count == 0)
{
return(null);
}
List <DTO_GiaoVien> listGV = new List <DTO_GiaoVien>();
for (int i = 0; i < data.Rows.Count; i++)
{
DTO_GiaoVien gv = new DTO_GiaoVien();
gv.Ma_GiaoVien = data.Rows[i]["Ma_GiaoVien"].ToString();
gv.HoTen = data.Rows[i]["HoTen"].ToString();
gv.Ma_Khoa = data.Rows[i]["Ma_Khoa"].ToString();
gv.Ma_BoMon = data.Rows[i]["Ma_BoMon"].ToString();
gv.GioiTinh = data.Rows[i]["GioiTinh"].ToString();
gv.NgaySinh = DateTime.Parse(data.Rows[i]["NgaySinh"].ToString());
gv.Email = data.Rows[i]["Email"].ToString();
gv.ChucVu = data.Rows[i]["ChucVu"].ToString();
gv.HocHam = data.Rows[i]["Ma_HocHam"].ToString();
gv.HocVi = data.Rows[i]["Ma_HocVi"].ToString();
gv.Ma_MonHoc1 = data.Rows[i]["Ma_MonHoc"].ToString();
gv.DiaChi1 = data.Rows[i]["DiaChi"].ToString();
listGV.Add(gv);
}
conn.Close();
return(listGV);
}
public bool Them(DTO_GiaoVien gv)
{
string query = "INSERT INTO dbo.GiaoVien( Ma_GiaoVien , HoTen ,NgaySinh ,GioiTinh , Email ,Ma_HocVi ,Ma_HocHam ,Ma_Khoa ,Ma_BoMon , Ma_MonHoc ,ChucVu ,DiaChi,paths )VALUES ( '" + gv.Ma_GiaoVien + "' , N'" + gv.HoTen + "' , '" + gv.NgaySinh + "',N'" + gv.GioiTinh + "' , '" + gv.Email + "' , '" + gv.HocVi + "' , '" + gv.HocHam + "' , '" + gv.Ma_Khoa + "' , '" + gv.Ma_BoMon + "' , '" + gv.Ma_MonHoc1 + "' , N'" + gv.ChucVu + "' , N'" + gv.DiaChi1 + "','" + gv.DuongDanAnh + "' )";
conn.Open();
try
{
base.executeQuery(query);
conn.Close();
return(true);
}
catch (Exception ex)
{
conn.Close();
return(false);
}
}
public DataTable GiaoVienXoa(ref string err, DTO_GiaoVien gv)
{
DataTable _dt = new DataTable();
try
{
return(_dt = data.GetDataTable("sp_GiaoVienXoa", CommandType.StoredProcedure, ref err
, new SqlParameter("@ID_TEACHER", gv.ID_TEACHER)
));
}
catch (Exception ex)
{
err = ex.Message;
return(_dt);
}
}
public void XoaGiaoVien()
{
DataTable numberr;
dtoGiaoVien = new DTO_GiaoVien()
{
ID_TEACHER = Convert.ToInt32(lblmagv.Text)
};
numberr = _gv.GiaoVienXoa(ref err, dtoGiaoVien);
if (numberr.Rows.Count > 0)
{
lblmagv.Text = "0";
txtgiaovien.Clear();
txtgiaovien.Focus();
ToastNotification.Show(this, numberr.Rows[0]["ErrMsg"].ToString(), null, 2000, (eToastGlowColor)eToastGlowColor.Blue, (eToastPosition)eToastPosition.BottomCenter);
}
}
public DataTable GiaoVienCalenThem(ref string err, DTO_GiaoVien gv)
{
DataTable _dt = new DataTable();
try
{
return(_dt = data.GetDataTable("sp_CalenThem", CommandType.StoredProcedure, ref err
, new SqlParameter("@ID", gv.ID_TEACHER)
, new SqlParameter("@IDclass", gv.ID_CLASS)
, new SqlParameter("@date", gv._Date)
, new SqlParameter("@im", gv.IM)
));
}
catch (Exception ex)
{
err = ex.Message;
return(_dt);
}
}
//Hàm sửa thông tin giáo viên
public bool SuaThongTin(DTO_GiaoVien a)
{
conn.Open();
string SQL = "UPDATE dbo.GiaoVien SET Ma_GiaoVien='" + a.Ma_GiaoVien + "',HoTen=N'" + a.HoTen + "',NgaySinh='" + a.NgaySinh.ToString() + "',GioiTinh=N'" + a.GioiTinh + "',Email='" + a.Email + "',Ma_HocVi='" + a.HocVi + "',Ma_HocHam='" + a.HocHam + "',Ma_Khoa='" + a.Ma_Khoa + "',Ma_BoMon='" + a.Ma_BoMon + "',Ma_MonHoc='" + a.Ma_MonHoc1 + "',ChucVu=N'" + a.ChucVu + "',DiaChi=N'" + a.DiaChi1 + "' WHERE Ma_GiaoVien='" + a.Ma_GiaoVien + "'";
try
{
SqlCommand cmd = new SqlCommand(SQL, conn);
// Query và kiểm tra
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception ex)
{
conn.Close();
return(false);
}
}
public void ThemGiaoVien()
{
if (txtgiaovien.Text == "")
{
ToastNotification.Show(this, "Vui lòng điền đủ thông tin!", null, 2000, (eToastGlowColor)eToastGlowColor.Blue, (eToastPosition)eToastPosition.BottomCenter);
return;
}
DataTable numberr;
dtoGiaoVien = new DTO_GiaoVien()
{
NAME_TEACHER = txtgiaovien.Text.Trim()
};
numberr = _gv.GiaoVienThem(ref err, dtoGiaoVien);
if (numberr.Rows.Count > 0)
{
ToastNotification.Show(this, numberr.Rows[0]["ErrMsg"].ToString(), null, 2000, (eToastGlowColor)eToastGlowColor.Blue, (eToastPosition)eToastPosition.BottomCenter);
}
}
public void CalenGiaoVienCapNhat(int STT)
{
DataTable numberr;
dtoGiaoVien = new DTO_GiaoVien()
{
ID_TEACHER = _id,
ID_CLASS = _class,
_Date = dtngaysua.Value.ToString("yyyy-MM-dd"),
IM = txtghichu.Text
};
numberr = _gv.GiaoVienCalenCapNhat(ref err, dtoGiaoVien, STT);
if (numberr.Rows.Count > 0)
{
cbGiaoVien.SelectedIndex = -1;
cbPhongHoc.SelectedIndex = -1;
cbtruonghoc.SelectedIndex = -1;
txtghichu.Clear();
ToastNotification.Show(this, numberr.Rows[0]["ErrMsg"].ToString(), null, 2000, (eToastGlowColor)eToastGlowColor.Blue, (eToastPosition)eToastPosition.BottomCenter);
}
}
public void LoadLichNhanvien(ref string err, ComboBox combo)
{
_dtogv = new DTO_GiaoVien()
{
ID_TEACHER = Convert.ToInt32(cbgiaovien.SelectedValue),
ID_CLASS = cls_Main._PhongValue
};
DataTable numberr;
numberr = _gv.LichGiaoVien(ref err, _dtogv);
if (numberr.Rows.Count > 0)
{
combo.DataSource = numberr;
combo.DisplayMember = "ThongTin";
combo.ValueMember = "STT";
}
else
{
combo.SelectedIndex = -1;
combo.DataSource = numberr;
}
}
public bool sua(DTO_GiaoVien a)
{
return(dAL.SuaThongTin(a));
}
public bool Them(DTO_GiaoVien gv)
{
return(dAL.Them(gv));
}
public bool SuaGiaoVien(DTO_GiaoVien a)
{
return(giaoVien.SuaGiaoVien(a));
}
public bool ThemGiaoVien(DTO_GiaoVien a)
{
return(giaoVien.ThemGiaoVien(a));
}
