private void loadCustomers() { DataTable data = getService.getDataWithFilter(app.objects["customers"], "CONVERT(VARCHAR(10), created_date, 111) BETWEEN '" + range.from.Date.ToString("yyyy/MM/dd") + "' AND '" + range.to.Date.ToString("yyyy/MM/dd") + "'"); if (data.Rows.Count > 0) { customerGridView.DataSource = data; } }
private void loadAjustments() { DataTable data = getService.getDataWithFilter(app.objects["adjustments"], "CONVERT(VARCHAR(10), transaction_date, 111) BETWEEN '" + range.from.Date.ToString("yyyy/MM/dd") + "' AND '" + range.to.Date.ToString("yyyy/MM/dd") + "'"); if (data.Rows.Count > 0) { adjustmentsGridView.DataSource = data; } }
private void loginButton_Click(object sender, EventArgs e) { try { User user = new User() { username = loginIDField.Text, password = loginPasswordField.Text, }; if (user.username == "" || user.username == "Username") { app.notifyTo(statusLabel, "Enter your username", "warning"); } else if (user.password == "" || user.password == "Password") { app.notifyTo(statusLabel, "Enter your Password", "warning"); } if (user.username != "" && user.username != "Username" && user.password != "" && user.password != "Password") { DataTable response = getService.getDataWithFilter(app.objects["users"], "username='******' and password='******'"); if (response.Rows.Count > 0) { DataRow row = response.Rows[0]; user.id = row.Field <int>("id"); user.name = row.Field <string>("name"); user.role = row.Field <string>("role"); user.bid = row.Field <int>("bid"); updateService.updateLastLoginDate(user); userlog(user.username); app.setSession(user); app.redirect(this, new Dashboard()); } else { app.notifyTo(statusLabel, "Invalid Username or Password!", "error"); } } } catch (Exception ex) { app.showError(ex.Message); } }
private void refreshCutsomerBalance(string name) { DataTable data = getService.getDataWithFilter(app.objects["debtors"], " name ='" + name + "'"); if (data.Rows.Count > 0) { int balance = data.Rows[0].Field <int>("amount"); if (balance == 0) { totalBalanceLabel.Text = "0.00"; } else { totalBalanceLabel.Text = app.toMoneyOf(balance); } } else { totalBalanceLabel.Text = "0.00"; } accountBalancePanel.Show(); }
public int addStock(Stock stock) { SSGetService getService = new SSGetService(); SSUpdateService updateService = new SSUpdateService(); Product existingProduct = getService.getProductByName(stock.name); if (existingProduct.name != null) { Location existingLocation = getService.getLocationByName(stock.location); if (existingLocation.name != null) { string batchName; string batchFormat = DateTime.Now.ToString("MMyyyy"); DataTable batchData = getService.getDataWithFilter(app.objects["batches"], " name like '%" + batchFormat + "' order by created_date desc"); if (batchData.Rows.Count > 0) { DataRow row = batchData.Rows[0]; string name = row.Field <string>("name"); string val = name.Substring(name.IndexOf('B') + 1, name.IndexOf('-') - 1); if (app.isAllDigits(val)) { batchName = "B" + (int.Parse(val) + 1) + "-" + batchFormat; } else { batchName = ""; } } else { batchName = "B1-" + batchFormat; } string batchKey = app.generateId(20); if (batchName != null && batchName != "") { using (SqlCommand batchCommand = new SqlCommand("INSERT INTO ss_batches(name,reference_key,pid,total,balance,sold)VALUES(@name,@reference_key,@pid,@total,@balance,@sold)")) { batchCommand.Parameters.AddWithValue("@name", batchName); batchCommand.Parameters.AddWithValue("@reference_key", batchKey); batchCommand.Parameters.AddWithValue("@pid", existingProduct.id); batchCommand.Parameters.AddWithValue("@total", stock.quantity); batchCommand.Parameters.AddWithValue("@balance", stock.quantity); batchCommand.Parameters.AddWithValue("@sold", 0); int batchResponse = service.execute(batchCommand); if (batchResponse > 0) { Batch batch = getService.getBatchByKey(batchKey); if (batch.key != null) { using (SqlCommand command = new SqlCommand("INSERT INTO ss_stocks(pid,bid,quantity,cost,description,last_modified_date)VALUES(@pid,@bid,@quantity,@cost,@description, getdate())")) { command.Parameters.AddWithValue("@pid", existingProduct.id); command.Parameters.AddWithValue("@bid", batch.id); command.Parameters.AddWithValue("@quantity", stock.quantity); command.Parameters.AddWithValue("@cost", stock.cost); command.Parameters.AddWithValue("@description", stock.description); int response = service.execute(command); if (response > 0) { return(response); } else { return(-1); } } } else { return(-1); } } else { return(-402); } } } else { return(-500); } } else { return(-404); } } else { return(-403); } }
private void generatePaymentReceipt() { User session = app.getSession(); DataTable payment = getService.getDataWithFilter(app.objects["payments"], "id=" + tid); DataTable user = getService.getDataWithFilter(app.objects["users"], "id=" + session.id); DataTable customer = getService.getDataWithFilter(app.objects["customers"], "id=" + cid); DataTable business = getService.getDataWithFilter(app.objects["business"], "id=" + session.bid); DataTable debtor = getService.getDataWithFilter(app.objects["debtors"], "cid=" + cid); if (payment.Rows.Count > 0 && user.Rows.Count > 0 && business.Rows.Count > 0) { ReportDataSource paymentRDS = new ReportDataSource("payment", payment); ReportDataSource userRDS = new ReportDataSource("user", user); ReportDataSource customerRDS = new ReportDataSource("customer", customer); ReportDataSource businessRDS = new ReportDataSource("business", business); ReportDataSource debtorRDS = new ReportDataSource("debtor", debtor); this.reportViewer.LocalReport.DataSources.Clear(); this.reportViewer.LocalReport.DataSources.Add(paymentRDS); this.reportViewer.LocalReport.DataSources.Add(userRDS); this.reportViewer.LocalReport.DataSources.Add(customerRDS); this.reportViewer.LocalReport.DataSources.Add(businessRDS); this.reportViewer.LocalReport.DataSources.Add(debtorRDS); this.reportViewer.LocalReport.ReportPath = "../../PaymentReceipt.rdlc"; this.reportViewer.Refresh(); } else { app.showWarning("Unable to load the payment receipt, please logout->login and try again"); } }