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