public IActionResult Claim(int?id)
{
ViewBag.history = new ClaimHistory();
DropdownListClaim drop = GetDropdown(id);
var modelUser = new Claim();
ViewBag.ModelMessage = false;
if (id != null && id > 1)
{
var EmpID = new SqlParameter("@ClaimID", id);
modelUser = _context.Claim.FromSql("sp_getClaim @ClaimID", EmpID).FirstOrDefaultAsync().Result;
if (modelUser == null)
{
ViewBag.ModelMessage = true;
return(RedirectToAction(nameof(Index)));
}
modelUser.CreatedDate = DateTime.Now;
var test = _context.History.FromSql("sp_getClaimHistory @ClaimID", EmpID).ToListAsync().Result.ToList();
ViewBag.history = test;
}
else
{
modelUser = new Claim();
}
ViewBag.Staffs = GetAllStaffs();
ViewBag.dropdownInfo = drop;
return(View(modelUser));
}
public DropdownListClaim GetDropdown(int?ClaimID)
{
DropdownListClaim drop = new DropdownListClaim();
var temp = _context.State.FromSql("sp_States").ToListAsync().Result.ToList();
//drop.states = new List<SelectListItem>();
foreach (var item in temp)
{
drop.states.Add(new SelectListItem()
{
Text = item.Id, Value = item.Id
});
}
//var tempStatus = _context.ClaimStatus.FromSql("sp_getStatus").ToListAsync().Result.ToList();
var ID = new SqlParameter("@ClaimID", ClaimID);
var tempStatus = _context.ClaimStatus.FromSql("sp_getStatus @ClaimID", ID).ToListAsync().Result.ToList();
var index = 0;
foreach (var item in tempStatus)
{
if (index == 0)
{
drop.Status.Add(new SelectListItem()
{
Text = item.ClaimStatusRef, Value = item.ClaimStatusRefID.ToString(), Selected = true
});
drop.Status[0].Selected = true;
}
else
{
if (User.FindFirst("RoleId").Value != "3")
{
drop.Status.Add(new SelectListItem()
{
Text = item.ClaimStatusRef, Value = item.ClaimStatusRefID.ToString(), Selected = false
});
}
else
{
if (item.ClaimStatusRefID != 4 && item.ClaimStatusRefID != 6 && item.ClaimStatusRefID != 7)
{
drop.Status.Add(new SelectListItem()
{
Text = item.ClaimStatusRef, Value = item.ClaimStatusRefID.ToString(), Selected = false
});
}
}
}
index = index + 1;
}
var tempFinding = _context.FindingReason.FromSql("sp_getReasonRef").ToListAsync().Result.ToList();
foreach (var item in tempFinding)
{
drop.Reason.Add(new SelectListItem()
{
Text = item.FindingReasonRef, Value = item.FindingReasonRefID.ToString()
});
}
var tempAction = _context.ClaimAction.FromSql("sp_getAction").ToListAsync().Result.ToList();
//drop.Action.Add(new SelectListItem() { Text = "Select", Value = "0" });
foreach (var item in tempAction)
{
drop.Action.Add(new SelectListItem()
{
Text = item.ClaimActionRef, Value = item.ClaimActionRefID.ToString()
});
}
var tempAssignee = _context.Claim.FromSql("sp_getClaim @ClaimID", ID).ToListAsync().Result.ToList();
foreach (var item in tempAssignee)
{
if (item.ClaimStatusRefID == 2)
{
drop.Assignee.Add(new SelectListItem()
{
Text = item.Assignee, Value = item.AssigneeID, Selected = true
});
drop.Assignee[0].Selected = true;
}
else if (item.ClaimStatusRefID == 3)
{
List <Supervisors> lSupervisors = new List <Supervisors>();
lSupervisors = _context.Supervisors.FromSql("sp_getSupervisors").ToListAsync().Result.ToList();
foreach (var oneSupervisor in lSupervisors)
{
if (Convert.ToInt32(oneSupervisor.EmployeeID) == Convert.ToInt32(item.AssigneeID))
{
drop.Assignee.Add(new SelectListItem {
Text = oneSupervisor.Users, Value = oneSupervisor.EmployeeID, Selected = true
});
}
else
{
drop.Assignee.Add(new SelectListItem {
Text = oneSupervisor.Users, Value = oneSupervisor.EmployeeID, Selected = false
});
}
}
}
else if (item.ClaimStatusRefID == 4)
{
List <UserStaff> lStaffs = new List <UserStaff>();
lStaffs = _context.UserStaff.FromSql("sp_getStaffDropdown").ToListAsync().Result.ToList();
foreach (var oneStaff in lStaffs)
{
if (Convert.ToInt32(oneStaff.EmployeeID) == Convert.ToInt32(item.AssigneeID))
{
drop.Assignee.Add(new SelectListItem {
Text = oneStaff.Users, Value = oneStaff.EmployeeID, Selected = true
});
}
else
{
drop.Assignee.Add(new SelectListItem {
Text = oneStaff.Users, Value = oneStaff.EmployeeID, Selected = false
});
}
}
}
else if (item.ClaimStatusRefID == 5)
{
drop.Assignee.Add(new SelectListItem()
{
Text = item.Assignee, Value = item.AssigneeID, Selected = true
});
drop.Assignee[0].Selected = true;
}
else if (item.ClaimStatusRefID == 6)
{
drop.Assignee.Add(new SelectListItem()
{
Text = item.Assignee, Value = item.AssigneeID, Selected = true
});
drop.Assignee[0].Selected = true;
}
else if (item.ClaimStatusRefID == 7)
{
drop.Assignee.Add(new SelectListItem()
{
Text = item.Assignee, Value = item.AssigneeID, Selected = true
});
drop.Assignee[0].Selected = true;
}
}
return(drop);
}
