public ActionResult LeaveRuleEdit(LeaveRuleAddViewModel vm)
{
string status = "failed";
//var leaveTypes = _leaveTypeService.GetLeaveTypes().ToList();
LeaveRuleAddViewModel lrVM = new LeaveRuleAddViewModel();
//lrVM.Params = leaveTypes;
LeaveRuleDTO lrd = new LeaveRuleDTO();
lrd.LeaveRuleDetails = vm.LeaveRuleDescription;
lrd.LeaveRuleName = vm.LeaveRuleName;
lrd.LeaveRuleId = vm.LeaveRuleId;
//Updating Leave Rules
int abc = _leaveRuleService.UpdateLeaveRule(lrd);
if (abc > 0)
{
status = "done";
}
//Editing Leave Rule Details
for (int i = 0; i < vm.Params.Count; i++)
{
LeaveRuleDetailDTO inLRD = new LeaveRuleDetailDTO();
inLRD.DetailId = vm.Params[i].LeaveRuleDetailId;
inLRD.LeaveRuleId = vm.LeaveRuleId;
inLRD.LeaveDays = vm.Params[i].Days != null?Convert.ToDecimal(vm.Params[i].Days) : 0;
inLRD.LeaveTypeId = Convert.ToInt32(vm.Params[i].LeaveTypeId);
int def = _leaveRuleDetailService.UpdateLeaveRuleDetails(inLRD);
}
ViewBag.Success = "The leave rule has been updated.";
return(RedirectToAction("LeaveRuleEdit", "LeaveRules", new { id = vm.LeaveRuleId, status }));
}
public ActionResult LeaveRuleAddClose(LeaveRuleAddViewModel vm)
{
var leaveTypes = _leaveTypeService.GetLeaveTypes().ToList();
LeaveRuleAddViewModel lrVM = new LeaveRuleAddViewModel();
lrVM.Params = leaveTypes;
if (!ModelState.IsValid)
{
return(View(lrVM));
}
LeaveRuleDTO lrd = new LeaveRuleDTO();
lrd.LeaveRuleDetails = vm.LeaveRuleDescription;
lrd.LeaveRuleName = vm.LeaveRuleName;
//Inserting Leave Rules
LeaveRuleDTO resLeaveRule = _leaveRuleService.InsertLeaveRule(lrd);
//Inserting Leave Rule Details
for (int i = 0; i < vm.Params.Count; i++)
{
LeaveRuleDetailDTO inLRD = new LeaveRuleDetailDTO();
inLRD.LeaveRuleId = resLeaveRule.LeaveRuleId;
inLRD.LeaveDays = vm.Params[i].Days != null?Convert.ToDecimal(vm.Params[i].Days) : 0;
inLRD.LeaveTypeId = Convert.ToInt32(vm.Params[i].LeaveTypeId);
LeaveRuleDetailDTO reLRD = _leaveRuleDetailService.InsertLeaveRuleDetail(inLRD);
}
return(RedirectToAction("LeaveRules", "LeaveRules"));
}
public ActionResult LeaveRuleAdd(LeaveRuleAddViewModel vm)
{
var leaveTypes = _leaveTypeService.GetLeaveTypes().ToList();
LeaveRuleAddViewModel lrVM = new LeaveRuleAddViewModel();
lrVM.Params = leaveTypes;
if (!ModelState.IsValid)
{
return(View(lrVM));
}
LeaveRuleDTO lrd = new LeaveRuleDTO();
lrd.LeaveRuleDetails = vm.LeaveRuleDescription;
lrd.LeaveRuleName = vm.LeaveRuleName;
//Inserting Leave Rules
LeaveRuleDTO resLeaveRule = _leaveRuleService.InsertLeaveRule(lrd);
//Inserting Leave Rule Details
for (int i = 0; i < vm.Params.Count; i++)
{
LeaveRuleDetailDTO inLRD = new LeaveRuleDetailDTO();
inLRD.LeaveRuleId = resLeaveRule.LeaveRuleId;
inLRD.LeaveDays = vm.Params[i].Days != null?Convert.ToDecimal(vm.Params[i].Days) : 0;
inLRD.LeaveTypeId = Convert.ToInt32(vm.Params[i].LeaveTypeId);
LeaveRuleDetailDTO reLRD = _leaveRuleDetailService.InsertLeaveRuleDetail(inLRD);
}
ViewBag.Success = "The leave rule \"" + resLeaveRule.LeaveRuleName + "\" has been added.";
ModelState.Clear();
return(View(lrVM));
}
public static LeaveRuleDetail ConvertRespondentInfoFromDTO(LeaveRuleDetailDTO leaveRuleDetailDTO)
{
Mapper.CreateMap <LeaveRuleDetailDTO, LeaveRuleDetail>().ConvertUsing(
m =>
{
return(new LeaveRuleDetail
{
LeaveDays = m.LeaveDays,
LeaveRuleId = m.LeaveRuleId,
LeaveTypeId = m.LeaveTypeId
});
});
return(Mapper.Map <LeaveRuleDetailDTO, LeaveRuleDetail>(leaveRuleDetailDTO));
}
public int UpdateLeaveRuleDetails(LeaveRuleDetailDTO editLRD)
{
var conn = DbConnectHelper.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("sp_InsertLeaveRuleDetails", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DetailID", editLRD.DetailId);
cmd.Parameters.AddWithValue("@LeaveRuleId", editLRD.LeaveRuleId);
cmd.Parameters.AddWithValue("@LeaveTypeId", editLRD.LeaveTypeId);
cmd.Parameters.AddWithValue("@LeaveDays", editLRD.LeaveDays);
int abc = cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
conn.Dispose();
return(abc);
}
public LeaveRuleDetailDTO InsertLeaveRuleDetail(LeaveRuleDetailDTO leaveRuleDetail)
{
LeaveRuleDetail lr = LeaveRuleDetailRequestFormatter.ConvertRespondentInfoFromDTO(leaveRuleDetail);
return(LeaveRuleDetailRequestFormatter.ConvertRespondentInfoToDTO(_unitOfWork.LeaveRuleDetailRepository.Create(lr)));
}
