public DataSet BAL_SYS_State_Select(SYS_State SYS_State, string mode)
{
DAL_SYS_State = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("StateID", SYS_State.stateid));
arrParameter.Add(new parameter("StateIDStr", SYS_State.stateidStr));
arrParameter.Add(new parameter("CountryID", SYS_State.countryid));
return(DAL_SYS_State.DAL_Select("SELECT_DELETE_SYS_State", arrParameter));
}
public int BAL_SYS_State_Delete(SYS_State SYS_State, string mode)
{
DAL_SYS_State = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("StateID", SYS_State.stateid));
arrParameter.Add(new parameter("StateIDStr", SYS_State.stateidStr));
arrParameter.Add(new parameter("CountryID", SYS_State.countryid));
arrParameter.Add(new parameter("IsActive", SYS_State.isactive));
return(DAL_SYS_State.DAL_Delete_Return("SELECT_DELETE_SYS_State", arrParameter));
}
public int BAL_SYS_State_Update(SYS_State SYS_State, string mode)
{
DAL_SYS_State = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("StateID", SYS_State.stateid));
arrParameter.Add(new parameter("CountryID", SYS_State.countryid));
arrParameter.Add(new parameter("State", SYS_State.state));
arrParameter.Add(new parameter("CreatedBy", SYS_State.createdby));
return(DAL_SYS_State.DAL_InsertUpdate_Return("Proc_SYS_StateInsertUpdate", arrParameter));
}