public MyAccount()
{
pmsutil = new PMSUtil();
InitializeComponent();
NameTextbox.Text = pmsutil.GetEmpName(Application.Current.Resources["uid"].ToString());
SyncMyLogs();
AccountNameHolder.Content = pmsutil.GetEmpName(Application.Current.Resources["uid"].ToString());
AccountRoleHolder.Content = pmsutil.GetAccountType(Application.Current.Resources["uid"].ToString());
}
private void ConfirmPayment_Click2(object sender, System.Windows.RoutedEventArgs e)
{
//dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
int amnt = int.Parse(AmountToBePaid.Content.ToString());
string OR = pmsutil.GenerateReceiptNum();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM transactions WHERE transaction_id = @transaction_id LIMIT 1;";
cmd.Parameters.AddWithValue("@transaction_id", tid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Unpaid")
{
ornum = OR;
using (conn2 = new MySqlConnection(dbman.GetConnStr()))
{
conn2.Open();
MySqlCommand cmd2 = conn2.CreateCommand();
cmd2.CommandText = "SELECT COUNT(*) FROM transactions WHERE or_number = @or_number;";
cmd2.Parameters.AddWithValue("@or_number", OR);
cmd2.Prepare();
int counter = int.Parse(cmd2.ExecuteScalar().ToString());
if (counter > 0)
{
InfoArea.Foreground = new SolidColorBrush(Colors.Red);
InfoArea.Content = "Duplicate Receipt Number Detected!";
}
else
{
UpdateTransaction();
trans1.SyncTransactions();
MsgSuccess();
this.Close();
}
}
}
}
}
}
Document doc = new Document();
doc.LoadFromFile("Data\\temp_receipt.docx");
doc.Replace("date", DateTime.Now.ToString("MM/dd/yyyy"), true, true);
doc.Replace("name", ReceivedFrom.Text, true, true);
doc.Replace("wordsum", amnt.ToWords(), true, true);
doc.Replace("amount", AmountToBePaid.Content.ToString(), true, true);
doc.Replace("Total1", "P " + AmountToBePaid.Content.ToString(), true, true);
doc.Replace("cashier", pmsutil.GetEmpName(Application.Current.Resources["uid"].ToString()), true, true);
doc.Replace("123456", OR, true, true);
int count1 = 1;
for (int i = 0; i < _list.Count; i++)
{
Transaction ti = (Transaction)_list[i];
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM transactions WHERE transaction_id = @transaction_id LIMIT 1;";
cmd.Parameters.AddWithValue("@transaction_id", ti.TransactionID);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Unpaid")
{
tid = ti.TransactionID;
ornum = OR;
doc.Replace("Item" + count1, db_reader.GetString("type"), true, true);
doc.Replace("Amount" + count1, db_reader.GetString("fee"), true, true);
count1++;
UpdateTransaction();
}
}
}
}
}
for (int xtemp = 12; count1 <= xtemp; count1++)
{
doc.Replace("Item" + count1, "", true, true);
doc.Replace("Amount" + count1, "", true, true);
}
string fname = "Receipt-No-" + OR + "-" + DateTime.Now.ToString("MMM_dd_yyyy") + ".pdf";
doc.SaveToFile("Data\\print_receipt.docx", Spire.Doc.FileFormat.Docx);
//Load Document
Document document = new Document();
document.LoadFromFile(@"Data\\print_receipt.docx");
//Convert Word to PDF
document.SaveToFile("Receipts\\" + fname, Spire.Doc.FileFormat.PDF);
System.Diagnostics.Process.Start("Receipts\\" + fname);
this.Close();
trans1.SyncTransactions();
}