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 })); }