public List <Menu> Get(QueryBO objQuery) { SqlDataReader reader = null; SqlConnection con = null; List <Menu> lstObject = null; SqlCommand objcmd = null; Menu obj = null; try { lstObject = new List <Menu>(); using (con = DBconnection.ConnectToDB()) { objcmd = new SqlCommand(); objcmd.Connection = con; objcmd.CommandType = CommandType.StoredProcedure; objcmd.CommandText = "STP_SelectMenuMaster"; objcmd.Parameters.Add(new SqlParameter("@PageNumber", objQuery.PageNumber)); objcmd.Parameters.Add(new SqlParameter("@PageSize", objQuery.PageSize)); objcmd.Parameters.Add(new SqlParameter("@Filter", objQuery.Filter)); objcmd.Parameters.Add(new SqlParameter("@Sort", objQuery.Sort)); objcmd.Parameters.Add(new SqlParameter("@TotalRecords", SqlDbType.Int)).Direction = ParameterDirection.Output; reader = objcmd.ExecuteReader(); if (reader != null && reader.HasRows) { while (reader.Read()) { obj = new Menu(); obj.MenuId = Convert.ToInt32("0" + reader["MenuId"]); obj.Title = Convert.ToString("" + reader["Title"]); obj.MenuHeading = Convert.ToString("" + reader["MenuHeading"]); obj.Description = Convert.ToString("" + reader["Description"]); obj.IconClass = Convert.ToString("" + reader["IconClass"]); obj.Controller = Convert.ToString("" + reader["Controller"]); obj.Action = Convert.ToString("" + reader["Action"]); obj.ParentId = Convert.ToInt32("0" + reader["ParentId"]); obj.Order = Convert.ToInt32("0" + reader["Order"]); obj.Status = Convert.ToInt32("0" + reader["Status"]); obj.IsParent = reader["IsParent"] == DBNull.Value ? false : (Boolean)reader["IsParent"]; lstObject.Add(obj); } } } objQuery.TotalRecords = Convert.ToInt32(objcmd.Parameters["@TotalRecords"].Value); } catch (Exception ex) { throw ex; } finally { reader.Dispose(); objcmd = null; con = null; } return(lstObject); }
public List <AreaMaster> Get(QueryBO objQuery) { SqlDataReader reader = null; SqlConnection con = null; List <AreaMaster> lstArea = null; SqlCommand objcmd = null; AreaMaster objArea = null; try { lstArea = new List <AreaMaster>(); using (con = DBconnection.ConnectToDB()) { objcmd = new SqlCommand(); objcmd.Connection = con; objcmd.CommandType = CommandType.StoredProcedure; objcmd.CommandText = "STP_SelectAreaMaster"; objcmd.Parameters.Add(new SqlParameter("@PageNumber", objQuery.PageNumber)); objcmd.Parameters.Add(new SqlParameter("@PageSize", objQuery.PageSize)); objcmd.Parameters.Add(new SqlParameter("@Filter", objQuery.Filter)); objcmd.Parameters.Add(new SqlParameter("@Sort", objQuery.Sort)); objcmd.Parameters.Add(new SqlParameter("@TotalRecords", SqlDbType.Int)).Direction = ParameterDirection.Output; reader = objcmd.ExecuteReader(); if (reader != null && reader.HasRows) { while (reader.Read()) { objArea = new AreaMaster(); objArea.AreaID = Convert.ToInt64(reader["AreaID"]); objArea.CityID = Convert.ToInt32(reader["CityID"]); objArea.StateID = Convert.ToInt32(reader["StateID"]); objArea.AreaName = Convert.ToString("" + reader["AreaName"]); objArea.CountryID = Convert.ToInt32(reader["CountryID"]); objArea.Status = Convert.ToInt32("" + reader["Status"]); objArea.Remarks = Convert.ToString("" + reader["Remarks"]); objArea.strStatus = Convert.ToString("" + reader["strStatus"]); lstArea.Add(objArea); } } } objQuery.TotalRecords = Convert.ToInt32(objcmd.Parameters["@TotalRecords"].Value); } catch (Exception ex) { throw ex; } finally { reader.Dispose(); objcmd = null; con = null; } return(lstArea); }
public List <CodeDetail> GetCodeDetail(QueryBO objQuery) { try { lstObject = new List <CodeDetail>(); using (con = DBconnection.ConnectToDB()) { objcmd = new SqlCommand(); objcmd.Connection = con; objcmd.CommandType = CommandType.StoredProcedure; objcmd.CommandText = "STP_SelectCodeDetail"; objcmd.Parameters.Add(new SqlParameter("@PageNumber", objQuery.PageNumber)); objcmd.Parameters.Add(new SqlParameter("@PageSize", objQuery.PageSize)); objcmd.Parameters.Add(new SqlParameter("@Filter", objQuery.Filter)); objcmd.Parameters.Add(new SqlParameter("@Sort", objQuery.Sort)); objcmd.Parameters.Add(new SqlParameter("@TotalRecords", SqlDbType.Int)).Direction = ParameterDirection.Output; reader = objcmd.ExecuteReader(); if (reader != null && reader.HasRows) { while (reader.Read()) { obj = new CodeDetail(); obj.CodeDetailId = Convert.ToInt64("0" + reader["CodeDetailId"]); obj.CodeTypeId = Convert.ToInt32("0" + reader["CodeTypeId"]); obj.DetailLongDesc = Convert.ToString("" + reader["DetailLongDesc"]); obj.DetailShortDesc = Convert.ToString("" + reader["DetailShortDesc"]); obj.ParentId = Convert.ToInt64("0" + reader["ParentId"]); obj.Status = Convert.ToBoolean(reader["Status"]); lstObject.Add(obj); } } } objQuery.TotalRecords = Convert.ToInt32(objcmd.Parameters["@TotalRecords"].Value); } catch (Exception ex) { throw ex; } finally { reader.Dispose(); objcmd = null; con = null; } return(lstObject); }
public static string Pager(QueryBO objQuery, PagingRoute pagingRoute) { StringBuilder sbPager = null; try { sbPager = new StringBuilder(); int numberOfPages = (int)(objQuery.TotalRecords / objQuery.PageSize); sbPager.Append("<ul class='pagination'>"); //sbPager.Append(""); //sbPager.Append(""); //sbPager.Append(""); double dblPageCount = (double)((decimal)objQuery.TotalRecords / objQuery.PageSize); int pageCount = (int)Math.Ceiling(dblPageCount); //List<ListItem> pages = new List<ListItem>(); if (pageCount > 0) { sbPager.Append("<li class='paginate_button previous " + (objQuery.PageNumber == 1 ? "disabled" : "") + "'><a href='@Html.Raw(" + GeneratePagingRoute(pagingRoute, "1") + ")'>Previous</a></li>"); //pages.Add(new ListItem("First", "1", currentPage > 1)); for (int i = 1; i <= pageCount; i++) { sbPager.Append("<li class='paginate_button " + (objQuery.PageNumber == i ? "disabled" : "") + "'><a href='" + GeneratePagingRoute(pagingRoute, i.ToString()) + "'>" + i.ToString() + "</a></li>"); //pages.Add(new ListItem(i.ToString(), i.ToString(), i != currentPage)); } sbPager.Append("<li class='paginate_button next " + (objQuery.PageNumber == pageCount ? "disabled" : "") + "'><a href='" + GeneratePagingRoute(pagingRoute, pageCount.ToString()) + "'>Last</a></li>"); } sbPager.Append("</ul>"); sbPager.Append("<script type='text/javascript;> $(document).ready(function(){ $('.pagination a').click(alert()); }); </script>"); } catch (Exception ex) { throw; } finally { } return(sbPager.ToString()); }
public List <User> Get(QueryBO objQuery) { SqlDataReader reader = null; SqlConnection con = null; List <User> lstUsers = null; SqlCommand objcmd = null; User objUser = null; try { lstUsers = new List <User>(); using (con = DBconnection.ConnectToDB()) { objcmd = new SqlCommand(); objcmd.Connection = con; objcmd.CommandType = CommandType.StoredProcedure; objcmd.CommandText = "STP_SelectUserMaster"; objcmd.Parameters.Add(new SqlParameter("@PageNumber", objQuery.PageNumber)); objcmd.Parameters.Add(new SqlParameter("@PageSize", objQuery.PageSize)); objcmd.Parameters.Add(new SqlParameter("@Filter", objQuery.Filter)); objcmd.Parameters.Add(new SqlParameter("@Sort", objQuery.Sort)); objcmd.Parameters.Add(new SqlParameter("@TotalRecords", SqlDbType.Int)).Direction = ParameterDirection.Output; reader = objcmd.ExecuteReader(); if (reader != null && reader.HasRows) { while (reader.Read()) { objUser = new User(); objUser.UserId = Convert.ToInt64(reader["UserId"]); objUser.FirstName = Convert.ToString("" + reader["FirstName"]); objUser.LastName = Convert.ToString("" + reader["LastName"]); objUser.FullName = Convert.ToString("" + reader["FullName"]); objUser.Mobile = Convert.ToString("" + reader["Mobile"]); objUser.Email = Convert.ToString("" + reader["Email"]); objUser.Password = Convert.ToString("" + reader["Password"]); objUser.WorkingSince = reader["WorkingSince"] == DBNull.Value ? (DateTime?)null : (DateTime)reader["WorkingSince"]; objUser.WorkingSinceWithUs = reader["WorkingSinceWithUs"] == DBNull.Value ? (DateTime?)null : (DateTime)reader["WorkingSinceWithUs"]; //Convert.ToDateTime(reader["WorkingSince"]); //objUser.WorkingSinceWithUs = Convert.ToDateTime(reader["WorkingSinceWithUs"]); objUser.Status = Convert.ToInt32("0" + reader["Status"]); if (!string.IsNullOrEmpty(Convert.ToString(reader["IsActiveOnSite"]))) { objUser.IsActiveOnSite = Convert.ToBoolean(reader["IsActiveOnSite"]); } objUser.UserType = Convert.ToInt16("0" + reader["UserType"]); objUser.strStatus = Convert.ToString("" + reader["strStatus"]); objUser.strUserType = Convert.ToString("" + reader["strUserType"]); objUser.ImageUrl = Convert.ToString("" + reader["ImageUrl"]); objUser.CompanyId = Convert.ToInt64("0" + reader["CompanyId"]); lstUsers.Add(objUser); } } } objQuery.TotalRecords = Convert.ToInt32(objcmd.Parameters["@TotalRecords"].Value); } catch (Exception ex) { throw ex; } finally { reader.Dispose(); objcmd = null; con = null; } return(lstUsers); }