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));
}
}
public JsonResult Addemp(user emp)
{
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 check = db.user.Where(c => c.username == emp.username);
int result = 0;
if (check.Count() != 0)
{
result = 0;
}
else
{
if (ModelState.IsValid)
{
emp.person_id = 3;
emp.count = 0;
emp.block = false;
db.user.Add(emp);
db.SaveChanges();
var org_id = db.organization.SingleOrDefault(c => c.manger_id == manager.id).id;
var emp_service = new Emp_Org_Services
{
emp_id = emp.id,
org_id = org_id
};
db.Emp_Org_Services.Add(emp_service);
db.SaveChanges();
result = 1;
}
else
{
result = -1;
}
}
return(Json(new { result, JsonRequestBehavior.AllowGet }));
}
