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);
}
