public Lop getLopByID(int id)
{
HocSinh hs = DB.HocSinhs.FirstOrDefault(m => m.maHS == id);
Lop lop = DB.Lops.Single(m => m.maLop == hs.maLop);
return(lop);
}
public bool InsertHocSinh(HocSinh gv)
{
string sqlQuery = @" if not exists ";
sqlQuery += " ( select * from HocSinh where mahocsinh = @mahocsinh) ";
sqlQuery += " insert into HocSinh ";
sqlQuery += " values ";
sqlQuery += " ( @mahocsinh, @hocvaten, @ngaysinh, @gioitinh, @tongiao, @quequan, ";
sqlQuery += " @diachithuongtru, @hotenbo, @nghenghiepbo, @hotenme, @nghenghiepme, @sodienthoai, @lopma ) ";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@mahocsinh", gv.mahocsinh);
parameters.Add("@hocvaten", gv.hocvaten);
parameters.Add("@ngaysinh", gv.ngaysinh);
parameters.Add("@gioitinh", gv.gioitinh);
parameters.Add("@tongiao", gv.tongiao);
parameters.Add("@quequan", gv.quequan);
parameters.Add("@diachithuongtru", gv.diachithuongtru);
parameters.Add("@hotenbo", gv.hotenbo);
parameters.Add("@nghenghiepbo", gv.nghenghiepbo);
parameters.Add("@hotenme", gv.hotenme);
parameters.Add("@nghenghiepme", gv.nghenghiepme);
parameters.Add("@sodienthoai", gv.sodienthoai);
parameters.Add("@lopma", gv.lopma);
return(con.InsertUpdateDelete(sqlQuery, false, parameters));
}
public int EditHocSinh(HocSinh hs)
{
try
{
HocSinh hocsinh = DB.HocSinhs.Single(m => m.maHS == hs.maHS);
hocsinh.hoTenCha = hs.hoTenCha;
hocsinh.hoTenHS = hs.hoTenHS;
hocsinh.hoTenMe = hs.hoTenMe;
hocsinh.maLop = hs.maLop;
hocsinh.ngaySinh = hs.ngaySinh;
hocsinh.ngheNghiepCha = hs.ngheNghiepCha;
hocsinh.ngheNghiepMe = hs.ngheNghiepMe;
hocsinh.tonGiao = hs.tonGiao;
hocsinh.trangThai = hs.trangThai;
hocsinh.chucVu = hs.chucVu;
hocsinh.danToc = hs.danToc;
hocsinh.gioiTinh = hs.gioiTinh;
hocsinh.dcTamTru = hs.dcTamTru;
hocsinh.dcThuongTru = hs.dcThuongTru;
DB.SubmitChanges();
}
catch (Exception e)
{
return(-1);
}
return(1);
}
public object addStudent(string masv, string tensv, string gt, string ns, string malop)
{
HocSinh hs = new HocSinh();
Lop lop = data.Lops.Single(a => a.MaLop == malop);
hs.MaSV = masv;
hs.TenSV = tensv;
if (gt == "Nam")
{
hs.Gioitinh = false;
}
if (gt == "Nữ")
{
hs.Gioitinh = true;
}
hs.NgaySinh = DateTime.ParseExact(ns, "dd/MM/yyyy", CultureInfo.InvariantCulture);
if (lop != null)
{
hs.MaLop = malop;
}
data.HocSinhs.InsertOnSubmit(hs);
data.SubmitChanges();
return(1);
}
public int SuaHocSinh(HocSinh hs)
{
try
{
return(_hsDAO.SuaHocSinh(hs));
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertHocSinh(HocSinh hs)
{
try
{
DB.HocSinhs.InsertOnSubmit(hs);
DB.SubmitChanges();
}
catch (Exception e)
{
return(-1);
}
return(1);
}
public int DeleteHocSinh(int mahs)
{
try
{
HocSinh hs = DB.HocSinhs.Where(h => h.maHS == mahs).FirstOrDefault();
DB.HocSinhs.DeleteOnSubmit(hs);
DB.SubmitChanges();
}
catch (Exception e)
{
return(-1);
}
return(1);
}
public bool UpdateHocSinh(HocSinh gv)
{
string sqlQuery = @"UPDATE HocSinh ";
sqlQuery += " SET ";
sqlQuery += " hocvaten = @hocvaten ";
sqlQuery += ", ngaysinh = @ngaysinh ";
sqlQuery += ", gioitinh = @gioitinh ";
sqlQuery += ", tongiao = @tongiao ";
sqlQuery += ", quequan = @quequan";
sqlQuery += ", diachithuongtru = @diachithuongtru";
sqlQuery += ", hotenbo = @hotenbo";
sqlQuery += ", nghenghiepbo = @nghenghiepbo";
sqlQuery += ", hotenme = @hotenme";
sqlQuery += ", nghenghiepme = @nghenghiepme";
sqlQuery += ", sodienthoai = @sodienthoai";
sqlQuery += ", lopma = @lopma";
sqlQuery += " WHERE mahocsinh = @mahocsinh ";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@mahocsinh", gv.mahocsinh);
parameters.Add("@hocvaten", gv.hocvaten);
parameters.Add("@ngaysinh", gv.ngaysinh);
parameters.Add("@gioitinh", gv.gioitinh);
parameters.Add("@tongiao", gv.tongiao);
parameters.Add("@quequan", gv.quequan);
parameters.Add("@diachithuongtru", gv.diachithuongtru);
parameters.Add("@hotenbo", gv.hotenbo);
parameters.Add("@nghenghiepbo", gv.nghenghiepbo);
parameters.Add("@hotenme", gv.hotenme);
parameters.Add("@nghenghiepme", gv.nghenghiepme);
parameters.Add("@sodienthoai", gv.sodienthoai);
parameters.Add("@lopma", gv.lopma);
return(con.InsertUpdateDelete(sqlQuery, false, parameters));
}
public int?Update_HocSinh(HocSinh hs)
{
return(hocsinh.Update_HocSinh(hs));
}
public int?Insert_HocSinh(HocSinh hs)
{
return(hocsinh.Insert_HocSinh(hs));
}
