public IHttpActionResult InsertDateProductReport(DateProductReportModel model)
{
//campaign.AgentID = "4";
DataTable dt = _campaignService.InsertDateProductReport(model);
if (dt.TableName == "Error")
{
return(ResponseMessage(Request.CreateErrorResponse((HttpStatusCode)500, new HttpError("Something went wrong"))));
}
return(Ok(dt));
}
public DataTable InsertDateProductReport(DateProductReportModel model)
{
DataTable dt = new DataTable();
List <sqlTbl> sqlParasList = new List <sqlTbl>();
sqlParasList.Add(new sqlTbl("@P_DateImpressions", model.DateImpressions));
sqlParasList.Add(new sqlTbl("@P_OccupiedImpressions", model.OccupiedImpressions));
sqlParasList.Add(new sqlTbl("@P_CampaignID", model.CampaignID));
sqlParasList.Add(new sqlTbl("@P_ProductID", model.ProductID));
sqlParasList.Add(new sqlTbl("@P_UserInsert", model.UserInsert));//.ToString("yyyy-MM-dd")));
sqlParasList.Add(new sqlTbl("@P_DateInsert", model.DateInsert));
sqlParasList.Add(new sqlTbl("@P_UserUpdate", model.UserUpdate));
sqlParasList.Add(new sqlTbl("@P_DateUpdate", model.DateUpdate));
sqlParasList.Add(new sqlTbl("@P_CapacityPerDay", model.CapacityPerDay));
dt = dbConnectionHelper.procedureRequest("InsertNewDateProductReport", sqlParasList, "iqmarket");
if (dbConnectionHelper.getError() != "")
{
//ErrorModel error = new ErrorModel();
//error.controlerName = "UserController";
//error.ProcedureName = "GetUserInfoByEmail";
//error.metodName = methodName;
//error.formName = formName;
//error.date = DateTime.Now;
//error.ErrorMessage = dbConnectionHelper.getError();
//error.username = userName;
//foreach (sqlTbl el in sqlParasList)
// error.parametarList += el.name + ": " + el.value + ";";
//errorHandler.errorLogInsert(error);
dt.TableName = "Error";
return(dt);
}
else
{
dt.TableName = "Table";
return(dt);
}
}
