public ActionResult AddAction(string NameGroupEmployee, string Note, bool acc1, bool acc2, bool acc3, bool acc4, bool acc5, bool acc6, bool acc7, bool acc8, bool acc9, bool acc10, bool acc11, bool acc12, bool acc13, bool acc14, bool acc15, bool acc16, bool acc17, bool acc18, bool acc19, bool acc20)
{
GroupEmployeeDao group_dao = new GroupEmployeeDao();
GroupEmployee group_new = new GroupEmployee();
group_new.GroupName = NameGroupEmployee;
group_new.Note = Note;
group_new.CreateDate = DateTime.Now;
bool[] list_access = new bool[20];
list_access[0] = acc1;
list_access[1] = acc2;
list_access[2] = acc3;
list_access[3] = acc4;
list_access[4] = acc5;
list_access[5] = acc6;
list_access[6] = acc7;
list_access[7] = acc8;
list_access[8] = acc9;
list_access[9] = acc10;
list_access[10] = acc11;
list_access[11] = acc12;
list_access[12] = acc13;
list_access[13] = acc14;
list_access[14] = acc15;
list_access[15] = acc16;
list_access[16] = acc17;
list_access[17] = acc18;
list_access[18] = acc19;
list_access[19] = acc20;
group_dao.InsertGroupEmployee(group_new, list_access);
// return RedirectToAction("List1", "GroupEmployee", new { id = bcbcb });
return(RedirectToAction("List", "GroupEmployee"));
}
public ResponseVM Update(ITGroupMemberVM itgroupmemberVM)
{
using (context)
{
using (var dbTransaction = context.Database.BeginTransaction())
{
try
{
ITGroupMember itgroupmemberTobeUpdated = context.ITGroupMembers.Where(x => x.ITGroupMemberid == Guid.Parse(itgroupmemberVM.ITGroupMemberid)).FirstOrDefault();
if (itgroupmemberTobeUpdated == null)
{
return(new ResponseVM("update", false, "ITGroupMember", ResponseVM.DOES_NOT_EXIST));
}
itgroupmemberTobeUpdated.ITGroupid = Guid.Parse(itgroupmemberVM.ITGroupid);
context.SaveChanges();
var removeFromGroupEmployees = context.GroupEmployees.Where(x => x.ITGroupMemberid == itgroupmemberTobeUpdated.ITGroupMemberid);
context.GroupEmployees.RemoveRange(removeFromGroupEmployees);
context.SaveChanges();
foreach (var empID in itgroupmemberVM.EmployeeIdList)
{
var employee = context.Employees.Find(empID);
if (employee == null)
{
return(new ResponseVM("create", false, "ITGroupMember", "Employee does not exists"));
}
var groupEmployee = new GroupEmployee
{
EmployeeID = empID,
ITGroupMemberid = itgroupmemberTobeUpdated.ITGroupMemberid,
EmployeeFullName = toViewModel.ToFullName(employee.FirstName, employee.LastName)
};
context.GroupEmployees.Add(groupEmployee);
context.SaveChanges();
}
dbTransaction.Commit();
return(new ResponseVM("updated", true, "ITGroupMember"));
}
catch (Exception ex)
{
dbTransaction.Rollback();
return(new ResponseVM
("updated", false, "ITGroupMember", ResponseVM.SOMETHING_WENT_WRONG, "", ex));
throw;
}
}
}
}
public ResponseVM Create(ITGroupMemberVM itgroupmemberVM)
{
using (context)
{
using (var dbTransaction = context.Database.BeginTransaction())
{
try
{
itgroupmemberVM.ITGroupMemberid = Guid.NewGuid().ToString();
var itgroupmemberSaved = context.ITGroupMembers.Add(toModel.ITGroupMember(itgroupmemberVM)).Entity;
context.SaveChanges();
foreach (var empID in itgroupmemberVM.EmployeeIdList)
{
var employee = context.Employees.Find(empID);
if (employee == null)
{
return(new ResponseVM("create", false, "ITGroupMember", "Employee does not exists"));
}
var groupEmployee = new GroupEmployee
{
EmployeeID = empID,
ITGroupMemberid = itgroupmemberSaved.ITGroupMemberid,
EmployeeFullName = toViewModel.ToFullName(employee.FirstName, employee.LastName)
};
context.GroupEmployees.Add(groupEmployee);
context.SaveChanges();
}
dbTransaction.Commit();
return(new ResponseVM
("create", true, "ITGroupMember"));
}
catch (Exception ex)
{
dbTransaction.Rollback();
return(new ResponseVM("create", false, "ITGroupMember", ResponseVM.SOMETHING_WENT_WRONG, "", ex));
}
}
}
}
public int InsertGroupEmployee(GroupEmployee group_employee, bool[] list_access)
{
db.GroupEmployees.Add(group_employee);
db.SaveChanges();
//foreach (bool access in list_access)
//{
//}
for (int i = 0; i < list_access.Length; i++)
{
if (list_access[i] == true)
{
Authorization au = new Authorization();
au.AccessID = i + 1;
au.GroupEmployeeID = group_employee.ID;
db.Authorizations.Add(au);
}
}
db.SaveChanges();
return(group_employee.ID);
}
public ActionResult Details(int id)
{
if (Session["UserLogin"] != null)
{
UserLogin em = (UserLogin)Session["UserLogin"];
AuthorizationDao au = new AuthorizationDao();
if (au.CheckAccess(em.GroupEmployeeID, 19) == true)
{
GroupEmployeeDao my = new GroupEmployeeDao();
GroupEmployee employee = my.FindGroupEmployeeByID(id);
return(View("Details", employee));
}
else
{
return(RedirectToAction("Error", "Error"));
}
}
else
{
return(RedirectToAction("Index", "Login", new { Area = "" }));
}
}
public int UpdateGroupEmployee(GroupEmployee group_employee, bool[] list_access)
{
object[] SqlParams =
{
new SqlParameter("@ID", group_employee.ID),
new SqlParameter("@GroupName", group_employee.GroupName),
new SqlParameter("@Note", group_employee.Note),
};
db.Database.ExecuteSqlCommand("UpdateGroupEmloyee @ID,@GroupName,@Note", SqlParams);
for (int i = 0; i < list_access.Length; i++)
{
if (list_access[i] == true)
{
Authorization au = new Authorization();
au.AccessID = i + 1;
au.GroupEmployeeID = group_employee.ID;
db.Authorizations.Add(au);
}
}
db.SaveChanges();
return(group_employee.ID);
}
public ActionResult Edit(int id)
{
if (Session["UserLogin"] != null)
{
UserLogin em = (UserLogin)Session["UserLogin"];
AuthorizationDao au = new AuthorizationDao();
if (au.CheckAccess(em.GroupEmployeeID, 19) == true)
{
GroupEmployeeDao dao = new GroupEmployeeDao();
GroupEmployee employee_edit = dao.FindGroupEmployeeByID(id);
IEnumerable <Authorization> list_access = dao.ListAuthorization(id);
ViewBag.ListAuthorization = list_access;
return(View("Edit", employee_edit));
}
else
{
return(RedirectToAction("Error", "Error"));
}
}
else
{
return(RedirectToAction("Index", "Login", new { Area = "" }));
}
}
