public void Insert(RoleDepartmentAccess roledepartmentaccess)
{
T_RoleDepartmentAccess t_roledepartmentaccess = new T_RoleDepartmentAccess();
Parse(t_roledepartmentaccess, roledepartmentaccess);
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
db.T_RoleDepartmentAccess.Add(t_roledepartmentaccess);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
protected void InitializeGridViewBottom()
{
int userid = Convert.ToInt32(Session["UserId"]);
bool isSingle = false;
int roleid = Convert.ToInt32(Session["RoleId"]);
RoleDepartmentAccess departmentAccess = new RoleDepartmentAccess();
var departmentlist = departmentAccess.GetRoleDepartmentList(roleid);
if (departmentlist.Count < 1)
{
isSingle = true;
}
Analysis analysis = new Analysis();
List<Analysis> data = new List<Analysis>();
if (isSingle)
data = analysis.GetAnalysis(Convert.ToDateTime(txtBoxBottomFromDate.Text), Convert.ToDateTime(txtBoxBottomToDate.Text), userid, txtBoxBottomJobId.Text.Trim(), txtBoxBottomCustomer.Text.Trim());
else
{
if (ddlBottomPersonel.Items.Count > 0)
{
if (ddlBottomPersonel.SelectedItem.Text.Trim() == "All")
{
data = analysis.GetAnalysis(Convert.ToInt32(ddlBottomDepartment.SelectedItem.Value), Convert.ToDateTime(txtBoxBottomFromDate.Text), Convert.ToDateTime(txtBoxBottomToDate.Text), txtBoxBottomJobId.Text.Trim(),txtBoxBottomCustomer.Text.Trim(), roleid);
}
else
{
data = analysis.GetAnalysis(Convert.ToDateTime(txtBoxBottomFromDate.Text), Convert.ToDateTime(txtBoxBottomToDate.Text), Convert.ToInt32(ddlBottomPersonel.SelectedItem.Value), txtBoxBottomJobId.Text.Trim(), txtBoxBottomCustomer.Text.Trim());
}
}
}
gridViewBottom.DataSource = data;
gridViewBottom.DataBind();
}
protected void InitializeBottomDropDownPersonel()
{
int userid = Convert.ToInt32(Session["UserId"]);
int roleid = Convert.ToInt32(Session["RoleId"]);
RoleDepartmentAccess departmentAccess = new RoleDepartmentAccess();
var departmentlist = departmentAccess.GetRoleDepartmentList(roleid);
User user = new User();
List<User> userlist = new List<User>();
user = user.GetUser(userid);
if (departmentlist.Count < 1)
{
userlist.Add(user);
ddlBottomPersonel.Enabled = false;
}
else
{
int departmentid = Convert.ToInt32(ddlBottomDepartment.SelectedItem.Value);
if (departmentid == 0)
{
foreach (RoleDepartmentAccess r in departmentlist)
{
var ulist = user.GetUserList(r.DepartmentId);
userlist.AddRange(ulist);
}
userlist = userlist.Distinct().ToList();
}
else
{
userlist = user.GetUserList(departmentid);
}
if (userlist.Count > 1)
{
User alluser = new User();
alluser.fullname = "All";
alluser.Id = 0;
userlist.Insert(0, alluser);
}
ddlBottomPersonel.Enabled = true;
}
ddlBottomPersonel.DataSource = userlist;
ddlBottomPersonel.DataTextField = "fullname";
ddlBottomPersonel.DataValueField = "Id";
ddlBottomPersonel.DataBind();
}
protected void InitializeBottomDropDownDepartment()
{
ddlBottomDepartment.Enabled = true;
int roleid = Convert.ToInt32(Session["RoleId"]);
RoleDepartmentAccess departmentAccess = new RoleDepartmentAccess();
var departmentlist = departmentAccess.GetRoleDepartmentList(roleid);
if (departmentlist.Count > 1)
{
departmentAccess.DepartmentId = 0;
departmentAccess.department = "All";
departmentlist.Insert(0, departmentAccess);
}
else if (departmentlist.Count < 1)
{
int userid = Convert.ToInt32(Session["UserId"]);
Department department = new Department();
User user = new User();
user = user.GetUser(userid);
department = department.GetDepartment(Convert.ToInt32(user.DepartmentId));
departmentAccess.DepartmentId = department.Id;
departmentAccess.department = department.Description;
departmentlist.Insert(0, departmentAccess);
ddlBottomDepartment.Enabled = false;
}
ddlBottomDepartment.DataSource = departmentlist;
ddlBottomDepartment.DataTextField = "department";
ddlBottomDepartment.DataValueField = "DepartmentId";
ddlBottomDepartment.DataBind();
}
public List<JobType> GetJobTypeListByRoleId(int roleid)
{
TimeTrackerEntities db = new TimeTrackerEntities();
RoleDepartmentAccess deptAccess = new RoleDepartmentAccess();
var deptlist = deptAccess.GetRoleDepartmentList(roleid);
JobTypeDepartment jobtypeDept = new JobTypeDepartment();
List<JobType> data = new List<JobType>();
foreach (RoleDepartmentAccess r in deptlist)
{
var jobtypelist = jobtypeDept.GetJobTypeList(r.DepartmentId);
//data.AddRange(jobtypelist);
foreach(JobType j in jobtypelist)
{
if (data.FirstOrDefault(d => d.Id == j.Id) == null)
{
data.Add(j);
}
}
}
//data = data.Distinct().ToList();
db.Dispose();
return data;
}
private void InitializeModalDepartmentCheckBox(int roleid)
{
RoleDepartmentAccess deptAccess = new RoleDepartmentAccess();
var roledeptlist = deptAccess.GetRoleDepartmentList(roleid);
for (int i = 0; i < modalGridViewDepartment.Rows.Count; i++)
{
Label labelDeptId = (Label)modalGridViewDepartment.Rows[i].FindControl("modalLabelDepartmentId");
CheckBox cbSelect = (CheckBox)modalGridViewDepartment.Rows[i].FindControl("modalChkBoxSelect");
for (int j = 0; j < roledeptlist.Count; j++)
{
if (labelDeptId.Text.Trim() == roledeptlist[j].DepartmentId.ToString())
{
cbSelect.Checked = true;
labelDeptId.ToolTip = roledeptlist[j].Id.ToString();
roledeptlist.RemoveAt(j);
break;
}
}
}
}
protected void modalBtnSubmit_Command(object sender, CommandEventArgs e)
{
int roleId = Convert.ToInt32(modalDropDownRoles.SelectedItem.Value);
RoleDepartmentAccess departmentAccess = new RoleDepartmentAccess();
for (int i = 0; i < modalGridViewDepartment.Rows.Count; i++)
{
CheckBox cb = (CheckBox)modalGridViewDepartment.Rows[i].FindControl("modalChkBoxSelect");
Label labelDepartmentId = (Label)modalGridViewDepartment.Rows[i].FindControl("modalLabelDepartmentId");
departmentAccess.DepartmentId = Convert.ToInt32(labelDepartmentId.Text);
departmentAccess.RoleId = roleId;
if (cb.Checked != true && labelDepartmentId.ToolTip != "ToolTip") //Delete
{
departmentAccess.Delete(Convert.ToInt32(labelDepartmentId.ToolTip));
}
else if (cb.Checked == true && labelDepartmentId.ToolTip == "ToolTip") //Add
{
departmentAccess.Insert(departmentAccess);
}
else if (cb.Checked == true && labelDepartmentId.ToolTip != "ToolTip") //Update
{
departmentAccess.Id = Convert.ToInt32(labelDepartmentId.ToolTip);
departmentAccess.Update(departmentAccess);
}
}
InitializeGridRoles();
}
public void Update(RoleDepartmentAccess roledepartmentaccess)
{
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
T_RoleDepartmentAccess t_roledepartmentaccess = db.T_RoleDepartmentAccess.FirstOrDefault(p => p.Id == roledepartmentaccess.Id);
Parse(t_roledepartmentaccess, roledepartmentaccess);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
private void Parse(T_RoleDepartmentAccess t_roledepartmentaccess, RoleDepartmentAccess roledepartmentaccess)
{
t_roledepartmentaccess.RoleId = roledepartmentaccess.RoleId;
t_roledepartmentaccess.DepartmentId = roledepartmentaccess.DepartmentId;
}
