Example #1
0
        public async Task <IActionResult> TransactionFinalise(string id, [FromBody] Transactions transactionUpdate)
        {
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var user = await dbContext.AspNetUsers.Where(z => z.Id == usr.Id).ToListAsync();

            var transaction = await dbContext.Transactions.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            if (transaction[0] == null)
            {
                return(NotFound("Transaction is not found"));
            }
            if (transaction[0].UserId != user[0].Id)
            {
                return(Forbid("Access Denied"));
            }
            if (transaction[0].State == "FINAL")
            {
                transaction[0].State         = "DONE";
                transaction[0].PaymentMethod = transactionUpdate.PaymentMethod;
                transaction[0].TimeStamp     = DateTime.Now;
                dbContext.Update(transaction[0]);
                await dbContext.SaveChangesAsync();

                ResetEmployees(transaction[0]);
                return(new ObjectResult(transaction[0]));
            }
            return(NotFound("Transaction is not ready"));
        }
Example #2
0
        public async Task <IActionResult> FindCompanyForTransaction(string id)
        {
            var random    = new Random();
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var user = await dbContext.AspNetUsers.Where(z => z.Id == usr.Id).ToListAsync();

            if (user[0] == null)
            {
                return(NotFound("User not found"));
            }
            var transaction = await dbContext.Transactions.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            if (transaction[0].State == "PRODUCT_ADDED")
            {
                transaction[0].State     = "FIND_COMPANY";
                transaction[0].TimeStamp = DateTime.Now;
                //transaction[0].Company = FindCompany();
                dbContext.Transactions.Update(transaction[0]);
                await dbContext.SaveChangesAsync();

                dynamic result = new ExpandoObject();

                result.Transaction = transaction[0];
                result.Resource    = "Transaction/GetTransactionById/" + transaction[0].Id;
                return(new ObjectResult(JsonConvert.SerializeObject(result)));
            }
            return(Forbid());
        }
Example #3
0
        public async Task <IActionResult> CompanyRejectForTransaction(string id)
        {
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var user = await dbContext.AspNetUsers.Where(z => z.Id == usr.Id).ToListAsync();

            if (user[0].Companies == null)
            {
                return(NotFound("User is a not company"));
            }
            var transaction = await dbContext.Transactions.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            if (transaction[0].State == "FIND_COMPANY")
            {
                transaction[0].TimeStamp = DateTime.Now;
                transaction[0].State     = "FIND_COMPANY";
                transaction[0].Company   = await FindCompany(transaction[0], user[0].Companies);

                dbContext.Transactions.Update(transaction[0]);
                await dbContext.SaveChangesAsync();

                dynamic result = new ExpandoObject();

                result.Transaction = transaction[0];
                result.Resource    = "Transaction/GetTransactionById/" + transaction[0].Id;
                return(new ObjectResult(JsonConvert.SerializeObject(result)));
            }
            return(NotFound("Not yet added a product"));
        }
Example #4
0
        public async Task <IActionResult> BeginTransaction([FromBody] Transactions input)
        {
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var user = await dbContext.AspNetUsers.Where(z => z.Id == usr.Id).ToListAsync();

            if (user[0] == null)
            {
                return(NotFound("User not found"));
            }
            var transaction = new Transactions()
            {
                Id = GenerateRandomInt(), State = "BEGIN", UserId = user[0].Id
            };

            transaction.Location      = input.Location;
            transaction.TimeStamp     = DateTime.Now;
            transaction.Discount      = 0;
            transaction.CompanyId     = 0;
            transaction.PaymentMethod = "Nothing";
            dbContext.Transactions.Add(transaction);
            await dbContext.SaveChangesAsync();

            dynamic result = new ExpandoObject();

            result.Transaction = transaction;
            result.Resource    = "Transaction/GetTransactionById/" + transaction.Id;
            return(new ObjectResult(JsonConvert.SerializeObject(result)));
        }
Example #5
0
        public async Task <IActionResult> AddNewSchedule(string id, string data)
        {
            var dbContext = new sirmotoContext();
            SirmotoDeviceSchedule schedule;

            try{
                schedule = JsonConvert.DeserializeObject <SirmotoDeviceSchedule>(data);
            }
            catch (Exception e)
            {
                return(BadRequest("Bad json data: " + data));
            }
            if (dbContext.SirmotoDevices.Where(z => z.Id == Int32.Parse(id)).Count() == 0)
            {
                return(NotFound("Device not found"));
            }
            schedule.Id       = GenerateRandomInt();
            schedule.DeviceId = Int32.Parse(id);
            dbContext.SirmotoDeviceSchedule.Add(schedule);
            await dbContext.SaveChangesAsync();

            dynamic result = new ExpandoObject();

            result.Schedule = schedule;
            result.Location = "Device/GetScheduleById/" + id;
            return(new ObjectResult(result));
        }
