protected void JqgridMatch1_RowDeleting(object sender, JQGridRowDeleteEventArgs e) { using (var dc = ThaitaeDataDataContext.Create()) { var faMatch = dc.FAMatches.Single(item => item.FAMatchId == Convert.ToInt32(e.RowKey)); dc.FAMatches.DeleteOnSubmit(faMatch); dc.SubmitChanges(); } }
protected void JqgridUser_RowDeleting(object sender, JQGridRowDeleteEventArgs e) { var userId = e.RowKey; if (string.IsNullOrEmpty(userId)) { return; } UserHelper.DeleteUserProfile(Convert.ToInt32(userId)); }
protected void JqgridMatch1_RowDeleting(object sender, JQGridRowDeleteEventArgs e) { using (var dc = ThaitaeDataDataContext.Create()) { var matchHome = dc.Matches.Single(item => item.MatchId == Convert.ToInt32(e.RowKey)); var matchAway = dc.Matches.Single( item => item.TeamHomeId == matchHome.TeamAwayId && item.TeamAwayId == matchHome.TeamHomeId && item.SeasonId == Convert.ToInt32(Session["seasonid"])); var faMatch = dc.TeamMatches.Where(item => item.MatchId == Convert.ToInt32(e.RowKey)).ToList(); dc.TeamMatches.DeleteAllOnSubmit(faMatch); dc.SubmitChanges(); dc.Matches.DeleteOnSubmit(matchHome); dc.Matches.DeleteOnSubmit(matchAway); dc.SubmitChanges(); } }