/// <summary>
/// get query script
/// </summary>
/// <param name="config"></param>
/// <param name="configType"></param>
/// <param name="isLogGet"></param>
/// <param name="topCount"></param>
/// <param name="sortdirection"></param>
/// <returns></returns>
public static string TBLQueryGet(ConfigurationSettingDataTbl config
, ConfigSettingType configType
, bool isLogGet
, int topCount = 0
, CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.None)
{
string topStr = string.Empty;
if (topCount > 0)
{
topStr = "top " + topCount;
}
string orderBy = string.Empty;
if (sortdirection == CommonEnum.SortDirection.ASC)
{
orderBy = "order by 1 asc";
}
else if (sortdirection == CommonEnum.SortDirection.DESC)
{
orderBy = "order by 1 desc";
}
string tblName = (isLogGet) ? ConfigSettingHelper.ConfigLogTableNameGet(configType) : ConfigSettingHelper.ConfigTableNameGet(configType);
string where = TBLQueryGetWhere(config, configType);
return(string.Format("select {0} * from {1} {2} {3} ", topStr, tblName, where, orderBy));
}
/// <summary>
/// error map script get
/// </summary>
/// <param name="searchTbl"></param>
/// <param name="isLogGet"></param>
/// <param name="topCount"></param>
/// <param name="sortdirection"></param>
/// <returns></returns>
public static string TBLQueryGet(ErrorMapConfigTbl searchTbl, bool isLogGet = false
, int topCount = 0
, CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.None)
{
string topStr = string.Empty;
if (topCount > 0)
{
topStr = "top " + topCount;
}
string orderBy = string.Empty;
if (sortdirection == CommonEnum.SortDirection.ASC)
{
orderBy = "order by 1 asc";
}
else if (sortdirection == CommonEnum.SortDirection.DESC)
{
orderBy = "order by 1 desc";
}
return(string.Format("select {0} * from {1} where 1=1 {2} {3} {4} {5}"
, topStr
, (isLogGet ? "ErrorMapLog" : "ErrorMap")
, CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.messageType, "and MessageType")
, CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.errorCode, "and errorCode")
, CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.textRegex, "and TextRegEx")
, orderBy));
}
/// <summary>
/// get configutaion entity list
/// </summary>
/// <param name="sConfig"></param>
/// <param name="isLogGet"></param>
/// <param name="topCount"></param>
/// <param name="sortdirection"></param>
/// <param name="defaultNullValue"></param>
/// <returns></returns>
public List <ConfigurationSettingDataTbl> CSDTblsGet(SupplierConfiguration sConfig
, bool isLogGet = false
, int topCount = 0
, CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.None
, string defaultNullValue = null)
{
ConfigurationSettingDataTbl config = ConvertToConfigurationSettingDataTbl(sConfig);
return(CSDTblsGet(config, isLogGet, topCount, sortdirection, defaultNullValue));
}
/// <summary>
/// get error map logs
/// </summary>
/// <param name="messageType"></param>
/// <param name="errorCode"></param>
/// <param name="textRegex"></param>
/// <param name="topCount"></param>
/// <param name="sortdirection"></param>
/// <returns></returns>
public List <ErrorMapConfigLogTbl> ErrorMapConfigLogGet(string messageType = null, string errorCode = null, string textRegex = null
, int topCount = 0
, CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.DESC)
{
ErrorMapConfigTbl searchTbl = TBLEntityGet(messageType, errorCode, textRegex);
string query = TBLQueryGet(searchTbl, true, topCount, sortdirection);
List <ErrorMapConfigLogTbl> logTbl = ErrorMapLogTblGet(query, this.ConnectionString);
return(logTbl);
}
/// <summary>
/// get configutaion entity list
/// </summary>
/// <param name="config"></param>
/// <param name="isLogGet"></param>
/// <param name="topCount"></param>
/// <param name="sortdirection"></param>
/// <param name="defaultNullValue"></param>
/// <returns></returns>
public List <ConfigurationSettingDataTbl> CSDTblsGet(ConfigurationSettingDataTbl config
, bool isLogGet = false
, int topCount = 0
, CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.None
, string defaultNullValue = null)
{
List <ConfigurationSettingDataTbl> tbls = CSDTblsGet(
TBLQueryGet(config, this.ConfigurationType, isLogGet, topCount, sortdirection)
, this.ConnectionString
, ConfigurationIDNameGet(isLogGet)
, defaultNullValue);
return(tbls);
}
