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