public DataTable GetUserList(ViewUserLoginModel objUserLoginList)
{
try
{
SqlParameter[] parmList =
{
new SqlParameter("@UserName", objUserLoginList.FilterUserName)
, new SqlParameter("@CurrentPage", objUserLoginList.CurrentPage)
, new SqlParameter("@PageSize", objUserLoginList.PageSize)
, new SqlParameter("@SortBy", objUserLoginList.SortBy)
, new SqlParameter("@SortOrder", objUserLoginList.SortOrder)
};
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_GetUserList, parmList);
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult List(ViewUserLoginModel objViewUserLoginModel)
{
try
{
objViewUserLoginModel.Message = objViewUserLoginModel.MessageType = String.Empty;
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.UserLogin + "/GetUsernameList", objViewUserLoginModel);
objViewUserLoginModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewUserLoginModel>().Result : null;
}
catch (Exception ex)
{
ErrorLog(ex, "UserList", "View POST");
}
return(PartialView("_UserList", objViewUserLoginModel));
}
/// <summary>
/// Get SubCategory List based on paging, searching and sorting parameter
/// </summary>
/// <param name="objViewUserLoginModel">object of Model ViewSubCategoryModel</param>
/// <returns></returns>
public ViewUserLoginModel GetUsernameList(ViewUserLoginModel objViewUserLoginModel)
{
List <UserLogin> lstUserLogin = new List <UserLogin>();
//if FilterSubCategoryName is NULL than set to empty
objViewUserLoginModel.FilterUserName = objViewUserLoginModel.FilterUserName ?? String.Empty;
//if SortBy is NULL than set to empty
objViewUserLoginModel.SortBy = objViewUserLoginModel.SortBy ?? String.Empty;
//call GetSubCategoryList Method which will retrun datatable of SubCategory
DataTable dtSubCategory = objDLUserLogin.GetUserList(objViewUserLoginModel);
//fetch each row of datable
foreach (DataRow dr in dtSubCategory.Rows)
{
//Convert datarow into Model object and set Model object property
UserLogin itemUserLogin = GetDataRowToEntity <UserLogin>(dr);
//Add SubCategory in List
lstUserLogin.Add(itemUserLogin);
}
//set SubCategory List of Model ViewSubCategoryModel
objViewUserLoginModel.UserLoginList = lstUserLogin;
//if SubCategory List count is not null and greater than 0 Than set Total Pages for Paging.
if (objViewUserLoginModel != null && objViewUserLoginModel.UserLoginList != null && objViewUserLoginModel.UserLoginList.Count > 0)
{
objViewUserLoginModel.CurrentPage = objViewUserLoginModel.UserLoginList[0].CurrentPage;
int totalRecord = objViewUserLoginModel.UserLoginList[0].TotalCount;
if (decimal.Remainder(totalRecord, objViewUserLoginModel.PageSize) > 0)
{
objViewUserLoginModel.TotalPages = (totalRecord / objViewUserLoginModel.PageSize + 1);
}
else
{
objViewUserLoginModel.TotalPages = totalRecord / objViewUserLoginModel.PageSize;
}
}
else
{
objViewUserLoginModel.TotalPages = 0;
objViewUserLoginModel.CurrentPage = 1;
}
return(objViewUserLoginModel);
}
public ActionResult List()
{
ViewUserLoginModel ObjViewUserLoginModel = new ViewUserLoginModel();
try
{
//initial set of current page, pageSize , Total pages
ObjViewUserLoginModel.CurrentPage = 1;
ObjViewUserLoginModel.PageSize = CommonUtils.PageSize;
ObjViewUserLoginModel.TotalPages = 0;
//Get SubCategory List
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.UserLogin + "/GetUsernameList", ObjViewUserLoginModel);
ObjViewUserLoginModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewUserLoginModel>().Result : null;
//ObjViewSubCategoryModel = objBLSubCategory.GetSubCategoryList(ObjViewSubCategoryModel);
}
catch (Exception ex)
{
ErrorLog(ex, "UserList", "View GET");
}
return(View("ViewUserList", ObjViewUserLoginModel));
}
public ViewUserLoginModel GetUsernameList(ViewUserLoginModel objViewUserLoginModel)
{
return(objBusUserLogin.GetUsernameList(objViewUserLoginModel));
}
