/// <summary>
/// Load Promo Lines Test Data
/// </summary>
/// <returns></returns>
private List <Promo_Line> LoadPromoLineTestData()
{
var firstPromoline = new Promo_Line
{
Amount = 12,
Stock_Code = "090939021252",
Dept = "A",
Sub_Dept = "B",
Sub_Detail = "X",
Link = 1,
Quantity = 1
};
var secondPromoline = new Promo_Line
{
Amount = 10,
Stock_Code = "099999000610",
Dept = "C",
Sub_Dept = "D",
Sub_Detail = "Y",
Link = 2,
Quantity = 1
};
var promoLine = new List <Promo_Line>
{
firstPromoline,
secondPromoline
};
return(promoLine);
}
/// <summary>
/// Method to get promo lines
/// </summary>
/// <param name="promoId">Promo id</param>
/// <param name="none"></param>
/// <returns>List of promo lines</returns>
public List <Promo_Line> GetPromoLines(string promoId, string none)
{
var dateStart = DateTime.Now;
_performancelog.Debug($"Start,PromoService,GetPromoLines,{string.Empty},{DateTime.Now:hh.mm.ss.ffffff}");
var promoLines = new List <Promo_Line>();
var rsDetail = GetRecords("SELECT * FROM PromoDetail WHERE PromoID=\'" + promoId + "\' ORDER BY Link, Stock_Code, Dept, Sub_Dept, SubDetail", DataSource.CSCMaster);
foreach (DataRow fields in rsDetail.Rows)
{
var promoLine = new Promo_Line
{
Amount = CommonUtility.GetFloatValue(fields["Amount"]),
Stock_Code = CommonUtility.GetStringValue(fields["Stock_Code"]),
Dept = CommonUtility.GetStringValue(fields["Dept"]),
Sub_Dept = CommonUtility.GetStringValue(fields["Sub_Dept"]),
Sub_Detail = CommonUtility.GetStringValue(fields["SubDetail"]),
Link = CommonUtility.GetByteValue(fields["Link"]),
Quantity = CommonUtility.GetFloatValue(fields["Qty"])
};
if (CommonUtility.GetStringValue(fields["Stock_Code"]) != none)
{
promoLine.Level = 1;
}
else if (CommonUtility.GetStringValue(fields["Dept"]) != none &&
CommonUtility.GetStringValue(fields["Sub_Dept"]) == none &&
CommonUtility.GetStringValue(fields["SubDetail"]) == none)
{
promoLine.Level = 2;
}
else if (CommonUtility.GetStringValue(fields["Dept"]) != none &&
CommonUtility.GetStringValue(fields["Sub_Dept"]) != none &&
CommonUtility.GetStringValue(fields["SubDetail"]) == none)
{
promoLine.Level = 3;
}
else if (CommonUtility.GetStringValue(fields["Dept"]) != none &&
CommonUtility.GetStringValue(fields["Sub_Dept"]) != none &&
CommonUtility.GetStringValue(fields["SubDetail"]) != none)
{
promoLine.Level = 4;
}
promoLines.Add(promoLine);
}
_performancelog.Debug($"End,PromoService,GetPromoLines,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
return(promoLines);
}
