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