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; } }