/// <summary>
/// Populate State/Province List from database
/// </summary>
private void populateStateList()
{
StateDataAccess stateDAL = new StateDataAccess();
string webroot = LACESUtilities.GetApplicationConstants("ASLARoot");
int StateProvidenceID = int.Parse(LACESUtilities.GetApplicationConstants("StateProvinceContentID"));
IList <State> stateList = stateDAL.GetAllStates(StateProvidenceID, webroot);
///Add default item
ListItem defaultItem = new ListItem("- Location -", "");
ddlLocation.Items.Add(defaultItem);
/////Add Distance Education item
//ListItem distanceEducation = new ListItem("Distance Education", "Distance Education");
//ddlLocation.Items.Add(distanceEducation);
foreach (State state in stateList)
{
ListItem item = new ListItem(state.StateName, state.StateCode);
ddlLocation.Items.Add(item);
}
//for other International value
ddlLocation.Items.Add(new ListItem("- Other International -", "OI"));
}
public void DeleteState(DeleteStateRequest request)
{
if (request != null)
{
var dataAccess = new StateDataAccess(request.Context);
var state = dataAccess.GetById(request.IdState);
dataAccess.Delete(state.FirstOrDefault());
}
}
public State UpdateState(UpdateStateRequest request)
{
State state = null;
if (request != null && request.State != null)
{
var dataAccess = new StateDataAccess(request.Context);
state = dataAccess.Update(request.State);
}
return(state);
}
public State GetStateById(GetStateByIdRequest request)
{
State state = null;
if (request != null)
{
var dataAccess = new StateDataAccess(request.Context);
var stateQuery = dataAccess.GetById(request.IdState);
stateQuery = stateQuery.Include(s => s.Country);
state = stateQuery.FirstOrDefault();
}
return(state);
}
public List <State> GetAllStates(GetAllStatesRequest request)
{
List <State> states = null;
if (request != null)
{
var dataAccess = new StateDataAccess(request.Context);
var statesQuery = dataAccess.GetAll();
statesQuery = statesQuery.Include(s => s.Country);
states = statesQuery.ToList();
}
return(states);
}
/// <summary>
/// Populate State List
/// </summary>
private void populateStateList()
{
StateDataAccess stateDAL = new StateDataAccess();
string webroot = LACESUtilities.GetApplicationConstants("ASLARoot");
int StateProvidenceID = int.Parse(LACESUtilities.GetApplicationConstants("StateProvinceContentID"));
IList <State> stateList = stateDAL.GetAllStates(StateProvidenceID, webroot); // Get all States
ListItem defaultItem = new ListItem("-State List-", "");
drpState.Items.Add(defaultItem);
foreach (State state in stateList)
{
ListItem item = new ListItem(state.StateName, state.StateCode);
drpState.Items.Add(item);
}
drpState.Items.Add(new ListItem("- Other International -", "OL"));
}
/// <summary>
/// Use to populate state list in the UI. Get state data from database.
/// Return none.
/// </summary>
private void populateStateList()
{
//Get all States from DB
StateDataAccess stateDAL = new StateDataAccess();
string webroot = LACESUtilities.GetApplicationConstants("ASLARoot");
int StateProvidenceID = int.Parse(LACESUtilities.GetApplicationConstants("StateProvinceContentID"));
IList <State> stateList = stateDAL.GetAllStates(StateProvidenceID, webroot);
//Add the default value in to the DropDownList
ListItem defaultItem = new ListItem("-State List-", "-State List-");
drpState.Items.Add(defaultItem);
//Prepare the list as a user friendly version and add into the DropDownList
foreach (State state in stateList)
{
ListItem item = new ListItem(state.StateName, state.StateCode);
drpState.Items.Add(item);
}
}