protected void InitializeGridRoles()
{
//int userid = Convert.ToInt32(Session["UserId"]);
GetMyAccessRights();
Roles role = new Roles();
if (role.GetRolesWithoutDepartmentAccess().Count > 0 && myAccessRights.CanAdd == true)
linkBtnAdd.Visible = true;
else
linkBtnAdd.Visible = false;
var roleList = role.GetRolesWithDepartmentAccess();
//Converter model = new Converter();
//DataTable table = model.ConvertToDataTable(roleList);
gridViewRoles.DataSource = roleList;
gridViewRoles.DataBind();
}
protected void gridViewRole_Command(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
GetMyAccessRights();
modalLabelError.Text = "";
modalLabelError.Visible = false;
modalBtnSubmit.Visible = Convert.ToBoolean(myAccessRights.CanUpdate);
int index = Convert.ToInt32(e.CommandArgument);
int roleid = Convert.ToInt32(((Label)gridViewRole.Rows[index].FindControl("labelRoleId")).Text);
modalBtnSubmit.CommandArgument = "Update";
Roles role = new Roles();
role = role.GetRole(roleid);
modalLabelRoleId.Text = role.Id.ToString();
modalTxtBoxDescription.Text = role.Description;
this.programmaticModalPopup.Show();
}
}
protected void InitializeGridViewRole()
{
GetMyAccessRights();
if (myAccessRights.CanAdd == true)
linkBtnAdd.Visible = true;
else
linkBtnAdd.Visible = false;
Roles role = new Roles();
List<Roles> rolelist = new List<Roles>();
rolelist = role.GetRoleList();
if (rolelist.Count > 0)
{
if (rolelist[0].Description == "All")
rolelist.RemoveAt(0);
}
gridViewRole.DataSource = rolelist;
gridViewRole.DataBind();
}
protected void InitializeModalDropDownRoles(int roleid = 0)
{
Roles role = new Roles();
List<Roles> datalist = new List<Roles>();
if (roleid == 0) //Add
{
datalist = role.GetRolesWithoutDepartmentAccess();
modalDropDownRoles.Enabled = true;
}
else //Update
{
role = role.GetRole(roleid);
datalist.Add(role);
modalDropDownRoles.Enabled = false;
}
modalDropDownRoles.DataSource = datalist;
modalDropDownRoles.DataTextField = "Description";
modalDropDownRoles.DataValueField = "Id";
modalDropDownRoles.DataBind();
}
protected void InitializeModalDropDownRole(string value = "")
{
Roles role = new Roles();
var roles = role.GetRoleList();
modalDropDownRole.DataSource = roles;
modalDropDownRole.DataTextField = "Description";
modalDropDownRole.DataValueField = "Id";
modalDropDownRole.DataBind();
if (value != null && value.Trim() != "")
{
foreach (ListItem i in modalDropDownRole.Items)
{
if (value.Trim() == i.Value.ToString().Trim())
{
i.Selected = true;
break;
}
}
}
}
protected void modalBtnSubmit_Command(object sender, CommandEventArgs e)
{
if (modalLabelError.Visible == true)
this.programmaticModalPopup.Show();
else
{
int userid = Convert.ToInt32(Session["UserId"]);
Roles role = new Roles();
if (modalLabelRoleId.Text.Trim() != "")
{
role = role.GetRole(Convert.ToInt32(modalLabelRoleId.Text));
}
role.Description = modalTxtBoxDescription.Text.Trim();
role.LastUpdateDate = DateTime.Now;
role.LastUpdatedBy = userid;
if (e.CommandArgument.ToString() == "Add")
{
role.CreateDate = DateTime.Now;
role.CreatedBy = userid;
role.Insert(role);
}
else if (e.CommandArgument.ToString() == "Update")
{
role.Update(role);
}
InitializeGridViewRole();
this.programmaticModalPopup.Hide();
}
}
private void UpdateParse(T_Roles t_role, Roles role)
{
t_role.Description = role.Description;
t_role.Rank = role.Rank;
t_role.LastUpdateDate = role.LastUpdateDate;
t_role.LastUpdatedBy = role.LastUpdatedBy;
t_role.IsSupervisor = role.IsSupervisor;
}
private T_Roles InsertParse(Roles role)
{
T_Roles t_role = new T_Roles();
t_role.Description = role.Description;
t_role.Rank = role.Rank;
t_role.CreateDate = role.CreateDate;
t_role.LastUpdateDate = role.LastUpdateDate;
t_role.CreatedBy = role.CreatedBy;
t_role.LastUpdatedBy = role.LastUpdatedBy;
t_role.IsSupervisor = role.IsSupervisor;
return t_role;
}
public void Update(Roles role)
{
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
T_Roles t_role = db.T_Roles.FirstOrDefault(p => p.Id == role.Id);
UpdateParse(t_role, role);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
//public List<Roles> GetRolesWithSupervisors()
//{
// TimeTrackerEntities db = new TimeTrackerEntities();
// var data = (from r in db.T_Roles
// join s in db.T_RolesSupervisor
// on r.Id equals s.RoleId
// select new Roles()
// {
// Id = r.Id,
// Description = r.Description,
// Rank = r.Rank,
// CreateDate = r.CreateDate,
// LastUpdateDate = r.LastUpdateDate,
// CreatedBy = r.CreatedBy,
// LastUpdatedBy = r.LastUpdatedBy,
// IsSupervisor = r.IsSupervisor
// }).Distinct().ToList();
// db.Dispose();
// return data;
//}
//public List<Roles> GetRolesWithoutSupervisor()
//{
// TimeTrackerEntities db = new TimeTrackerEntities();
// var data = (from r in db.T_Roles
// join s in db.T_RolesSupervisor
// on r.Id equals s.RoleId
// orderby r.Id
// select new Roles()
// {
// Id = r.Id,
// Description = r.Description,
// Rank = r.Rank,
// CreateDate = r.CreateDate,
// LastUpdateDate = r.LastUpdateDate,
// CreatedBy = r.CreatedBy,
// LastUpdatedBy = r.LastUpdatedBy,
// IsSupervisor = r.IsSupervisor
// }).Distinct().ToList();
// db.Dispose();
// var list = GetRoleList();
// for (int i = 0; i < data.Count; i++)
// {
// for (int j = 0; j < list.Count; j++)
// {
// if (data[i].Id == list[j].Id)
// {
// list.RemoveAt(j);
// break;
// }
// }
// }
// return list;
//}
public void Insert(Roles role)
{
T_Roles t_role = InsertParse(role);
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
db.T_Roles.Add(t_role);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
