public static DataTable ExecuteReader(BusinessModel mdl)
{
DataTable dt = new DataTable();
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["PPFConnectionString"].ToString()))
{
cn.Open();
SqlCommand cm = new SqlCommand(mdl.StoredProcedureName.ToString(), cn);
cm.CommandType = CommandType.StoredProcedure;
SqlCommandBuilder.DeriveParameters(cm);
foreach (SqlParameter p in cm.Parameters)
{
if (p.Direction == ParameterDirection.Input || p.Direction == ParameterDirection.InputOutput)
{
foreach (PropertyInfo pi in mdl.GetType().GetProperties())
{
if (p.ParameterName.ToLower().Replace("@", "") == pi.Name.ToLower())
{
p.Value = FormatObject(p, pi.GetValue(mdl, null));
break;
}
}
}
}
if (ConfigurationManager.AppSettings["OutputSqlCommandParameter"] == "1")
{
Utility.OutputWindow.Write.SQLParameter(cm);
}
dt.Load(cm.ExecuteReader());
}
return dt;
}
public IActionResult PostCreateNewBusiness(BusinessModel businessModel)
{
if (CheckModelState(businessModel))
{
return(View("CreateNewBusiness"));
}
_logger.Log(LogLevel.Information, businessModel.GetType().ToString());
_logger.Log(LogLevel.Information, $"PostCreateNewBusiness {businessModel}");
return(RedirectToAction("FillStaff", businessModel));
}
