public APIResult UpdateClient(TblUserPermission data) { APIResult res = new APIResult(); using (Sonartez_server db = new Sonartez_server(connectionString)) { var matchedObj = (from c in db.TblUserPermission where c.ID == data.ID select c).SingleOrDefault(); if (matchedObj == null) { try { // does not exist Table<TblUserPermission> TblObj = db.TblUserPermission; data.ServerUpdate = DateTime.Now; TblObj.InsertOnSubmit(data); TblObj.Context.SubmitChanges(); res.UpdateDate = data.ServerUpdate.Value; res.Success = true; } catch (Exception ex) { res.Message = ex.Message; res.Success = false; } } else { try { matchedObj.PermissionID = data.PermissionID; matchedObj.PermissionName = data.PermissionName; matchedObj.UserID = data.UserID; matchedObj.ServerUpdate = DateTime.Now; matchedObj.UpdateTime = data.UpdateTime; db.SubmitChanges(); res.UpdateDate = data.UpdateTime.Value; res.Success = true; } catch (Exception ex) { res.Message = ex.Message; res.Success = false; } } } return res; }
partial void UpdateTblUserPermission(TblUserPermission instance);
partial void DeleteTblUserPermission(TblUserPermission instance);
partial void InsertTblUserPermission(TblUserPermission instance);