public INTUnits GetOne(int ID)
{
SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString());
Con.Open();
SqlCommand cmd = null;
SqlDataReader SDR = null;
INTUnits ObjTmp = new INTUnits();
try
{
string Query = "SELECT * FROM INTUnits where UnitID=" + ID;
cmd = new SqlCommand(Query, Con);
cmd.Parameters.AddWithValue("@UnitID", ID);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
ObjTmp.UnitID = SDR.GetInt32(0);
ObjTmp.Name = SDR.GetString(1);
ObjTmp.Unit = SDR.GetString(2);
ObjTmp.ParentId = SDR.GetInt32(3);
}
}
catch (System.Exception e)
{ e.ToString(); }
finally { Con.Close(); }
return(ObjTmp);
}
public static List <INTUnits> GetAll()
{
DBCon con = new DBCon();
SqlCommand cmd = null;
SqlDataReader SDR = null;
List <INTUnits> listUnit = new List <INTUnits>();
try
{
string Quary = "Select * from INTUnits ORDER BY UnitID DESC";
cmd = new SqlCommand(Quary, con.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
INTUnits OBJINT = new INTUnits();
OBJINT.UnitID = SDR.GetInt32(0);
OBJINT.Name = SDR.GetString(1);
OBJINT.Unit = SDR.GetString(2);
OBJINT.ParentId = SDR.GetInt32(3);
listUnit.Add(OBJINT);
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); con.Con.Close(); }
return(listUnit);
}
