Esempio n. 1
0
 private void btnDeleteOrderTruck_Click(object sender, EventArgs e)
 {
     if (!String.IsNullOrEmpty(selectedOrderTruck))
     {
         if (cbbCustomer.SelectedIndex < 0 || cbbMaterialType.SelectedIndex < 0 || String.IsNullOrEmpty(txtSubTotal.Text))
         {
             MessageBox.Show("Please select the ordertruck to delete.", "Message");
         }
         else
         {
             try
             {
                 MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
                 OrderTruck        deleteOrderTruck  = new OrderTruck();
                 deleteOrderTruck.deleteOrderTruck(mongoDBConnection.getMongoData(), selectedOrderTruck);
                 MessageBox.Show("Order truck is deleted successfully.", "Message");
                 this.clearOrderTruckTab();
                 this.displayDataTableOrderTruck(dataGridViewOrderTruck);
                 this.loadValueCustomeFilterCombobox(cbbSearchCustomer);
                 this.loadValueFilterMaterialTypeCombobox(cbbSearchMaterialType);
                 this.resetFilterValue();
             }
             catch (Exception)
             {
                 MessageBox.Show("Failed to delete the customer. Please try again.", "Message");
             }
         }
     }
     else
     {
         MessageBox.Show("Please select the customer to delete.", "Message");
     }
 }
Esempio n. 2
0
        private void btnDeleteUser_Click(object sender, EventArgs e)
        {
            if (!String.IsNullOrEmpty(txtUserName.Text.Trim()))
            {
                DialogResult dr = MessageBox.Show("Do you want to update this user?", "Confirmed Message", MessageBoxButtons.YesNoCancel,
                                                  MessageBoxIcon.Information);

                if (dr == DialogResult.Yes)
                {
                    MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
                    User deleteUser = new User();
                    try
                    {
                        deleteUser.deleteByUsername(mongoDBConnection.getMongoData(), txtUserName.Text.Trim());
                        MessageBox.Show("The user is deleted successfully.", "Message");
                        txtUserName.Clear();
                        txtPassword.Clear();
                        if (ckcActive.Checked)
                        {
                            ckcActive.Checked = false;
                        }
                        txtUserName.Enabled = true;
                        this.displayDataTableUser(dataGridViewUser);
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("Failed to delete this user. Please try again.", "Message");
                    }
                }
            }
            else
            {
                MessageBox.Show("Please select the user to delete.", "Message");
            }
        }
Esempio n. 3
0
        public static HttpResponseMessage Run([HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "getall")] HttpRequestMessage req, TraceWriter log)
        {
            var driverData = MongoDBConnection.GetCollection <dynamic>("DriverCollectionName").Find(new BsonDocument()).ToList();

            // Fetching the name from the path parameter in the request URL test
            return(req.CreateResponse(HttpStatusCode.OK, driverData, JsonMediaTypeFormatter.DefaultMediaType));
        }
Esempio n. 4
0
        public static HttpResponseMessage Run([HttpTrigger(AuthorizationLevel.Anonymous,
                                                           "get", Route = "promodata/{series}")] HttpRequestMessage req,
                                              string series,
                                              TraceWriter log)
        {
            IDatabase        cache    = RedisConnection.Connection.GetDatabase();
            string           redisKey = System.Environment.GetEnvironmentVariable("RedisKeyModelThree");
            List <PromoData> promos   = new List <PromoData>();
            var length = cache.ListLength(redisKey);

            if (length > 0)//in redis
            {
                foreach (string item in cache.ListRange(redisKey, 0, (length - 1)))
                {
                    promos.Add(JsonConvert.DeserializeObject <PromoData>(item));
                }
            }
            else//get from mongodb and insert into redis
            {
                var promoCollection = MongoDBConnection.GetCollection <PromoData>("PromotionCollectionName");
                promos = promoCollection.AsQueryable().OrderByDescending(p => p.CreatedTime).Take(5).ToList();

                log.Info(promos.Count().ToString());

                foreach (var promo in promos)
                {
                    cache.ListLeftPush(redisKey, JsonConvert.SerializeObject(promo));
                }

                cache.ListTrim(redisKey, 0, 4);
            }

            return(req.CreateResponse(HttpStatusCode.OK, promos, JsonMediaTypeFormatter.DefaultMediaType));
        }
