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)); }