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