public async Task <ActionResult> Create([Bind(Include = "Id,Name,Clients_Id,WorkshiftCategories_Id,DayOfWeek,Start,DurationMinutes,Notes,Active")] WorkshiftTemplateModels workshiftTemplateModels) { int check = (from wt in db.WsTemplate where wt.Name == workshiftTemplateModels.Name && wt.Clients_Id == workshiftTemplateModels.Clients_Id && wt.WorkshiftCategories_Id == workshiftTemplateModels.WorkshiftCategories_Id && wt.DayOfWeek == workshiftTemplateModels.DayOfWeek && wt.Start == workshiftTemplateModels.Start && wt.DurationMinutes == workshiftTemplateModels.DurationMinutes select wt).Count(); if (check > 0) { ModelState.AddModelError("Duplicate", "Data Workshift Templates already exist!"); } if (ModelState.IsValid) { workshiftTemplateModels.Id = Guid.NewGuid(); db.WsTemplate.Add(workshiftTemplateModels); await db.SaveChangesAsync(); return(RedirectToAction("Create")); } ViewBag.listClient = new SelectList(db.Clients.Where(x => x.Active == true).OrderBy(x => x.CompanyName).ToList(), "Id", "CompanyName"); ViewBag.listCategory = new SelectList(db.WsCategory.Where(x => x.Active == true).OrderBy(x => x.Name).ToList(), "Id", "Name"); var dow = from Common.Master.DayOfWeek d in Enum.GetValues(typeof(Common.Master.DayOfWeek)) select new { Id = (byte)d, Name = d.ToString() }; ViewBag.listDOW = new SelectList(dow, "Id", "Name"); return(View(workshiftTemplateModels)); }
public async Task <ActionResult> Create([Bind(Include = "Id,Name,Owner_Id,Owner_RefId,BankName,AccountNumber,Notes,Active,Internal")] BankAccountModels bankAccountModels) { if (ModelState.IsValid) { bankAccountModels.Id = Guid.NewGuid(); db.BankAccount.Add(bankAccountModels); await db.SaveChangesAsync(); return(RedirectToAction("Create")); } return(View(bankAccountModels)); }
public async Task <ActionResult> Create([Bind(Include = "Id,Name,Notes,Active")] WorkshiftCategoryModels workshiftCategoryModels) { if (ModelState.IsValid) { workshiftCategoryModels.Id = Guid.NewGuid(); db.WsCategory.Add(workshiftCategoryModels); await db.SaveChangesAsync(); return(RedirectToAction("Create")); } return(View(workshiftCategoryModels)); }
public async Task <ActionResult> Create([Bind(Include = "Id,CompanyName,Address,BillingAddress,ContactPersonName,Phone1,Phone2,Notes,NPWP,NPWPAddress,Active")] ClientModels clientModels) { if (ModelState.IsValid) { clientModels.Id = Guid.NewGuid(); db.Clients.Add(clientModels); await db.SaveChangesAsync(); return(RedirectToAction("Create")); } return(View(clientModels)); }
public async Task <ActionResult> Create([Bind(Include = "Id,Name,Notes,Active")] AttendanceStatusModels attendanceStatusModels) { if (ModelState.IsValid) { attendanceStatusModels.Id = Guid.NewGuid(); db.AttStatus.Add(attendanceStatusModels); await db.SaveChangesAsync(); return(RedirectToAction("Create")); } return(View(attendanceStatusModels)); }
public async Task <IActionResult> Post([FromBody] DUsers model) { try { await _context.Users.AddAsync(model); await _context.SaveChangesAsync(); return(Success("User added successfully.", null, model)); } catch (Exception ex) { return(Error <object>("Something went wrong!", ex.Message, null)); } }
public async Task <ActionResult> Create([Bind(Include = "Id,RefId,AttendanceStatuses_Id,Amount,Notes,Active")] AttendancePayRateModels attendancePayRateModels) { if (ModelState.IsValid) { attendancePayRateModels.Id = Guid.NewGuid(); db.AttPayRate.Add(attendancePayRateModels); await db.SaveChangesAsync(); return(RedirectToAction("Create")); } ViewBag.listClient = new SelectList(db.Clients.Where(x => x.Active == true).OrderBy(x => x.CompanyName).ToList(), "Id", "CompanyName"); //ViewBag.listWsTemplate = new SelectList(db.WsTemplate.Where(x => x.Active == true).OrderBy(x => x.Name).ToList(), "Id", "Name"); ViewBag.listAttStatus = new SelectList(db.AttStatus.Where(x => x.Active == true).OrderBy(x => x.Name).ToList(), "Id", "Name"); return(View(attendancePayRateModels)); }
public static void AddDefaultDepartments() { using (var db = new HrContext()) { db.Departments.AddRangeAsync(defaultDepartments); db.SaveChangesAsync(); } }
public async Task <ActionResult> Edit([Bind(Include = "Id,FullName,UserName,Email,RoleId,Identification,DOB,Height,Weight,Phone1,Phone2,Address1,Address2,Notes")] UserViewModel userModels) { if (ModelState.IsValid) { var user = new UserModels() { Id = userModels.Id, FullName = userModels.FullName, Email = userModels.Email, Identification = userModels.Identification, DOB = userModels.DOB, Height = userModels.Height, Weight = userModels.Weight, Phone1 = userModels.Phone1, Phone2 = userModels.Phone2, Address1 = userModels.Address1, Address2 = userModels.Address2, Notes = userModels.Notes }; var userRole = new UserRoleModels() { UserId = userModels.Id, RoleId = userModels.RoleId }; using (var database = new HrContext()) { database.User.Attach(user); database.Entry(user).Property(x => x.FullName).IsModified = true; database.Entry(user).Property(x => x.Email).IsModified = true; database.Entry(user).Property(x => x.Identification).IsModified = true; database.Entry(user).Property(x => x.DOB).IsModified = true; database.Entry(user).Property(x => x.Height).IsModified = true; database.Entry(user).Property(x => x.Weight).IsModified = true; database.Entry(user).Property(x => x.Phone1).IsModified = true; database.Entry(user).Property(x => x.Phone2).IsModified = true; database.Entry(user).Property(x => x.Address1).IsModified = true; database.Entry(user).Property(x => x.Address2).IsModified = true; database.Entry(user).Property(x => x.Notes).IsModified = true; database.UserRole.Attach(userRole); database.Entry(userRole).Property(x => x.RoleId).IsModified = true; await database.SaveChangesAsync(); } return(RedirectToAction("Index")); } ViewBag.listRole = new SelectList(db.Role.OrderBy(x => x.Name).ToList(), "Id", "Name"); return(View(userModels)); }
public async Task <ActionResult> Create([Bind(Include = "Id,UserAccounts_Id,TimestampIn,TimestampOut,Notes,Flag1,Flag2,Approved,Workshifts_DayOfWeek,Workshifts_Start,Workshifts_DurationMinutes,EffectiveTimestampIn,EffectiveTimestampOut,Clients_Id,Rejected,PayrollItems_Id,AttendanceStatuses_Id,Workshifts_Id,AttendancePayRates_Id,AttendancePayRates_Amount")] AttendanceModels attendanceModels) { if (ModelState.IsValid) { attendanceModels.Id = Guid.NewGuid(); attendanceModels.Workshifts_Start = attendanceModels.EffectiveTimestampIn; attendanceModels.Workshifts_DurationMinutes = (int)attendanceModels.EffectiveTimestampOut.Subtract(attendanceModels.EffectiveTimestampIn).TotalMinutes; attendanceModels.AttendancePayRates_Amount = attendanceModels.AttendancePayRates_Amount == null ? 0 : attendanceModels.AttendancePayRates_Amount; db.Attendance.Add(attendanceModels); await db.SaveChangesAsync(); ViewBag.listClient = new SelectList(db.Clients.Where(x => x.Active == true).OrderBy(x => x.CompanyName).ToList(), "Id", "CompanyName"); ViewBag.listEmployee = new SelectList(db.User.OrderBy(x => x.FullName).ToList(), "Id", "FullName"); ViewBag.listAttStatus = new SelectList(db.AttStatus.Where(x => x.Active == true).OrderBy(x => x.Name).ToList(), "Id", "Name"); ViewBag.StatusAction = "Submit"; return(View()); //return RedirectToAction("Create"); } ViewBag.listClient = new SelectList(db.Clients.Where(x => x.Active == true).OrderBy(x => x.CompanyName).ToList(), "Id", "CompanyName"); ViewBag.listEmployee = new SelectList(db.User.OrderBy(x => x.FullName).ToList(), "Id", "FullName"); ViewBag.listAttStatus = new SelectList(db.AttStatus.Where(x => x.Active == true).OrderBy(x => x.Name).ToList(), "Id", "Name"); return(View(attendanceModels)); }