private void calendar_DayDoubleClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
// Проверяем, что человек хочет перенести на выходной день
foreach (Pabo.Calendar.DateItem date_ in calendar.Dates)
{
if (date_.Date == DateTime.Parse(e.Date))
{
if (date_.BackColor1 == CalendarForm.weekendBackColor)
{
if (MessageBox.Show($"Вы хотите перенсти рабочий день на {e.Date}?", "Выберите действие",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
// Если пользователь согласился на перенос на эту дату
// Нужно взять this.firstDate, сделать его выходным, а dayToTransfer - наоборот
var dayToTransfer = DateTime.Parse(e.Date);
// Изменяем вторую дату на то, чем был первый день в БД
using (var conn = DBUtils.GetDBConnection())
{
conn.Open();
SqlCommand selectDateFromWorkingDay = new SqlCommand("SELECT * FROM WorkingDay " +
$"WHERE [Date] = '{this.firstDate.ToLocalTime().ToString()}';", conn);
// Если такая дата уже была в базе данных помечена как нерабочая
if (selectDateFromWorkingDay.ExecuteScalar() != null)
{
using (var reader = selectDateFromWorkingDay.ExecuteReader())
while (reader.Read())
{
var isWeekend = reader.GetBoolean(3);
var isHoliday = reader.GetBoolean(4);
var isPreHoliday = reader.GetBoolean(5);
transferDay(dayToTransfer, isWeekend, isHoliday, isPreHoliday);
}
}
else
{
transferDay(dayToTransfer, false, false, false);
}
conn.Close();
}
// Изменяем первую дату на выходной
transferDay(this.firstDate, true, false, false);
this.Hide();
return;
}
else
{
return;
}
}
}
}
MessageBox.Show("День переносить можно только на выходной", "Внимание",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void calendario_DayClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
DateTime datetime;
datetime = DateTime.Parse(e.Date);
DataTable dt = new DataTable();
dt = BusinesAdministrador.TotalDeVendas();
decimal valorTotal = 0;
if (dt != null)
{
var total = dt.AsEnumerable().Where(x => x.Field <string>("data_fechamento") == datetime.ToShortDateString()).Sum(x => x.Field <decimal>("TotalDeVendas"));
var dinheiro = dt.AsEnumerable().Where(x => x.Field <int>("id_pagamento") == 1).Where(x => x.Field <string>("data_fechamento") == datetime.ToShortDateString()).Sum(x => x.Field <decimal>("TotalDeVendas"));
var debito = dt.AsEnumerable().Where(x => x.Field <int>("id_pagamento") == 2).Where(x => x.Field <string>("data_fechamento") == datetime.ToShortDateString()).Sum(x => x.Field <decimal>("TotalDeVendas"));
var credito = dt.AsEnumerable().Where(x => x.Field <int>("id_pagamento") == 3).Where(x => x.Field <string>("data_fechamento") == datetime.ToShortDateString()).Sum(x => x.Field <decimal>("TotalDeVendas"));
var fiado = dt.AsEnumerable().Where(x => x.Field <int>("id_pagamento") == 4).Where(x => x.Field <string>("data_fechamento") == datetime.ToShortDateString()).Sum(x => x.Field <decimal>("TotalDeVendas"));
lblTotalVendas.Text = total.ToString("C");
lblVendaDinheiro.Text = dinheiro.ToString("C");
lblVendaDebito.Text = debito.ToString("C");
lblVendaFiado.Text = fiado.ToString("C");
lblVendasCredito.Text = credito.ToString("C");
}
}
private void pbCalendar_DayClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
CalendarDayClick(pbCalendar1, e);
//CalendarDayClick(pbCalendar2, e);
//CalendarDayClick(pbCalendar3, e);
//CalendarDayClick(pbCalendar4, e);
}
private void pbCalendar_DayClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
if (pbCalendar.Dates.IndexOf(DateTime.Parse(e.Date)) != -1)
{
lblDateSelected.Text = e.Date;
btnSelect.Enabled = true;
}
}
private void pbCalendar_DayDoubleClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
if (pbCalendar.Dates.IndexOf(DateTime.Parse(e.Date)) != -1)
{
lblDateSelected.Text = e.Date;
bDateIsSelected = true;
this.Visible = false;
}
}
private void calendar_DayClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
var date = e.Date;
selectActionMenu.Tag = date;
selectActionMenu.Show(this.Left + e.DayRectangle.Left + e.DayX + e.DayRectangle.Width,
this.Top + e.DayRectangle.Top + e.DayY + e.DayRectangle.Height + this.selectActionMenu.Height);
}
}
private bool CalendarDoubleClick(Pabo.Calendar.PBCalendar sender, Pabo.Calendar.DayClickEventArgs e)
{
DateTime dt = Convert.ToDateTime(e.Date);
Int32 dtIndex = -1;
dtIndex = sender.Dates.IndexOf(dt.Date);
if (dtIndex != -1)
{
sender.Dates.RemoveAt(dtIndex);
}
return(dtIndex != -1);
}
private void pbCalendar_DayDoubleClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
if (AlreadyHere == false)
{
AlreadyHere = true;
CalendarDoubleClick(pbCalendar1, e);
CalendarDoubleClick(pbCalendar2, e);
if (CalendarDoubleClick(pbCalendar3, e) == true)
{
clsDaysOpen.deleteDate(e.Date);
}
AlreadyHere = false;
}
else
{
}
clsDaysOpen.update();
}
private void monthCalendar1_DayClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
int n = (from r in dtNgayNghi.AsEnumerable()
where r.Field <DateTime>("tu_ngay") <= Convert.ToDateTime(e.Date) && r.Field <DateTime>("den_ngay") >= Convert.ToDateTime(e.Date)
select r.Field <string>("ghi_chu")).Count();
if (n > 0)
{
var ghichu = (from r in dtNgayNghi.AsEnumerable()
where r.Field <DateTime>("tu_ngay") <= Convert.ToDateTime(e.Date) && r.Field <DateTime>("den_ngay") >= Convert.ToDateTime(e.Date)
select r.Field <string>("ghi_chu")).First();
var loainpid = (from r in dtNgayNghi.AsEnumerable()
where r.Field <DateTime>("tu_ngay") <= Convert.ToDateTime(e.Date) && r.Field <DateTime>("den_ngay") >= Convert.ToDateTime(e.Date)
select r.Field <int>("loai_ngay_phep_id")).First();
var tungay = (from r in dtNgayNghi.AsEnumerable()
where r.Field <DateTime>("tu_ngay") <= Convert.ToDateTime(e.Date) && r.Field <DateTime>("den_ngay") >= Convert.ToDateTime(e.Date)
select r.Field <DateTime>("tu_ngay")).First();
var denngay = (from r in dtNgayNghi.AsEnumerable()
where r.Field <DateTime>("tu_ngay") <= Convert.ToDateTime(e.Date) && r.Field <DateTime>("den_ngay") >= Convert.ToDateTime(e.Date)
select r.Field <DateTime>("den_ngay")).First();
var isungtruoc = (from r in dtNgayNghi.AsEnumerable()
where r.Field <DateTime>("tu_ngay") <= Convert.ToDateTime(e.Date) && r.Field <DateTime>("den_ngay") >= Convert.ToDateTime(e.Date)
select r.Field <Boolean>("is_ung_truoc")).First();
dtp_TuNGay.Value = Convert.ToDateTime(tungay);
dtp_DenNgay.Value = Convert.ToDateTime(denngay);
cb_LoaiNgayPhep.SelectedValue = Convert.ToInt16(loainpid);
cb_UngNP.Checked = Convert.ToBoolean(isungtruoc);
rTB_GhiChu.Text = ghichu.ToString();
}
else
{
rTB_GhiChu.Text = "";
cb_UngNP.Checked = false;
}
}
private void CalendarDayClick(Pabo.Calendar.PBCalendar sender, Pabo.Calendar.DayClickEventArgs e)
{
Pabo.Calendar.DateItem[] dItems;
Int32 dtIndex = -1;
DateTime dateWork = Convert.ToDateTime(e.Date);
int newImageListIndex = 0;
String newDateText = "";
dtIndex = pbCalendar1.Dates.IndexOf(dateWork);
if (dtIndex == -1)
{
AddDateToCalendar(dateWork, false, "");
clsDaysOpen.AddDate(dateWork, false, "");
}
else if (mClickMode == 2)
{
dItems = pbCalendar1.Dates.DateInfo(dateWork);
if (dItems[0].ImageListIndex == 0)
{
newImageListIndex = -1;
}
else
{
newImageListIndex = 0;
}
dItems[0].ImageListIndex = newImageListIndex;
dItems = pbCalendar2.Dates.DateInfo(dateWork);
dItems[0].ImageListIndex = newImageListIndex;
dItems = pbCalendar3.Dates.DateInfo(dateWork);
dItems[0].ImageListIndex = newImageListIndex;
clsDaysOpen.FindDate(dateWork);
clsDaysOpen.IsCommodity = (newImageListIndex == 0);
}
else if (mClickMode == 3)
{
dItems = pbCalendar1.Dates.DateInfo(dateWork);
if (dItems[0].Text == "")
{
newDateText = "Spcl";
}
else
{
newDateText = "";
}
dItems[0].Text = newDateText;
dItems = pbCalendar2.Dates.DateInfo(dateWork);
dItems[0].Text = newDateText;
dItems = pbCalendar3.Dates.DateInfo(dateWork);
dItems[0].Text = newDateText;
clsDaysOpen.FindDate(dateWork);
if (newDateText == "")
{
clsDaysOpen.SpecialItems = "";
}
else
{
clsDaysOpen.SpecialItems = SpecialFoodList();
}
}
clsDaysOpen.update();
}
private void monthCalendar1_DayClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
getSelection();
}
private void calendario_DayClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
}
private void calendario_DayClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
//removendo os controles entrada
foreach (Control item in painelEntradas.Controls.OfType <Panel>())
{
painelEntradas.Controls.Clear();
}
foreach (Control item in pTotal.Controls.OfType <Label>())
{
pTotal.Controls.Clear();
}
//
//removendo os controles saida
foreach (Control item in painelSaidas.Controls.OfType <Panel>())
{
painelSaidas.Controls.Clear();
}
foreach (Control item in pTotal.Controls.OfType <Label>())
{
pTotal.Controls.Clear();
}
//
DateTime datetime;
datetime = DateTime.Parse(e.Date);
DataTable dtResultado = new DataTable();
dtResultado = DoDiarioDeCaixa.DiarioDeCaixa_ResultadoEntrada();
decimal valorTotal = 0;
if (dtResultado != null)
{
//var jc8x = dt.AsEnumerable().Where(x => x.Field<string>("Data") == datetime.ToShortDateString()).Sum(x => x.Field<decimal>("Valor"));
//var dinheiro = dt.AsEnumerable().Where(x => x.Field<int>("id_pagamento") == 1).Where(x => x.Field<string>("data_fechamento") == datetime.ToShortDateString()).Sum(x => x.Field<decimal>("TotalDeVendas"));
var dt = dtResultado.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).
Select(k =>
{
var row = dtResultado.NewRow();
row.ItemArray = new object[]
{
k.Field <string>("descricao"),
k.Field <decimal>("Valor")
};
return(row);
}
);
if (dt.Any())
{
DataTable dtNew = dt.CopyToDataTable();
for (int i = 0; i < dtNew.Rows.Count; i++)
{
#region entradas
Panel p = new Panel();
p.Name = "painelDinamico";
p.Width = 246;
p.Height = 51;
p.BorderStyle = BorderStyle.FixedSingle;
p.Left = 3;
p.Top = i * 54;
p.BackColor = Color.WhiteSmoke;
painelEntradas.Controls.Add(p);
Label descricao = new Label();
descricao.AutoSize = true;
descricao.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Regular);
descricao.ForeColor = Color.Black;
descricao.Text = dtNew.Rows[i][0].ToString() + ": " + dtNew.Rows[i][1].ToString();
descricao.Left = 3;
descricao.Top = 15;
p.Controls.Add(descricao);
//total de entradas
Label tEntrada = new Label();
tEntrada.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Bold);
tEntrada.ForeColor = Color.Gray;
tEntrada.Left = 7;
tEntrada.Top = 10;
tEntrada.Text = "Total Entradas";
tEntrada.AutoSize = true;
pTotal.Controls.Add(tEntrada);
Label TotalEntrada = new Label();
TotalEntrada.Name = "valorEntrada";
TotalEntrada.Font = new Font("Micrsoft Sans Serif", 14, FontStyle.Regular);
TotalEntrada.ForeColor = Color.Gray;
TotalEntrada.AutoSize = true;
var total = dtResultado.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).Sum(x => x.Field <decimal>("Valor"));
TotalEntrada.Text = total.ToString("C");
TotalEntrada.Top = 22;
TotalEntrada.Left = 7;
pTotal.Controls.Add(TotalEntrada);
//entrada em dinheiro
Label tDinheiro = new Label();
tDinheiro.Font = new Font("Microsoft Sans Serif", 6, FontStyle.Bold);
tDinheiro.ForeColor = Color.Gray;
tDinheiro.Left = 170;
tDinheiro.Top = 10;
tDinheiro.Text = "Total Dinheiro";
tDinheiro.AutoSize = true;
pTotal.Controls.Add(tDinheiro);
Label TotalEntradaDinheiro = new Label();
TotalEntradaDinheiro.Name = "dinheiro";
TotalEntradaDinheiro.Font = new Font("Micrsoft Sans Serif", 12, FontStyle.Regular);
TotalEntradaDinheiro.ForeColor = Color.Gray;
TotalEntradaDinheiro.AutoSize = true;
var totalDinheiro = dtResultado.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).Where(x => x.Field <int>("Dinheiro") == 1).Sum(x => x.Field <decimal>("Valor"));
TotalEntradaDinheiro.Text = totalDinheiro.ToString("C");
TotalEntradaDinheiro.Top = 22;
TotalEntradaDinheiro.Left = 170;
pTotal.Controls.Add(TotalEntradaDinheiro);
#endregion entradas
}
}
}
DataTable dtSaidas = new DataTable();
dtSaidas = DoDiarioDeCaixa.DiarioDeCaixaResultadoSaida();
if (dtSaidas != null)
{
//var jc8x = dt.AsEnumerable().Where(x => x.Field<string>("Data") == datetime.ToShortDateString()).Sum(x => x.Field<decimal>("Valor"));
//var dinheiro = dt.AsEnumerable().Where(x => x.Field<int>("id_pagamento") == 1).Where(x => x.Field<string>("data_fechamento") == datetime.ToShortDateString()).Sum(x => x.Field<decimal>("TotalDeVendas"));
var dt = dtSaidas.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).
Select(k =>
{
var row = dtSaidas.NewRow();
row.ItemArray = new object[]
{
k.Field <string>("descricao"),
k.Field <decimal>("Valor")
};
return(row);
}
);
if (dt.Any())
{
DataTable dtNew = dt.CopyToDataTable();
for (int i = 0; i < dtNew.Rows.Count; i++)
{
#region saidas
Panel s = new Panel();
s.Name = "painelDinamico";
s.Width = 246;
s.Height = 51;
s.BorderStyle = BorderStyle.FixedSingle;
s.Left = 3;
s.Top = i * 54;
s.BackColor = Color.WhiteSmoke;
painelSaidas.Controls.Add(s);
Label tituloS = new Label();
tituloS.AutoSize = true;
tituloS.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Regular);
tituloS.ForeColor = Color.Black;
tituloS.Text = dtNew.Rows[i][0].ToString() + ": " + dtNew.Rows[i][1].ToString();
tituloS.Left = 3;
tituloS.Top = 15;
s.Controls.Add(tituloS);
//total de entradas
Label tSaida = new Label();
tSaida.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Bold);
tSaida.ForeColor = Color.Gray;
tSaida.Left = 358;
tSaida.Top = 10;
tSaida.Text = "Total Saídas";
tSaida.AutoSize = true;
pTotal.Controls.Add(tSaida);
Label TotalSaida = new Label();
TotalSaida.Name = "valorSaida";
TotalSaida.Font = new Font("Micrsoft Sans Serif", 14, FontStyle.Regular);
TotalSaida.ForeColor = Color.Gray;
TotalSaida.AutoSize = true;
var totalSaida = dtSaidas.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).Sum(x => x.Field <decimal>("Valor"));
TotalSaida.Text = totalSaida.ToString("C");
TotalSaida.Top = 22;
TotalSaida.Left = 358;
pTotal.Controls.Add(TotalSaida);
//entrada em dinheiro
Label sDinheiro = new Label();
sDinheiro.Font = new Font("Microsoft Sans Serif", 6, FontStyle.Bold);
sDinheiro.ForeColor = Color.Gray;
sDinheiro.Left = 535;
sDinheiro.Top = 10;
sDinheiro.Text = "Total Dinheiro";
sDinheiro.AutoSize = true;
pTotal.Controls.Add(sDinheiro);
Label TotalSaidaDinheiro = new Label();
TotalSaidaDinheiro.Name = "dinheiro";
TotalSaidaDinheiro.Font = new Font("Micrsoft Sans Serif", 12, FontStyle.Regular);
TotalSaidaDinheiro.ForeColor = Color.Gray;
TotalSaidaDinheiro.AutoSize = true;
var totalSDinheiro = dtSaidas.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).Where(x => x.Field <int>("Dinheiro") == 1).Sum(x => x.Field <decimal>("Valor"));
TotalSaidaDinheiro.Text = totalSDinheiro.ToString("C");
TotalSaidaDinheiro.Top = 22;
TotalSaidaDinheiro.Left = 535;
pTotal.Controls.Add(TotalSaidaDinheiro);
#endregion saidas
}
}
}
}
private void calendario_DayClick(object sender, Pabo.Calendar.DayClickEventArgs e)
{
//removendo os controles entrada
foreach (Control item in painelEntradas.Controls.OfType <Panel>())
{
painelEntradas.Controls.Clear();
}
foreach (Control item in pTotais.Controls.OfType <Panel>())
{
pTotais.Controls.Clear();
}
//
//removendo os controles saida
foreach (Control item in painelSaidas.Controls.OfType <Panel>())
{
painelSaidas.Controls.Clear();
}
foreach (Control item in pTotais.Controls.OfType <Panel>())
{
pTotais.Controls.Clear();
}
//
DateTime datetime;
datetime = DateTime.Parse(e.Date);
#region entradas
DataTable dtResultado = new DataTable();
dtResultado = DoDiarioDeCaixa.DiarioDeCaixa_ResultadoEntrada();
decimal valorTotal = 0;
if (dtResultado != null)
{
//var jc8x = dt.AsEnumerable().Where(x => x.Field<string>("Data") == datetime.ToShortDateString()).Sum(x => x.Field<decimal>("Valor"));
//var dinheiro = dt.AsEnumerable().Where(x => x.Field<int>("id_pagamento") == 1).Where(x => x.Field<string>("data_fechamento") == datetime.ToShortDateString()).Sum(x => x.Field<decimal>("TotalDeVendas"));
var dt = dtResultado.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).
Select(k =>
{
var row = dtResultado.NewRow();
row.ItemArray = new object[]
{
k.Field <string>("descricao"),
k.Field <int>("Dinheiro"),
k.Field <decimal>("Valor"),
k.Field <int>("Mes")
};
return(row);
}
);
if (dt.Any())
{
DataTable dtNew = dt.CopyToDataTable();
for (int i = 0; i < dtNew.Rows.Count; i++)
{
Panel p = new Panel();
p.Name = "painelDinamico";
p.Width = 246;
p.Height = 51;
p.BorderStyle = BorderStyle.FixedSingle;
p.Left = 3;
p.Top = i * 54;
p.BackColor = Color.WhiteSmoke;
painelEntradas.Controls.Add(p);
Label descricao = new Label();
descricao.AutoSize = true;
descricao.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Regular);
descricao.ForeColor = Color.Black;
descricao.Text = dtNew.Rows[i][0].ToString() + ": " + dtNew.Rows[i][2].ToString();
descricao.Left = 3;
descricao.Top = 15;
p.Controls.Add(descricao);
//total de entradas
Panel pTotalEntrada = new Panel();
pTotalEntrada.Width = 294;
pTotalEntrada.Height = 65;
pTotalEntrada.Top = 3;
pTotalEntrada.Left = 9;
pTotalEntrada.BackColor = Color.Green;
pTotais.Controls.Add(pTotalEntrada);
Label tEntrada = new Label();
tEntrada.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Bold);
tEntrada.ForeColor = Color.White;
tEntrada.Left = 7;
tEntrada.Top = 10;
tEntrada.Text = "Total Entradas";
tEntrada.AutoSize = true;
pTotalEntrada.Controls.Add(tEntrada);
Label TotalEntrada = new Label();
TotalEntrada.Name = "valorEntrada";
TotalEntrada.Font = new Font("Micrsoft Sans Serif", 14, FontStyle.Regular);
TotalEntrada.ForeColor = Color.White;
TotalEntrada.AutoSize = true;
var totalEntrada = dtResultado.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).Sum(x => x.Field <decimal>("Valor"));
TotalEntrada.Text = totalEntrada.ToString("C");
TotalEntrada.Top = 22;
TotalEntrada.Left = 7;
pTotalEntrada.Controls.Add(TotalEntrada);
//entrada em dinheiro
Label tDinheiro = new Label();
tDinheiro.Font = new Font("Microsoft Sans Serif", 6, FontStyle.Bold);
tDinheiro.ForeColor = Color.White;
tDinheiro.Left = 170;
tDinheiro.Top = 10;
tDinheiro.Text = "Total Dinheiro";
tDinheiro.AutoSize = true;
pTotalEntrada.Controls.Add(tDinheiro);
Label TotalEntradaDinheiro = new Label();
TotalEntradaDinheiro.Name = "dinheiro";
TotalEntradaDinheiro.Font = new Font("Micrsoft Sans Serif", 12, FontStyle.Regular);
TotalEntradaDinheiro.ForeColor = Color.White;
TotalEntradaDinheiro.AutoSize = true;
totalEntradaDinheiro = dtResultado.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).Where(x => x.Field <int>("Dinheiro") == 1).Sum(x => x.Field <decimal>("Valor"));
TotalEntradaDinheiro.Text = totalEntradaDinheiro.ToString("C");
TotalEntradaDinheiro.Top = 22;
TotalEntradaDinheiro.Left = 170;
pTotalEntrada.Controls.Add(TotalEntradaDinheiro);
//
var totalMensalEntrada = dtResultado.AsEnumerable().Where(x => x.Field <int>("Mes") == datetime.Month).Sum(x => x.Field <decimal>("Valor"));
totalMesEntrada.Text = totalMensalEntrada.ToString("C");
}
}
}
#endregion entradas
#region saidas
DataTable dtSaidas = new DataTable();
dtSaidas = DoDiarioDeCaixa.DiarioDeCaixaResultadoSaida();
if (dtSaidas != null)
{
//var jc8x = dt.AsEnumerable().Where(x => x.Field<string>("Data") == datetime.ToShortDateString()).Sum(x => x.Field<decimal>("Valor"));
//var dinheiro = dt.AsEnumerable().Where(x => x.Field<int>("id_pagamento") == 1).Where(x => x.Field<string>("data_fechamento") == datetime.ToShortDateString()).Sum(x => x.Field<decimal>("TotalDeVendas"));
var dt = dtSaidas.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).
Select(k =>
{
var row = dtSaidas.NewRow();
row.ItemArray = new object[]
{
k.Field <string>("descricao"),
k.Field <int>("Dinheiro"),
k.Field <decimal>("Valor"),
k.Field <int>("Mes")
};
return(row);
}
);
if (dt.Any())
{
DataTable dtNew = dt.CopyToDataTable();
for (int i = 0; i < dtNew.Rows.Count; i++)
{
Panel s = new Panel();
s.Name = "painelDinamico";
s.Width = 246;
s.Height = 51;
s.BorderStyle = BorderStyle.FixedSingle;
s.Left = 3;
s.Top = i * 54;
s.BackColor = Color.WhiteSmoke;
painelSaidas.Controls.Add(s);
Label tituloS = new Label();
tituloS.AutoSize = true;
tituloS.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Regular);
tituloS.ForeColor = Color.Black;
tituloS.Text = dtNew.Rows[i][0].ToString() + ": " + dtNew.Rows[i][2].ToString();
tituloS.Left = 3;
tituloS.Top = 15;
s.Controls.Add(tituloS);
//total de Saidas
Panel pTotalSaida = new Panel();
pTotalSaida.Width = 294;
pTotalSaida.Height = 65;
pTotalSaida.BackColor = Color.Red;
pTotalSaida.Top = 74;
pTotalSaida.Left = 9;
pTotais.Controls.Add(pTotalSaida);
//
Label tSaida = new Label();
tSaida.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Bold);
tSaida.ForeColor = Color.White;
tSaida.Left = 7;
tSaida.Top = 10;
tSaida.Text = "Total Saídas";
tSaida.AutoSize = true;
pTotalSaida.Controls.Add(tSaida);
Label TotalSaida = new Label();
TotalSaida.Name = "valorSaida";
TotalSaida.Font = new Font("Micrsoft Sans Serif", 14, FontStyle.Regular);
TotalSaida.ForeColor = Color.White;
TotalSaida.AutoSize = true;
var totalSaida = dtSaidas.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).Sum(x => x.Field <decimal>("Valor"));
TotalSaida.Text = totalSaida.ToString("C");
TotalSaida.Top = 22;
TotalSaida.Left = 7;
pTotalSaida.Controls.Add(TotalSaida);
//saida em dinheiro
Label sDinheiro = new Label();
sDinheiro.Font = new Font("Microsoft Sans Serif", 6, FontStyle.Bold);
sDinheiro.ForeColor = Color.White;
sDinheiro.Left = 170;
sDinheiro.Top = 10;
sDinheiro.Text = "Total Dinheiro";
sDinheiro.AutoSize = true;
pTotalSaida.Controls.Add(sDinheiro);
Label TotalSaidaDinheiro = new Label();
TotalSaidaDinheiro.Name = "dinheiro";
TotalSaidaDinheiro.Font = new Font("Microsoft Sans Serif", 12, FontStyle.Regular);
TotalSaidaDinheiro.ForeColor = Color.White;
TotalSaidaDinheiro.AutoSize = true;
totalSaidaDinheiro = dtSaidas.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).Where(x => x.Field <int>("Dinheiro") == 1).Sum(x => x.Field <decimal>("Valor"));
TotalSaidaDinheiro.Text = totalSaidaDinheiro.ToString("C");
TotalSaidaDinheiro.Top = 22;
TotalSaidaDinheiro.Left = 170;
var valorMensalSaida = dtSaidas.AsEnumerable().Where(x => x.Field <int>("Mes") == datetime.Month).Sum(x => x.Field <decimal>("Valor"));
totalMesSaida.Text = valorMensalSaida.ToString("C");
pTotalSaida.Controls.Add(TotalSaidaDinheiro);
}
}
}
#endregion saidas
//saldo inicial
//DoCadastros.SaldoInicial_NovoDia(Convert.ToDateTime(datetime.ToShortDateString()));
DataTable dtSaldo = new DataTable();
dtSaldo = DoDiarioDeCaixa.DiarioCaixa_SaldoInicial();
var saldoInicial = dtSaldo.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).
Select(k =>
{
var row = dtSaldo.NewRow();
row.ItemArray = new object[]
{
k.Field <decimal>("saldo_inicial")
};
return(row);
});
if (saldoInicial.Any())
{
DataTable dtNew = saldoInicial.CopyToDataTable();
Panel pSaldoInicial = new Panel();
pSaldoInicial.Width = 294;
pSaldoInicial.Height = 65;
pSaldoInicial.BorderStyle = BorderStyle.FixedSingle;
pSaldoInicial.Top = 144;
pSaldoInicial.Left = 9;
pTotais.Controls.Add(pSaldoInicial);
//
Label saldoTitulo = new Label();
saldoTitulo.Name = "saldoTitulo";
saldoTitulo.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Regular);
saldoTitulo.ForeColor = Color.Black;
saldoTitulo.AutoSize = true;
saldoTitulo.Text = "Saldo Inicial";
saldoTitulo.Top = 10;
saldoTitulo.Left = 7;
pSaldoInicial.Controls.Add(saldoTitulo);
//
Label saldoI = new Label();
saldoI.Name = "saldoInicial";
saldoI.Font = new Font("Microsoft Sans Serif", 14, FontStyle.Regular);
saldoI.ForeColor = Color.Black;
saldoI.AutoSize = true;
openingBalance = decimal.Parse(dtNew.Rows[0][0].ToString());
saldoI.Text = openingBalance.ToString();
saldoI.Top = 22;
saldoI.Left = 7;
pSaldoInicial.Controls.Add(saldoI);
}
DataTable dtSaldoFinal = new DataTable();
dtSaldoFinal = DoDiarioDeCaixa.DiarioCaixa_SaldoFinal();
var saldoFinal = dtSaldoFinal.AsEnumerable().Where(x => x.Field <string>("Data") == datetime.ToShortDateString()).
Select(k =>
{
var row = dtSaldoFinal.NewRow();
row.ItemArray = new object[]
{
k.Field <decimal>("saldo_final")
};
return(row);
});
if (saldoFinal.Any())
{
DataTable dtResult = saldoFinal.CopyToDataTable();
//troco
Panel pTroco = new Panel();
pTroco.Width = 294;
pTroco.Height = 65;
pTroco.BorderStyle = BorderStyle.FixedSingle;
pTroco.Top = 213;
pTroco.Left = 9;
pTotais.Controls.Add(pTroco);
//
Label trocoTitulo = new Label();
trocoTitulo.Name = "trocoTitulo";
trocoTitulo.Font = new Font("Microsoft Sans Serif", 7, FontStyle.Regular);
trocoTitulo.ForeColor = Color.Black;
trocoTitulo.AutoSize = true;
trocoTitulo.Text = "Troco";
trocoTitulo.Top = 10;
trocoTitulo.Left = 7;
pTroco.Controls.Add(trocoTitulo);
//
Label troco = new Label();
troco.Name = "troco";
troco.Font = new Font("Microsoft Sans Serif", 14, FontStyle.Regular);
troco.ForeColor = Color.Black;
troco.AutoSize = true;
decimal valorTroco = Convert.ToDecimal(dtResult.Rows[0][0].ToString());
//decimal valorTroco = Convert.ToDecimal(dtSaldoCaixa.Rows[0][0].ToString());
troco.Text = valorTroco.ToString("C");
troco.Top = 22;
troco.Left = 7;
pTroco.Controls.Add(troco);
//DoCadastros.SaldoInicial_Troco(valorTroco, Convert.ToDateTime(datetime.ToShortDateString()));
}
}
