public static DTO.ThiSinh ThongTinThiSinh(string MsThiSinh)
{
DTO.ThiSinh ts = new DTO.ThiSinh();
DataTable data = new DataTable();
data = DAL.ThiSinh.ThongTinThiSinh(MsThiSinh);
DataRow row = data.Rows[0];
ts.Ho = row["Ho"].ToString();
ts.Ten = row["Ten"].ToString();
ts.NgaySinh = row["NgaySinh"].ToString();
ts.GioiTinh = row["GioiTinh"].ToString();
ts.DiaChi = row["DiaChi"].ToString();
ts.QuocTich = row["QuocTich"].ToString();
ts.CMND = row["CMND"].ToString();
if (row["HinhAnh"].ToString() != "")
{
ts.HinhAnh = row["HinhAnh"].ToString();
}
else
{
ts.HinhAnh = "avatar.png";
}
return(ts);
}
private void KetQuaThi_Load(object sender, EventArgs e)
{
DTO.ThiSinh ts = new DTO.ThiSinh();
ts = BLL.ThiSinh.ThongTinThiSinh(Program.SBD);
int KQ = SoCauDung();
int CauDaLam = 30 - SoCauChuaLam();
lb_hovaten.Text = ts.Ho + " " + ts.Ten;
lb_gioiTinh.Text = ts.GioiTinh;
if (KQ >= 26)
{
lb_ketqua.Text = "Đậu";
}
else
{
lb_ketqua.Text = "Rớt";
}
lb_socaudung.Text = KQ.ToString();
lb_QuocTich.Text = ts.QuocTich;
lb_ngaysinh.Text = ts.NgaySinh;
lb_diaChi.Text = ts.DiaChi;
lb_sCauDaLam.Text = CauDaLam.ToString();
String filepath = @"imagets\" + ts.HinhAnh;
pictureBox1.Image = Image.FromFile(filepath.ToString());
}
private void XacNhan_Load(object sender, EventArgs e)
{
DTO.ThiSinh ts = new DTO.ThiSinh();
ts = BLL.ThiSinh.ThongTinThiSinh(Program.SBD);
lb_hovaten.Text = ts.Ho + " " + ts.Ten;
lb_gioiTinh.Text = ts.GioiTinh;
lb_QuocTich.Text = ts.QuocTich;
lb_ngaysinh.Text = ts.NgaySinh;
lb_diaChi.Text = ts.DiaChi;
string filepath = @"imagets\" + ts.HinhAnh;
try { pictureBox1.Image = Image.FromFile(filepath.ToString()); } catch { filepath = @"imagets\avatar.png"; pictureBox1.Image = Image.FromFile(filepath.ToString()); }
}
private void button3_Click(object sender, EventArgs e)
{
String namepic = openpic.SafeFileName;
DTO.ThiSinh ts = new DTO.ThiSinh();
ts = getData();
if (namepic.Equals("openFileDialog1"))
{
namepic = "avatar.png";
}
switch (BLL.ThiSinh.Suathisinh(ts, msts))
{
case 1: { pic_edit.Image = Image.FromFile(@"system picture\complete.png"); break; }
default: { pic_edit.Image = Image.FromFile(@"system picture\fail.png"); break; }
}
pic_edit.Show();
load_thisinh();
}
private DTO.ThiSinh getData()
{
DTO.ThiSinh ts = new DTO.ThiSinh();
ts.CMND = txtcmnd.Text;
ts.DiaChi = rtxtdiachi.Text;
if (rbtn_nam.Checked == true)
{
ts.GioiTinh = "1";
}
else
{
ts.GioiTinh = "0";
}
ts.HinhAnh = pic_qltsdt.Name;
ts.Ho = txt_Ho.Text;
ts.MsThiSinh = txt_sbd.Text;
ts.NgaySinh = datebirth.Text;
ts.PhanHoi = "";
ts.QuocTich = txt_quoctich.Text;
ts.Ten = txt_ten.Text;
return(ts);
}
private void click_them(object sender, EventArgs e)
{
String namepic = openpic.SafeFileName;
if (namepic.Equals("openFileDialog1"))
{
namepic = "avatar.png";
}
DTO.ThiSinh thisinh = new DTO.ThiSinh();
thisinh = getData();
int kq = BLL.ThiSinh.Add(thisinh);
switch (kq)
{
case 1: { pic_add.Image = Image.FromFile(@"system picture\complete.png"); break; }
case -1: { MessageBox.Show("Lỗi thêm thí sinh. Hãy kiểm tra kết nối với máy chủ", "Thông báo"); break; }
case 0: { pic_add.Image = Image.FromFile(@"system picture\fail.png"); break; }
}
pic_add.Show();
load_thisinh();
}
public static int SuaThiSinh(DTO.ThiSinh ts, string msts)
{
string cmd = "EXEC SuaThiSinh '" + msts + "','" + ts.MsThiSinh + "',N'" + ts.Ho + "',N'" + ts.Ten + "','" + ts.NgaySinh + "'," + ts.GioiTinh + ",N'" + ts.QuocTich + "',N'" + ts.DiaChi + "','" + ts.HinhAnh + "','" + ts.CMND + "'";
return(ConnectDB.ExecuteNonQuery(cmd));
}
public static int Suathisinh(DTO.ThiSinh ts, string msts)
{
return(DAL.ThiSinh.SuaThiSinh(ts, msts));
}
public static int Add(DTO.ThiSinh ts)
{
return(DAL.ThiSinh.Add(ts));
}