Example #6
0
        public async Task <IActionResult> AddProduct(string id, [FromBody] PickedUpProducts[] products)
        {
            var randomnum = new Random().Next();
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var user = await dbContext.AspNetUsers.Where(z => z.Id == usr.Id).ToListAsync();

            var transaction = await dbContext.Transactions.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            if (transaction.Count == 0)
            {
                return(NotFound("Transaction not found"));
            }
            else if (transaction[0].UserId != user[0].Id)
            {
                return(Forbid());
            }
            else if (transaction[0].State != "BEGIN")
            {
                return(Forbid());
            }
            else
            {
                foreach (var item in products)
                {
                    item.Id            = GenerateRandomInt();
                    item.TransactionId = Int32.Parse(id);
                    var product = await dbContext.Products.Where(z => z.Id == item.ProductId).ToListAsync();

                    if (product[0] == null)
                    {
                        return(BadRequest("Product item not found: " + item.ProductId));
                    }
                    var getproductType = await dbContext.Products.Where(z => z.Id == item.ProductId).ToListAsync();

                    var productType = getproductType[0].Type;
                    if (productType == "LAYANAN")
                    {
                        item.Quantity = 1;
                        //item.HitCount++;
                        //dbContext.Update(layanan[0]);
                    }
                    transaction[0].PickedUpProducts.Add(item);
                }
                transaction[0].State = "PRODUCT_ADDED";
                dbContext.Update(transaction[0]);
                await dbContext.SaveChangesAsync();

                dynamic result = new ExpandoObject();

                result.Transaction = transaction;
                result.Resource    = "Transaction/GetTransactionById/" + transaction[0].Id;
                return(new ObjectResult(JsonConvert.SerializeObject(result)));
            }
        }
Example #7
0
        private async void ResetEmployees(Transactions transactions)
        {
            var dbContext = new sirmotoContext();
            var list      = await dbContext.Employees.Where(w => w.CompanyId == transactions.CompanyId).ToListAsync();

            foreach (var item in list)
            {
                item.State = "IDLE";
                dbContext.Update(item);
            }
            await dbContext.SaveChangesAsync();
        }
Example #8
0
        public async Task <IActionResult> RemoveSchedule(string id)
        {
            var dbContext = new sirmotoContext();
            var schedule  = await dbContext.SirmotoDeviceSchedule.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            if (schedule.Count == 0)
            {
                return(NotFound("Device not found"));
            }
            else
            {
                dbContext.SirmotoDeviceSchedule.Remove(schedule[0]);
                await dbContext.SaveChangesAsync();
            }
            return(new ObjectResult("[INFO] Unregistered schedule no " + id));
        }
Example #9
0
        public async Task <IActionResult> CompanyAcceptForTransaction(string id)
        {
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var user = await dbContext.AspNetUsers.Where(z => z.Id == usr.Id).ToListAsync();

            var company = await dbContext.Companies.Where(z => z.UserId == user[0].Id).ToListAsync();

            if (company.Count == 0)
            {
                return(NotFound("User is a not company"));
            }
            var transaction = await dbContext.Transactions.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            if (transaction[0].State == "COMPANY_ADDED")
            {
                transaction[0].TimeStamp = DateTime.Now;
                if (company[0].Employees.Count == 0)
                {
                    return(BadRequest());
                }
                transaction[0].State = "FINAL";
                //var company1 = dbContext.Companies.Where(z => z.UserId == user[0].Id ).ToArray();
                var employess = await AssembleEmployees(transaction[0], company[0]);

                foreach (var item in employess)
                {
                    transaction[0].PickedUpEmployees.Add(new PickedUpEmployees {
                        Id            = GenerateRandomInt(),
                        EmployeeId    = item.Id,
                        TransactionId = transaction[0].Id
                    });
                }
                //transaction[0].PickedUpEmployees = ;
                dbContext.Transactions.Update(transaction[0]);
                await dbContext.SaveChangesAsync();

                dynamic result = new ExpandoObject();

                result.Transaction = transaction[0];
                result.Resource    = "Transaction/GetTransactionById/" + transaction[0].Id;
                return(new ObjectResult(JsonConvert.SerializeObject(result)));
            }
            return(NotFound("Not assigned to a company yet"));
        }
Example #10
0
        public async Task <IActionResult> SendSiramCommand(string id)
        {
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var usrId  = usr.Id;
            var device = await dbContext.SirmotoDevices.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            if (device[0] == null)
            {
                return(NotFound("[WARN] Device not found"));
            }
            else
            {
                device[0].DeviceInfo = "STATE_WATERING_ONDEMAND";
                dbContext.Update(device[0]);
                await dbContext.SaveChangesAsync();
            }
            return(new ObjectResult("done"));
        }
