public void ValueChanged(BaseEntryForm EntryForm, object sender) { BaseField field = sender as BaseField; switch (field.Name) { case nameof(LeaveAsk.leaveCategory): { //ComboBoxField leavecatfield = field as ComboBoxField; //ManyToOneField Stafffield = EntryForm.Fields[nameof(LeaveAsk.staff)] as ManyToOneField; //Staff staff = Stafffield.SelectedItem as Staff; //Int32Filed nbdays = EntryForm.Fields[nameof(LeaveAsk.nbDaysWanted)] as Int32Filed; ManyToOneField leavecatfield = EntryForm.Fields[nameof(LeaveAsk.leaveCategory)] as ManyToOneField; LeaveCategory leavecategory = leavecatfield.SelectedItem as LeaveCategory; ManyToOneField stafffield = EntryForm.Fields[nameof(LeaveAsk.staff)] as ManyToOneField; Staff staff = stafffield.SelectedItem as Staff; Int32Filed nbdays = EntryForm.Fields[nameof(LeaveAsk.nbDaysWanted)] as Int32Filed; if (leavecategory.Reference == "Administrativeleave") { staff.nbTotalDaysAdmin = staff.nbTotalDaysAdmin - nbdays; } } break; } }
public async Task <LeaveCategory> CreateAsync(LeaveCategory leaveCategory) { var categoryId = await Connection.InsertAsync <int>(leaveCategory, transaction : Transaction); leaveCategory.Id = categoryId; return(leaveCategory); }
public bool Insert(LeaveCategoryVM leaveCategoryVM) { var push = new LeaveCategory(leaveCategoryVM); aplicationContext.LeaveCategories.Add(push); var result = aplicationContext.SaveChanges(); return(result > 0); }
public async Task <IActionResult> OnGetAsync(long id) { if (_accountManage.IsLoggedIn != true || _accountManage.User.UserType != UserType.Admin) { return(RedirectToPage("/LoginPage")); } ViewData["User_Name"] = _accountManage.User.Name; ViewData.Add("ProfileImg", _accountManage.User.ProfileImageSrc); LeaveCategory = await _db.LeaveCategories.FindAsync(id); return(Page()); }
public LeaveCategory GetLeaveCategoryData(int id) { try { LeaveCategory LeaveCategory = _appContext.leaveCategories.Find(id); return(LeaveCategory); } catch (Exception ex) { throw ex; } }
public async Task <VerifyRecordResult> AddAsync(LeaveCategoryAdapterModel paraObject) { LeaveCategory itemParameter = Mapper.Map <LeaveCategory>(paraObject); CleanTrackingHelper.Clean <LeaveCategory>(context); await context.LeaveCategory .AddAsync(itemParameter); await context.SaveChangesAsync(); CleanTrackingHelper.Clean <LeaveCategory>(context); return(VerifyRecordResultFactory.Build(true)); }
public async Task <LeaveCategoryAdapterModel> GetAsync(int id) { LeaveCategory item = await context.LeaveCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == id); LeaveCategoryAdapterModel result = Mapper.Map <LeaveCategoryAdapterModel>(item); await OhterDependencyData(result); return(result); }
public int UpdateLeaveCategory(LeaveCategory LeaveCategory) { try { _appContext.Entry(LeaveCategory).State = EntityState.Modified; _appContext.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
public int AddLeaveCategory(LeaveCategory LeaveCategory) { try { _appContext.leaveCategories.Add(LeaveCategory); _appContext.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
public int DeleteLeaveCategory(int id) { try { LeaveCategory LeaveCategory = _appContext.leaveCategories.Find(id); _appContext.leaveCategories.Remove(LeaveCategory); _appContext.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
public async Task <VerifyRecordResult> DeleteAsync(int id) { CleanTrackingHelper.Clean <LeaveCategory>(context); LeaveCategory item = await context.LeaveCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == id); if (item == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法刪除紀錄)); } else { CleanTrackingHelper.Clean <LeaveCategory>(context); context.Entry(item).State = EntityState.Deleted; await context.SaveChangesAsync(); CleanTrackingHelper.Clean <LeaveCategory>(context); return(VerifyRecordResultFactory.Build(true)); } }
public async Task <VerifyRecordResult> BeforeUpdateCheckAsync(LeaveFormAdapterModel paraObject) { var searchItem = await context.LeaveForm .AsNoTracking() .FirstOrDefaultAsync(x => x.BeginDate == paraObject.BeginDate && x.Id != paraObject.Id); if (searchItem != null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.要修改的紀錄已經存在無法修改)); } CleanTrackingHelper.Clean <MyUser>(context); CleanTrackingHelper.Clean <LeaveCategory>(context); LeaveCategory itemLeaveCategory = await context.LeaveCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.LeaveCategoryId); if (itemLeaveCategory == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.需要指定請假類別)); } MyUser item = await context.MyUser .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.MyUserId); if (item == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.需要指定使用者)); } item = await context.MyUser .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.AgentId); if (item == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.需要指定使用者)); } return(VerifyRecordResultFactory.Build(true)); }
public async Task <VerifyRecordResult> UpdateAsync(LeaveCategoryAdapterModel paraObject) { LeaveCategory itemData = Mapper.Map <LeaveCategory>(paraObject); CleanTrackingHelper.Clean <LeaveCategory>(context); LeaveCategory item = await context.LeaveCategory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (item == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法修改紀錄)); } else { CleanTrackingHelper.Clean <LeaveCategory>(context); context.Entry(itemData).State = EntityState.Modified; await context.SaveChangesAsync(); CleanTrackingHelper.Clean <LeaveCategory>(context); return(VerifyRecordResultFactory.Build(true)); } }
public async Task <LeaveCategory> UpdateAsync(LeaveCategory leaveCategory) { var result = await Connection.UpdateAsync(leaveCategory, transaction : Transaction); return(await GetAsync(leaveCategory.Id)); }
public int Edit([FromBody] LeaveCategory LeaveCategory) { return(_unitOfWork.Leave.UpdateLeaveCategory(LeaveCategory)); }
public int Create([FromBody] LeaveCategory LeaveCategory) { return(_unitOfWork.Leave.AddLeaveCategory(LeaveCategory)); }
public static IEnumerable <LeaveCategory> GetLeaveCategories() { return(LeaveCategory.getAll()); }