Esempio n. 1
0
        public static Stocks GetStocksByKioskID_ProdID(int kioskid, int prodid)
        {
            var     dal = new StocksDAL();
            DataRow row = dal.GetStocksByKioskID_ProdID(kioskid, prodid);

            var ins = new Stocks();

            ins.Bind(row);

            return(ins);
        }
Esempio n. 2
0
        public static List <Stocks> GetStocksByReferenceAndKioskID(string directsupplier, int kioskid)
        {
            var dal        = new StocksDAL();
            var collection = new List <Stocks>();

            foreach (DataRow row in dal.GetStocksByReferenceAndKioskID(directsupplier, kioskid).Rows)
            {
                var instance = new Stocks();
                instance.Bind3(row);
                collection.Add(instance);
            }

            return(collection);
        }
Esempio n. 3
0
        public static List <Stocks> GetKioskPhoneStocks(int id, int type)
        {
            var dal  = new StocksDAL();
            var coll = new List <Stocks>();

            foreach (DataRow row in dal.GetKioskPhoneStocks(id, type).Rows)
            {
                var ins = new Stocks();

                ins.Bind2(row);
                coll.Add(ins);
            }

            return(coll);
        }
 private void UpdateStocks(Stocks ins)
 {
     base.com.CommandText = "spUpdateStocks";
     base.com.Parameters.Clear();
     base.com.Parameters.AddWithValue("_ProdID", ins.ProdID);
     base.com.Parameters.AddWithValue("_KioskID", ins.KioskID);
     base.com.Parameters.AddWithValue("_StockIn", ins.StockIn);
     base.com.Parameters.AddWithValue("_Remarks", ins.Remarks);
     base.com.Parameters.AddWithValue("_CreatedBy", ins.CreatedBy);
     base.com.Parameters.AddWithValue("_Reference", ins.Reference);
     base.com.ExecuteScalar();
 }
        private bool InsertStocks2(Stocks ins)
        {
            base.com.CommandText = "spInsertStocks";
            base.com.Parameters.Clear();
            base.com.Parameters.AddWithValue("_ProdID", ins.ProdID);
            base.com.Parameters.AddWithValue("_KioskID", ins.KioskID);
            base.com.Parameters.AddWithValue("_StockIn", ins.StockIn);
            base.com.Parameters.AddWithValue("_Remarks", ins.Remarks);
            base.com.Parameters.AddWithValue("_CreatedBy", ins.CreatedBy);
            base.com.Parameters.AddWithValue("_Reference", ins.Reference);
            base.com.Parameters.AddWithValue("_DistRec", ins.DistReciept);

            int res;

             res = Convert.ToInt32(base.com.ExecuteScalar());

            return res > 0;
        }
        private List<Stocks> GetKioskStockByType(int kioskid, int type)
        {
            base.com.CommandText = "spGetKioskStockByType";
            base.com.Parameters.Clear();
            base.com.Parameters.AddWithValue("_KioskID", kioskid);
            base.com.Parameters.AddWithValue("_Type", type);
            //
            MySqlDataAdapter da = new MySqlDataAdapter(base.com);
            DataTable dt = new DataTable();
            da.Fill(dt);

            var coll = new List<Stocks>();

            foreach (DataRow row in dt.Rows)
            {
                var ins = new Stocks();
                ins.Bind2(row);
                coll.Add(ins);
            }

            return coll;
        }
 private void DeleteStocksByKioskID_ProdID(Stocks ins)
 {
     base.com.CommandText = "spDeleteKioskStockByProdIDKioskID";
     base.com.Parameters.Clear();
     base.com.Parameters.AddWithValue("_KioskID", ins.KioskID);
     base.com.Parameters.AddWithValue("_ProdID", ins.ProdID);
     base.com.ExecuteNonQuery();
 }
        public static List<Stocks> GetStocksByReferenceAndKioskID(string directsupplier, int kioskid)
        {
            var dal = new StocksDAL();
            var collection = new List<Stocks>();

            foreach (DataRow row in dal.GetStocksByReferenceAndKioskID(directsupplier, kioskid).Rows)
            {
                var instance = new Stocks();
                instance.Bind3(row);
                collection.Add(instance);
            }

            return collection;
        }
        public static Stocks GetStocksByKioskID_ProdID(int kioskid, int prodid)
        {
            var dal = new StocksDAL();
            DataRow row = dal.GetStocksByKioskID_ProdID(kioskid, prodid);

            var ins = new Stocks();
            ins.Bind(row);

            return ins;
        }
Esempio n. 10
0
        public static List<Stocks> GetKioskPhoneStocks(int id, int type)
        {
            var dal = new StocksDAL();
            var coll = new List<Stocks>();

            foreach (DataRow row in dal.GetKioskPhoneStocks(id, type).Rows)
            {
                var ins = new Stocks();

                ins.Bind2(row);
                coll.Add(ins);
            }

            return coll;
        }