private void SavePlan(tblPlan plan)
{
// Save the plan to the database
try
{
db.Entry(plan).State = System.Data.Entity.EntityState.Added;
intSaveStatus = db.SaveChanges();
}
catch (EntityException ex)
{
MessageBox.Show(ex.Message, "Save", MessageBoxButton.OK, MessageBoxImage.Error);
throw;
}
}
private void PopulateControlsBasedOnPlan()
{
_Plan = _Data.NWODC.tblPlans.Where(a => a.ID == Convert.ToInt32(ddlPaymentOption.SelectedValue)).SingleOrDefault();
if (_Plan != null)
{
if (_Plan.ID != 1)
{
imgbtnBuyNow.Enabled = true;
imgbtnBuyNow.Visible = true;
btnApplyFreeOffer.Enabled = false;
btnApplyFreeOffer.Visible = false;
}
else
{
imgbtnBuyNow.Enabled = false;
imgbtnBuyNow.Visible = false;
btnApplyFreeOffer.Enabled = true;
btnApplyFreeOffer.Visible = true;
}
lblTotal.Text = string.Format("{0:C}", _Plan.TotalAmount);
lblMonths.Text = _Plan.Units.ToString();
if (_Campaign.ExpiryDate == null)
{
lblEstimatedExpirationDate.Text = string.Format("{0:ddd, MMM d, yyyy}", DateTime.Now.AddMonths(_Plan.Units));
}
else
{
lblEstimatedExpirationDate.Text = string.Format("{0:ddd, MMM d, yyyy}", ((DateTime)_Campaign.ExpiryDate).AddMonths(_Plan.Units));
}
}
else
{
imgbtnBuyNow.Enabled = false;
ThrowError(this, new ControlErrorArgs()
{
InnerException = new Exception("Validation of Plan for ProfileID" +
ddlPaymentOption.SelectedValue + ", " + _Profile.ID + " has been provided by user. Request came from user: "******" from IP: " +
Request.UserHostAddress),
Message = "Invalid Profile.",
Severity = 1
});
}
}
private void lstPlans_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
// Populate the controls with the new data when we select a different plan from the list.
dbOp = dbOperation.Edit;
stkAddEdit.Visibility = Visibility.Visible;
stkPlanButtons.Visibility = Visibility.Hidden;
selectedPlan = plans.ElementAt(lstPlans.SelectedIndex);
if (selectedPlan.planID > 0)
{
txbPlanID.Text = selectedPlan.planID.ToString();
txbPlanName.Text = selectedPlan.planName;
txbPlanDesc.Text = selectedPlan.planDescription;
txbPrice.Text = selectedPlan.planPrice.ToString();
cmbDuration.Text = selectedPlan.planTerm;
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
// We are creating a new record in the plan database table
if (dbOp == dbOperation.Add)
{
if (ValidateInput() == true)
{
tblPlan plan = new tblPlan();
plan.planName = txbPlanName.Text.Trim();
plan.planDescription = txbPlanDesc.Text.Trim();
plan.planPrice = int.Parse(txbPrice.Text.Trim());
plan.planTerm = cmbDuration.Text;
SavePlan(plan);
if (intSaveStatus == 1)
{
resetControls();
MessageBox.Show("New Plan created", "Save", MessageBoxButton.OK, MessageBoxImage.Information);
refreshPlanList();
}
else
{
MessageBox.Show("Unable to Save Plan", "Save", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show(errMsg, "Save", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
// This is the update of an existing plan.
if (ValidateInput() == true)
{
foreach (var plan in db.tblPlans.Where(d => d.planID == selectedPlan.planID))
{
selectedPlan.planID = int.Parse(txbPlanID.Text.Trim());
selectedPlan.planName = txbPlanName.Text.Trim();
selectedPlan.planDescription = txbPlanDesc.Text.Trim();
selectedPlan.planPrice = int.Parse(txbPrice.Text.Trim());
selectedPlan.planTerm = cmbDuration.Text;
}
intSaveStatus = db.SaveChanges();
if (intSaveStatus == 1)
{
refreshPlanList();
MessageBox.Show("Plan Updated", "Update", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Unable to Update Plan", "Update", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
else
{
MessageBox.Show(errMsg, "Update", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
