Example #1
0
        public ActionResult Create([Bind(Include = "Id,Name,Description,ActiveStatus")] Role role)
        {
            if (ModelState.IsValid)
            {
                role.Id = Guid.NewGuid();
                db.Roles.Add(role);
                db.SaveChanges();
                using (var insertDb = new HRMContext())
                {
                    RolePermission rolePermission = new RolePermission();

                    insertDb.RolePermissions.RemoveRange(db.RolePermissions.Where(r => r.RoleId == role.Id));

                    db.ModulePermissions.ToList().ForEach(mp =>
                    {
                        rolePermission = new RolePermission()
                        {
                            Id             = Guid.NewGuid(),
                            RoleId         = role.Id,
                            ModuleId       = mp.ModuleId,
                            PermissionName = mp.PermissionName,
                            Permission     = false
                        };
                        insertDb.RolePermissions.Add(rolePermission);
                    });
                    insertDb.SaveChanges();
                }

                return(RedirectToAction("Index"));
            }

            return(View(role));
        }
        public IActionResult Create(Dept dept)
        {
            if (ModelState.IsValid)
            {
                _context.Depts.Add(dept);
                _context.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(dept));
        }
Example #3
0
        public ActionResult Create([Bind(Include = "Id,loginId,Password,ActiveStatus")] User user)
        {
            if (ModelState.IsValid)
            {
                user.Id = Guid.NewGuid();
                db.Users.Add(user);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(user));
        }
Example #4
0
 public static void WriteErrorLog(ErrorLog errorLog)
 {
     try
     {
         if (errorLog.ErrorMessage.Length > 1023)
         {
             errorLog.ErrorMessage = errorLog.ErrorMessage.Substring(0, 1000);
         }
         using (HRMContext db = new HRMContext())
         {
             errorLog.Id         = Guid.NewGuid();
             errorLog.CreateDate = DateTime.UtcNow;
             db.ErrorLogs.Add(errorLog);
             db.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         using (var db = new HRMContext())
         {
             var log = new ErrorLog();
             log.Id           = Guid.NewGuid();
             log.CreateDate   = DateTime.UtcNow;
             log.ErrorFor     = "Exception to write error log";
             log.ErrorFrom    = "WriteErrorLog";
             log.ErrorMessage = ex.Message.Length > 1023 ? ex.Message.Substring(0, 1000) : ex.Message;
             db.ErrorLogs.Add(log);
             db.SaveChanges();
         }
     }
 }
Example #5
0
        public ActionResult Create([Bind(Include = "Id,EmpCode,FullName,NickName,DesignationId,DeptId,Phone,Email,Address")] Employee employee)
        {
            if (ModelState.IsValid)
            {
                employee.ActionDate = DateTime.Now;
                if (employee.Id != 0)
                {
                    db.Entry(employee).State = EntityState.Modified;
                }
                else
                {
                    db.Employees.Add(employee);
                }
                db.SaveChanges();
                return(RedirectToAction("Create"));
            }

            ViewBag.DeptId        = new SelectList(db.Depts, "Id", "Name", employee.DeptId);
            ViewBag.DesignationId = new SelectList(db.Designations, "Id", "Name", employee.DesignationId);
            return(View(employee));
        }
Example #6
0
        public ActionResult Create(Employee employee)
        {
            if (ModelState.IsValid)
            {
                employee.ActionDate = DateTime.Now;
                if (employee.Id != 0)
                {
                    db.Entry(employee).State = EntityState.Modified;
                }
                else
                {
                    db.Employees.Add(employee);
                }
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.DeptId        = new SelectList(db.Depts, "DeptId", "Name", employee.DeptId);
            ViewBag.DesignationId = new SelectList(db.Designations, "Id", "Name", employee.DesignationId);
            return(View(employee));
        }
        // PUT: odata/Employee(5)
        public IHttpActionResult Put([FromODataUri] int key, Delta <Employee> patch)
        {
            Validate(patch.GetEntity());

            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            Employee employee = db.Employees.Find(key);

            if (employee == null)
            {
                return(NotFound());
            }

            patch.Put(employee);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!EmployeeExists(key))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(Updated(employee));
        }
Example #8
0
    public static void Initialize(IServiceProvider serviceProvider)
    {
        using (var context = new HRMContext(
                   serviceProvider.GetRequiredService <DbContextOptions <HRMContext> >()))
        {
            // Check any employee exists
            if (context.Employees.Any())
            {
                return; // Data already exists no need to generate
            }

            context.Employees.AddRange(
                new Employee
            {
                Name        = "Md. Mahedee Hasan",
                Designation = "Head of Software Development",
                FathersName = "Yeasin Bhuiyan",
                MothersName = "Moriom Begum",
                DateOfBirth = new DateTime(1984, 12, 19, 00, 00, 00)
            },

                new Employee
            {
                Name        = "Khaleda Islam",
                Designation = "Software Engineer",
                FathersName = "Shahidul Islam",
                MothersName = "Momtaz Begum",
                DateOfBirth = new DateTime(1990, 10, 29, 00, 00, 00)
            },

                new Employee
            {
                Name        = "Tahiya Hasan Arisha",
                Designation = "Jr. Software Engineer",
                FathersName = "Md. Mahedee Hasan",
                MothersName = "Khaleda Islam",
                DateOfBirth = new DateTime(2017, 09, 17, 00, 00, 00)
            }
                );
            context.SaveChanges();
        }
    }
Example #9
0
 public int SaveChanges()
 {
     return(DbContext.SaveChanges());
 }
Example #10
0
 public bool Commit()
 {
     return(_context.SaveChanges() > 0);
 }