Esempio n. 5
0
        public static HttpResponseMessage Run([HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "id/{name}")] HttpRequestMessage req, string name, TraceWriter log)
        {
            string query = "{VehicleId:{$eq:\"" + name + "\"}}";
            var    data  = MongoDBConnection.GetCollection <dynamic>("DriverCollectionName").Find(query).ToList();

            // Fetching the name from the path parameter in the request URL test
            return(req.CreateResponse(HttpStatusCode.OK, data, JsonMediaTypeFormatter.DefaultMediaType));
        }
Esempio n. 6
0
        private void btnUpdateCustomer_Click(object sender, EventArgs e)
        {
            Customer currentCustomer   = new Customer();
            String   updateName        = txtName.Text.Trim();
            String   updatePhoneNumber = txtPhoneNumber.Text.Trim();
            String   updateAddress     = txtAddress.Text.Trim();
            bool     updateIsActive    = ckcActiveCustomer.Checked;

            if (!String.IsNullOrEmpty(selectedCustomer))
            {
                MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
                currentCustomer = currentCustomer.findCustomerByID(mongoDBConnection.getMongoData(), selectedCustomer);
                Customer updateCustomer = new Customer();
                if (String.IsNullOrEmpty(txtName.Text) && String.IsNullOrEmpty(txtPhoneNumber.Text))
                {
                    MessageBox.Show("Please enter name and phone number.", "Message");
                }
                else if (String.IsNullOrEmpty(txtName.Text))
                {
                    MessageBox.Show("Please enter name field.", "Message");
                }
                else if (String.IsNullOrEmpty(txtPhoneNumber.Text))
                {
                    MessageBox.Show("Please enter phone number field.", "Message");
                }
                else
                {
                    updateCustomer.name        = updateName;
                    updateCustomer.phoneNumber = updatePhoneNumber;
                    updateCustomer.address     = updateAddress;
                    updateCustomer.isActive    = updateIsActive;
                    updateCustomer.modifyDate  = DateTime.Now.ToUniversalTime();

                    currentCustomer.updateCustomer(mongoDBConnection.getMongoData(), currentCustomer, updateCustomer);
                    MessageBox.Show("The customer is updated successfully.", "Message");
                    selectedCustomer = String.Empty;
                    txtName.Clear();
                    txtPhoneNumber.Clear();
                    txtAddress.Clear();
                    if (ckcActiveCustomer.Checked)
                    {
                        ckcActiveCustomer.Checked = false;
                    }
                    this.displayDataTableCustomer(dataGridViewCustomer);
                    this.loadValueCustomerCombobox(cbbCustomer);
                    OrderTruck orderTruck = new OrderTruck();
                    updateCustomer = updateCustomer.findCustomerByID(mongoDBConnection.getMongoData(), currentCustomer._id.ToString());
                    // Update all order truck with update customer's info.
                    orderTruck.updateOrderTruckByCustomer(mongoDBConnection.getMongoData(), updateCustomer);
                    this.displayDataTableOrderTruck(dataGridViewOrderTruck);
                }
            }
            else
            {
                MessageBox.Show("Please select the customer to delete.", "Message");
            }
        }
Esempio n. 7
0
        public void displayDataTableOrderTruck(DataGridView dataGridView)
        {
            OrderTruck        orderTruckData    = new OrderTruck();
            MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
            List <OrderTruck> listOrderTrucks   = orderTruckData.getAllOrderTrucks(mongoDBConnection.getMongoData());

            listOrderTrucksFilter = listOrderTrucks;
            this.viewDataTableOrdertruck(dataGridViewOrderTruck, listOrderTrucks);
        }
