public int InsertRegionTable(regionTable comp) { iwaywardDataContext db = new iwaywardDataContext(); try { db.regionTable.InsertOnSubmit(comp); db.SubmitChanges(); return(int.Parse(comp.regionID.ToString())); } catch { return(0); } }
public int UpdateRegionTableByComId(regionTable post) { iwaywardDataContext db = new iwaywardDataContext(); try { var result = (from item in db.regionTable where item.regionID == post.regionID select item).Single(); result.regionID = post.regionID; result.provinceID = post.provinceID; result.provinceName = post.provinceName; result.cityID = post.cityID; result.cityName = post.cityName; result.regionName = post.regionName; db.SubmitChanges(); return(int.Parse(result.regionID.ToString())); } catch { return(0); } }