public List <Area> GetAllArea(AreaAdvanceSearch areaAdvanceSearch)
{
List <Area> areaList = null;
try
{
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[PSA].[GetAllArea]";
cmd.Parameters.Add("@SearchValue", SqlDbType.NVarChar, -1).Value = string.IsNullOrEmpty(areaAdvanceSearch.SearchTerm) ? "" : areaAdvanceSearch.SearchTerm;
cmd.Parameters.Add("@RowStart", SqlDbType.Int).Value = areaAdvanceSearch.DataTablePaging.Start;
if (areaAdvanceSearch.DataTablePaging.Length == -1)
{
cmd.Parameters.AddWithValue("@Length", DBNull.Value);
}
else
{
cmd.Parameters.Add("@Length", SqlDbType.Int).Value = areaAdvanceSearch.DataTablePaging.Length;
}
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
areaList = new List <Area>();
while (sdr.Read())
{
Area area = new Area();
{
area.Code = (sdr["Code"].ToString() != "" ? int.Parse(sdr["Code"].ToString()) : area.Code);
area.Country = new Country();
area.Country.Description = (sdr["Country"].ToString() != "" ? sdr["Country"].ToString() : area.Country.Description);
area.State = new State();
area.State.Description = (sdr["State"].ToString() != "" ? (sdr["State"].ToString()) : area.State.Description);
area.District = new District();
area.District.Description = (sdr["District"].ToString() != "" ? (sdr["District"].ToString()) : area.District.Description);
area.Description = (sdr["Description"].ToString() != "" ? sdr["Description"].ToString() : area.Description);
area.PSASysCommon = new PSASysCommon();
area.PSASysCommon.CreatedDateString = (sdr["CreatedDate"].ToString() != "" ? DateTime.Parse(sdr["CreatedDate"].ToString()).ToString(settings.DateFormat) : area.PSASysCommon.CreatedDateString);
area.TotalCount = (sdr["TotalCount"].ToString() != "" ? int.Parse(sdr["TotalCount"].ToString()) : area.TotalCount);
area.FilteredCount = (sdr["FilteredCount"].ToString() != "" ? int.Parse(sdr["FilteredCount"].ToString()) : area.FilteredCount);
}
areaList.Add(area);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(areaList);
}
public List <Area> GetAllArea(AreaAdvanceSearch areaAdvanceSearch)
{
return(_areaRepository.GetAllArea(areaAdvanceSearch));
}