Esempio n. 8
0
        public PlaylistsRepository(MongoDBConnection connection)
        {
            if (connection == null)
            {
                throw new ArgumentNullException(nameof(connection));
            }

            _collection = connection.GetCollection <Playlist>(CollectionName);
        }
Esempio n. 9
0
        private void btnAddOrderTruck_Click(object sender, EventArgs e)
        {
            String customerName = "";
            String materialType = "";
            String note         = txtNote.Text.Trim();

            if (cbbCustomer.SelectedIndex < 0)
            {
                MessageBox.Show("Please select the customer's name.", "Message");
            }
            else if (cbbMaterialType.SelectedIndex < 0)
            {
                MessageBox.Show("Please select the material type.", "Message");
            }
            else if (String.IsNullOrEmpty(txtSubTotal.Text.Trim()))
            {
                MessageBox.Show("Please input the subtotal.", "Message");
            }
            else if (dateTPCompletedDay.CustomFormat == " ")
            {
                MessageBox.Show("Please select the completed day.", "Message");
            }
            else
            {
                customerName = cbbCustomer.SelectedItem.ToString().Trim();
                materialType = cbbMaterialType.SelectedItem.ToString().Trim();
                MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
                Customer          selectedCustomer  = new Customer();
                selectedCustomer = selectedCustomer.findCustomerByName(customerName, mongoDBConnection.getMongoData());
                DateTime   completedDay  = dateTPCompletedDay.Value.ToUniversalTime();
                OrderTruck newOrderTruck = new OrderTruck();
                newOrderTruck.customer      = selectedCustomer;
                newOrderTruck.materialType  = materialType;
                newOrderTruck.subtotal      = int.Parse(txtSubTotal.Text.Trim());
                newOrderTruck.note          = txtNote.Text.Trim();
                newOrderTruck.completedDate = completedDay;
                newOrderTruck.createDate    = DateTime.Now.ToUniversalTime();
                newOrderTruck.modifyDate    = DateTime.Now.ToUniversalTime();
                newOrderTruck.isPaid        = ckcIsPaid.Checked;
                this.clearOrderTruckTab();
                try
                {
                    newOrderTruck.addOrderTruck(mongoDBConnection.getMongoData(), newOrderTruck);
                    MessageBox.Show("New order truck is add successfully.", "Message");
                    this.clearOrderTruckTab();
                    this.displayDataTableOrderTruck(dataGridViewOrderTruck);
                    this.loadValueCustomeFilterCombobox(cbbSearchCustomer);
                    this.loadValueFilterMaterialTypeCombobox(cbbSearchMaterialType);
                    this.resetFilterValue();
                }
                catch (Exception)
                {
                    MessageBox.Show("Failed to add new order truck. Please try again.", "Message");
                }
            }
        }
Esempio n. 10
0
        public async static Task <HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = "content/{id}")] HttpRequestMessage req, string id, TraceWriter log)
        {
            //add content into MongoDB
            dynamic data = await req.Content.ReadAsStringAsync();

            var circleData = JsonConvert.DeserializeObject <CircleData>(data as string);

            MongoDBConnection.GetCollection <CircleData>("CircleCollectionName").InsertOne(circleData);

            return(req.CreateResponse(HttpStatusCode.OK, "Inserted"));
        }
Esempio n. 11
0
        public void loadValueCustomerCombobox(ComboBox customerCombobox)
        {
            MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
            Customer          customer          = new Customer();
            List <Customer>   listCustomers     = customer.getAllActiveCustomers(mongoDBConnection.getMongoData());

            cbbCustomer.Items.Clear();
            cbbCustomer.ResetText();
            foreach (Customer customer1 in listCustomers)
            {
                cbbCustomer.Items.Add(customer1.name);
            }
        }
Esempio n. 12
0
        public void displayDataTableUser(DataGridView dataGridView)
        {
            User userData = new User();
            MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
            List <User>       listUsers         = userData.getListAllUsers(mongoDBConnection.getMongoData());

            dataGridView.Rows.Clear();
            dataGridView.Refresh();
            for (int i = 0; i < listUsers.Count; i++)
            {
                dataGridView.Rows.Add(new object[] { i + 1, listUsers[i].userName, listUsers[i].passWord, listUsers[i].createDate.ToLocalTime(), listUsers[i].active });
            }
        }
