public List<UserRollModel> GetAllAccessSpecificRollsByAccessValue(int userAccessNameId)
{
List<UserRollModel> userRollModels = new List<UserRollModel>();
string query = String.Format("Select UserRollValue,RollStatus from tblUserRoll where UserAccessNameId='{0}' order by UserRollValue ", userAccessNameId);
sqlCommand.CommandText = query;
using (sqlConnection)
{
sqlConnection.Open();
SqlDataReader rdr = sqlCommand.ExecuteReader();
while (rdr.Read())
{
UserRollModel userRollModel = new UserRollModel();
userRollModel.RollValue = rdr[0].ToString();
userRollModel.Status = rdr[1].ToString();
userRollModels.Add(userRollModel);
}
sqlConnection.Close();
}
return userRollModels;
}
public int UpdateRoolsOfSelectedUserAccess(UserRollModel userRollModel)
{
int rowsUpdated = 0;
string query = String.Format("Update tblUserRoll set RollStatus='{0}' where UserAccessNameId='{1}'", userRollModel.Status,userRollModel.AccessRollId);
using (SqlConnection con7 = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString) )
{
SqlCommand cmd7 = new SqlCommand(query,con7);
con7.Open();
rowsUpdated = cmd7.ExecuteNonQuery();
con7.Close();
}
return rowsUpdated;
}
protected void createButton_Click(object sender, EventArgs e)
{
int lastIdentityOfUserAccess = 0;
UserAccessModel userAccessModel = new UserAccessModel();
userAccessModel.UserAccessName = userAccessTextBox.Text;
if (userAccessTextBox.Text=="")
{
statusLabel.Text = "Please enter the name";
}
else
{
if (IsUserAccessNameExist(userAccessTextBox.Text))
{
statusLabel.Text = "This user access name already exist. Try with another name.";
}
else
{
if (SaveUserAccessName(userAccessModel) > 0)
{
lastIdentityOfUserAccess = GetLastIdentityOfUserAccess();
foreach (ListItem item in perDealershipOverridesCheckBoxList.Items)
{
UserRollModel userRollModel = new UserRollModel();
userRollModel.RollValue = item.Value;
if (item.Selected)
{
userRollModel.Status = "True";
}
else
{
userRollModel.Status = "False";
}
userRollModel.AccessRollId = lastIdentityOfUserAccess;
if (SaveUserRolls(userRollModel) > 0)
{
statusLabel.ForeColor = System.Drawing.Color.Green;
statusLabel.Text = "User rolls saved.";
GetAllUserAccessNameInDropdownList();
ListItem li = new ListItem("Select user access", "-1");
userAccessDropDownlist.Items.Insert(0, li);
}
else
{
statusLabel.Text = "User rolls not saved.";
GetAllUserAccessNameInDropdownList();
ListItem li = new ListItem("Select user access", "-1");
userAccessDropDownlist.Items.Insert(0, li);
}
}
foreach (ListItem item in globalRulesCheckBoxList.Items)
{
UserRollModel userRollModel = new UserRollModel();
userRollModel.RollValue = item.Value;
if (item.Selected)
{
userRollModel.Status = "True";
}
else
{
userRollModel.Status = "False";
}
userRollModel.AccessRollId = lastIdentityOfUserAccess;
if (SaveUserRolls(userRollModel) > 0)
{
statusLabel.ForeColor = System.Drawing.Color.Green;
statusLabel.Text = "User rolls saved.";
GetAllUserAccessNameInDropdownList();
ListItem li = new ListItem("Select user access", "-1");
userAccessDropDownlist.Items.Insert(0, li);
}
else
{
statusLabel.Text = "User rolls not saved.";
GetAllUserAccessNameInDropdownList();
ListItem li = new ListItem("Select user access", "-1");
userAccessDropDownlist.Items.Insert(0, li);
}
}
DeSelectItemInCheckBoxList();
}
else
{
statusLabel.Text = "User Access not saved.";
}
}
}
}
public int SaveUserRolls(UserRollModel userRollModel)
{
int rowsInserted = 0;
string query = String.Format("Insert into tblUserRoll values('{0}','{1}','{2}')",userRollModel.RollValue,userRollModel.Status,userRollModel.AccessRollId);
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString))
{
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
rowsInserted = cmd.ExecuteNonQuery();
con.Close();
}
return rowsInserted;
}