protected void rgUsers_DeleteCommand(object source, GridCommandEventArgs e) { Int32 idPI_ApplicationUser = 0; int? idPI_ApplicationUserRole = 0; try { //MK - get the idPI_ApplicationUser and idPI_ApplicationUserRole from the grid item string ID = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["idPI_ApplicationUser"].ToString(); idPI_ApplicationUser = Convert.ToInt32(ID); //get idPI_ApplicationUserRole ClsAppUsers appuser = new ClsAppUsers(); ClsAppUsers thisuser = appuser.GetAppUser(idPI_ApplicationUser); idPI_ApplicationUserRole = thisuser.idPI_ApplicationUserRole; //Delete from tblPI_ApplicationUserRole and tblPI_ApplicationUser //stp: [dbo].[spPI_ApplicationUserRole_Delete] //@idPI_ApplicationUserRole int SqlConnection cnn; SqlCommand cmd; cnn = new SqlConnection(strConnString); cnn.Open(); cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spPI_ApplicationUserRole_Delete"; cmd.Parameters.Add("@idPI_ApplicationUserRole", SqlDbType.Int).Value = idPI_ApplicationUserRole; cmd.Connection = cnn; cmd.ExecuteNonQuery(); //Delete District Restriction, if there is one rgUsers_DeleteRestrictions(idPI_ApplicationUser); //stp: PROCEDURE [dbo].[spPI_ApplicationUser_Delete] //@idPI_ApplicationUser int SqlCommand cmd2; cnn = new SqlConnection(strConnString); cnn.Open(); cmd2 = new SqlCommand(); cmd2.CommandType = CommandType.StoredProcedure; cmd2.CommandText = "spPI_ApplicationUser_Delete"; cmd2.Parameters.Add("@idPI_ApplicationUser", SqlDbType.Int).Value = idPI_ApplicationUser; cmd2.Connection = cnn; cmd2.ExecuteNonQuery(); } catch (Exception ex) { pnlDanger.Visible = true; lblDanger.Text = GetCurrentMethod() + " - " + ex.Message.ToString(); } }
protected void loadUsers() { ClsAppUsers au = new ClsAppUsers(); List <ClsAppUsers> appusers = au.GetListClsAppUsers(idPI_Application); rgUsers.DataSource = appusers; }
public ClsAppUsers GetAppUser(Int32 idApplicationUser) { PurolatorReportingSQLDataContext prContext = new PurolatorReportingSQLDataContext(); ClsAppUsers oAppUser = (from data in prContext.GetTable <vw_PI_ApplicationUser>() where data.idPI_ApplicationUser == idApplicationUser select new ClsAppUsers { UserName = data.UserName, ActiveDirectoryName = data.ActiveDirectoryName, idPI_ApplicationUserRole = data.idPI_ApplicationUserRole, idPI_ApplicationUser = data.idPI_ApplicationUser, RoleName = data.RoleName, role_UpdatedBy = data.role_UpdatedBy, role_UpdatedOn = data.role_UpdatedOn, idEmployee = data.idEmployee, idPI_ApplicationRole = data.idPI_ApplicationRole }).FirstOrDefault(); return(oAppUser); }