private void CarregaDGVs()
{
DateTime Data = new DateTime(AnoAtual, mesAtual, 1);
DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao);
BLLConsultaCMV bll = new BLLConsultaCMV(cx);
DataTable table = bll.ListarCustoReceitaPaxAcrescimos(idUnidade, Data);
dgvCusto.DataSource = table;
dgvCusto.Columns[0].Width = 70;
dgvCusto.Columns[0].HeaderText = "DATA";
dgvCusto.Columns[1].Width = 70;
dgvCusto.Columns[1].HeaderText = "CUSTO";
dgvCusto.Columns[2].Width = 70;
dgvCusto.Columns[2].HeaderText = "+CUSTO";
dgvCusto.Columns[3].Width = 70;
dgvCusto.Columns[3].HeaderText = "RECEITA_B";
dgvCusto.Columns[4].Width = 70;
dgvCusto.Columns[4].HeaderText = "RECEITA_L";
dgvCusto.Columns[5].Width = 70;
dgvCusto.Columns[5].HeaderText = "+RECEITA";
dgvCusto.Columns[6].Width = 50;
dgvCusto.Columns[6].HeaderText = "PAX";
dgvCusto.Columns[7].Width = 50;
dgvCusto.Columns[7].HeaderText = "+PAX";
//carrega dgvAcrescimos
dgvAcrescimos.Rows.Clear();
BLLAcrescimos blla = new BLLAcrescimos(cx);
DataTable acrescimos = blla.LocalizarAcrescimos(idUnidade, Data);
string data;
String[] S;
for (int i = 0; i < acrescimos.Rows.Count; i++)
{
data = Convert.ToDateTime(acrescimos.Rows[i][1]).ToShortDateString();
S = new string[] { acrescimos.Rows[i][0].ToString(), data, acrescimos.Rows[i][2].ToString(), acrescimos.Rows[i][3].ToString(), acrescimos.Rows[i][4].ToString(), acrescimos.Rows[i][5].ToString() };
dgvAcrescimos.Rows.Add(S);
}
}
private void AtualizaDGV()
{
String[] T = new string[] { "-1", "CONTA GERENCIAL", "CUSTO", "$", "%" };
this.dgvDetalhe.Rows.Add(T);
String[] V;
int grupoCusto = 01;
DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao);
BLLCmvGraficos bll = new BLLCmvGraficos(cx);
BLLConsultaCMV bllc = new BLLConsultaCMV(cx);
DataTable TABELA;
if (geral)
{
TABELA = bll.TabelaCustoCMVReceitaPaxGeral(unidade, diaI, diaF, grupoCusto);
}
else
{
TABELA = bll.TabelaCustoCMVReceitaPaxPorGrupo(unidade, diaI, diaF, grupo, grupoCusto);
}
if (TABELA.Rows.Count > 0)
{
for (int i = 0; i < TABELA.Rows.Count; i++)
{
V = new string[] { TABELA.Rows[i][0].ToString(), TABELA.Rows[i][1].ToString(), Convert.ToDouble(TABELA.Rows[i][2]).ToString("#,0.00"), Convert.ToDouble(TABELA.Rows[i][3]).ToString("#,0.00"), Convert.ToDouble(TABELA.Rows[i][4]).ToString("#,0.00") + "%" };
this.dgvDetalhe.Rows.Add(V);
}
}
else
{
}
V = new string[] { "0", "", "", "", "" };
this.dgvDetalhe.Rows.Add(V);
if (TABELA.Rows.Count > 0)
{
V = new string[] { "-1", "TOTAL", Convert.ToDouble(TABELA.Rows[0][5]).ToString("#,0.00"), (Convert.ToDouble(TABELA.Rows[0][5]) / Convert.ToDouble(TABELA.Rows[0][7])).ToString("#,0.00"), ((Convert.ToDouble(TABELA.Rows[0][5]) / Convert.ToDouble(TABELA.Rows[0][6])) * 100).ToString("#,0.00") + "%" };
this.dgvDetalhe.Rows.Add(V);
}
lbReceitaePax.Text = $"Total Pax = {Convert.ToDouble(TABELA.Rows[0][7]).ToString("#,0")} - total receita = R$ {Convert.ToDouble(TABELA.Rows[0][6]).ToString("#,0.00")}";
}
void CarregarPizza1()
{
DateTime Diai = new DateTime(Convert.ToInt32(numAno.Value), Convert.ToInt32(cbMes.SelectedValue), 1);
DateTime Diaf = Diai.AddDays(-(Diai.Day - 1)).AddMonths(1).AddDays(-1);
DateTime DiaA = Diai;
int unidade = Convert.ToInt32(cbUnidade.SelectedValue);
DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao);
BLLConsultaCMV bll = new BLLConsultaCMV(cx);
DataTable tabela;
ComparativoCusto.Series.Clear();
Series series1 = new Series
{
Name = "Serie1",
IsVisibleInLegend = true,
Color = System.Drawing.Color.Green,
ChartType = SeriesChartType.Pie
};
ComparativoCusto.Series.Add(series1);
double valor1, valor2, valor3;
string percent1, percent2, percent3;
tabela = bll.TotalCustoPorTipo(unidade, "a", Diai, Diaf);
try { valor1 = Convert.ToDouble(tabela.Rows[0][0]); }catch { valor1 = 0; }
tabela = bll.TotalCustoPorTipo(unidade, "b", Diai, Diaf);
try { valor2 = Convert.ToDouble(tabela.Rows[0][0]); } catch { valor2 = 0; }
tabela = bll.TotalCustoPorTipo(unidade, "o", Diai, Diaf);
try { valor3 = Convert.ToDouble(tabela.Rows[0][0]); } catch { valor3 = 0; }
if ((Math.Round(valor1 / (valor1 + valor2 + valor3), 2)) * 100 >= 5)
{
percent1 = ((Math.Round(valor1 / (valor1 + valor2 + valor3), 2)) * 100).ToString() + "%";
}
else
{
percent1 = "";
}
if ((Math.Round(valor2 / (valor1 + valor2 + valor3), 2)) * 100 >= 5)
{
percent2 = ((Math.Round(valor2 / (valor1 + valor2 + valor3), 2)) * 100).ToString() + "%";
}
else
{
percent2 = "";
}
if ((Math.Round(valor3 / (valor1 + valor2 + valor3), 2)) * 100 >= 5)
{
percent3 = ((Math.Round(valor3 / (valor1 + valor2 + valor3), 2)) * 100).ToString() + "%";
}
else
{
percent3 = "";
}
series1.Points.Add(valor1);
series1.Points.Add(valor2);
series1.Points.Add(valor3);
var p1 = series1.Points[0];
p1.AxisLabel = percent1;
p1.LegendText = "Alimentos";
var p2 = series1.Points[1];
p2.AxisLabel = percent2;
p2.LegendText = "Bebidas";
var p3 = series1.Points[2];
p3.AxisLabel = percent3;
p3.LegendText = "Outros";
}
private void CarregaDiaENoite()
{
graficoComparativo1.Series[0].Points.Clear();
graficoComparativo1.Series[1].Points.Clear();
DateTime diaI = new DateTime(Convert.ToInt32(numAno.Value), Convert.ToInt32(cbMes.SelectedValue), 1);
DateTime diaF = diaI.AddDays(-(diaI.Day - 1)).AddMonths(1).AddDays(-1);
DateTime DiaA = diaI;
int unidade = Convert.ToInt32(cbUnidade.SelectedValue);
int paxD, paxN, p, c;
double cmvD, cmvN;
DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao);
BLLConsultaCMV bll = new BLLConsultaCMV(cx);
DataTable TabelaCustoD, TabelaCustoN, TabelaPax, totalCustoD, totalCustoN, totalCusto, totalPaxD, totalPaxN;
TabelaCustoD = bll.TabelaCustoPorTutno(unidade, diaI, diaF, "a");
TabelaCustoN = bll.TabelaCustoPorTutno(unidade, diaI, diaF, "j");
TabelaPax = bll.TabelaPaxPorDia(unidade, diaI, diaF);
totalCustoD = bll.TotalCustoAeB(unidade, diaI, diaF, "a");
totalCustoN = bll.TotalCustoAeB(unidade, diaI, diaF, "j");
totalCusto = bll.TotalCustoAeBGeral(unidade, diaI, diaF);
totalPaxD = bll.TotalPax(unidade, diaI, diaF, 1);
totalPaxN = bll.TotalPax(unidade, diaI, diaF, 0);
DiaA = diaI;
p = 0;
c = 0;
if (cbComparativo.SelectedValue.ToString() == "1")
{
cmvD = 0;
cmvN = 0;
for (int i = 0; i < diaF.Day; i++)
{
try
{
if (Convert.ToDateTime(TabelaCustoD.Rows[c][0]) != Convert.ToDateTime(TabelaPax.Rows[p][0]))
{
if (Convert.ToDateTime(TabelaCustoD.Rows[c][0]) > Convert.ToDateTime(TabelaPax.Rows[p][0]))
{
cmvD = 0;
p++;
}
else
{
cmvD = 0;
c++;
}
}
else
{
if (Convert.ToDateTime(TabelaCustoD.Rows[c][0]) == DiaA)
{
cmvD = Math.Round(Convert.ToDouble(TabelaCustoD.Rows[c][1]) / Convert.ToDouble(TabelaPax.Rows[p][1]), 2) * -1;
c++;
p++;
}
else
{
cmvD = 0;
}
}
}
catch
{
cmvD = 0;
p++;
c++;
}
graficoComparativo1.Series["Dia"].Points.AddXY(DiaA.Day.ToString(), cmvD);
DiaA = DiaA.AddDays(1);
}
DiaA = diaI;
p = 0;
c = 0;
for (int i = 0; i < diaF.Day; i++)
{
try
{
if (Convert.ToDateTime(TabelaCustoN.Rows[c][0]) != Convert.ToDateTime(TabelaPax.Rows[p][0]))
{
if (Convert.ToDateTime(TabelaCustoN.Rows[c][0]) > Convert.ToDateTime(TabelaPax.Rows[p][0]))
{
cmvN = 0;
p++;
}
else
{
cmvN = 0;
c++;
}
}
else
{
if (Convert.ToDateTime(TabelaCustoN.Rows[c][0]) == DiaA)
{
cmvN = Math.Round(Convert.ToDouble(TabelaCustoN.Rows[c][1]) / Convert.ToDouble(TabelaPax.Rows[p][1]), 2) * -1;
c++;
p++;
}
else
{
cmvN = 0;
}
}
}
catch
{
cmvN = 0;
p++;
c++;
}
graficoComparativo1.Series["Noite"].Points.AddXY(DiaA.Day.ToString(), cmvN);
DiaA = DiaA.AddDays(1);
}
try
{
paxD = Convert.ToInt32(totalPaxD.Rows[0][0]);
paxN = Convert.ToInt32(totalPaxN.Rows[0][0]);
cmvD = Convert.ToDouble(totalCustoD.Rows[0][0]) / (paxD + paxN);
cmvN = Convert.ToDouble(totalCustoN.Rows[0][0]) / (paxD + paxN);
graficoComparativo1.Series["Dia"].Points.AddXY("Total", Math.Round(cmvD * -1, 2));
graficoComparativo1.Series["Noite"].Points.AddXY("Total", Math.Round(cmvN * -1, 2));
}
catch { }
}
else
{
}
}
