public List<FinishingLine> getFinishingLineAll()
{
List<FinishingLine> fininshinglines = new List<FinishingLine>();
FinishingLine f;
try
{
conn = db.openConn();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append(" SELECT id,name FROM finishing_lines ");
string sql;
sql = sb.ToString();
comm = new SqlCommand();
comm.CommandText = sql;
comm.CommandType = CommandType.Text;
comm.Connection = conn;
dr = comm.ExecuteReader();
if (dr.HasRows)
{
DataTable dt = new DataTable();
dt.Load(dr);
foreach (DataRow drw in dt.Rows)
{
f = new FinishingLine();
f.ID = Convert.ToInt32(drw["id"].ToString());
f.Name= drw["name"].ToString();
fininshinglines.Add(f);
}
}
}
catch (Exception ex)
{
dr.Close();
conn.Close();
return null;
throw ex;
}
finally
{
conn.Close();
}
return fininshinglines;
}