public IQueryable <State> FindBy(System.Linq.Expressions.Expression <Func <State, bool> > predicate)
{
StateDAL dalObject = new StateDAL();
IQueryable <State> results = dalObject.FindBy(predicate);
return(results);
}
private void BindState()
{
int stateId = Request.QueryString["StateId"].ToInt();
if (stateId > 0)
{
State stateLookup = StateDAL.GetItem(stateId);
if (stateLookup != null)
{
lblStateId.Text = stateLookup.StateId.ToString();
lblStateName.Text = stateLookup.StateName;
lblStateAbbreviation.Text = stateLookup.StateAbbreviation.ToString();
}
else
{
lblMessage.Text = "State could not be found.";
}
}
else
{
lblMessage.Text = "Invalid ID. State record could not be found.";
}
}
public IQueryable <State> GetAll()
{
StateDAL dalObject = new StateDAL();
IQueryable <State> results = dalObject.GetAll();
return(results);
}
public List <StateDO> GetStates(int CountryId)
{
List <StateDO> obj = new List <StateDO>();
StateDAL objDal = new StateDAL();
obj = objDal.GetStates(CountryId);
return(obj);
}
public frmCity()
{
InitializeComponent();
DALObject = new DAL.City.CityDAL();
StateDAL = new StateDAL();
FirstControl = txtCityName;
}
private void BindStateList()
{
StateCollection stateList = new StateCollection();
stateList = StateDAL.GetCollection();
rptStateList.DataSource = stateList;
rptStateList.DataBind();
}
void LookupCountry_EditValueChanged(object sender, EventArgs e)
{
if (LookupCountry.EditValue == null)
{
LookupState.Properties.DataSource = null;
}
else
{
StateDAL StateDAL = new StateDAL();
LookupState.Properties.DataSource = StateDAL.GetLookupList((int)LookupCountry.EditValue);
}
}
public Boolean Delete(SqlInt32 CategoryID)
{
StateDAL dalState = new StateDAL();
if (dalState.Delete(CategoryID))
{
return(true);
}
else
{
Message = dalState.Message;
return(false);
}
}
public Boolean Update(StateENT entState)
{
StateDAL dalState = new StateDAL();
if (dalState.Update(entState))
{
return(true);
}
else
{
Message = dalState.Message;
return(false);
}
}
public List <StateMaster> GetData(StateMasterFilter objFilter, bool prevFilter = false)
{
StateDAL objStateDAL = null;
try
{
objStateDAL = new StateDAL();
SetStateFilter(objFilter, prevFilter);
return(objStateDAL.Get(objFilter));
}
catch (Exception ex)
{
throw;
}
finally
{
objStateDAL = null;
}
}
public Response SaveState(StateMaster state, string CRUDAction)
{
StateDAL objStateDAL = null;
Response objResponse;
string ErrorCode = "";
try
{
objStateDAL = new StateDAL();
objStateDAL.Save(state, CRUDAction, out ErrorCode);
objResponse.ErrorCode = ErrorCode;
objResponse.Description = "";
}
catch (Exception ex)
{
throw;
}
finally
{
objStateDAL = null;
}
return(objResponse);
}
//returns a list of the states
public List <US_State> GetStates()
{
return(StateDAL.GetStates());
}
public StateENT SelectByPK(SqlInt32 StateID)
{
StateDAL dalState = new StateDAL();
return(dalState.SelectByPK(StateID));
}
public DataTable SelectForDropDownList()
{
StateDAL dalState = new StateDAL();
return(dalState.SelectForDropDownList());
}
public DataTable SelectAll()
{
StateDAL dalState = new StateDAL();
return(dalState.SelectAll());
}
public StateBLL()
{
Dal = new StateDAL();
}
public void Add(State entity)
{
StateDAL dalObject = new StateDAL();
dalObject.Add(entity);
}
public DataTable LoadState()
{
StateDAL state = new StateDAL();
return(state.LoadState());
}
public void Delete(int id)
{
StateDAL dalObject = new StateDAL();
dalObject.Delete(id);
}
public void Edit(State entity)
{
StateDAL dalObject = new StateDAL();
dalObject.Edit(entity);
}