/// <summary>
/// error map entity get by DB returns
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static ErrorMapConfigTbl ErrorMapTblGet(SqlDataReader reader)
{
ErrorMapConfigTbl tbl = new ErrorMapConfigTbl();
tbl.messageType = reader["MessageType"].ToString();
tbl.errorCode = reader["ErrorCode"].ToString();
tbl.textRegex = reader["TextRegEx"].ToString();
tbl.errorNode = reader["ErrorNode"].ToString();
tbl.message = reader["Message"].ToString();
tbl.interruptProcessing = reader["InterruptProcessingBool"].ToString();
tbl.logError = reader["LogErrorBool"].ToString();
tbl.CreateDate = Convert.ToDateTime(reader["CreateDate"].ToString());
tbl.CreatedBy = reader["CreatedBy"].ToString();
tbl.UpdateDate = CarSCSCommonHelper.ColumnNameCheck <DateTime>(reader, "UpdateDate", DateTime.MinValue);
tbl.updatedBy = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "LastUPdatedBy", null);
tbl.errorMapID = Convert.ToInt32(reader["ErrorMapID"].ToString());
return(tbl);
}
/// <summary>
/// get ConfigurationSettingDataTbl entity list by query
/// </summary>
/// <param name="query"></param>
/// <param name="connectionString"></param>
/// <param name="configIDColName"></param>
/// <param name="defaultNullValue"></param>
/// <returns></returns>
public static List <ConfigurationSettingDataTbl> CSDTblsGet(string query, string connectionString
, string configIDColName = "PoSConfigurationID", string defaultNullValue = null)
{
List <ConfigurationSettingDataTbl> tbls = new List <ConfigurationSettingDataTbl>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = query;
cmd.CommandTimeout = 0;
SqlDataReader reader = cmd.ExecuteReader();
ConfigurationSettingDataTbl tbl;
while (reader.Read())
{
tbl = new ConfigurationSettingDataTbl();
tbl.environment = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "environmentName", defaultNullValue);
tbl.settingName = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "settingName", defaultNullValue);
tbl.value = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "SettingValue", defaultNullValue);
tbl.jurisdictionCode = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "jurisdictionCode", defaultNullValue);
tbl.companyCode = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "companyCode", defaultNullValue);
tbl.managementUnitCode = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "managementUnitCode", defaultNullValue);
tbl.supplierID = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "supplierID", defaultNullValue);
tbl.clientID = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "clientID", defaultNullValue);
tbl.CreateDate = CarSCSCommonHelper.ColumnNameCheck <DateTime>(reader, "CreateDate", DateTime.MinValue);
tbl.CreatedBy = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "CreatedBy", defaultNullValue);
tbl.UpdateDate = CarSCSCommonHelper.ColumnNameCheck <DateTime>(reader, "UpdateDate", DateTime.MinValue);
tbl.LastUpdatedBy = CarSCSCommonHelper.ColumnNameCheck <string>(reader, "LastUpdatedBy", defaultNullValue);
tbl.ConfigurationID = CarSCSCommonHelper.ColumnNameCheck <int>(reader, configIDColName, 0);
tbl.AuditActionID = CarSCSCommonHelper.ColumnNameCheck <int>(reader, "AuditActionID", 0);
tbls.Add(tbl);
}
conn.Close();
}
return(tbls);
}
