//Ham them bac si moi vao danh sach
public bool ThemBacSi(BacSi bs)
{
string sql = string.Format(" exec sp_ThemBacSi '{0}','{1}', '{2}', '{3}', N'{4}', N'{5}', N'{6}', N'{7}', '{8}', '{9}', '{10}', N'{11}', N'{12}', N'{13}', N'{14}', N'{15}', N'{16}' "
, bs.MaBacSi, bs.MaPhongKham, bs.MaPhongBenh, bs.MaKhoa, bs.Ho, bs.Ten, bs.GioiTinh, bs.NgaySinh.ToString("MM/dd/yyyy"),
bs.CMND, bs.Email, bs.SDT, bs.DiaChi, bs.NgayVaoLam.ToString("MM/dd/yyyy"), bs.ChucVu, bs.TrinhDo, bs.HocHam, bs.HocVi, bs.MaBacSi, bs.MaPhongKham);
if (conn.ExcuteQuery(sql))
{
MessageBox.Show("Thêm Bác sĩ thành công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return true;
}
else
return false;
}
//Ham lay thong tin bac si trong event cua datagridview
private BacSi LayThongTinBacSi()
{
BacSi bs = new BacSi();
bs.MaBacSi = txtQLNS_MaBacSi.Text;
bs.MaKhoa = cboQLNS_MaKhoaBS.SelectedValue.ToString();
bs.MaPhongBenh = cboQLNS_PhongBenhBS.SelectedValue.ToString();
bs.MaPhongKham = cboQLNS_PhongKhamBS.SelectedValue.ToString();
bs.Ho = txtQLNS_HoBS.Text;
bs.Ten = txtQLNS_TenBS.Text;
bs.NgaySinh = Convert.ToDateTime(dtPickerQLNS_NgaySinh.Value.ToString());
bs.GioiTinh = cboQLNS_GioiTinhBS.SelectedValue.ToString();
bs.CMND = Convert.ToInt32(txtQLNS_CMNDBS.Text);
bs.Email = txtQLNS_EmailBS.Text;
bs.SDT = Convert.ToInt64(txtQLNS_SDTBS.Text);
bs.DiaChi = txtQLNS_DiaChiBS.Text;
bs.NgayVaoLam = Convert.ToDateTime(dtPickerQLNS_NgayVaoLamBS.Value.ToString());
bs.MaKhoa = cboQLNS_MaKhoaBS.SelectedValue.ToString();
bs.ChucVu = txtQLNS_ChucVuBS.Text;
bs.TrinhDo = cboQLNS_TrinhDoBS.Text;
bs.HocHam = cboQLNS_HocHamBS.Text;
bs.HocVi = cboQLNS_HocViBS.Text;
return bs;
}
/* public bool ThemBacSi(BacSi bs)
{
string sql = string.Format("Insert into BACSI(STT, MaBacSi, MaKhoa, Ho, Ten, GioiTinh, NgaySinh, CMND, Email, SDT, DiaChi, NgayVaoLam, ChucVu, TrinhDo,"
+ "HocHam, HocVi) values('{0}','{1}', '{2}', N'{3}', N'{4}', N'{5}', N'{6}', '{7}', '{8}', '{9}', N'{10}', N'{11}', N'{12}', N'{13}', N'{14}', N'{15}')",
"0",bs.MaBacSi, bs.MaKhoa, bs.Ho, bs.Ten, bs.GioiTinh, bs.NgaySinh.ToString("MM/dd/yyyy"), bs.CMND, bs.Email, bs.SDT, bs.DiaChi, bs.NgayVaoLam.ToString("MM/dd/yyyy"),
bs.ChucVu, bs.TrinhDo, bs.HocHam, bs.HocVi);
if (conn.ExcuteQuery(sql))
{
MessageBox.Show("Thêm Bác sĩ thành công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return true;
}
else
return false;
}
*/
public bool SuaDoiBacSi(BacSi bs)
{
string sql = string.Format("Update BACSI set Ho = N'{0}', Ten = N'{1}', NgaySinh = N'{2}', GioiTinh = N'{3}', CMND ='{4}',"
+ "Email = '{5}', SDT = '{6}', DiaChi = N'{7}', NgayVaoLam = N'{8}', MaKhoa = N'{9}', ChucVu = N'{10}', "
+ "TrinhDo = N'{11}', HocHam = N'{12}', HocVi = N'{13}', MaPhongKham = '{14}', MaPhongBenh = '{15}' where MaBacSi = '{16}'", bs.Ho, bs.Ten, bs.NgaySinh.ToString("MM/dd/yyyy"), bs.GioiTinh, bs.CMND,
bs.Email, bs.SDT, bs.DiaChi, bs.NgayVaoLam.ToString("MM/dd/yyyy"), bs.MaKhoa, bs.ChucVu, bs.TrinhDo, bs.HocHam, bs.HocVi,bs.MaPhongKham, bs.MaPhongBenh, bs.MaBacSi);
if(conn.ExcuteQuery(sql))
{
MessageBox.Show("Sửa đổi thông tin bác sĩ thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return true;
}
else
return false;
}