public List <SysSetting> GetAllSysSetting(SysSettingAdvanceSearch sysSettingAdvanceSearch)
{
List <SysSetting> sysSettingList = 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].[GetAllSysSetting]";
cmd.Parameters.Add("@SearchValue", SqlDbType.NVarChar, -1).Value = string.IsNullOrEmpty(sysSettingAdvanceSearch.SearchTerm) ? "" : sysSettingAdvanceSearch.SearchTerm;
cmd.Parameters.Add("@RowStart", SqlDbType.Int).Value = sysSettingAdvanceSearch.DataTablePaging.Start;
if (sysSettingAdvanceSearch.DataTablePaging.Length == -1)
{
cmd.Parameters.AddWithValue("@Length", DBNull.Value);
}
else
{
cmd.Parameters.Add("@Length", SqlDbType.Int).Value = sysSettingAdvanceSearch.DataTablePaging.Length;
}
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
sysSettingList = new List <SysSetting>();
while (sdr.Read())
{
SysSetting sysSetting = new SysSetting();
{
sysSetting.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : sysSetting.ID);
sysSetting.Name = (sdr["Name"].ToString() != "" ? sdr["Name"].ToString() : sysSetting.Name);
sysSetting.Value = (sdr["Value"].ToString() != "" ? sdr["Value"].ToString() : sysSetting.Value);
sysSetting.TotalCount = (sdr["TotalCount"].ToString() != "" ? int.Parse(sdr["TotalCount"].ToString()) : sysSetting.TotalCount);
sysSetting.FilteredCount = (sdr["FilteredCount"].ToString() != "" ? int.Parse(sdr["FilteredCount"].ToString()) : sysSetting.FilteredCount);
}
sysSettingList.Add(sysSetting);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(sysSettingList);
}
public List <SysSetting> GetAllSysSetting(SysSettingAdvanceSearch sysSettingAdvanceSearch)
{
return(_sysSettingRepository.GetAllSysSetting(sysSettingAdvanceSearch));
}
