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); }