//GET: /PolicyCarOtherGroupItemDataTableItem/List
public ActionResult List(int id, int policyGroupId, string filter, int?page, string sortField, int?sortOrder)
{
PolicyCarOtherGroupItemDataTableItemsVM policyCarOtherGroupItemDataTableItemsVM = new PolicyCarOtherGroupItemDataTableItemsVM();
//Check Policy Exists
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyGroupId);
if (policyGroup == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
policyCarOtherGroupItemDataTableItemsVM.PolicyGroup = policyGroup;
//Check PolicyOtherGroupHeader Exists
PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader();
policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(id);
if (policyOtherGroupHeader == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
policyCarOtherGroupItemDataTableItemsVM.PolicyOtherGroupHeader = policyOtherGroupHeader;
//Set Access Rights
policyCarOtherGroupItemDataTableItemsVM.HasWriteAccess = false;
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToPolicyGroup(policyGroupId))
{
policyCarOtherGroupItemDataTableItemsVM.HasWriteAccess = true;
}
//SortField + SortOrder settings
if (string.IsNullOrEmpty(sortField))
{
//Dynamically generated in proc
sortField = string.Empty;
}
ViewData["CurrentSortField"] = sortField;
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
}
DataTable policyCarOtherGroupItemDataTableItems = policyCarOtherGroupItemDataTableItemRepository.GetPolicyCarOtherGroupItemDataTableItems(
id, policyGroup.PolicyGroupId, filter ?? "", sortField, sortOrder ?? 0, page ?? 1, ref policyCarOtherGroupItemDataTableItemsVM);
policyCarOtherGroupItemDataTableItemsVM.PolicyCarOtherGroupItemDataTableItems = policyCarOtherGroupItemDataTableItems;
return(View(policyCarOtherGroupItemDataTableItemsVM));
}
//Sortable List
public DataTable GetPolicyCarOtherGroupItemDataTableItems(int id, int policyGroupId, string filter, string sortField, int sortOrder, int page, ref PolicyCarOtherGroupItemDataTableItemsVM policyCarOtherGroupItemDataTableItemsVM)
{
//query db
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
DataSet policyCarOtherGroupItemDataTableItems = new DataSet();
string connectionStringName = Settings.getConnectionStringName();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("spDesktopDataAdmin_SelectPolicyCarOtherGroupItemDataTableRows_v1", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PolicyOtherGroupHeaderId", id);
cmd.Parameters.AddWithValue("@PolicyGroupId", policyGroupId);
cmd.Parameters.AddWithValue("@Filter", filter);
cmd.Parameters.AddWithValue("@SortField", sortField);
cmd.Parameters.AddWithValue("@SortOrder", sortOrder);
cmd.Parameters.AddWithValue("@PageNumber", page);
cmd.Parameters.AddWithValue("@AdminUserGuid", adminUserGuid);
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(policyCarOtherGroupItemDataTableItems);
}
}
if (policyCarOtherGroupItemDataTableItems.Tables[1] != null)
{
DataTable dt = policyCarOtherGroupItemDataTableItems.Tables[1];
int totalRecords = (from DataRow dr in dt.Rows select(int) dr["Record Count"]).FirstOrDefault();
int pageSize = 16;
policyCarOtherGroupItemDataTableItemsVM.PageIndex = page;
policyCarOtherGroupItemDataTableItemsVM.PageSize = pageSize;
policyCarOtherGroupItemDataTableItemsVM.TotalCount = totalRecords;
policyCarOtherGroupItemDataTableItemsVM.TotalPages = (int)Math.Ceiling(totalRecords / (double)pageSize);
}
return(policyCarOtherGroupItemDataTableItems.Tables[0]);
}
