/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
var service = new ReferralAgencyService(new SampleProjectContext());
SortProperty sortProperty = gAgencies.SortProperty;
var qry = service.Queryable("Campus,AgencyTypeValue");
int?campusId = gfSettings.GetUserPreference("Campus").AsInteger(false);
if (campusId.HasValue)
{
qry = qry.Where(a => a.CampusId == campusId.Value);
}
int?definedValueId = gfSettings.GetUserPreference("Agency Type").AsInteger(false);
if (definedValueId.HasValue)
{
qry = qry.Where(a => a.AgencyTypeValueId == definedValueId.Value);
}
// Sort results
if (sortProperty != null)
{
gAgencies.DataSource = qry.Sort(sortProperty).ToList();
}
else
{
gAgencies.DataSource = qry.OrderBy(a => a.Name).ToList();
}
gAgencies.DataBind();
}
/// <summary>
/// Handles the Delete event of the gAgencies control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RowEventArgs"/> instance containing the event data.</param>
protected void gAgencies_Delete( object sender, RowEventArgs e )
{
var dataContext = new SampleProjectContext();
var service = new ReferralAgencyService( dataContext );
var referralAgency = service.Get( (int)e.RowKeyValue );
if ( referralAgency != null )
{
string errorMessage;
if ( !service.CanDelete( referralAgency, out errorMessage ) )
{
mdGridWarning.Show( errorMessage, ModalAlertType.Information );
return;
}
service.Delete( referralAgency );
dataContext.SaveChanges();
}
BindGrid();
}
/// <summary>
/// Handles the Delete event of the gAgencies control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RowEventArgs"/> instance containing the event data.</param>
protected void gAgencies_Delete(object sender, RowEventArgs e)
{
var dataContext = new SampleProjectContext();
var service = new ReferralAgencyService(dataContext);
var referralAgency = service.Get((int)e.RowKeyValue);
if (referralAgency != null)
{
string errorMessage;
if (!service.CanDelete(referralAgency, out errorMessage))
{
mdGridWarning.Show(errorMessage, ModalAlertType.Information);
return;
}
service.Delete(referralAgency);
dataContext.SaveChanges();
}
BindGrid();
}
/// <summary>
/// Handles the Click event of the btnSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param>
protected void btnSave_Click(object sender, EventArgs e)
{
ReferralAgency referralAgency;
var dataContext = new SampleProjectContext();
var service = new ReferralAgencyService(dataContext);
int campusId = int.Parse(hfReferralAgencyId.Value);
if (campusId == 0)
{
referralAgency = new ReferralAgency();
service.Add(referralAgency);
}
else
{
referralAgency = service.Get(campusId);
}
referralAgency.Name = tbName.Text;
referralAgency.Description = tbDescription.Text;
referralAgency.CampusId = cpCampus.SelectedCampusId;
referralAgency.AgencyTypeValueId = ddlAgencyType.SelectedValueAsId();
referralAgency.ContactName = tbContactName.Text;
referralAgency.PhoneNumber = tbPhoneNumber.Text;
referralAgency.Website = tbWebsite.Text;
if (!referralAgency.IsValid || !Page.IsValid)
{
// Controls will render the error messages
return;
}
dataContext.SaveChanges();
NavigateToParentPage();
}
/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
var service = new ReferralAgencyService( new SampleProjectContext() );
SortProperty sortProperty = gAgencies.SortProperty;
var qry = service.Queryable( "Campus,AgencyTypeValue" );
int? campusId = gfSettings.GetUserPreference( "Campus" ).AsInteger( false );
if ( campusId.HasValue )
{
qry = qry.Where( a => a.CampusId == campusId.Value );
}
int? definedValueId = gfSettings.GetUserPreference( "Agency Type" ).AsInteger( false );
if ( definedValueId.HasValue )
{
qry = qry.Where( a => a.AgencyTypeValueId == definedValueId.Value );
}
// Sort results
if ( sortProperty != null )
{
gAgencies.DataSource = qry.Sort( sortProperty ).ToList();
}
else
{
gAgencies.DataSource = qry.OrderBy( a => a.Name ).ToList();
}
gAgencies.DataBind();
}
/// <summary>
/// Handles the Click event of the btnSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param>
protected void btnSave_Click( object sender, EventArgs e )
{
ReferralAgency referralAgency;
var dataContext = new SampleProjectContext();
var service = new ReferralAgencyService( dataContext );
int referralAgencyId = int.Parse( hfReferralAgencyId.Value );
if ( referralAgencyId == 0 )
{
referralAgency = new ReferralAgency();
service.Add( referralAgency );
}
else
{
referralAgency = service.Get( referralAgencyId );
}
referralAgency.Name = tbName.Text;
referralAgency.Description = tbDescription.Text;
referralAgency.CampusId = cpCampus.SelectedCampusId;
referralAgency.AgencyTypeValueId = ddlAgencyType.SelectedValueAsId();
referralAgency.ContactName = tbContactName.Text;
referralAgency.PhoneNumber = tbPhoneNumber.Text;
referralAgency.Website = tbWebsite.Text;
if ( !referralAgency.IsValid || !Page.IsValid )
{
// Controls will render the error messages
return;
}
dataContext.SaveChanges();
NavigateToParentPage();
}
