protected void Page_Load(object sender, EventArgs e)
{
GetOrgCode();
//Adding a newe funding entry
if (DataItem is GridInsertionObject)
{
GetAgreementID();
agreement = siftaDB.Agreements.FirstOrDefault(p => p.AgreementID == AgreementID);
AddModsToComboBox();
rntbCooperator.Value = 0;
rntbUSGS.Value = 0;
btnInsert.Visible = true;
if (agreement != null && agreement.Customer.CustomerAgreementTypeID != null)
{
if (agreement.Customer.lutCustomerAgreementType.Type != "JFA")
{
rntbUSGS.Value = null;
rntbUSGS.EmptyMessage = "JFA Customer Only";
rntbUSGS.BackColor = System.Drawing.Color.LightGray;
}
rntbUSGS.Enabled = agreement.Customer.lutCustomerAgreementType.Type == "JFA";
}
}
//Editing an existing Funding entry
if (DataItem is CooperativeFunding)
{
CooperativeFunding x = (DataItem as CooperativeFunding);
AgreementID = x.AgreementID;
agreement = siftaDB.Agreements.FirstOrDefault(p => p.AgreementID == AgreementID);
AddModsToComboBox();
rcbMod.SelectedValue = x.AgreementModID.ToString();
btnUpdate.Visible = true;
//Cast the DataItem as a cooperative funding
var cf = (CooperativeFunding)DataItem;
rcbAccount.DataBind();
rcbAccount.SelectedValue = cf.AccountNumber;
rntbFiscalYear.Value = cf.FiscalYear;
rntbUSGS.Value = cf.FundingUSGSCMF;
rntbCooperator.Value = cf.FundingCustomer;
rcbStatus.SelectedValue = cf.Status;
rtbRemarks.Text = cf.Remarks;
if (agreement.Customer.lutCustomerAgreementType.Type != "JFA")
{
rntbUSGS.Value = null;
rntbUSGS.EmptyMessage = "JFA Customer Only";
rntbUSGS.BackColor = System.Drawing.Color.LightGray;
}
rntbUSGS.Enabled = agreement.Customer.lutCustomerAgreementType.Type == "JFA";
}
}
protected void rgCoopFunding_InsertCommand(object sender, GridCommandEventArgs e)
{
//Add metrics
var metric = new MetricHandler(customer.OrgCode, customer.CustomerID, null, MetricType.RecordAdded, "Cooperative Funding", "Cooperative Funding Added");
metric.SubmitChanges();
UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);
GridDataItem parentItem = (GridDataItem)e.Item.OwnerTableView.ParentItem;
var AgreementID = Convert.ToInt32(parentItem.GetDataKeyValue("AgreementID"));
var cf = new CooperativeFunding();
GrabCooperativeFundingValuesFromForm(ref cf, userControl);
cf.AgreementID = AgreementID;
cf.CreatedBy = user.ID;
cf.CreatedDate = DateTime.Now;
siftaDB.CooperativeFundings.InsertOnSubmit(cf);
siftaDB.SubmitChanges();
}
private void GrabCooperativeFundingValuesFromForm(ref CooperativeFunding cf, UserControl control)
{
var rntbFiscalYear = (RadNumericTextBox)control.FindControl("rntbFiscalYear");
var rcbMod = (RadComboBox)control.FindControl("rcbMod");
var rcbAccount = (RadComboBox)control.FindControl("rcbAccount");
var rntbUSGS = (RadNumericTextBox)control.FindControl("rntbUSGS");
var rntbCooperator = (RadNumericTextBox)control.FindControl("rntbCooperator");
var rcbStatus = (RadComboBox)control.FindControl("rcbStatus");
var rtbRemarks = (RadTextBox)control.FindControl("rtbRemarks");
var mod = siftaDB.AgreementMods.FirstOrDefault(p => p.AgreementModID.ToString() == rcbMod.SelectedValue);
cf.ModNumber = mod.Number;
cf.AgreementModID = mod.AgreementModID;
cf.FiscalYear = Convert.ToInt32(rntbFiscalYear.Value);
cf.AccountNumber = rcbAccount.Text;
cf.FundingUSGSCMF = Convert.ToDouble(rntbUSGS.Value);
cf.FundingCustomer = Convert.ToDouble(rntbCooperator.Value);
cf.Status = rcbStatus.SelectedValue;
cf.Remarks = rtbRemarks.Text;
cf.ModifiedBy = user.ID;
cf.ModifiedDate = DateTime.Now;
}
