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")); }
public async Task <IActionResult> UpdateDeviceStatus(string id, [FromBody] SirmotoDevices sirmoto) { 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].UserId != usr.Id) { return(Forbid("[ERRO] Access denied")); } device[0].Description = (String.IsNullOrEmpty(sirmoto.Description)) ? device[0].Description : sirmoto.Description; device[0].DeviceInfo = (String.IsNullOrEmpty(sirmoto.DeviceName)) ? device[0].DeviceInfo : sirmoto.DeviceName; device[0].DeviceName = (String.IsNullOrEmpty(sirmoto.DeviceName)) ? device[0].DeviceName : sirmoto.DeviceName; device[0].DeviceState = (String.IsNullOrEmpty(sirmoto.DeviceState)) ? device[0].DeviceState : sirmoto.DeviceState; if (device[0] == null) { return(NotFound("[WARN] Device not found")); } else { dbContext.Update(sirmoto); } return(new ObjectResult(JsonConvert.SerializeObject(device[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))); } }
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(); }
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")); }
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()); }
public async Task <IActionResult> GetDeviceById(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 == null) { System.Diagnostics.Debug.WriteLine("LOLL" + id); return(NotFound("[WARN] Device not found")); } else { device[0].LastUpdated = DateTime.UtcNow; dbContext.Update(device[0]); dbContext.SaveChanges(); return(new ObjectResult(JsonConvert.SerializeObject(device[0]))); } }