public DataTable GetDataTable(string psSql)
{
DataTable dt = new DataTable();
try {
using (SCT db = new SCT())
{
string conStr = db.Database.Connection.ConnectionString;
using (SqlConnection conn = new SqlConnection(conStr))
{
SqlCommand cmd = new SqlCommand(psSql, conn);
using (SqlDataAdapter ad = new SqlDataAdapter(cmd))
{
ad.SelectCommand.CommandType = CommandType.Text;
ad.Fill(dt);
}
}
}
}
catch (Exception e) {
LogError(e.ToString(), "OrderImportClasses.DataHelper.GetDataTable()");
}
return(dt);
}
public void LogError(string psMessage, string psModule)
{
ShippingRequestError E = new ShippingRequestError();// new ShippingRequestError();
E.DateCreated = System.DateTime.Now;
E.Module = psModule;
E.ErrorDetail = psMessage;
using (SCT db = new SCT())
{
db.ShippingRequestErrors.Add(E);
db.SaveChanges();
}
}
private string GetConfigProperty(string psProperty)
{
string lsResult = "";
try {
using (DataModel.SCT db = new DataModel.SCT())
{
SiteConfig sc = db.SiteConfigs.First(s => s.ConfigItem == psProperty);
if (sc != null)
{
lsResult = Util.GetString(sc.ConfigValue);
}
}
}
catch (Exception ex)
{
Log.LogError(ex.ToString(), "ProcessOrders.GetConfigProperty");
}
return(lsResult);
}