public void GetUpgradeForStandardInclusion(string productid, string pbrandids)
{
DateTime dateValue = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
client = new SQSAdminServiceClient();
client.Endpoint.Address = new System.ServiceModel.EndpointAddress(CommonVariables.WcfEndpoint);
DataSet ds = client.SQSAdmin_StandardInclusion_GetUpgradeOptionByStandardInclusion(productid, pbrandids);
client.Close();
UpgradeOptionProducts.Clear();
PromotionProducts.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
GenericProduct p = new GenericProduct();
p.BrandID = int.Parse(dr["brandid"].ToString());
p.BrandName = dr["brandname"].ToString();
p.ProductID = dr["productid"].ToString();
p.ProductName = dr["productname"].ToString();
p.ProductDescription = dr["productdescription"].ToString();
p.validationruleID = int.Parse(dr["idStudioM_Inclusionvalidationrule"].ToString());
p.Promotion = bool.Parse(dr["Promotion"].ToString());
DateTime.TryParse(dr["EffectiveDate"].ToString(), out dateValue);
if (dateValue != (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue)
{
p.EffectiveDate = dateValue.AddHours(3);
}
p.Active = bool.Parse(dr["active"].ToString());
if (p.Promotion)
{
PromotionProducts.Add(p);
}
else if (p.Active)
{
// upgrade products show only the active items
UpgradeOptionProducts.Add(p);
}
}
}
public void GetStandardInclusion(string productid, string productname, int pstateid, string brandids)
{
client = new SQSAdminServiceClient();
client.Endpoint.Address = new System.ServiceModel.EndpointAddress(CommonVariables.WcfEndpoint);
DataSet ds = client.SQSAdmin_StandardInclusion_GetStandardInclusionProducts(productid, productname, pstateid, brandids);
client.Close();
StandarInclusionProducts.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
GenericProduct p = new GenericProduct();
p.BrandID = int.Parse(dr["BrandID"].ToString());
p.BrandName = dr["BrandName"].ToString();
p.ProductID = dr["productid"].ToString();
p.ProductName = dr["productname"].ToString();
p.ProductDescription = dr["productdescription"].ToString();
p.validationruleID = 0;
StandarInclusionProducts.Add(p);
}
UpgradeOptionProducts.Clear();
PromotionProducts.Clear();
}