public DataTable SelectChargeDetails()
{
DALComponent dalComponent = new DALComponent();
dalComponent.SqlCommandText = "[SelectChargeDetails]";
return(dalComponent.SelectRecord());
}
public DataTable SelectCategoryGroup()
{
DALComponent dalComponent = new DALComponent();
dalComponent.SqlCommandText = "SelectCategoryGroup";
return(dalComponent.SelectRecord());
}
public DataTable SelectCity()
{
DALComponent dalCom = new DALComponent();
dalCom.SqlCommandText = "SelectCity";
return(dalCom.SelectRecord());
}
public DataTable SelectMaxID()
{
DALComponent dalComponent = new DALComponent();
dalComponent.SqlCommandText = "SelectMaxID";
return(dalComponent.SelectRecord());
}
public DataTable SelectUserAds(int userId)
{
dalComponent = new DALComponent();
dalComponent.SetParameters("@userId", SqlDbType.Int, 4, userId);
dalComponent.SqlCommandText = "[SelectUserAds]";
return(dalComponent.SelectRecord());
}
public DataTable SelectReportsByCity(string cityname)
{
dalComponent = new DALComponent();
dalComponent.SetParameters("@cityname", SqlDbType.VarChar, 50, cityname);
dalComponent.SqlCommandText = "[SelectReportsByCity]";
return(dalComponent.SelectRecord());
}
public DataTable SelectChargeDetailsByID(int chargeId)
{
DALComponent dalComponent = new DALComponent();
dalComponent.SetParameters("@chargeId", SqlDbType.Int, 4, chargeId);
dalComponent.SqlCommandText = "[SelectChargeDetailsByID]";
return(dalComponent.SelectRecord());
}
public DataTable SelectCityById(int cityid)
{
DALComponent dalCom = new DALComponent();
dalCom.SetParameters("@cityid", SqlDbType.Int, 4, cityid);
dalCom.SqlCommandText = "[SelectCityById]";
return(dalCom.SelectRecord());
}
public DataTable SelectCityByName(string cityname)
{
DALComponent dalCom = new DALComponent();
dalCom.SetParameters("@cityname", SqlDbType.VarChar, 50, cityname);
dalCom.SqlCommandText = "[SelectCityByName]";
return(dalCom.SelectRecord());
}
public DataTable GetAdDetails(int adpostId, int userId)
{
dalComponent = new DALComponent();
dalComponent.SetParameters("@adpostId", SqlDbType.Int, 4, adpostId);
dalComponent.SetParameters("@userId", SqlDbType.Int, 4, userId);
dalComponent.SqlCommandText = "[GetAdDetails]";
return(dalComponent.SelectRecord());
}
public DataTable SelectReportsByDate(DateTime FromDate, DateTime ToDate)
{
dalComponent = new DALComponent();
dalComponent.SetParameters("@fromdate", SqlDbType.SmallDateTime, 4, FromDate);
dalComponent.SetParameters("@todate", SqlDbType.SmallDateTime, 4, ToDate);
dalComponent.SqlCommandText = "[SelectReportsByDate]";
return(dalComponent.SelectRecord());
}
public DataTable SearchUsers(string Keyword)
{
try
{
dalComponent = new DALComponent();
dalComponent.SetParameters("@Keyword", SqlDbType.VarChar, 200, Keyword);
dalComponent.SqlCommandText = "SearchUsers";
return(dalComponent.SelectRecord());
}
catch (Exception ex)
{
throw;
}
}
public DataTable AvailableCategoryGroup(string groupName)
{
try
{
DALComponent dalComponent = new DALComponent();
dalComponent.SetParameters("@groupname", SqlDbType.VarChar, 50, groupName);
dalComponent.SqlCommandText = "[AvailableCategoryGroup]";
return(dalComponent.SelectRecord());
}
catch (Exception ex)
{
throw;
}
}
public DataTable GetUserName(int userId)
{
dalComponent.SetParameters("@UserId", SqlDbType.Int, 4, userId);
dalComponent.SqlCommandText = "UserNameGet";
return(dalComponent.SelectRecord());
}
public DataTable GetAllAdDetails()
{
dalComponent = new DALComponent();
dalComponent.SqlCommandText = "[GetAllAdDetails]";
return(dalComponent.SelectRecord());
}