public Result <bool> insert_tacgia(tacgia_ett tacgia) { Result <bool> rs = new Result <bool>(); try { // create new tbl_tacgia to insert to database_context tbl_tacgia temp = new tbl_tacgia(); temp.tentg = tacgia.tentacgia; temp.gioitinh = tacgia.gioitinh; temp.diachi = tacgia.diachi; db.tbl_tacgias.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 <tacgia_ett> > select_all_tacgia() { Result <List <tacgia_ett> > rs = new Result <List <tacgia_ett> >(); try { List <tacgia_ett> lst = new List <tacgia_ett>(); var dt = db.tbl_tacgias; if (dt.Count() > 0) { foreach (tbl_tacgia item in dt) { tacgia_ett temp = new tacgia_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> edit_tacgia(tacgia_ett tacgia) { Result <bool> rs = new Result <bool>(); try { // find the only row to edit var dt = db.tbl_tacgias.Where(o => o.matg == tacgia.matacgia).SingleOrDefault(); // if fields are null or "" then maintaining the old data; if (tacgia.tentacgia != null && tacgia.tentacgia != "") { dt.tentg = tacgia.tentacgia; } if (tacgia.gioitinh != null && tacgia.gioitinh != "") { dt.gioitinh = tacgia.gioitinh; } if (tacgia.diachi != null && tacgia.diachi != "") { dt.diachi = tacgia.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 <List <tacgia_ett> > select_tacgia_fields(string input, string howtosearch) { Result <List <tacgia_ett> > rs = new Result <List <tacgia_ett> >(); try { IQueryable <tbl_tacgia> dt = null; List <tacgia_ett> lst = new List <tacgia_ett>(); switch (howtosearch) { case "hoten": dt = db.tbl_tacgias.Where(o => o.tentg.Contains(input)); break; default: break; } if (dt.Count() > 0) { foreach (tbl_tacgia item in dt) { tacgia_ett temp = new tacgia_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); } }