public List <CountryStateViewModel> Select(int flag, CountryStateViewModel objEntity)
{
var objEntityList = new List <CountryStateViewModel>();
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_COUNTRYSTATEVIEWMODELSELECT))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, flag);
using (IDataReader reader = objDB.ExecuteReader(sprocCmd))
{
while (reader.Read())
{
var objEntityViewModel = new CountryStateViewModel();
objEntityViewModel.CountryId = reader.GetColumnValue <Int32>(COLUMN_NAME_COUNTRYID);
objEntityViewModel.CountryName = reader.GetColumnValue <String>(COLUMN_NAME_COUNTRYNAME);
objEntityViewModel.StateId = reader.GetColumnValue <Int32>(COLUMN_NAME_STATEID);
objEntityViewModel.StateName = reader.GetColumnValue <String>(COLUMN_NAME_STATENAME);
if (objEntityViewModel != null)
{
objEntityList.Add(objEntityViewModel);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(objEntityList);
}
public SettingContactViewModel(string defState = "AB")
{
countryState = new CountryStateViewModel(defState);
}
public SettingContactViewModel()
{
countryState = new CountryStateViewModel();
}
public RegisterViewModel()
{
securityQuestions = new SecurityQuestionViewModel();
countryState = new CountryStateViewModel();
}
public SearchFormViewModel(string defaultState = "AB")
{
countryState = new CountryStateViewModel(defaultState);
}
public SearchFormViewModel()
{
countryState = new CountryStateViewModel();
}
