private void btnGerarCapacity_Click(object sender, EventArgs e)
{
try
{
string param = cGlobal.InputBox("Digite o ano", "Capacity", "");
if (!string.IsNullOrEmpty(param))
{
cCapacity cc = new cCapacity();
cc.ano = param;
if (!cc.verifica_capacity_ano(cc))
{
if (cc.gera_capacity(cc) > 1)
{
MessageBox.Show("Capacity gerado com sucesso.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Problemas ao gerar Capacity.", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
#region LOG
cLog lg = new cLog();
lg.log = string.Concat("Geração de Capacity para o ano ", param, Environment.NewLine);
lg.form = this.Text;
lg.metodo = sender.ToString();
lg.dt = DateTime.Now;
lg.usersistema = cGlobal.userlogado;
lg.userRede = Environment.UserName;
lg.terminal = Environment.MachineName;
lg.tp_flag = true;
lg.grava_log(lg);
#endregion
}
else
{
MessageBox.Show(string.Format("Já consta capacity gerado para o ano de {0}.", param), "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
else
{
return;
}
}
catch (Exception ex)
{
#region LOG ERRO
cLog lg = new cLog();
lg.log = ex.Message.Replace("'", "");
lg.form = this.Text;
lg.metodo = sender.ToString();
lg.dt = DateTime.Now;
lg.usersistema = cGlobal.userlogado;
lg.userRede = Environment.UserName;
lg.terminal = Environment.MachineName;
lg.tp_flag = false;
lg.grava_log(lg);
#endregion
}
}
private void frmCapacity_Load(object sender, EventArgs e)
{
try
{
cCapacity cp = new cCapacity();
dtpData.Value = DateTime.Now;
inicio(DateTime.Now);
}
catch (Exception ex)
{
#region LOG ERRO
cLog lg = new cLog();
lg.log = ex.Message.Replace("'", "");
lg.form = this.Text;
lg.metodo = sender.ToString();
lg.dt = DateTime.Now;
lg.usersistema = cGlobal.userlogado;
lg.userRede = Environment.UserName;
lg.terminal = Environment.MachineName;
lg.tp_flag = false;
lg.grava_log(lg);
#endregion
}
}
//private void liberarObjetos(object obj)
//{
// try
// {
// System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
// obj = null;
// }
// catch (Exception ex)
// {
// obj = null;
// MessageBox.Show("Ocorreu um erro durante a liberação do objeto " + ex.ToString());
// }
// finally
// {
// GC.Collect();
// }
//}
#endregion
#region METODOS
private void inicio(DateTime data)
{
#region CAMPOS
DataGridViewTextBoxColumn campo0 = new DataGridViewTextBoxColumn();
campo0.Name = "Responsavel";
campo0.HeaderText = "RESPONSÁVEL";
campo0.DataPropertyName = "RESPONSAVEL";
campo0.Width = 130;
DataGridViewTextBoxColumn campo1 = new DataGridViewTextBoxColumn();
campo1.Name = "MINUTOS";
campo1.HeaderText = "MINUTOS";
campo1.DataPropertyName = "MINUTOS";
campo1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
DataGridViewTextBoxColumn campo2 = new DataGridViewTextBoxColumn();
campo2.Name = "DISPONIVEL";
campo2.HeaderText = "DISPONÍVEL";
campo2.DataPropertyName = "DISPONIVEL";
campo2.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
DataGridViewTextBoxColumn campo3 = new DataGridViewTextBoxColumn();
campo3.Name = "Comprometido";
campo3.HeaderText = "COMPROMETIDO";
campo3.DataPropertyName = "COMPROMETIDO";
campo3.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
DataGridViewTextBoxColumn campo4 = new DataGridViewTextBoxColumn();
campo4.Name = "Reservado";
campo4.HeaderText = "RESERVADO";
campo4.DataPropertyName = "RESERVA";
campo4.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
#endregion
cCapacity cc = new cCapacity();
using (DataSet ds = cc.retorna_capacity_dia(data))
{
using (DataTable dt = ds.Tables["Capacity"])
{
dgvCapacity.Columns.Clear();
dgvCapacity.AutoGenerateColumns = false;
dgvCapacity.Columns.AddRange(new DataGridViewColumn[] { campo0, campo1, campo2, campo3, campo4 });
dgvCapacity.DataSource = dt;
dgvCapacity.Columns["RESPONSAVEL"].Frozen = true;
cDGV modelo = new cDGV();
dgvCapacity = modelo.Grade(dgvCapacity);
#region GRAFICO
chtGrafico.DataSource = null;
chtGrafico.DataBind();
chtGrafico.DataSource = dt;
chtGrafico.Series["Minutos"].XValueMember = Convert.ToString(dt.Columns[2].ToString());
chtGrafico.Series["Minutos"].YValueMembers = Convert.ToString(dt.Columns[3].ToString());
chtGrafico.Series["Disponivel"].XValueMember = Convert.ToString(dt.Columns[2].ToString());
chtGrafico.Series["Disponivel"].YValueMembers = Convert.ToString(dt.Columns[4].ToString());
chtGrafico.Series["Comprometido"].XValueMember = Convert.ToString(dt.Columns[2].ToString());
chtGrafico.Series["Comprometido"].YValueMembers = Convert.ToString(dt.Columns[5].ToString());
chtGrafico.Series["Reservado"].XValueMember = Convert.ToString(dt.Columns[2].ToString());
chtGrafico.Series["Reservado"].YValueMembers = Convert.ToString(dt.Columns[6].ToString());
chtGrafico.DataBind();
#endregion
}
}
}
