예제 #1
0
        protected void btnAddPlan_Click(object sender, EventArgs e)
        {
            var plan = new Plan
            {
                PlanName      = txtPlanName.Text,
                PlanFixedCost = Decimal.Parse(txtPlanFixedCost.Text),
                PlanVarCost   = Decimal.Parse(txtPlanVarCost.Text)
            };

            var repo = new PlanRepo();

            try
            {
                int returnVal = repo.Add(plan);
                panelDisplayPlans.Visible = true;
                gridViewPlans.Visible     = true;
                //Wizard1.Visible = false;
                //lblPlanInstructions.Visible = false;
                panelAddPlan.Visible = false;
                lblShowPlans.Text    = "Plan successfully added. Here is the updated list:";
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        // The return type can be changed to IEnumerable, however to support
        // paging and sorting, the following parameters must be added:
        //     int maximumRows
        //     int startRowIndex
        //     out int totalRowCount
        //     string sortByExpression
        public IEnumerable <CustomersAndPlans> GridViewCustomersAndPlans_GetData()
        {
            List <CustomersAndPlans> customerPlans = new List <CustomersAndPlans>();

            var customers = new CustomerRepo().GetAll();

            foreach (var c in customers)
            {
                var planInfo = new PlanRepo().GetOne(c.PlanID);
                customerPlans.Add(new CustomersAndPlans
                {
                    CustID        = c.CustID,
                    CustName      = c.CustName,
                    CustEmail     = c.CustEmail,
                    PlanName      = planInfo.PlanName,
                    PlanFixedCost = planInfo.PlanFixedCost,
                    PlanVarCost   = planInfo.PlanVarCost
                });
            }

            return(customerPlans);
        }
예제 #3
0
        protected void btnAddCustomer_Click(object sender, EventArgs e)
        {
            var selectedPlan = new PlanRepo().GetAll().Where(x => x.PlanName == cboPlan.SelectedValue).FirstOrDefault();
            //var plan = new PlanRepo().ExecuteQuery($"select planID from plan where planname = {cboPlan.SelectedValue};");


            var customer = new Customer
            {
                CustName  = txtCustomerName.Text,
                CustEmail = txtCustomerEmail.Text,
                PlanID    = selectedPlan.PlanID
            };

            var repo = new CustomerRepo();

            int returnVal = repo.Add(customer);

            panelDisplayCustomers.Visible = true;
            gridViewCustomers.Visible     = true;
            panelAddCustomer.Visible      = false;
            lblShowCustomers.Text         = "Customer successfully added. Here is the updated list:";
        }
예제 #4
0
 public PlanController(PlanRepo planRepo)
 {
     _PlanRepo = planRepo;
 }