public int updateCost(Batch batch) { SSGetService getService = new SSGetService(); SSAddService addService = new SSAddService(); Batch existingBatch = getService.getBatchByName(batch.name); if (existingBatch.name != null) { using (SqlCommand command = new SqlCommand("UPDATE ss_stocks SET cost=@cost WHERE bid=" + existingBatch.id + "")) { command.Parameters.AddWithValue("@cost", batch.cost); int response = service.execute(command); if (response > 0) { addService.addLog(new Log() { type = "Updated Cost", statement = command.CommandText, description = "Updated [" + existingBatch.id + "] Batch", }); } return(response); } } else { return(-404); } }
public int updatePrice(Product product) { SSGetService getService = new SSGetService(); SSAddService addService = new SSAddService(); Product existingProduct = getService.getProductByName(product.name); if (existingProduct.name != null) { using (SqlCommand command = new SqlCommand("UPDATE ss_products SET price=@price WHERE id=" + existingProduct.id + "")) { command.Parameters.AddWithValue("@price", product.price); int response = service.execute(command); if (response > 0) { addService.addLog(new Log() { type = "Updated Price", statement = command.CommandText, description = "Updated [" + existingProduct.id + "] Product", }); } return(response); } } else { return(-404); } }
public int updateDebtorBalance(Debtor debtor) { SSGetService getService = new SSGetService(); SSAddService addService = new SSAddService(); Debtor existingDebtor = getService.getDebtorByIdEvenIfZero(debtor.cid); if (existingDebtor.name != null) { using (SqlCommand command = new SqlCommand("UPDATE ss_debtors SET amount=@balance,last_modified_date=getdate() WHERE cid=" + existingDebtor.cid + "")) { command.Parameters.AddWithValue("@balance", debtor.amount); int response = service.execute(command); if (response > 0) { addService.addLog(new Log() { type = "Updated customer debit balance to " + debtor.amount, statement = command.CommandText, description = "Updated [" + existingDebtor.cid + "] Debit Amount", }); } return(response); } } else { return(-404); } }
public int updateCustomerBalance(Customer customer) { SSGetService getService = new SSGetService(); SSAddService addService = new SSAddService(); Customer existingCustomer = getService.getCustomerById(customer.id); if (existingCustomer.name != null) { using (SqlCommand command = new SqlCommand("UPDATE ss_customers SET account_balance=@balance, last_modified_date=getdate() WHERE id=" + existingCustomer.id + "")) { command.Parameters.AddWithValue("@balance", customer.account_balance); int response = service.execute(command); if (response > 0) { addService.addLog(new Log() { type = "Updated customer balance", statement = command.CommandText, description = "Updated [" + existingCustomer.id + "] Customer", }); } return(response); } } else { return(-404); } }
public int updateLastLoginDate(User user) { SSGetService getService = new SSGetService(); SSAddService addService = new SSAddService(); using (SqlCommand command = new SqlCommand("UPDATE ss_users SET login_date=CURRENT_TIMESTAMP WHERE id=" + user.id + "")) { int response = service.execute(command); addService.addLog(new Log() { type = "User logged in", statement = user.username, description = "User logged in " + user.name, }); return(response); } }
public int updateBatchBalance(Batch batch) { SSGetService getService = new SSGetService(); SSAddService addService = new SSAddService(); using (SqlCommand command = new SqlCommand("UPDATE ss_batches SET balance=@balance, sold=@sold WHERE id=" + batch.id + "")) { command.Parameters.AddWithValue("@balance", batch.balance); command.Parameters.AddWithValue("@sold", batch.sold); int response = service.execute(command); if (response > 0) { addService.addLog(new Log() { type = "Updated batch balance", statement = command.CommandText, description = "Updated [" + batch.id + "] Batch", }); } return(response); } }
public int addBusiness(Business business) { SSGetService getService = new SSGetService(); SSAddService addService = new SSAddService(); SSRemoteService remoteService = new SSRemoteService(); SSUpdateService updateService = new SSUpdateService(); //Business existingBusiness = getService.getBusinessByName(business.business_name); //if (existingBusiness.name == null) //{ // Key key = remoteService.getProductKey(business.product_key); // if (key.product_key != null) // { // if (key.status == "PA") // { business.status = "AC"; //update remote productKet status //done using (SqlCommand command = new SqlCommand("INSERT INTO ss_business(name,motto,address,telephone,email_address,product_key,machine_name,status,logo)VALUES(@name,@motto,@address,@telephone,@email_address,@product_key,@machine_name,@status,@logo)")) { command.Parameters.AddWithValue("@name", business.business_name); command.Parameters.AddWithValue("@motto", business.motto.ToString().ToUpper()); command.Parameters.AddWithValue("@address", business.address); command.Parameters.AddWithValue("@telephone", business.telephone); command.Parameters.AddWithValue("@email_address", business.email_address); command.Parameters.AddWithValue("@product_key", business.product_key); command.Parameters.AddWithValue("@machine_name", business.machine_name); command.Parameters.AddWithValue("@status", business.status); if (business.logo != null) { command.Parameters.Add("@logo", SqlDbType.Image, business.logo.Length).Value = business.logo; } int response1 = service.execute(command); int response2 = 1; //service.remoteExecute(command); if (response1 > 0 && response2 > 0) { Business currentBusiness = getService.getBusinessByName(business.business_name); if (currentBusiness.business_name != null) { //register admin user User user = new User() { bid = currentBusiness.id, name = business.name, username = business.username, password = business.password, mobile_number = business.telephone, role = "All", }; if (business.logo != null) { user.picture = business.logo; } int res = addService.addUser(user); if (res > 0) { this.addLog(new Log() { type = "Add Business", statement = command.CommandText, description = "Added Business" + business.business_name, }); return(res); } else { return(-1); } } else { return(-2); } } else { return(-3); } } // } // else // { // return 201; // } // } // else // { // return -404; // } //} //else //{ // return -200; //} }