public int InsertServicepipei(servicepipei perRe) { servicepipeiDataContext db = new servicepipeiDataContext(); try { db.servicepipei.InsertOnSubmit(perRe); db.SubmitChanges(); return(int.Parse(perRe.UserID.ToString())); } catch { return(0); } }
public int UpdateServicepipeifoByUserID(servicepipei attInd) { servicepipeiDataContext db = new servicepipeiDataContext(); try { var result = (from item in db.servicepipei where item.UserID == attInd.UserID select item).Single(); result.ServicID = attInd.ServicID; result.PUserID = attInd.PUserID; db.SubmitChanges(); return(int.Parse(result.UserID.ToString())); } catch { return(0); } }