public void adduser(userinfo eh) { var uid = db.Usr.Max(v => v.ID) + 1; Usr ei = new Usr(); Secur sr = new Secur(); UserRole ur = new UserRole(); ei.UserID = uid; ei.EmpID = eh.EmpID; var emp = db.EmpInfo.Where(x => x.ID == eh.EmpID).FirstOrDefault(); emp.Usr = eh.UserName.Trim(); ei.UserName = eh.UserName.Trim(); ei.UserKey = sr.Encrypt(eh.UserKey.Trim()); ei.EntryKey = "000"; ei.Role = eh.Role; ei.Email = eh.Email; ei.Telephone = eh.Telephone; ei.IsActive = eh.IsActive; ei.ValidFrom = eh.ValidFrom; ei.CreatedBy = eh.Createby; ei.CreatedDate = DateTime.Today; ei.CreatedTime = DateTime.Now.TimeOfDay; ur.UserID = uid; ur.RoleID = eh.Role; ur.IsActive = eh.IsActive; ur.ValidFrom = DateTime.Today; ur.CreatedBy = eh.Createby; ur.CreatedDate = DateTime.Today; ur.CreatedTime = DateTime.Now.TimeOfDay; db.Usr.Add(ei); db.SaveChanges(); db.UserRole.Add(ur); db.SaveChanges(); }
public JsonResult AdAc(string syname, int cby) { SysList sl = new SysList(); sl.ID = db.SysList.ToList().LastOrDefault().ID + 1; sl.SysName = syname; sl.IsActive = true; sl.CreateDate = DateTime.Now; sl.CreateBy = cby; db.SysList.Add(sl); db.SaveChanges(); return(Json(new { Success = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult EditUser([Bind(Include = "ID,UserID,EmpID,UserName,UserKey,Role,Telephone,EmpID,Email,IsActive,ValidFrom,CreatedBy")] Usr eh) { ViewBag.depts = new SelectList(am.Role, "ID", "RoleName"); var empi = am.EmpInfo.Where(x => x.Usr == eh.UserName).Select(c => c.FullName).FirstOrDefault(); ViewBag.emp = empi; if (ModelState.IsValid) { CoreManager DM = new CoreManager(); if (!DM.IsLoginName(eh.UserName, eh.ID)) { var ei = am.Usr.SingleOrDefault(v => v.UserID == eh.UserID); var ri = am.UserRole.SingleOrDefault(v => v.UserID == eh.UserID); if (ei == null) { return(HttpNotFound()); } ei.UserName = eh.UserName.Trim(); ei.Role = eh.Role; ei.Email = eh.Email; ei.Telephone = eh.Telephone; ei.IsActive = eh.IsActive; ei.ValidFrom = eh.ValidFrom; ei.CreatedBy = eh.CreatedBy; ei.EmpID = eh.EmpID; var emp = am.EmpInfo.Where(x => x.ID == eh.EmpID).FirstOrDefault(); if (emp != null) { emp.Usr = eh.UserName.Trim(); } if (ri != null) { ri.RoleID = eh.Role; ri.ValidFrom = eh.ValidFrom; ri.IsActive = eh.IsActive; } am.SaveChanges(); return(RedirectToAction("Index", "User")); } else { ModelState.AddModelError("", "الاسم موجود من قبل"); return(View()); } } return(RedirectToAction("Index", "User")); }
public JsonResult adnewemp(string empname, DateTime createDate, string NationalID , string address, int SOCIALSTATUSES, bool Gender, int jobkadr, int Emp_JCat_FK, int JobGarde, int JobStatus, int Hr_dept, int cby) { HR_EmpReform erf = new HR_EmpReform(); erf.Emp_Id = db.HR_EmpReform.ToList().LastOrDefault().Emp_Id + 1; erf.Emp_Name = empname; erf.Emp_NationalID = NationalID; erf.Address = address; erf.SocialStatues = SOCIALSTATUSES; erf.Gender = Gender; erf.Emp_kader_FK = jobkadr; erf.Emp_JCat_FK = Emp_JCat_FK; erf.Emp_JGrade = JobGarde; erf.Job_Status_ID = JobStatus; erf.DeptID = Hr_dept; erf.CreatedDate = DateTime.Now; erf.CreatedBy = cby; db.HR_EmpReform.Add(erf); db.SaveChanges(); return(Json(new { Success = true }, JsonRequestBehavior.AllowGet)); }
public JsonResult adnpro(string proname, DateTime?fdate, DateTime?sdate, DateTime?tdate, DateTime?declaredate, decimal?totalval, int?kprofk, int?purnamefk, int cby) { ProList pl = new ProList(); pl.ProName = proname; pl.TotalVal = totalval ?? 0; pl.KProFK = kprofk; pl.PurNameFK = purnamefk; pl.FirstAccepteDate = fdate; pl.SecandAccepteDate = sdate; pl.ThirdAceepteDate = tdate; pl.CreateBy = cby; pl.CreateDate = DateTime.Now; pl.IsActive = true; pl.Posted = 1; pl.ProStop = false; db.ProList.Add(pl); db.SaveChanges(); return(Json(new { Success = true, Message = " تم إضافة المشروع بنجاح" }, JsonRequestBehavior.AllowGet)); }