private void BtnLogin_Click(object sender, RoutedEventArgs e) { if (!TxtUsername.Text.Equals(string.Empty) && !PbPassword.Password.Equals(string.Empty)) { try { using (SqlConnection conn = DBUtils.GetDBConnection()) { using (SqlDataAdapter da = new SqlDataAdapter("SELECT Code, Name, [Access Level] FROM Employees WHERE Password = '******' AND Code = '" + TxtUsername.Text + "'", conn)) { dt = new DataTable(); da.Fill(dt); } if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; User USER = new User(row["Code"].ToString(), int.Parse(row["Access Level"].ToString().Split('-')[0].Trim()), row["Name"].ToString()); owner.LoginSuccessful(USER); } else { LblError.Content = "User does not exist. Contact administrator for assistance"; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } else if (TxtUsername.Text.Equals(string.Empty) && PbPassword.Password.Equals(string.Empty)) { LblError.Content = "Username & Password can not be empty!"; } else if (TxtUsername.Text.Equals(string.Empty)) { LblError.Content = "Username can not be empty!"; } else if (PbPassword.Password.Equals(string.Empty)) { LblError.Content = "Password can not be empty!"; } }
private void GetExpenseCode() { dt = new DataTable(); int newCodeNum = 0; try { using (SqlConnection conn = DBUtils.GetDBConnection()) { conn.Open(); using (var da = new SqlDataAdapter("SELECT Code FROM Expenses", conn)) { da.Fill(dt); } } if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { string curCode = row["Code"].ToString().Trim(); int curCodeNum = int.Parse(curCode.Remove(0, 3)); if (curCodeNum > newCodeNum) { newCodeNum = curCodeNum; } } newCodeNum++; newCode = "EXP" + newCodeNum.ToString("00000"); } else { newCode = "EXP00001"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void LoadInvoices() { try { using (var conn = DBUtils.GetDBConnection()) { conn.Open(); var sql = string.Empty; if (USER.GetAccessLevel() == 1) { sql = "SELECT Date, Client, [Invoice Number], [Bill Amount (R)], [Drawing Fee (%)], [DF Amount (R)], [Commission Due (R)], Finalized, Paid FROM Invoices WHERE " + "Code = '" + USER.GetCode() + "'"; } else if (USER.GetAccessLevel() == 2) { if (!selectedEmpCode.Equals(string.Empty)) { sql = "SELECT Date, Client, [Invoice Number], [Bill Amount (R)], [Drawing Fee (%)], [DF Amount (R)], [Commission Due (R)], [Company Comm (R)], [Personal Comm (R)], " + "Finalized, Paid FROM Invoices WHERE " + "Code = '" + selectedEmpCode + "'"; } else { sql = "SELECT Date, Client, [Invoice Number], [Bill Amount (R)], [Drawing Fee (%)], [DF Amount (R)], [Commission Due (R)], [Company Comm (R)], [Personal Comm (R)], " + "Finalized, Paid FROM Invoices"; } } using (SqlDataAdapter da = new SqlDataAdapter(sql, conn)) { dt = new DataTable(); da.Fill(dt); } DGInvoice.ItemsSource = dt.DefaultView; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void LoadEmployees() { try { using (SqlConnection conn = DBUtils.GetDBConnection()) { conn.Open(); using (var da = new SqlDataAdapter("SELECT Code, Name FROM Employees", conn)) { dt = new DataTable(); da.Fill(dt); } DGEmployees.ItemsSource = dt.DefaultView; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void BtnDone_Click(object sender, RoutedEventArgs e) { if (!TxtInvoiceNumber.Text.Equals(string.Empty)) { StringBuilder sb = new StringBuilder().Append("Are you sure you want to continue?"); if (MessageBox.Show(sb.ToString(), "Confirmation", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { if (USER.GetAccessLevel() == 1 || (USER.GetAccessLevel() == 2 && selectedEmpCode.Equals(string.Empty))) { try { using (var conn = DBUtils.GetDBConnection()) { conn.Open(); using (var cmd = new SqlCommand("INSERT INTO Invoices VALUES (@Code, @Date, @Client, @InvNum, @BillAmount, @DrawFee, @DFAmount, @CommDue, @CompComm, @PersonalComm, @Finalized, @Paid)", conn)) { cmd.Parameters.AddWithValue("@Code", USER.GetCode()); cmd.Parameters.AddWithValue("@Date", DtpDate.SelectedDate.Value.Date); cmd.Parameters.AddWithValue("@Client", CbClient.SelectedItem.ToString().Split('-')[0].Trim()); cmd.Parameters.AddWithValue("@InvNum", TxtInvoiceNumber.Text.Trim()); cmd.Parameters.AddWithValue("@BillAmount", billAmount); cmd.Parameters.AddWithValue("@DrawFee", drawingFee); cmd.Parameters.AddWithValue("@DFAmount", dfAmount); cmd.Parameters.AddWithValue("@CommDue", commDue); cmd.Parameters.AddWithValue("@CompComm", companyComm); cmd.Parameters.AddWithValue("@PersonalComm", personalComm); cmd.Parameters.AddWithValue("@Paid", "No"); if (!(bool)CbFinalized.IsChecked) { cmd.Parameters.AddWithValue("@Finalized", "No"); } else { cmd.Parameters.AddWithValue("@Finalized", "Yes"); } cmd.ExecuteNonQuery(); DialogResult = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } else if (USER.GetAccessLevel() == 2 && !selectedEmpCode.Equals(string.Empty)) { try { using (var conn = DBUtils.GetDBConnection()) { conn.Open(); using (var cmd = new SqlCommand("INSERT INTO Invoices VALUES (@Code, @Date, @Client, @InvNum, @BillAmount, @DrawFee, @DFAmount, @CommDue, @CompComm, @PersonalComm, @Finalized, @Paid)", conn)) { cmd.Parameters.AddWithValue("@Code", selectedEmpCode); cmd.Parameters.AddWithValue("@Date", DtpDate.SelectedDate.Value.Date); cmd.Parameters.AddWithValue("@Client", CbClient.SelectedItem.ToString().Split('-')[0].Trim()); cmd.Parameters.AddWithValue("@InvNum", TxtInvoiceNumber.Text.Trim()); cmd.Parameters.AddWithValue("@BillAmount", billAmount); cmd.Parameters.AddWithValue("@DrawFee", drawingFee); cmd.Parameters.AddWithValue("@DFAmount", dfAmount); cmd.Parameters.AddWithValue("@CommDue", commDue); cmd.Parameters.AddWithValue("@CompComm", companyComm); cmd.Parameters.AddWithValue("@PersonalComm", personalComm); if (!(bool)CbFinalized.IsChecked) { cmd.Parameters.AddWithValue("@Finalized", "No"); } else { cmd.Parameters.AddWithValue("@Finalized", "Yes"); } if (!(bool)CbPaid.IsChecked) { cmd.Parameters.AddWithValue("@Paid", "No"); } else { cmd.Parameters.AddWithValue("@Paid", "Yes"); } cmd.ExecuteNonQuery(); DialogResult = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } } } }
private void LoadInvoice() { try { using (var conn = DBUtils.GetDBConnection()) { conn.Open(); var sql = string.Empty; if (!selectedEmpCode.Equals(string.Empty)) { sql = "SELECT Date, Client, [Bill Amount (R)], [Drawing Fee (%)], [DF Amount (R)], [Commission Due (R)], Paid FROM Invoices WHERE " + " Code = '" + selectedEmpCode + "' AND [Invoice Number] = '" + invNumber + "'"; } else { sql = "SELECT Date, Client, [Bill Amount (R)], [Drawing Fee (%)], [DF Amount (R)], [Commission Due (R)], Paid FROM Invoices WHERE " + "[Invoice Number] = '" + invNumber + "'"; } using (var da = new SqlDataAdapter(sql, conn)) { dt = new DataTable(); da.Fill(dt); } if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; foreach (string item in CbClient.Items) { if (row["Client"].ToString().Equals(item.Split('-')[0].Trim())) { CbClient.SelectedItem = item; } } if (decimal.TryParse(row["Bill Amount (R)"].ToString().Replace(",", "").Replace(".", "").TrimStart('0'), out decimal billAmountResult)) { billAmountResult /= 100; billAmount = billAmountResult; TxtBillAmount.Text = billAmount.ToString("N2", nfi); } if (decimal.TryParse(row["Drawing Fee (%)"].ToString().Replace(",", "").Replace(".", "").TrimStart('0'), out decimal drawingFeeResult)) { drawingFeeResult /= 100; drawingFee = drawingFeeResult; TxtDrawingFee.Text = drawingFee.ToString("P", nfi); } if (decimal.TryParse(row["DF Amount (R)"].ToString().Replace(",", "").Replace(".", "").TrimStart('0'), out decimal dfAmountResult)) { dfAmountResult /= 100; dfAmount = dfAmountResult; TxtDFAmount.Text = dfAmount.ToString("N2", nfi); } if (decimal.TryParse(row["Commission Due (R)"].ToString().Replace(",", "").Replace(".", "").TrimStart('0'), out decimal commDueResult)) { commDueResult /= 100; commDue = commDueResult; TxtCommDue.Text = commDue.ToString("N2", nfi); } DtpDate.SelectedDate = DateTime.Parse(row["Date"].ToString()); if (!row["Paid"].Equals("Yes")) { CbPaid.IsChecked = false; } else { CbPaid.IsChecked = true; } CalculateCommissionDue(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); } }