public INTGSTBL GetOne(int ID) { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString()); Con.Open(); SqlCommand cmd = null; SqlDataReader SDR = null; INTGSTBL ObjTmp = new INTGSTBL(); try { string Query = "SELECT * FROM INTGSTBL where GSID=@GSID"; cmd = new SqlCommand(Query, Con); cmd.Parameters.AddWithValue("@GSID", ID); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp.GSID = SDR.GetInt32(0); ObjTmp.CatID = SDR.GetInt32(1); ObjTmp.Name = SDR.GetString(2); ObjTmp.Typeid = SDR.GetInt32(3); ObjTmp.UnitID = SDR.GetInt32(4); ObjTmp.Qty = SDR.GetDouble(5); ObjTmp.PurchasedPrize = SDR.GetDouble(6); ObjTmp.PurchasedTax = SDR.GetDouble(7); ObjTmp.SalePrize = SDR.GetDouble(8); ObjTmp.SaleTax = SDR.GetDouble(9); ObjTmp.ISSaleable = SDR.GetBoolean(10); ObjTmp.ISdirectlyPurchased = SDR.GetBoolean(11); ObjTmp.ISProcessed = SDR.GetBoolean(12); ObjTmp.ServicePrize = SDR.GetDouble(13); ObjTmp.ServiceTax = SDR.GetDouble(14); } } catch (System.Exception e) { e.ToString(); } finally { Con.Close(); } return(ObjTmp); }
public static List <INTGSTBL> GetAll() { DBCon con = new DBCon(); SqlCommand cmd = null; SqlDataReader SDR = null; List <INTGSTBL> listintcat = new List <INTGSTBL>(); try { string Quary = "Select * from INTGSTBL"; cmd = new SqlCommand(Quary, con.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { INTGSTBL OBJINT = new INTGSTBL(); OBJINT.GSID = SDR.GetInt32(0); OBJINT.CatID = SDR.GetInt32(1); OBJINT.Name = SDR.GetString(2); OBJINT.Typeid = SDR.GetInt32(3); OBJINT.UnitID = SDR.GetInt32(4); OBJINT.Qty = SDR.GetDouble(5); OBJINT.PurchasedPrize = SDR.GetDouble(6); OBJINT.PurchasedTax = SDR.GetDouble(7); OBJINT.SalePrize = SDR.GetDouble(8); OBJINT.SaleTax = SDR.GetDouble(9); OBJINT.ISSaleable = SDR.GetBoolean(10); OBJINT.ISdirectlyPurchased = SDR.GetBoolean(11); OBJINT.ISProcessed = SDR.GetBoolean(12); OBJINT.ServicePrize = SDR.GetDouble(13); OBJINT.ServiceTax = SDR.GetDouble(14); listintcat.Add(OBJINT); } } catch (Exception e) { e.ToString(); } finally { cmd.Dispose(); con.Con.Close(); } return(listintcat); }