public Result<bool> edit_sach(sach_ett sach) { Result<bool> rs = new Result<bool>(); try { // find the only row to edit var dt = db.tbl_saches.Where(o => o.masach == sach.masach).SingleOrDefault(); // if fields are null or "" then maintaining the old data; if (sach.tensach != null && sach.tensach != "") { dt.tensach = sach.tensach; } if (sach.matg != null) { dt.matg = sach.matg; } if (sach.manxb != null) { dt.manxb = sach.manxb; } if (sach.malv != null) { dt.malv = sach.malv; } if (sach.soluong != null) { dt.soluong = sach.soluong; } if (sach.sotrang != null) { dt.sotrang = sach.sotrang; } if (sach.ngaynhap != null || sach.ngaynhap != "") { dt.ngaynhap = sach.ngaynhap; } db.SubmitChanges(); rs.data = true; rs.errcode = ErrorCode.sucess; return rs; } catch (Exception e) { rs.data = false; rs.errcode = ErrorCode.fail; rs.errInfor = e.ToString(); return rs; } }
public Result<List<sach_ett>> select_all_sach() { Result<List<sach_ett>> rs = new Result<List<sach_ett>>(); try { List<sach_ett> lst = new List<sach_ett>(); var dt = db.tbl_saches; if (dt.Count() > 0) { foreach (tbl_sach item in dt) { sach_ett temp = new sach_ett(item); lst.Add(temp); } rs.data = lst; rs.errcode = ErrorCode.sucess; } else { rs.data = null; rs.errInfor = Constants.empty_data; } return rs; } catch (Exception e) { rs.data = null; rs.errInfor = e.ToString(); rs.errcode = ErrorCode.fail; return rs; } }
public Result<bool> insert_sach(sach_ett sach) { Result<bool> rs = new Result<bool>(); try { // create new tbl_sach to insert to database_context tbl_sach temp = new tbl_sach(); temp.tensach = sach.tensach; temp.matg = sach.matg; temp.manxb = sach.manxb; temp.malv = sach.malv; temp.sotrang = sach.sotrang; temp.soluong = sach.soluong; temp.ngaynhap = sach.ngaynhap; db.tbl_saches.InsertOnSubmit(temp); db.SubmitChanges(); rs.data = true; rs.errcode = ErrorCode.sucess; return rs; } catch (Exception e) { rs.data = false; rs.errcode = ErrorCode.fail; rs.errInfor = e.ToString(); return rs; } }