public Result<bool> edit_phieumuontra(phieumuontra_ett phieumuontra, List<string> list_masach) { Result<bool> rs = new Result<bool>(); try { // find the only row to edit var dt = db.tbl_phieumuon_tras.Where(o => o.sophieumuon == phieumuontra.sophieumuon).SingleOrDefault(); // if fields are null or "" then maintaining the old data; if (phieumuontra.madg != null) { dt.madg = phieumuontra.madg; } if (phieumuontra.manv != null) { dt.manv = phieumuontra.manv; } if (phieumuontra.ngaymuon != null && phieumuontra.ngaymuon != "") { dt.ngaymuon = phieumuontra.ngaymuon; } if (phieumuontra.ngaytra != null && phieumuontra.ngaytra != "") { dt.ngaytra = phieumuontra.ngaytra; } if (phieumuontra.ghichu != null && phieumuontra.ghichu != "") { dt.ghichu = phieumuontra.ghichu; } if (phieumuontra.xacnhantra != null) { dt.xacnhantra = phieumuontra.xacnhantra; if (phieumuontra.xacnhantra==true) { if (list_masach.Count() > 0) { foreach (string item in list_masach) { var data = db.tbl_saches.Where(o => o.masach == int.Parse(item)).SingleOrDefault(); data.soluong++; } } } } 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<phieumuontra_ett> insert_phieumuontra(phieumuontra_ett phieumuontra, List<string> list_masach) { Result<phieumuontra_ett> rs = new Result<phieumuontra_ett>(); try { // create new tbl_phieumuontra to insert to database_context tbl_phieumuon_tra temp = new tbl_phieumuon_tra(); temp.manv = phieumuontra.manv; temp.madg = phieumuontra.madg; temp.ngaytra = phieumuontra.ngaytra; temp.ngaymuon = phieumuontra.ngaymuon; temp.xacnhantra = phieumuontra.xacnhantra; temp.ghichu = phieumuontra.ghichu; db.tbl_phieumuon_tras.InsertOnSubmit(temp); if (list_masach.Count() > 0) { foreach (string item in list_masach) { var dt = db.tbl_saches.Where(o => o.masach == int.Parse(item)).SingleOrDefault(); dt.soluong--; } } db.SubmitChanges(); var last_record = db.tbl_phieumuon_tras.OrderByDescending(o => o.sophieumuon).Take(1); if (last_record.Count() > 0) { foreach (var item in last_record) { phieumuontra_ett temp1 = new phieumuontra_ett(item); rs.data = temp1; } } rs.errcode = ErrorCode.sucess; return rs; } catch (Exception e) { rs.data = null; rs.errcode = ErrorCode.fail; rs.errInfor = e.ToString(); return rs; } }