public Tblsohuudetai get_sohuudetai_id(int id)
{
Tblsohuudetai dv = new Tblsohuudetai();
using (sql_NCKHContext db = new sql_NCKHContext())
{
dv = db.Tblsohuudetais.SingleOrDefault(x => x.Id == id);
}
return dv;
}
public bool delete_sohuudetai(int id)
{
try
{
using (sql_NCKHContext db = new sql_NCKHContext())
{
Tblsohuudetai d = db.Tblsohuudetais.SingleOrDefault(x => x.Id == id);
if (string.IsNullOrEmpty(d.ToString()))
return true;
db.Tblsohuudetais.Remove(d);
db.SaveChanges();
return true;
}
}
catch (Exception)
{
return false;
}
}
public alter create_sohuudetai([FromBody] List<Tblsohuudetai> sh)
{
alter al = new alter();
try
{
if(sh.Count() == 0)
{
al.ketqua = false;
al.thongbao = "Không để rỗng";
return al;
}
using (sql_NCKHContext db = new sql_NCKHContext())
{
int dem = 0;
foreach(var item in sh)
{
Tblsohuudetai result = db.Tblsohuudetais.SingleOrDefault(x => x.Iddetai == item.Iddetai && x.Idsohuu == item.Idsohuu);
if (result ==null)
{
Tblsohuudetai a = new Tblsohuudetai();
a.Iddetai = item.Iddetai;
a.Idsohuu = item.Idsohuu;
db.Tblsohuudetais.Add(a);
db.SaveChanges();
}
else
{
dem++;
}
}
al.ketqua = true;
al.thongbao = string.Format("Thêm thành công {0}, lỗi {1} ", sh.Count() - dem, dem);
return al;
}
}
catch (Exception ex)
{
al.ketqua = false;
al.thongbao = ex.Message;
return al;
}
}
public bool edit_sohuudetai(int id, [FromBody] Tblsohuudetai sh)
{
try
{
using (sql_NCKHContext db = new sql_NCKHContext())
{
Tblsohuudetai d = db.Tblsohuudetais.SingleOrDefault(x => x.Id == id);
if (string.IsNullOrEmpty(d.ToString()))
return false;
d.Idsohuu = sh.Idsohuu;
d.Ghichu = sh.Ghichu;
db.SaveChanges();
return true;
}
}
catch (Exception)
{
return false;
}
}
