示例#1
0
        public string Save(StockOutDB stockOutDB)
        {
            // stockOutGateway.GetAvailable()
            //available = stockOutGateway.GetAvailable(stockOutDB.Item);
            //quantity = stockOutDB.StockOutQuantity;


            //if (quantity > available)
            //{

            //    return "Insufficient Items in ="+stockOutDB.Item;


            //}
            //else
            //{

            int rowAffect = stockOutGateway.Save(stockOutDB);

            int rowAffect2 = stockOutGateway.ChangeInAvailableInItemSetup(stockOutDB);

            if (rowAffect > 0 && rowAffect2 > 0)
            {
                return("Save Successful");
            }
            else
            {
                return("Save Failed");
            }
        }
示例#2
0
 public int Check(StockOutDB stockOutDB)
 {
     available = stockOutGateway.GetAvailable(stockOutDB.ItemName, stockOutDB.CompanyId);
     quantity  = stockOutDB.StockOutQuantity;
     if (quantity > available)
     {
         return(checkInS + 1);
     }
     else
     {
         return(0);
     }
 }
示例#3
0
        public int ChangeInAvailableInItemSetup(StockOutDB stockOutDB)
        {
            availble = availble - quantity;

            string query = "UPDATE ItemSetup SET AvailableQuantity='" + availble + "' WHERE ItemName= '" + stockOutDB.ItemName + "' AND CompanyId= '" + stockOutDB.CompanyId + "'";

            command = new SqlCommand(query, connection);
            connection.Open();
            int rowAffect = command.ExecuteNonQuery();

            connection.Close();
            return(rowAffect);
        }
示例#4
0
        public int Save(StockOutDB stockOutDB)
        {
            quantity = stockOutDB.StockOutQuantity;

            string query = "INSERT INTO StockOut (CompanyId,ItemId,Quantity,ItemType) VALUES('" + stockOutDB.CompanyId + "','" + stockOutDB.ItemId + "'," + stockOutDB.StockOutQuantity + ",'" + stockOutDB.ItemType + "')";

            command = new SqlCommand(query, connection);
            connection.Open();
            int rowAffect = command.ExecuteNonQuery();

            connection.Close();
            return(rowAffect);
        }
示例#5
0
        public int CheckBefore(int quantity, string itemName, int companyId)
        {
            StockOutDB stockOutDB = new StockOutDB();

            available = stockOutGateway.GetAvailable(itemName, companyId);
            int check_CheckBefore = 0;

            if (quantity > available)
            {
                check_CheckBefore = check_CheckBefore + 1;
                return(check_CheckBefore);
            }
            else
            {
                return(0);
            }
        }
示例#6
0
        public int GetReorderLevel(string item, int companyId)
        {
            string query = "SELECT ReorderLevel FROM ItemSetup WHERE ItemName= '" + item + "' AND CompanyId='" + companyId + "'";

            command = new SqlCommand(query, connection);
            connection.Open();
            reader = command.ExecuteReader();
            StockOutDB stockOutDB = new StockOutDB();

            reader.Read();
            if (reader.HasRows)
            {
                stockOutDB = new StockOutDB();

                stockOutDB.ReorderLevel = Convert.ToInt32(reader["ReorderLevel"]);
            }
            reader.Close();
            connection.Close();
            return(stockOutDB.ReorderLevel);;
        }
示例#7
0
        public int GetAvailable(string item, int companyId)
        {
            string query = "SELECT AvailableQuantity FROM ItemSetup WHERE ItemName= '" + item + "' AND CompanyId= '" + companyId + "'";

            command = new SqlCommand(query, connection);
            connection.Open();
            reader = command.ExecuteReader();
            StockOutDB stockOutDB = new StockOutDB();

            reader.Read();
            if (reader.HasRows)
            {
                stockOutDB = new StockOutDB();

                stockOutDB.AvailableQuantity = Convert.ToInt32(reader["AvailableQuantity"]);
                availble = stockOutDB.AvailableQuantity;
            }
            reader.Close();
            connection.Close();
            return(stockOutDB.AvailableQuantity);;
        }