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);
}
}
