public Result<bool> edit_nhaxuatban(nhaxuatban_ett nhaxuatban) { Result<bool> rs = new Result<bool>(); try { // find the only row to edit var dt = db.tbl_nxbs.Where(o => o.manxb == nhaxuatban.manxb).SingleOrDefault(); // if fields are null or "" then maintaining the old data; if (nhaxuatban.tennxb != null && nhaxuatban.tennxb != "") { dt.tennxb = nhaxuatban.tennxb; } if (nhaxuatban.sdt != null && nhaxuatban.sdt != "") { dt.sdt = nhaxuatban.sdt; } if (nhaxuatban.diachi != null && nhaxuatban.diachi != "") { dt.diachi = nhaxuatban.diachi; } 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<bool> insert_nhaxuatban(nhaxuatban_ett nhaxuatban) { Result<bool> rs = new Result<bool>(); try { // create new tbl_nhaxuatban to insert to database_context tbl_nxb temp = new tbl_nxb(); temp.tennxb = nhaxuatban.tennxb; temp.sdt = nhaxuatban.sdt; temp.diachi = nhaxuatban.diachi; db.tbl_nxbs.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; } }
public Result<List<nhaxuatban_ett>> select_nhaxuatban_fields(string input, string howtosearch) { Result<List<nhaxuatban_ett>> rs = new Result<List<nhaxuatban_ett>>(); try { IQueryable<tbl_nxb> dt = null; List<nhaxuatban_ett> lst = new List<nhaxuatban_ett>(); switch (howtosearch) { case "tennxb": dt = db.tbl_nxbs.Where(o => o.tennxb.Contains(input)); break; default: break; } if (dt.Count() > 0) { foreach (tbl_nxb item in dt) { nhaxuatban_ett temp = new nhaxuatban_ett(item); lst.Add(temp); } rs.data = lst; rs.errcode = ErrorCode.sucess; return rs; } 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<List<nhaxuatban_ett>> select_all_nhaxuatban() { Result<List<nhaxuatban_ett>> rs = new Result<List<nhaxuatban_ett>>(); try { List<nhaxuatban_ett> lst = new List<nhaxuatban_ett>(); var dt = db.tbl_nxbs; if (dt.Count() > 0) { foreach (tbl_nxb item in dt) { nhaxuatban_ett temp = new nhaxuatban_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; } }