public bool LayThongTinSinhVien(int intUserID, ref SinhVien objSinhVien)
{
try
{
using (var db = new Project_16HCB_CSDLEntities())
{
SqlParameter paMSSV = new SqlParameter("@MSSV", intUserID);
var result = db.Database.SqlQuery <SinhVien>("exec sp_getThongTinSinhVien @MSSV", paMSSV).ToList();
objSinhVien = result[0];
var lstVanTay = db.VANTAYs.Where(i => i.C_userID == intUserID).ToList();
List <VanTay> lstTemp = new List <VanTay>();
for (int i = 0; i < lstVanTay.Count(); i++)
{
VanTay objVanTayDTO = new VanTay();
objVanTayDTO._id = lstVanTay[i].C_id;
objVanTayDTO._mavantay = lstVanTay[i].C_maVanTay;
objVanTayDTO._url = lstVanTay[i].C_url;
objVanTayDTO._userid = intUserID;
lstTemp.Add(objVanTayDTO);
}
objSinhVien._lstVanTay = lstTemp;
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public void DeleteTheTu(int maTheTu)
{
try
{
VanTay vanTay = context.VanTays.Where(x => x.MaVanTay == maTheTu).Single <VanTay>();
context.VanTays.Remove(vanTay);
context.SaveChanges();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public void UpdateVanTay(VanTay vanTayUpdate)
{
try
{
VanTay vanTay = context.VanTays.Where(x => x.MaVanTay == vanTayUpdate.MaVanTay).Single <VanTay>();
vanTay.MaNguoi = vanTayUpdate.MaNguoi;
vanTay.NgonTay = vanTayUpdate.NgonTay;
vanTay.ThuocTinhVanTay = vanTayUpdate.ThuocTinhVanTay;
vanTay.ThoiGianDangKy = vanTayUpdate.ThoiGianDangKy;
vanTay.TrangThai = vanTayUpdate.TrangThai;
context.SaveChanges();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public int AddVanTay(VanTay vanTay)
{
int maVanTay = 0;
try
{
context.VanTays.Add(vanTay);
context.SaveChanges();
maVanTay = vanTay.MaVanTay;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(maVanTay);
}
