public int Insert(Bang_DK_DeTai entity)
{
//var dao2 = new NhomDaTtDao();
//var dao3 = new GiangVienDao();
//var dao4 = new LoaiDaDao();
db.Bang_DK_DeTai.Add(entity);
db.SaveChanges();
return(entity.MaDetai);
//if (manhom == null)
//{
// return -2;
//}
//else
//{
// var magv = dao2.TimTheoMa(manhom.MaNhom);
// int maloai = magv.MaLoaiDA;
// var maloaida = dao4.GetById(maloai);
// int ma = maloaida.MaLoaiDA;
// entity.MaLoaiDA = ma;
// ThongTinNhom kt1 = db.ThongTinNhoms.SingleOrDefault(x => x.ThanhVien2 == entity.MaDetai && x.Bang_DK_DeTai.MaLoaiDA == maloaida.MaLoaiDA);
// ThongTinNhom kt2 = db.ThongTinNhoms.SingleOrDefault(x => x.ThanhVien3 == entity.MaDetai && x.Bang_DK_DeTai.MaLoaiDA == maloaida.MaLoaiDA);
// ThongTinNhom kt3 = db.ThongTinNhoms.SingleOrDefault(x => x.NguoiDangKy == entity.MaDetai && x.Bang_DK_DeTai.MaLoaiDA == maloaida.MaLoaiDA);
// if (kt1 != null || kt2 != null || kt3 != null)
// {
// return -1;
// }
// else
// {
// entity.MaDetai = 0;
// }
//}
}
public int Insert(ThongTinNhom entity)
{
var dao = new NhomDaTtDao();
var magv = dao.TimMagvTheoMaNhom(entity.MaNhom);
var mada = magv.MaLoaiDA;
////kiem tra ma nhom tung thanh vien
if (entity.SoLuongThanhVien == 1)
{
db.ThongTinNhoms.Add(entity);
db.SaveChanges();
return(entity.STT);
}
else
{
if (entity.SoLuongThanhVien == 2)
{
var nhomtv2 = dao.TimMagv(entity.ThanhVien2, mada);
var ttb = nhomtv2.MaGV;
if (magv.MaGV != ttb)
{
return(-1);
}
else
{
ThongTinNhom bien1 = db.ThongTinNhoms.SingleOrDefault(x => x.ThanhVien2 == entity.ThanhVien2);
ThongTinNhom bien2 = db.ThongTinNhoms.SingleOrDefault(x => x.ThanhVien3 == entity.ThanhVien2);
ThongTinNhom bien3 = db.ThongTinNhoms.SingleOrDefault(x => x.NguoiDangKy == entity.ThanhVien2);
if (bien1 != null || bien2 != null)
{
return(0);
}
else
{
db.ThongTinNhoms.Add(entity);
db.SaveChanges();
return(entity.STT);
}
}
}
else
{
var nhomtv2 = dao.TimMagv(entity.ThanhVien2, mada);
var nhomtv3 = dao.TimMagv(entity.ThanhVien3, mada);
if (magv.MaGV != nhomtv2.MaGV || magv.MaGV != nhomtv3.MaGV)
{
return(-1);
}
else
{
ThongTinNhom bien1 = db.ThongTinNhoms.SingleOrDefault(x => x.ThanhVien2 == entity.ThanhVien2);
ThongTinNhom bien2 = db.ThongTinNhoms.SingleOrDefault(x => x.ThanhVien2 == entity.ThanhVien3);
ThongTinNhom bien3 = db.ThongTinNhoms.SingleOrDefault(x => x.ThanhVien3 == entity.ThanhVien2);
ThongTinNhom bien4 = db.ThongTinNhoms.SingleOrDefault(x => x.ThanhVien3 == entity.ThanhVien3);
if (bien1 != null || bien2 != null || bien3 != null || bien4 != null)
{
return(0);
}
else
{
db.ThongTinNhoms.Add(entity);
db.SaveChanges();
return(entity.STT);
}
}
}
}
}
//==============================================
public int Insert(Nhom_DA_TT entity)
{
db.Nhom_DA_TT.Add(entity);
db.SaveChanges();
return(entity.MaNhom);
}
//phương thức thêm mới sinh viên
public int Insert(SinhVien entity)
{
db.SinhViens.Add(entity);
db.SaveChanges();
return(entity.MaSV);
}
//==============================================
public int Insert(GiangVien entity)
{
db.GiangViens.Add(entity);
db.SaveChanges();
return(1);
}