Esempio n. 13
0
        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            var mongoDBConnection = new MongoDBConnection()
            {
                MongoClientSettings = GetMongoDBSettings(Configuration),
                DatabaseName        = Configuration["AppSettings:MongoDBName"]
            };

            services.AddSingleton <IMongoDBConnection>(mongoDBConnection);
            services.AddSingleton <IActionRepository, ActionRepository>();

            services.AddMvc();
        }
Esempio n. 14
0
        private void btnAddCustomer_Click(object sender, EventArgs e)
        {
            String   name        = txtName.Text.Trim();
            String   phoneNumber = txtPhoneNumber.Text.Trim();
            String   address     = txtAddress.Text.Trim();
            bool     isActive    = ckcActiveCustomer.Checked;
            Customer newCustomer = new Customer();

            newCustomer.name        = name;
            newCustomer.phoneNumber = phoneNumber;
            newCustomer.address     = address;
            newCustomer.isActive    = ckcActiveCustomer.Checked;
            newCustomer.createDate  = DateTime.Now.ToUniversalTime();
            newCustomer.modifyDate  = DateTime.Now.ToUniversalTime();

            if (String.IsNullOrEmpty(name) && String.IsNullOrEmpty(phoneNumber))
            {
                MessageBox.Show("Please enter name and phone number.", "Message");
            }
            else if (String.IsNullOrEmpty(name))
            {
                MessageBox.Show("Please enter name field.", "Message");
            }
            else if (String.IsNullOrEmpty(phoneNumber))
            {
                MessageBox.Show("Please enter phone number field.", "Message");
            }
            else
            {
                try
                {
                    MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
                    newCustomer.addCustomer(mongoDBConnection.getMongoData(), newCustomer);
                    MessageBox.Show("New Customer is added successfully.", "Message");
                    txtName.Clear();
                    txtPhoneNumber.Clear();
                    txtAddress.Clear();
                    if (ckcActiveCustomer.Checked)
                    {
                        ckcActiveCustomer.Checked = false;
                    }
                    this.displayDataTableCustomer(dataGridViewCustomer);
                    this.loadValueCustomerCombobox(cbbCustomer);
                }
                catch (Exception)
                {
                    MessageBox.Show("Failed to add new customer. Please try again.", "Message");
                }
            }
        }
Esempio n. 15
0
        private void btnUpdateUser_Click(object sender, EventArgs e)
        {
            String username = txtUserName.Text.Trim();
            String password = txtPassword.Text.Trim();

            if (String.IsNullOrEmpty(username) && String.IsNullOrEmpty(password))
            {
                MessageBox.Show("Please enter your username and passowrd.", "Message");
            }
            else if (String.IsNullOrEmpty(username))
            {
                MessageBox.Show("Please enter your username.", "Message");
            }
            else if (String.IsNullOrEmpty(password))
            {
                MessageBox.Show("Please enter your passowrd.", "Message");
            }
            else
            {
                DialogResult dr = MessageBox.Show("Do you want to update this user?", "Confirmed Message", MessageBoxButtons.YesNoCancel,
                                                  MessageBoxIcon.Information);

                if (dr == DialogResult.Yes)
                {
                    MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
                    User currentUser = new User();
                    try
                    {
                        currentUser = currentUser.findUserByName(username, mongoDBConnection.getMongoData());
                        User newUser = new User();
                        newUser.passWord = password;
                        newUser.active   = ckcActive.Checked;
                        currentUser.updateUser(mongoDBConnection.getMongoData(), currentUser, newUser);
                        MessageBox.Show("The user is updated successfully.", "Message");
                        txtUserName.Clear();
                        txtPassword.Clear();
                        if (ckcActive.Checked)
                        {
                            ckcActive.Checked = false;
                        }
                        txtUserName.Enabled = true;
                        this.displayDataTableUser(dataGridViewUser);
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("Failed to update this user. Please try again.", "Message");
                    }
                }
            }
        }
