public BlagajnaDialog(BlagajnaDetailsModel blagajna)
{
InitializeComponent();
label_cek.Text = $"Cek: {blagajna.cek} ({blagajna.cekNefiskalizovan})";
label_gotovina.Text = $"Gotovina: {blagajna.gotovina} ({blagajna.gotovinaNefiskalizovan})";
label_kartica.Text = $"Kartica: {blagajna.kartica} ({blagajna.karticaNefiskalizovan})";
label_virman.Text = $"Virman: {blagajna.virman} ({blagajna.virmanNefiskalizovan})";
label_promet.Text = $"Promet: {blagajna.uplaceno} ({blagajna.uplacenoNefiskalizovan})";
}
private void button_blagajna_Click(object sender, EventArgs e)
{
BlagajnaDetailsModel blagajna = SQLiteDataAccess.GetBlagajnaFiskalizovaniData();
BlagajnaDialog testDialog = new BlagajnaDialog(blagajna);
// Show testDialog as a modal dialog and determine if DialogResult = OK.
if (testDialog.ShowDialog(this) == DialogResult.OK)
{
// TODO implement
}
testDialog.Dispose();
}
internal static BlagajnaDetailsModel GetBlagajnaFiskalizovaniData()
{
using (IDbConnection cnn = new SQLiteConnection(LoadWarehouseConnectionString()))
{
string sqlFiskalizovan = @"SELECT SUM(uplaceno), sum(virman), sum(kartica), sum(cek), sum(gotovina)
FROM Bill
WHERE status='Fiskalizovan'";
var result = cnn.ExecuteReader(sqlFiskalizovan, new DynamicParameters());
BlagajnaDetailsModel blagajna = new BlagajnaDetailsModel();
while (result.Read())
{
blagajna.uplaceno = float.TryParse(result[0].ToString(), out float uplaceno) ? uplaceno : 0;
blagajna.virman = float.TryParse(result[1].ToString(), out float virman) ? virman : 0;
blagajna.kartica = float.TryParse(result[2].ToString(), out float kartica) ? kartica : 0;
blagajna.cek = float.TryParse(result[3].ToString(), out float cek) ? cek : 0;
blagajna.gotovina = float.TryParse(result[4].ToString(), out float gotovina) ? gotovina : 0;
}
string sqlNefiskalizovan = @"SELECT SUM(uplaceno), sum(virman), sum(kartica), sum(cek), sum(gotovina)
FROM Bill
WHERE status!='Fiskalizovan'";
result = cnn.ExecuteReader(sqlNefiskalizovan, new DynamicParameters());
while (result.Read())
{
blagajna.uplacenoNefiskalizovan = float.TryParse(result[0].ToString(), out float uplacenoNefiskalizovan) ? uplacenoNefiskalizovan : 0;
blagajna.virmanNefiskalizovan = float.TryParse(result[1].ToString(), out float virmanNefiskalizovan) ? virmanNefiskalizovan : 0;
blagajna.karticaNefiskalizovan = float.TryParse(result[2].ToString(), out float karticaNefiskalizovan) ? karticaNefiskalizovan : 0;
blagajna.cekNefiskalizovan = float.TryParse(result[3].ToString(), out float cekNefiskalizovan) ? cekNefiskalizovan : 0;
blagajna.gotovinaNefiskalizovan = float.TryParse(result[4].ToString(), out float gotovinaNefiskalizovan) ? gotovinaNefiskalizovan : 0;
}
return(blagajna);
}
}
