/// <summary>
/// IStateCodeを実装しているインスタンスからItemStateを取得する
/// </summary>
/// <param name="poco"></param>
/// <returns></returns>
public ItemState GetItemState(IStateCode poco)
{
var r1 = (from a in ItemStates
where a.ItemStateCode == poco.StateCode
select a).FirstOrDefault();
return(r1);
}
public IEnumerable <IStateCode> SelectStates()
{
IDataReader objDataReader = null;
List <IStateCode> objImageDetailList = null;
IStateCode obj = null;
var dbHelper = DBHelper.Instance;
try
{
objDataReader = dbHelper.ExecuteDataReader("SELECT StateCode, StateName, StateNameHindi, DisplayOrder, IsTabSate FROM StateCode ORDER BY StateName", CommandType.Text);
if (objDataReader != null)
{
objImageDetailList = new List <IStateCode>();
do
{
while (objDataReader.Read())
{
obj = new StateCode();
if (!objDataReader.IsDBNull(0))
{
obj.Code = objDataReader.GetString(0);
}
if (!objDataReader.IsDBNull(1))
{
obj.Name = objDataReader.GetString(1);
}
if (!objDataReader.IsDBNull(2))
{
obj.NameHindi = objDataReader.GetString(2);
}
if (!objDataReader.IsDBNull(3))
{
obj.DisplayOrder = objDataReader.GetInt32(3);
}
if (!objDataReader.IsDBNull(4))
{
obj.IsTabSate = objDataReader.GetInt32(4);
}
objImageDetailList.Add(obj);
}
}while (objDataReader.NextResult());
}
if (!objDataReader.IsClosed)
{
objDataReader.Close();
}
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbHelper.ClearAllParameters();
dbHelper.CloseConnection();
dbHelper.Dispose();
}
return(objImageDetailList);
}