Esempio n. 16
0
        public void displayDataTableCustomer(DataGridView dataGridView)
        {
            Customer          customerData      = new Customer();
            MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
            List <Customer>   listCustomers     = customerData.getAllCustomers(mongoDBConnection.getMongoData());

            dataGridViewCustomer.Rows.Clear();
            dataGridViewCustomer.Refresh();
            for (int i = 0; i < listCustomers.Count; i++)
            {
                dataGridViewCustomer.Rows.Add(new object[] { i + 1, listCustomers[i].name, listCustomers[i].phoneNumber, listCustomers[i].address,
                                                             listCustomers[i].createDate.ToLocalTime().ToString("dd/MM/yyyy"), listCustomers[i].modifyDate.ToLocalTime().ToString("dd/MM/yyyy"), listCustomers[i].isActive, listCustomers[i]._id });
            }
            for (int i = 0; i < dataGridView.ColumnCount; i++)
            {
                dataGridView.Columns[i].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
            }
        }
Esempio n. 17
0
        static void Main(string[] args)
        {
            var con = new MongoDBConnection("Server=127.0.0.1;Port=27017;Database=cdactraining;");
            var cmd = new MongoDBCommand("SELECT * FROM employees", con);

            try
            {
                con.Open();
                var reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    Console.WriteLine(reader["empName"]);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
Esempio n. 18
0
        private void btnAddUser_Click(object sender, EventArgs e)
        {
            String username = txtUserName.Text.Trim();
            String password = txtPassword.Text.Trim();

            if (String.IsNullOrEmpty(username) && String.IsNullOrEmpty(password))
            {
                MessageBox.Show("Please enter your username and passowrd.", "Message");
            }
            else if (String.IsNullOrEmpty(username))
            {
                MessageBox.Show("Please enter your username.", "Message");
            }
            else if (String.IsNullOrEmpty(password))
            {
                MessageBox.Show("Please enter your passowrd.", "Message");
            }
            else
            {
                User newUser = new User();
                newUser.userName   = username;
                newUser.passWord   = newUser.getMD5(password);
                newUser.createDate = DateTime.Now.ToUniversalTime();
                newUser.active     = ckcActive.Checked;
                try
                {
                    MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
                    newUser.addUser(mongoDBConnection.getMongoData(), newUser);
                    MessageBox.Show("New user is added successfully.", "Message");
                    txtUserName.Clear();
                    txtPassword.Clear();
                    if (ckcActive.Checked)
                    {
                        ckcActive.Checked = false;
                    }
                    this.displayDataTableUser(dataGridViewUser);
                }
                catch (Exception)
                {
                    MessageBox.Show("Failed to add new user. Please try again.", "Message");
                }
            }
        }
Esempio n. 19
0
 private void btnDeleteCustomer_Click(object sender, EventArgs e)
 {
     if (!String.IsNullOrEmpty(selectedCustomer))
     {
         if (String.IsNullOrEmpty(txtName.Text) || String.IsNullOrEmpty(txtPhoneNumber.Text) || String.IsNullOrEmpty(txtAddress.Text))
         {
             MessageBox.Show("Please select the customer to delete.", "Message");
         }
         else
         {
             try
             {
                 MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
                 Customer          deleteCustomer    = new Customer();
                 deleteCustomer.deleteCustomer(mongoDBConnection.getMongoData(), selectedCustomer);
                 MessageBox.Show("Customer is deleted successfully . Please try again.", "Message");
                 selectedCustomer = String.Empty;
                 txtName.Clear();
                 txtPhoneNumber.Clear();
                 txtAddress.Clear();
                 if (ckcActiveCustomer.Checked)
                 {
                     ckcActiveCustomer.Checked = false;
                 }
                 this.displayDataTableCustomer(dataGridViewCustomer);
                 this.loadValueCustomerCombobox(cbbCustomer);
             }
             catch (Exception)
             {
                 MessageBox.Show("Failed to delete the customer. Please try again.", "Message");
             }
         }
     }
     else
     {
         MessageBox.Show("Please select the customer to delete.", "Message");
     }
 }
Esempio n. 20
0
 /// <summary>
 /// To get the mongo db connection
 /// </summary>
 /// <param name="dataBaseName">The database name.</param>
 /// <returns>A Mongo Database</returns>
 private MongoDatabase GetMyDiaryMongoDbConnection(string dataBaseName)
 {
     return(MongoDBConnection.Get("mongodb://localhost", dataBaseName));
 }
Esempio n. 21
0
 public static WriteConcernResult Delete(MongoDBConnection db, string id)
 {
     return db.Comments.Remove(Query.EQ("_id", id));
 }
Esempio n. 22
0
 public static IEnumerable<Comment> Get(MongoDBConnection db, string uid)
 {
     return db.Comments.FindAll().Where(i => i.CreatedByUID == uid);
 }
Esempio n. 23
0
        private void Login_Click(object sender, EventArgs e)
        {
            String username = txtUserName.Text.Trim();
            String password = txtPassword.Text.Trim();


            if (String.IsNullOrEmpty(username) && String.IsNullOrEmpty(password))
            {
                MessageBox.Show("Please enter your username and passowrd.", "Message");
            }
            else if (String.IsNullOrEmpty(username))
            {
                MessageBox.Show("Please enter your username.", "Message");
            }
            else if (String.IsNullOrEmpty(password))
            {
                MessageBox.Show("Please enter your passowrd.", "Message");
            }
            else
            {
                MongoDBConnection mongoDBConnection = null;
                try
                {
                    mongoDBConnection = MongoDBConnection.getMongoConnection;
                    Console.WriteLine(mongoDBConnection);
                    IMongoDatabase mongoDatabase = mongoDBConnection.getMongoData();

                    User loginUser = new User();
                    //{
                    //    userName = "******",
                    //    passWord = "******",
                    //    createDate = DateTime.Now.ToUniversalTime()
                    //};
                    loginUser = loginUser.findUserByName(username, mongoDatabase);
                    if (null != loginUser)
                    {
                        if (loginUser.passWord.Equals(loginUser.getMD5(password)))
                        {
                            if (!loginUser.active)
                            {
                                MessageBox.Show("Your username is inactive. Please try again.", "Message");
                                txtUserName.Clear();
                                txtPassword.Clear();
                            }
                            else
                            {
                                Console.WriteLine(loginUser.createDate.ToLocalTime().ToString());

                                this.Hide();
                                var form = new Form2();
                                form.Show();
                            }
                        }
                        else
                        {
                            MessageBox.Show("Your password is incorrect. Please try again.", "Message");
                            txtPassword.Clear();
                        }
                    }
                    else
                    {
                        MessageBox.Show("Your username is incorrect. Please try again.", "Message");
                        txtUserName.Clear();
                        txtPassword.Clear();
                    };
                } catch (TimeoutException e1)
                {
                    MessageBox.Show("Please check your connection again.", "Message");
                    Console.WriteLine(e1.ToString());
                }
            }
        }
Esempio n. 24
0
 public MongoDBTransaction(IClientSessionHandle clientSessionHandle, MongoDBConnection mongoDBConnection)
 {
     _clientSessionHandle = clientSessionHandle;
     _mongoDBConnection   = mongoDBConnection;
 }
Esempio n. 25
0
        //public static WriteConcernResult Create(MongoDBConnection db, SetterComment SetterComment)
        //{
        //    // TODO
        //}
        public static Comment IsUniqueComment(MongoDBConnection db, SetterComment SetterComment)
        {
            if (db.Comments.Count() > 0)
            {
                return db.Comments.FindOne(Query<Comment>.Where(i => i.PostId == SetterComment.PostId && (i.PostId == SetterComment.PostId && i.CreatedByUID == SetterComment.CreatedByUID)));
            }

            return null;
        }
Esempio n. 26
0
        private void UpdateAccessTime(AssetBase asset)
        {

            using (MongoDBConnection dbcon = new MongoDBConnection(m_connectionString))
            {
                dbcon.Open();

                using (MongoDBCommand cmd
                    = new MongoDBCommand("update assets set access_time=?access_time where id=?id", dbcon))
                {
                    try
                    {
                        using (cmd)
                        {
                            // create unix epoch time
                            int now = (int)Utils.DateTimeToUnixTime(DateTime.UtcNow);
                            cmd.Parameters.AddWithValue("?id", asset.ID);
                            cmd.Parameters.AddWithValue("?access_time", now);
                            cmd.ExecuteNonQuery();
                        }
                    }
                    catch (Exception e)
                    {
                        m_log.Error(
                            string.Format(
                                "[ASSETS DB]: Failure updating access_time for asset {0} with name {1}.  Exception  ", 
                                asset.FullID, asset.Name), 
                            e);
                    }
                }
            }
        }
Esempio n. 27
0
        /// <summary>
        /// Check if the assets exist in the database.
        /// </summary>
        /// <param name="uuidss">The assets' IDs</param>
        /// <returns>For each asset: true if it exists, false otherwise</returns>
        public override bool[] AssetsExist(UUID[] uuids)
        {
            if (uuids.Length == 0)
                return new bool[0];

            HashSet<UUID> exist = new HashSet<UUID>();

            string ids = "'" + string.Join("','", uuids) + "'";
            string sql = string.Format("SELECT id FROM assets WHERE id IN ({0})", ids);

            using (MongoDBConnection dbcon = new MongoDBConnection(m_connectionString))
            {
                dbcon.Open();
                using (MongoDBCommand cmd = new MongoDBCommand(sql, dbcon))
                {
                    using (MongoDBDataReader dbReader = cmd.ExecuteReader())
                    {
                        while (dbReader.Read())
                        {
                            UUID id = DBGuid.FromDB(dbReader["id"]);
                            exist.Add(id);
                        }
                    }
                }
            }

            bool[] results = new bool[uuids.Length];
            for (int i = 0; i < uuids.Length; i++)
                results[i] = exist.Contains(uuids[i]);

            return results;
        }
Esempio n. 28
0
        /// <summary>
        /// Returns a list of AssetMetadata objects. The list is a subset of
        /// the entire data set offset by <paramref name="start" /> containing
        /// <paramref name="count" /> elements.
        /// </summary>
        /// <param name="start">The number of results to discard from the total data set.</param>
        /// <param name="count">The number of rows the returned list should contain.</param>
        /// <returns>A list of AssetMetadata objects.</returns>
        public override List<AssetMetadata> FetchAssetMetadataSet(int start, int count)
        {
            List<AssetMetadata> retList = new List<AssetMetadata>(count);

            using (MongoDBConnection dbcon = new MongoDBConnection(m_connectionString))
            {
                dbcon.Open();

                using (MongoDBCommand cmd
                    = new MongoDBCommand(
                        "SELECT name,description,assetType,temporary,id,asset_flags,CreatorID FROM assets LIMIT ?start, ?count",
                        dbcon))
                {
                    cmd.Parameters.AddWithValue("?start", start);
                    cmd.Parameters.AddWithValue("?count", count);

                    try
                    {
                        using (MongoDBDataReader dbReader = cmd.ExecuteReader())
                        {
                            while (dbReader.Read())
                            {
                                AssetMetadata metadata = new AssetMetadata();
                                metadata.Name = (string)dbReader["name"];
                                metadata.Description = (string)dbReader["description"];
                                metadata.Type = (sbyte)dbReader["assetType"];
                                metadata.Temporary = Convert.ToBoolean(dbReader["temporary"]); // Not sure if this is correct.
                                metadata.Flags = (AssetFlags)Convert.ToInt32(dbReader["asset_flags"]);
                                metadata.FullID = DBGuid.FromDB(dbReader["id"]);
                                metadata.CreatorID = dbReader["CreatorID"].ToString();

                                // Current SHA1s are not stored/computed.
                                metadata.SHA1 = new byte[] { };

                                retList.Add(metadata);
                            }
                        }
                    }
                    catch (Exception e)
                    {
                        m_log.Error(
                            string.Format(
                                "[ASSETS DB]: MongoDB failure fetching asset set from {0}, count {1}.  Exception  ", 
                                start, count), 
                            e);
                    }
                }
            }

            return retList;
        }
Esempio n. 29
0
        public override bool Delete(string id)
        {
            using (MongoDBConnection dbcon = new MongoDBConnection(m_connectionString))
            {
                dbcon.Open();

                using (MongoDBCommand cmd = new MongoDBCommand("delete from assets where id=?id", dbcon))
                {
                    cmd.Parameters.AddWithValue("?id", id);
                    cmd.ExecuteNonQuery();
                }
            }

            return true;
        }
Esempio n. 30
0
        private void btnUpdateOrderTruck_Click(object sender, EventArgs e)
        {
            String customerName = "";
            String materialType = "";
            String note         = txtNote.Text.Trim();

            if (cbbCustomer.SelectedIndex < 0)
            {
                MessageBox.Show("Please select the customer's name to update order truck.", "Message");
            }
            else if (cbbMaterialType.SelectedIndex < 0)
            {
                MessageBox.Show("Please select the material type to update order truck.", "Message");
            }
            else if (String.IsNullOrEmpty(txtSubTotal.Text.Trim()))
            {
                MessageBox.Show("Please input the subtotal to update order truck.", "Message");
            }
            //else if (dateTPCompletedDay.CustomFormat == " ")
            //{
            //    MessageBox.Show("Please select the completed day to update order truck.", "Message");
            //}
            else
            {
                if (!String.IsNullOrEmpty(selectedOrderTruck))
                {
                    try
                    {
                        MongoDBConnection mongoDBConnection = MongoDBConnection.getMongoConnection;
                        OrderTruck        currentOrderTruck = new OrderTruck();
                        OrderTruck        updatedOrderTruck = new OrderTruck();
                        Customer          updatedCustomer   = new Customer();
                        currentOrderTruck              = currentOrderTruck.getOrderTruckByID(mongoDBConnection.getMongoData(), selectedOrderTruck);
                        updatedOrderTruck.customer     = updatedCustomer.findCustomerByName(cbbCustomer.SelectedItem.ToString(), mongoDBConnection.getMongoData());
                        updatedOrderTruck.materialType = cbbMaterialType.SelectedItem.ToString().Trim();
                        updatedOrderTruck.note         = txtNote.Text.Trim();
                        updatedOrderTruck.subtotal     = int.Parse(txtSubTotal.Text.Trim());
                        if (dateTPCompletedDay.CustomFormat == " ")
                        {
                            updatedOrderTruck.completedDate = currentOrderTruck.completedDate;
                        }
                        else
                        {
                            updatedOrderTruck.completedDate = dateTPCompletedDay.Value.ToUniversalTime();
                        }
                        updatedOrderTruck.modifyDate = DateTime.Now.ToUniversalTime();
                        updatedOrderTruck.isPaid     = ckcIsPaid.Checked;
                        updatedOrderTruck.updateOrderTruck(mongoDBConnection.getMongoData(), currentOrderTruck, updatedOrderTruck);
                        MessageBox.Show("The order truck is updated successfully.", "Message");
                        selectedOrderTruck = String.Empty;
                        this.clearOrderTruckTab();
                        this.displayDataTableOrderTruck(dataGridViewOrderTruck);
                        this.loadValueCustomeFilterCombobox(cbbSearchCustomer);
                        this.loadValueFilterMaterialTypeCombobox(cbbSearchMaterialType);
                        this.resetFilterValue();
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("Failed to update the selected order truck. Please try again.", "Message");
                    }
                }
                else
                {
                    MessageBox.Show("Please select the order truck to update.", "Message");
                }
            }
        }
 public MongoDBUnitofWork(IConnection _conn)
 {
     _MongoDBConn = (MongoDBConnection)_conn;
 }