protected void btnSave_Click(object sender, EventArgs e)
{
SubsystemRoles role = new SubsystemRoles();
SubsystemRolesDAL rolesDal = new SubsystemRolesDAL();
bool isFirstTime = true;
foreach (ListItem item in cblRoles.Items)
{
role.roleID = Int32.Parse(item.Value);
if (item.Selected)
{
if (isFirstTime)
{
rolesDal.SaveSubsystemRole(Int32.Parse(ddlSystem2.SelectedValue), Int32.Parse(ddlSubsystem2.SelectedValue), role.roleID, 1);
}
else
{
rolesDal.SaveSubsystemRole(Int32.Parse(ddlSystem2.SelectedValue), Int32.Parse(ddlSubsystem2.SelectedValue), role.roleID, 0);
}
role.isChecked = 1;
isFirstTime = false;
}
}
//No boxes checked
if (isFirstTime)
{
rolesDal.SaveSubsystemRole(Int32.Parse(ddlSystem2.SelectedValue), Int32.Parse(ddlSubsystem2.SelectedValue), role.roleID, 2);
}
lblMessage.Text = "Items Saved " + DateTime.Now.ToLongTimeString();
lblMessage.Visible = true;
}
public List <SubsystemRoles> GetRolesForSubsystem(int system, int subsystem)
{
List <SubsystemRoles> roleList = new List <SubsystemRoles>();
SqlCommand getCommand = new SqlCommand("ADMIN_GET_SUBSYSTEM_ROLES", Connection);
getCommand.CommandType = CommandType.StoredProcedure;
getCommand.Parameters.AddWithValue("@systemID", system);
getCommand.Parameters.AddWithValue("@subsystemID", subsystem);
try
{
Connection.Open();
SqlDataReader reader = getCommand.ExecuteReader();
while (reader.Read())
{
SubsystemRoles role = new SubsystemRoles();
role.roleID = (int)reader.GetDecimal(0);
role.roleName = reader.GetString(1);
role.isChecked = reader.GetInt32(2);
roleList.Add(role);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
Connection.Close();
}
return(roleList);
}