public GateTypeListEntityDC GetAllGateType()
{
GateTypeListEntityDC productResponse = new GateTypeListEntityDC();
GateTypeEntityDC member = new GateTypeEntityDC();
GateTerminalDAL memberDAL = new GateTerminalDAL();
productResponse = memberDAL.GetAllGateType();
return(productResponse);
}
public GateTypeListEntityDC GetAllGateType()
{
GateTypeListEntityDC Accounts = new GateTypeListEntityDC();
List <GateTypeEntityDC> AccountList = new List <GateTypeEntityDC>();
using (DbConnection conn = DeLorean.CreateConnection())
{
conn.Open();
try
{
using (DbCommand sprocCmd = conn.CreateCommand())
{
sprocCmd.CommandType = CommandType.StoredProcedure;
sprocCmd.CommandText = GET_ALL_GATETYPE;
using (IDataReader sprocReader = DeLorean.ExecuteReader(sprocCmd))
{
while (sprocReader.Read())
{
GateTypeEntityDC Account = new GateTypeEntityDC();
Account.GateTypeID = sprocReader["GateTypeID"].ToInt();
Account.GateTypeName = sprocReader["GateTypeName"].ToStringDefault();
// Accounts.GateTypeList.Add(Account);
AccountList.Add(Account);
Accounts.GateTypeList = AccountList;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
return(Accounts);
}
