public int AddMarketTargets(MarketTarget marketTargets)
{
try
{
List<SqlParameter> spParams = new List<SqlParameter>();
spParams.Add(Param.CreateParam("MARKETID", SqlDbType.VarChar, marketTargets.marketId));
spParams.Add(Param.CreateParam("COMPANYID", SqlDbType.Int, marketTargets.companyId));
spParams.Add(Param.CreateParam("UPDATEDBY", SqlDbType.VarChar, Security.GetCurrentUserId));
spParams.Add(Param.CreateParam("DIRECTBUCKET1", SqlDbType.Int, marketTargets.directBucket1));
spParams.Add(Param.CreateParam("DIRECTBUCKET2", SqlDbType.Int, marketTargets.directBucket2));
spParams.Add(Param.CreateParam("DIRECTBUCKET3", SqlDbType.Int, marketTargets.directBucket3));
spParams.Add(Param.CreateParam("DIRECTBUCKET4", SqlDbType.Int, marketTargets.directBucket4));
spParams.Add(Param.CreateParam("DIRECTBUCKET5", SqlDbType.Int, marketTargets.directBucket5));
spParams.Add(Param.CreateParam("DIRECTBUCKET6", SqlDbType.Int, marketTargets.directBucket6));
spParams.Add(Param.CreateParam("AGENCYBUCKET1", SqlDbType.Int, marketTargets.agencyBucket1));
spParams.Add(Param.CreateParam("AGENCYBUCKET2", SqlDbType.Int, marketTargets.agencyBucket2));
spParams.Add(Param.CreateParam("AGENCYBUCKET3", SqlDbType.Int, marketTargets.agencyBucket3));
spParams.Add(Param.CreateParam("AGENCYBUCKET4", SqlDbType.Int, marketTargets.agencyBucket4));
spParams.Add(Param.CreateParam("AGENCYBUCKET5", SqlDbType.Int, marketTargets.agencyBucket5));
spParams.Add(Param.CreateParam("AGENCYBUCKET6", SqlDbType.Int, marketTargets.agencyBucket6));
using (IO io = new IO(WebCommon.KPIConnectionString))
{
marketTargets.targetId = Convert.ToInt32(io.ExecuteScalarQuery(IO.CreateCommandFromStoredProc("KPI_ADDMARKETTARGETS", spParams)));
}
return marketTargets.targetId;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to add the targets for the Market.");
}
}
public void UpdateMarketTargets(MarketTarget marketTargets)
{
try
{
List<SqlParameter> spParams = new List<SqlParameter>();
spParams.Add(Param.CreateParam("TARGETID", SqlDbType.Int, marketTargets.targetId));
spParams.Add(Param.CreateParam("UPDATEDBY", SqlDbType.VarChar, Security.GetCurrentUserId));
spParams.Add(Param.CreateParam("DIRECTBUCKET1", SqlDbType.Int, marketTargets.directBucket1));
spParams.Add(Param.CreateParam("DIRECTBUCKET2", SqlDbType.Int, marketTargets.directBucket2));
spParams.Add(Param.CreateParam("DIRECTBUCKET3", SqlDbType.Int, marketTargets.directBucket3));
spParams.Add(Param.CreateParam("DIRECTBUCKET4", SqlDbType.Int, marketTargets.directBucket4));
spParams.Add(Param.CreateParam("DIRECTBUCKET5", SqlDbType.Int, marketTargets.directBucket5));
spParams.Add(Param.CreateParam("DIRECTBUCKET6", SqlDbType.Int, marketTargets.directBucket6));
spParams.Add(Param.CreateParam("AGENCYBUCKET1", SqlDbType.Int, marketTargets.agencyBucket1));
spParams.Add(Param.CreateParam("AGENCYBUCKET2", SqlDbType.Int, marketTargets.agencyBucket2));
spParams.Add(Param.CreateParam("AGENCYBUCKET3", SqlDbType.Int, marketTargets.agencyBucket3));
spParams.Add(Param.CreateParam("AGENCYBUCKET4", SqlDbType.Int, marketTargets.agencyBucket4));
spParams.Add(Param.CreateParam("AGENCYBUCKET5", SqlDbType.Int, marketTargets.agencyBucket5));
spParams.Add(Param.CreateParam("AGENCYBUCKET6", SqlDbType.Int, marketTargets.agencyBucket6));
using (IO io = new IO(WebCommon.KPIConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("KPI_UPDATEMARKETTARGETS", spParams));
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to update the targets for the Market.");
}
}
public MarketTarget GetMarketTargets(string marketId, int companyId)
{
try
{
DataSet marketTargetData;
using (IO io = new IO(WebCommon.KPIConnectionString))
{
marketTargetData = io.ExecuteDataSetQuery(IO.CreateCommandFromStoredProc("KPI_GETMARKETTARGETS",
Param.CreateParam("MARKETID", SqlDbType.VarChar, marketId),
Param.CreateParam("COMPANYID", SqlDbType.Int, companyId)));
}
if (marketTargetData.Tables.Count == 0 || marketTargetData.Tables[0].Rows.Count == 0)
{
return null;
}
MarketTarget marketTargets = new MarketTarget();
marketTargets.targetId = Convert.ToInt32(marketTargetData.Tables[0].Rows[0]["TARGET_ID"]);
marketTargets.marketId = marketId;
marketTargets.directBucket1 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "DIRECT_BUCKET_1", 0));
marketTargets.directBucket2 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "DIRECT_BUCKET_2", 0));
marketTargets.directBucket3 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "DIRECT_BUCKET_3", 0));
marketTargets.directBucket4 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "DIRECT_BUCKET_4", 0));
marketTargets.directBucket5 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "DIRECT_BUCKET_5", 0));
marketTargets.directBucket5 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "DIRECT_BUCKET_6", 0));
marketTargets.agencyBucket1 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "AGENCY_BUCKET_1", 0));
marketTargets.agencyBucket2 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "AGENCY_BUCKET_2", 0));
marketTargets.agencyBucket3 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "AGENCY_BUCKET_3", 0));
marketTargets.agencyBucket4 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "AGENCY_BUCKET_4", 0));
marketTargets.agencyBucket5 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "AGENCY_BUCKET_5", 0));
marketTargets.agencyBucket5 = Convert.ToInt32(IO.GetDataRowValue(marketTargetData.Tables[0].Rows[0], "AGENCY_BUCKET_6", 0));
marketTargets.updatedBy = Convert.ToString(marketTargetData.Tables[0].Rows[0]["UPDATED_BY"]);
marketTargets.companyId = Convert.ToInt32(marketTargetData.Tables[0].Rows[0]["COMPANY_ID"]);
return marketTargets;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to retrieve the targets for the Market.");
}
}
public MarketTargetReport(string marketId, DateTime reportDate, MarketTarget marketTargetData, List<MarketTargetReportItem> marketTargetReportData)
{
this.marketId = marketId;
this.reportDate = reportDate;
this.marketTargetData = marketTargetData;
this.marketTargetReportData = marketTargetReportData;
}
