public void ZReport(app_account_session app_account_session)
{
string Header = string.Empty;
string Detail = string.Empty;
string Footer = string.Empty;
string CompanyName = string.Empty;
string BranchName = string.Empty;
app_company app_company = null;
if (app_account_session.app_company != null)
{
CompanyName = app_account_session.app_company.name;
app_company = app_account_session.app_company;
}
else
{
using (db db = new db())
{
if (db.app_company.Where(x => x.id_company == app_account_session.id_company).FirstOrDefault() != null)
{
app_company = db.app_company.Where(x => x.id_company == app_account_session.id_company).FirstOrDefault();
CompanyName = app_company.name;
}
}
}
string UserName = "";
if (app_account_session.security_user != null)
{
UserName = app_account_session.security_user.name;
}
else
{
using (db db = new db())
{
if (db.security_user.Where(x => x.id_user == app_account_session.id_user).FirstOrDefault() != null)
{
security_user security_user = db.security_user.Where(x => x.id_user == app_account_session.id_user).FirstOrDefault();
UserName = security_user.name;
}
}
}
using (db db = new db())
{
if (db.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault() != null)
{
app_branch app_branch = db.app_branch.Where(x => x.id_branch == CurrentSession.Id_Branch).FirstOrDefault();
BranchName = app_branch.name;
}
}
string SessionID = app_account_session.id_session.ToString();
DateTime OpenDate = app_account_session.op_date;
DateTime CloseDate = DateTime.Now;
if (app_account_session.cl_date != null)
{
CloseDate = (DateTime)app_account_session.cl_date;
}
Header =
"***Z Report***" + "\n"
+ CompanyName + "\t" + BranchName + "\n"
+ "R.U.C. :" + app_company.gov_code + "\n"
+ app_company.address + "\n"
+ "***" + app_company.alias + "***" + "\n"
+ "Apertura : " + OpenDate + "\n"
+ "Cierre : " + CloseDate
+ "\n"
+ "--------------------------------" + "\n"
+ "Hora Factura / Valor Moneda" + "\n"
+ "--------------------------------" + "\n";
string CustomerName = string.Empty;
foreach (app_account_detail detail in app_account_session.app_account_detail.GroupBy(x => x.id_currencyfx).Select(x => x.FirstOrDefault()).ToList())
{
Detail += "Moneda : " + detail.app_currencyfx.app_currency.name + "\n";
if (detail.tran_type == app_account_detail.tran_types.Open)
{
Detail += "Balance de Apertura : " + Math.Round(detail.credit, 2) + "\n";
}
foreach (app_account_detail d in app_account_session.app_account_detail.Where(x => x.tran_type == app_account_detail.tran_types.Transaction && x.id_currencyfx == detail.id_currencyfx).ToList())
{
string AccountName = string.Empty;
if (d.app_account == null)
{
using (db db = new db())
{
app_account app_account = db.app_account.Where(x => x.id_account == d.id_account).FirstOrDefault();
AccountName = app_account.name;
}
}
string currency = string.Empty;
if (d.app_currencyfx == null)
{
using (db db = new db())
{
currency = db.app_currencyfx.Where(x => x.id_currencyfx == d.id_currencyfx).FirstOrDefault().app_currency.name;
}
}
string InvoiceNumber = string.Empty;
string InvoiceTime = string.Empty;
payment_detail payment_detail = d.payment_detail as payment_detail;
foreach (payment_schedual payment_schedual in payment_detail.payment_schedual)
{
if (payment_schedual.sales_invoice.number != null)
{
if (!(InvoiceNumber.Contains(payment_schedual.sales_invoice.number)))
{
InvoiceNumber += payment_schedual.sales_invoice.number;
InvoiceTime = payment_schedual.sales_invoice.trans_date.ToShortTimeString();
}
}
}
decimal?value = d.credit - d.debit;
}
var listvat = app_account_session.app_account_detail.Where(x => x.tran_type == app_account_detail.tran_types.Transaction && x.id_currencyfx == detail.id_currencyfx)
.GroupBy(a => new { a.id_payment_type, a.id_currencyfx })
.Select(g => new
{
Currencyname = g.Max(x => x.app_currencyfx).app_currency.name,
paymentname = g.Max(x => x.payment_type).name,
id_currencyfx = g.Key.id_currencyfx,
id_payment_type = g.Key.id_payment_type,
value = g.Sum(a => a.credit)
}).ToList().OrderBy(x => x.id_currencyfx);
Detail += "Total de Ventas Neto :" + Math.Round(listvat.Sum(x => x.value), 2) + "\n";
foreach (dynamic item in listvat)
{
Detail += item.paymentname + "\t" + Math.Round(item.value, 2) + "\n";
}
foreach (app_account_detail account_detail in app_account_session.app_account_detail.Where(x => x.tran_type == app_account_detail.tran_types.Close && x.id_currencyfx == detail.id_currencyfx).GroupBy(x => x.id_currencyfx).Select(x => x.FirstOrDefault()).ToList())
{
Detail += "Balance de Cierre : " + Math.Round(account_detail.debit, 2);
Detail += "\n--------------------------------" + "\n";
}
Detail += "\n--------------------------------" + "\n";
}
using (db db = new db())
{
decimal amount = 0M;
int[] id_schedual = new int[10];
int index = 0;
foreach (app_account_detail account_detail in db.app_account_detail.Where(x => x.id_session == app_account_session.id_session && x.tran_type == app_account_detail.tran_types.Transaction).ToList())
{
foreach (payment_schedual payment_schedual in account_detail.payment_detail.payment_schedual.ToList())
{
if (!id_schedual.Contains(payment_schedual.parent.id_payment_schedual))
{
if (payment_schedual.parent != null)
{
id_schedual[index] = payment_schedual.parent.id_payment_schedual;
amount += payment_schedual.parent.debit;
}
else
{
amount += payment_schedual.credit;
}
}
}
}
Detail += "Total de Ventas Neto : " + Math.Round(amount, 2) + " \n";
}
Footer += "Cajero/a : " + UserName + " /n";
Footer += "--------------------------------" + " \n";
string Text = Header + Detail + Footer;
Reciept Reciept = new Reciept();
PrintDialog pd = new PrintDialog();
FlowDocument document = new FlowDocument(new Paragraph(new Run(Text)));
document.Name = "ItemMovement";
document.FontFamily = new FontFamily("Courier New");
document.FontSize = 11.0;
document.FontStretch = FontStretches.Normal;
document.FontWeight = FontWeights.Normal;
document.PagePadding = new Thickness(20);
document.PageHeight = double.NaN;
document.PageWidth = double.NaN;
//document.
//Specify minimum page sizes. Origintally 283, but was too small.
document.MinPageWidth = 283;
//Specify maximum page sizes.
document.MaxPageWidth = 300;
IDocumentPaginatorSource idpSource = document;
try
{
Nullable <bool> print = pd.ShowDialog();
if (print == true)
{
pd.PrintDocument(idpSource.DocumentPaginator, Text);
}
}
catch
{ MessageBox.Show("Output (Reciept Printer) not Found Error", "Error 101"); }
}
private void btnActivateAccount_Click(object sender, RoutedEventArgs e)
{
if (db.app_account.Where(x => x.id_account == CurrentSession.Id_Account).FirstOrDefault() != null)
{
//Get the correct Account.
app_account app_account = db.app_account.Where(x => x.id_account == CurrentSession.Id_Account).FirstOrDefault();
app_account_session app_account_session = null;
if (db.app_account_session.Where(x => x.id_account == CurrentSession.Id_Account && x.is_active).FirstOrDefault() != null)
{
app_account_session = db.app_account_session.Where(x => x.id_account == CurrentSession.Id_Account && x.is_active).FirstOrDefault();
}
if (app_account_session != null && app_account_session.is_active)
{
///We need to CLOSE (InActive) the active Session.
///For this we will need...
///- Create Account Details for each type of Closing Balance.
///- Close Session.
///- Keep Account Active. (Previously we used to close Account, now Session handles that.)
//Loop through each account and create an Account Detail for the Opening Balance.
foreach (Class.clsTransferAmount counted_account_detail in listOpenAmt)
{
app_account_detail app_account_detail = new global::entity.app_account_detail();
app_account_detail.id_session = app_account_session.id_session;
app_account_detail.id_account = app_account_session.id_account;
app_account_detail.id_currencyfx = counted_account_detail.id_currencyfx;
app_account_detail.id_payment_type = counted_account_detail.id_payment_type;
app_account_detail.debit = counted_account_detail.amountCounted;
app_account_detail.comment = "Closing Balance";
app_account_detail.tran_type = app_account_detail.tran_types.Close;
app_account_detail.trans_date = DateTime.Now;
//CHECK
app_account_detail.id_session = app_account_session.id_session;
app_account_session.cl_date = DateTime.Now;
app_account_session.is_active = false;
db.app_account_detail.Add(app_account_detail);
app_account.is_active = false;
//Save Changes
db.SaveChanges();
is_active = app_account_session.is_active;
RaisePropertyChanged("is_active");
}
if (MessageBox.Show("Session is Closed, thank you for using CognitivoERP! "
+ "/n Would you like to Print the Z-Report?", "Print Z-Report?", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
entity.Brillo.Logic.Reciept TicketPrint = new entity.Brillo.Logic.Reciept();
TicketPrint.ZReport(app_account_session);
}
catch (Exception ex)
{
MessageBox.Show("Error: Trying to print Z-Report : " + ex.Message);
}
}
}
else
{
//We need to OPEN (Activate) the inactive Session..
//Create New Session.
app_account_session = new entity.app_account_session();
app_account_session.id_account = app_account.id_account;
//Loop through each account and create an Account Detail for the Closing Balance.
foreach (Class.clsTransferAmount counted_account_detail in listOpenAmt)
{
app_account_detail app_account_detail = new global::entity.app_account_detail();
app_account_detail.id_account = app_account.id_account;
app_account_detail.id_currencyfx = counted_account_detail.id_currencyfx;
app_account_detail.id_payment_type = counted_account_detail.id_payment_type;
app_account_detail.credit = counted_account_detail.amountCounted;
app_account_detail.comment = "Opening Balance";
app_account_detail.tran_type = app_account_detail.tran_types.Open;
app_account_detail.trans_date = DateTime.Now;
app_account_session.app_account_detail.Add(app_account_detail);
db.app_account_session.Add(app_account_session);
}
app_account.is_active = true;
//Save Changes
db.SaveChanges();
is_active = app_account_session.is_active;
RaisePropertyChanged("is_active");
MessageBox.Show("Session is Open, Good Luck!");
}
if (app_accountViewSource != null)
{
if (app_accountViewSource.View != null)
{
app_accountViewSource.View.Refresh();
}
}
//Reload Data
db.Entry(app_account).Reload();
}
}
