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); } }