public ActionResult AssignEmpToServices()
{
ViewBag.fullname = Session["UserName"];
ViewBag.userid = Session["UserID"];
ViewBag.user_id = new SelectList(db.user, "Id");
int UserID = Convert.ToInt32(Session["UserID"]);
var manager = db.user.SingleOrDefault(c => c.id == UserID);
int org_id = db.organization.SingleOrDefault(c => c.manger_id == manager.id).id;
var emps = db.Emp_Org_Services.Where(c => c.org_id == org_id).ToList();
var branches = db.Branch.Where(c => c.organization_id == org_id).ToList();
var services = db.Services_.Where(c => c.org_id == org_id).ToList();
EmpsOrg EmpsOrg = new EmpsOrg();
List <user> employees = new List <user>();
foreach (var x in emps)
{
var e = db.user.SingleOrDefault(c => c.id == x.emp_id);
var a = e.name;
if (!employees.Contains(x.user))
{
employees.Add(e);
}
}
EmpsOrg.emps = employees;
EmpsOrg.branches = branches;
EmpsOrg.services = services;
return(View(EmpsOrg));
}
public ActionResult AssignEmpToServices(EmpsOrg EmpsOrg)
{
string result = "";
ViewBag.fullname = Session["UserName"];
ViewBag.userid = Session["UserID"];
ViewBag.user_id = new SelectList(db.user, "Id");
int UserID = Convert.ToInt32(Session["UserID"]);
var manager = db.user.SingleOrDefault(c => c.id == UserID);
var org_id = db.organization.SingleOrDefault(c => c.manger_id == manager.id).id;
var e = db.Emp_Org_Services.SingleOrDefault(c => c.emp_id == EmpsOrg.emp_id && c.branch_id == null && c.service_id == null);
var e2 = db.Emp_Org_Services.Where(c => c.emp_id == EmpsOrg.emp_id).ToList();
var check = 0;
foreach (var x in e2)
{
if (EmpsOrg.service_id == x.service_id)
{
check = 1;
}
}
if (e != null)
{
db.Emp_Org_Services.Remove(e);
db.SaveChanges();
}
if (EmpsOrg.branch_id != e2[0].branch_id && e2[0].branch_id != null)
{
result = "هذا الموظف بالفعل مضاف لفرع لا يمكن اضافته الى فرع اخر...";
return(Json(result, JsonRequestBehavior.AllowGet));
}
else if (check != 0)
{
result = "هذا الموظف مضاف بالفعل الى هذه الخدمة " +
db.Services_.SingleOrDefault(c => c.id == EmpsOrg.service_id).name;
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
var empOrgServices = new Emp_Org_Services
{
emp_id = EmpsOrg.emp_id,
service_id = EmpsOrg.service_id,
branch_id = EmpsOrg.branch_id,
org_id = org_id
};
db.Emp_Org_Services.Add(empOrgServices);
db.SaveChanges();
result = "تم بنجاح ...";
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