Example #11
0
        private async Task <Employees[]> AssembleEmployees(Transactions transaction, Companies company)
        {
            var dbContext    = new sirmotoContext();
            var transactions = dbContext.Transactions
                               .Include(t => t.PickedUpProducts);
            var count             = 1;
            var previousItemQuery = await dbContext.PickedUpProducts.Where(w => w.TransactionId == transaction.Id).ToListAsync();

            var previousItem = previousItemQuery[0];

            foreach (var item in previousItemQuery)
            {
                var product = dbContext.Products.Where(z => z.Id == item.ProductId).ToArray()[0];
                if (product.RequiredWorker == 1 && transaction.PickedUpProducts.Count < 4)
                {
                    continue;
                }
                else if (product.RequiredWorker < 3 && transaction.PickedUpProducts.Count < 4)
                {
                    count += 1;
                }
                else if (product.RequiredWorker < 5 && transaction.PickedUpProducts.Count < 5)
                {
                    count += 2;
                }
                previousItem = item;
            }
            var employess     = dbContext.Employees.Where(z => z.State == "IDLE" && z.CompanyId == company.Id);
            var employeeslist = await employess.ToArrayAsync();

            count = (employess.Count() < count) ? employess.Count() : count;
            for (int i = 0; i < count; i++)
            {
                employeeslist[i].State = "WORKING";
                dbContext.Update(employeeslist[i]);
            }

            await dbContext.SaveChangesAsync();

            return(employess.Take(count).ToArray());
        }
Example #12
0
        public async Task <IActionResult> RegisterDevice([FromBody] SirmotoDevices data)
        {
            var random    = new Random();
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var user = await dbContext.AspNetUsers.Where(z => z.Email == usr.Email).ToListAsync();

            data.Description = "None";
            data.Id          = random.Next();
            data.UserId      = usr.Id;
            data.DeviceInfo  = "READY";
            data.LastUpdated = DateTime.Now;
            dbContext.SirmotoDevices.Add(data);
            await dbContext.SaveChangesAsync();

            dynamic result = new ExpandoObject();

            result.Sirmoto  = data;
            result.Resource = "Device/GetDeviceById/" + data.Id;
            return(new ObjectResult(JsonConvert.SerializeObject(result)));
        }
Example #13
0
        public async Task <IActionResult> GetCompanyForTransaction(string id)
        {
            var random    = new Random();
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var user = await dbContext.AspNetUsers.Where(z => z.Id == usr.Id).ToListAsync();

            if (user[0] == null)
            {
                return(NotFound("User not found"));
            }
            var transaction = await dbContext.Transactions.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            var transactionToProcess = transaction[0];

            if (transaction[0].State == "FIND_COMPANY")
            {
                var company = await FindCompany(transaction[0]);

                if (company == null)
                {
                    return(BadRequest("No company is available"));
                }
                transaction[0].State     = "COMPANY_ADDED";
                transaction[0].TimeStamp = DateTime.Now;
                transaction[0].CompanyId = company.Id;
                dbContext.Transactions.Update(transaction[0]);
                await dbContext.SaveChangesAsync();

                dynamic result = new ExpandoObject();

                result.Transaction = transaction[0];
                result.Resource    = "Transaction/GetTransactionById/" + transaction[0].Id;
                return(new ObjectResult(JsonConvert.SerializeObject(result)));
            }
            return(NotFound("Not assigned to a company yet"));
        }
Example #14
0
        public async Task <IActionResult> Unregister(string id)
        {
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var usrId  = usr.Id;
            var device = await dbContext.SirmotoDevices.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            if (device.Count == 0)
            {
                return(NotFound("[WARN] Device not found"));
            }
            else if (device[0].UserId != usr.Id)
            {
                return(Forbid("[ERRO] Access denied"));
            }
            else
            {
                dbContext.Remove(device[0]);
                await dbContext.SaveChangesAsync();
            }
            return(new ObjectResult("[INFO] Unregistered devie no " + id));
        }
Example #15
0
        public async Task <IActionResult> DeleteTrans(string id)
        {
            var dbContext = new sirmotoContext();
            var usr       = await GetCurrentUserAsync();

            var usrId        = usr.Id;
            var transactions = await dbContext.Transactions.Where(z => z.Id == Int32.Parse(id)).ToListAsync();

            if (transactions[0] == null)
            {
                return(NotFound("Transaction not found"));
            }
            else if (transactions[0].State != "DONE" || transactions[0].State != "FINAL")
            {
                dbContext.Remove(transactions[0]);
                await dbContext.SaveChangesAsync();

                return(new ObjectResult("Cancelled transaction id " + id));
            }
            else
            {
                return(Forbid("Transaction cannot be cancelled, id " + id));
            }
        }