public static IEnumerable <vwCampaign> Select()
{
ANWO.Data data = new ANWO.Data();
SessionStateBag session = new SessionStateBag();
int profID = session.Profile.ID;
return(data.NWODC.vwCampaigns.Where(a => a.ProfileID == profID));
}
public static IEnumerable <tblAlert> Select()
{
ANWO.Data data = new ANWO.Data();
SessionStateBag session = new SessionStateBag();
int profID = session.Profile.ID;
return(data.NWODC.tblAlerts.Where(a => a.ProfileID == profID).OrderByDescending(a => a.DateCreated));
}
public static List <tblPlan> GetPlansAfterFilter(PlanType expectedPlans)
{
List <tblPlan> listToReturn = new List <tblPlan>();
ANWO.Data data = new ANWO.Data();
if (expectedPlans == PlanType.Regular)
{
listToReturn = data.NWODC.tblPlans.Where(a => a.PlanTypeID == 2).ToList();
}
else if (expectedPlans == PlanType.Promotional)
{
listToReturn = data.NWODC.tblPlans.Where(a => a.PlanTypeID == 1).ToList();
}
return(listToReturn);
}
public PlanType GetConsumedDiscountedPlanTypes()
{
PlanType planType = PlanType.Undefined;
var campaigns = this.tblCampaigns;
ANWO.Data data = new ANWO.Data();
bool promotionApplied = false;
if (campaigns != null && campaigns.Count() > 0)
{
foreach (var item in campaigns)
{
var invoices = item.tblInvoices.Where(a => a.PaymentStatus == "Completed");
if (invoices != null && invoices.Count() > 0)
{
foreach (var invoice in invoices)
{
if (invoice.tblPlan.PlanTypeID == 1)
{
promotionApplied = true;
break;
}
}
}
}
}
if (promotionApplied)
{
planType = PlanType.Regular;
}
else
{
planType = PlanType.Promotional;
}
return(planType);
}
public static void Delete(int ID)
{
ANWO.Data data = new ANWO.Data();
data.NWODC.tblAlerts.DeleteOnSubmit(data.NWODC.tblAlerts.Where(a => a.ID == ID).SingleOrDefault());
data.NWODC.SubmitChanges();
}
