public List <ATMDTO> getListATM()
{
try
{
List <ATMDTO> dsATM = new List <ATMDTO>();
string queryString = "SELECT * FROM ATM";
SqlCommand cmd = new SqlCommand(queryString, DataConnection.connect);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ATMDTO type = new ATMDTO(int.Parse(dr["ATMID"].ToString()),
Convert.ToString(dr["Branch"]),
Convert.ToString(dr["Address"]));
dsATM.Add(type);
}
dr.Close();
DataConnection.closeConnection();
return(dsATM);
}
catch (Exception)
{
DataConnection.closeConnection();
return(null);
}
}
public List <ATMDTO> convertToObject(DataTable input)
{
List <ATMDTO> output = new List <ATMDTO>();
foreach (DataRow dr in input.Rows)
{
ATMDTO obj = new ATMDTO();
obj.ATMID = Convert.ToInt32(dr["ATMID"]);
obj.Branch = Convert.ToString(dr["Branch"]);
obj.Addr = Convert.ToString(dr["Addr"]);
output.Add(obj);
}
return(output);
}
