private void button3_Click(object sender, EventArgs e)
{
ImageDAO imageDAO = new ImageDAO();
CodeDAO codeDAO = new CodeDAO();
SourceControlDAO sourceControl = new SourceControlDAO();
BugDAO bugDAO = new BugDAO();
DialogResult dr = MessageBox.Show("Are you sure want to delete this bug?", "Are you sure", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information);
if (dr == DialogResult.Yes)
{
try
{
codeDAO.Delete(bugId);
imageDAO.Delete(bugId);
bugDAO.Delete(bugId);
sourceControl.Delete(bugId);
MessageBox.Show("Deleted");
this.Dispose();
new Bugs().Show();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
private void button5_Click(object sender, EventArgs e)
{
string codeFileName = bug.Codes.CodeFileName;
string codeFilePath = bug.Codes.CodeFilePath;
string c = fastColoredTextBox1.Text;
FixerDAO fixerDAO = new FixerDAO();
BugDAO bugDAO = new BugDAO();
Fixer fixer = new Fixer
{
FixedBy = Login.userId,
BugId = Program.bugId
};
try
{
fixerDAO.Insert(fixer);
bugDAO.BugFixed(Program.bugId);
MessageBox.Show("Oh great work");
this.Dispose();
new Bugs().Show();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
string path = "code/" + codeFileName + ".txt";
using (StreamWriter sw = File.CreateText(path))
{
sw.WriteLine(c);
}
}
public void load_tester_bugs()
{
BugDAO us = new BugDAO();
DataTable data = us.GetTesterBugs(id);
BindingSource bsource = new BindingSource();
bsource.DataSource = data;
Tester_bug.DataSource = bsource;
}
public void load_Programmer_bugs()
{
BugDAO us = new BugDAO();
DataTable data = us.GetProgrammerBugs(id);
BindingSource bsource = new BindingSource();
bsource.DataSource = data;
Tbl_grid.DataSource = bsource;
}
private void btn_view_Click(object sender, EventArgs e)
{
BugDAO us = new BugDAO();
OracleDataAdapter data = us.GetBugs();
DataTable dataset = new DataTable();
data.Fill(dataset);
BindingSource bsource = new BindingSource();
bsource.DataSource = dataset;
Tbl_data_error.DataSource = bsource;
data.Update(dataset);
}
private void button4_Click_2(object sender, EventArgs e)
{
BugDAO us = new BugDAO();
OracleDataAdapter data = us.GetBugs();
DataTable dataset = new DataTable();
data.Fill(dataset);
BindingSource bsource = new BindingSource();
bsource.DataSource = dataset;
BugView.DataSource = bsource;
data.Update(dataset);
}
public TesterDash()
{
InitializeComponent();
panel1.AutoScroll = false;
panel1.HorizontalScroll.Enabled = false;
panel1.HorizontalScroll.Visible = false;
panel1.HorizontalScroll.Maximum = 0;
panel1.AutoScroll = true;
LoopPanel loop = new LoopPanel();
BugDAO bug = new BugDAO();
loop.loopPanel(bug.getAllBugs(), panel1, this, new UpdateBug(false));
}
public void loadErrors()
{
BugDAO us = new BugDAO();
OracleDataAdapter data = us.GetBugs();
DataTable dataset = new DataTable();
data.Fill(dataset);
BindingSource bsource = new BindingSource();
bsource.DataSource = dataset;
Error_table.DataSource = bsource;
Tbl_grid1.DataSource = bsource;
Tbl_grid2.DataSource = bsource;
data.Update(dataset);
}
public void getAllBugsTest()
{
BugDAO bugDAO = new BugDAO();
List <Bug> bug = null;
try
{
bug = bugDAO.getAllBugs();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Assert.AreEqual("", bug);
}
private void tbl_bug_view_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
MessageBox.Show("You Cannot Select This Row");
}
else
{
String value = BugView.Rows[e.RowIndex].Cells[0].Value.ToString();
bug_id = int.Parse(value);
BugDAO us = new BugDAO();
DataTable data = us.GetBugs(bug_id);
BindingSource bsource = new BindingSource();
bsource.DataSource = data;
Tbl_data_history.DataSource = bsource;
}
}
private void Bugs_Load(object sender, EventArgs e)
{
panelBugs.AutoScroll = false;
panelBugs.HorizontalScroll.Enabled = false;
panelBugs.HorizontalScroll.Visible = false;
panelBugs.HorizontalScroll.Maximum = 0;
panelBugs.AutoScroll = true;
panelAssigned.AutoScroll = false;
panelAssigned.HorizontalScroll.Enabled = false;
panelAssigned.HorizontalScroll.Visible = false;
panelAssigned.HorizontalScroll.Maximum = 0;
panelAssigned.AutoScroll = true;
BugDAO bugDao = new BugDAO();
try
{
List <Bug> list = bugDao.getAllBugs();
var newLoopPanel = new LoopPanel();
var newUpdateBug = new UpdateBug(false);
newLoopPanel.loopPanel(list, panelBugs, this, newUpdateBug);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
try
{
List <Bug> bug = bugDao.GetAllBugsByProgrammerId(Login.userId);
var newLoopPanel = new LoopPanel();
var newUpdateBug = new UpdateBug(true);
newLoopPanel.loopPanel(bug, panelAssigned, this, newUpdateBug);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void Bugs_Load(object sender, EventArgs e)
{
panelBugs.AutoScroll = false;
panelBugs.HorizontalScroll.Enabled = false;
panelBugs.HorizontalScroll.Visible = false;
panelBugs.HorizontalScroll.Maximum = 0;
panelBugs.AutoScroll = true;
panelAssigned.AutoScroll = false;
panelAssigned.HorizontalScroll.Enabled = false;
panelAssigned.HorizontalScroll.Visible = false;
panelAssigned.HorizontalScroll.Maximum = 0;
panelAssigned.AutoScroll = true;
BugDAO bugDao = new BugDAO();
ArrayList list = bugDao.getAllBugs();
foreach (var l in list)
{
Console.WriteLine(l);
}
}
private void tbl_data_error_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
MessageBox.Show("You Cannot Select This Row");
}
else
{
BugDAO bg = new BugDAO();
String value = Tbl_data_error.Rows[e.RowIndex].Cells[0].Value.ToString();
Tbl_data_error_id = int.Parse(value);
DataTable dr = bg.GetAllBugs(Tbl_data_error_id);
if (dr.Rows.Count > 0)
{
txt_program_name.Text = "Program: " + dr.Rows[0][1].ToString();
txt_class_name.Text = "Class: " + dr.Rows[0][2].ToString();
txt_method_name.Text = "Method: " + dr.Rows[0][3].ToString();
txt_symptom1.Text = "Symptoms: " + dr.Rows[0][6].ToString();
txt_cause1.Text = "Cause: " + dr.Rows[0][7].ToString();
txt_date1.Text = " Date: " + dr.Rows[0][5].ToString();
txt_description1.Text = "Image name: " + dr.Rows[0][9].ToString();
txt_found_by.Text = "Found by: " + dr.Rows[0][12].ToString();
linkLabel1.Text = dr.Rows[0][10].ToString();
txt_source1.Text = dr.Rows[0][11].ToString();
byte[] imgData = (byte[])dr.Rows[0][8];
MemoryStream ms = new MemoryStream();
ms.Write(imgData, 0, imgData.Length);
Bitmap bmp = new Bitmap(ms, false);
pic_desc.Image = bmp;
ms.Dispose();
}
else
{
MessageBox.Show("No data found");
}
}
}
public BugBO(string tipo)
{
bugDAO = new BugDAO(tipo);
}
private void button2_Click(object sender, EventArgs e)
{
String class_name = txt_class.Text;
String method = txt_method.Text;
String line = txt_line.Text;
int linee = int.Parse(line);
String path = txt_path.Text;
String symptom = txt_sym.Text;
String cause = txt_cause.Text;
String img_desc = txt_name.Text;
String code_block = FastColour.Text;
String source_link = txt_link.Text;
if (String.IsNullOrEmpty(class_name))
{
MessageBox.Show("Please Provide Valid Information");
}
else if (String.IsNullOrEmpty(method))
{
MessageBox.Show("Please Provide Valid mathod name");
}
else if (String.IsNullOrEmpty(symptom))
{
MessageBox.Show("Please Provide Valid Symptom");
}
else if (String.IsNullOrEmpty(cause))
{
MessageBox.Show("Please Provide Valid Cause");
}
else if (String.IsNullOrEmpty(path))
{
MessageBox.Show("Please Provide Valid Path");
}
else if (String.IsNullOrEmpty(img_desc))
{
MessageBox.Show("Please Provide Valid Image Description");
}
else if (program_id == 0)
{
MessageBox.Show("Please Select program from Table");
}
else if (String.IsNullOrEmpty(source_link))
{
MessageBox.Show("Please Provide Valid Source Link");
}
else if (String.IsNullOrEmpty(code_block))
{
MessageBox.Show("Please Provide Error Code");
}
else
{
Bug bug = new Bug()
{
program = program_id,
class_name = class_name,
method_name = method,
line_number = linee,
found_by = id
};
BugDAO bu = new BugDAO();
bug_id = bu.Insert(bug);
Console.WriteLine(bug_id);
BugDetails bugd = new BugDetails()
{
bug_id = bug_id,
image = imgdata,
symptom = symptom,
cause = cause,
image_name = img_desc,
code_block = code_block,
source_link = source_link
};
BugDetailsDAO db = new BugDetailsDAO();
int done = db.Insert(bugd);
if (done != 0 && bug_id != 0)
{
MessageBox.Show("inserted");
ClearFields();
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
//bug
Bug bug = new Bug
{
BugId = bugId,
ProjectName = label1.Text,
ClassName = textBox2.Text,
MethodName = textBox3.Text,
StartLine = Convert.ToInt16(textBox4.Text),
EndLine = Convert.ToInt16(textBox5.Text),
ProgrammerId = Login.userId,
Status = "0"
};
try
{
BugDAO bugDao = new BugDAO();
bugDao.Update(bug);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//image
if (!string.IsNullOrEmpty(ImageName))
{
string appPath = Path.GetDirectoryName(Application.ExecutablePath) + @"\code_image\";
Bug_Tracker.Model.Image image = new Bug_Tracker.Model.Image
{
ImageId = imageId,
ImagePath = "code_image",
ImageName = ImageName,
BugId = bug.BugId
};
try
{
ImageDAO codeDao = new ImageDAO();
codeDao.Update(image);
File.Delete("code_image/" + currentImageName);
File.Copy(imageName, appPath + ImageName);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////code
string c = fastColoredTextBox1.Text;
//Code code = new Code
//{
// CodeId = codeId,
// CodeFilePath = "code",
// CodeFileName = codeFileName,
// ProgrammingLanguage = programminLanguage,
// BugId = bug.BugId
//};
try
{
string path = @"code/" + codeFileName + ".txt";
using (StreamWriter sw = File.CreateText(path))
{
sw.WriteLine(c);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
MessageBox.Show("Updated");
}
private void button1_Click(object sender, EventArgs e)
{
//bug
BugViewModel bug = new BugViewModel
{
ProjectName = textBox1.Text,
ClassName = textBox2.Text,
MethodName = textBox3.Text,
StartLine = Convert.ToInt16(textBox4.Text),
EndLine = Convert.ToInt16(textBox5.Text),
ProgrammerId = Login.userId
};
try
{
BugDAO bugDao = new BugDAO();
bugDao.Insert(bug);
} catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//image
string appPath = Path.GetDirectoryName(Application.ExecutablePath) + @"\code_image\";
Bug_Tracker.Model.PictureViewModel image = new Bug_Tracker.Model.PictureViewModel
{
ImagePath = "code_image",
ImageName = imageName,
BugId = bug.BugId
};
try
{
ImageDAO codeDao = new ImageDAO();
codeDao.Insert(image);
File.Copy(imageName, appPath + ImageName);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////code
string c = fastColoredTextBox1.Text;
string codeFileName = DateTime.Now.Second.ToString();
CodeViewModel code = new CodeViewModel
{
CodeFilePath = "code",
CodeFileName = codeFileName,
ProgrammingLanguage = programminLanguage,
BugId = bug.BugId
};
try
{
CodeDAO codeDao = new CodeDAO();
codeDao.Insert(code);
string path = "code/" + codeFileName + ".txt";
if (!File.Exists(path))
{
// Create a file to write to.
using (StreamWriter sw = File.CreateText(path))
{
sw.WriteLine(c);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
//Bug bug = new Bug { BugId = }
}
private void UpdateBug_Load_1(object sender, EventArgs e)
{
BugDAO bugDAO = new BugDAO();
bug = bugDAO.GetById(Program.bugId);
this.StartPosition = FormStartPosition.CenterScreen;
//this.FormBorderStyle = FormBorderStyle.None;
this.WindowState = FormWindowState.Maximized;
if (disableButtons)
{
textBox2.Enabled = false;
textBox3.Enabled = false;
textBox4.Enabled = false;
textBox5.Enabled = false;
button2.Hide();
button3.Hide();
btnUpdate.Hide();
button5.Show();
}
else
{
button5.Show();
}
//binding value to related labels and textbox
label1.Text = bug.ProjectName;
textBox2.Text = bug.ClassName;
textBox3.Text = bug.MethodName;
textBox4.Text = bug.StartLine.ToString();
textBox5.Text = bug.EndLine.ToString();
programminLanguage = bug.Codes.ProgrammingLanguage;
currentImageName = bug.Images.ImageName;
codeFileName = bug.Codes.CodeFileName;
//assiging related table's id
bugId = bug.BugId;
codeId = bug.Codes.CodeId;
imageId = bug.Images.ImageId;
linkLabel1.Text = bug.SourceControl.Link;
/*
* Open the file to read from.
* reading text from code file
*/
string path = bug.Codes.CodeFilePath + "/" + bug.Codes.CodeFileName + ".txt";
using (StreamReader sr = File.OpenText(path))
{
string s = "";
while ((s = sr.ReadLine()) != null)
{
fastColoredTextBox1.Text = fastColoredTextBox1.Text + Environment.NewLine + s;
}
}
//assigning programming language for text box
string programmingLanguage = bug.Codes.ProgrammingLanguage;
if (programmingLanguage == "CSharp")
{
fastColoredTextBox1.Language = FastColoredTextBoxNS.Language.CSharp;
}
else if (programmingLanguage == "HTML")
{
fastColoredTextBox1.Language = FastColoredTextBoxNS.Language.HTML;
}
else if (programmingLanguage == "JavaScript")
{
fastColoredTextBox1.Language = FastColoredTextBoxNS.Language.JS;
}
else if (programmingLanguage == "Lua")
{
fastColoredTextBox1.Language = FastColoredTextBoxNS.Language.Lua;
}
else if (programmingLanguage == "PHP")
{
fastColoredTextBox1.Language = FastColoredTextBoxNS.Language.PHP;
}
else if (programmingLanguage == "SQL")
{
fastColoredTextBox1.Language = FastColoredTextBoxNS.Language.SQL;
}
else if (programmingLanguage == "VB")
{
fastColoredTextBox1.Language = FastColoredTextBoxNS.Language.VB;
}
else if (programmingLanguage == "XML")
{
fastColoredTextBox1.Language = FastColoredTextBoxNS.Language.XML;
}
if (bug.Images.ImageName != "")
{
pictureBox1.Image = new Bitmap(Path.Combine(bug.Images.ImagePath + "/", bug.Images.ImageName));
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(comboBox1.SelectedItem.ToString()) || string.IsNullOrEmpty(textBox2.Text) || string.IsNullOrEmpty(textBox3.Text) || string.IsNullOrEmpty(textBox4.Text) || string.IsNullOrEmpty(textBox5.Text) || string.IsNullOrEmpty(textBox1.Text) || string.IsNullOrEmpty(textBox6.Text) || string.IsNullOrEmpty(textBox7.Text))
{
MessageBox.Show("You must add all project information");
}
else if (string.IsNullOrEmpty(fastColoredTextBox1.Text))
{
MessageBox.Show("Code field cann't be null");
}
else
{
//bug
Bug bug = new Bug
{
ProjectName = comboBox1.SelectedItem.ToString(),
ClassName = textBox2.Text,
MethodName = textBox3.Text,
StartLine = Convert.ToInt16(textBox4.Text),
EndLine = Convert.ToInt16(textBox5.Text),
ProgrammerId = Login.userId,
Status = "0"
};
try
{
BugDAO bugDao = new BugDAO();
bugDao.Insert(bug);
inserted = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//image
if (!string.IsNullOrEmpty(imageName))
{
string appPath = Path.GetDirectoryName(Application.ExecutablePath) + @"\code_image\";
Bug_Tracker.Model.Image image = new Bug_Tracker.Model.Image
{
ImagePath = "code_image",
ImageName = ImageName,
BugId = bug.BugId
};
try
{
ImageDAO codeDao = new ImageDAO();
codeDao.Insert(image);
File.Copy(imageName, appPath + ImageName);
inserted1 = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////code
string c = fastColoredTextBox1.Text;
string codeFileName = DateTime.Now.Second.ToString();
Code code = new Code
{
CodeFilePath = "code",
CodeFileName = codeFileName,
ProgrammingLanguage = programminLanguage,
BugId = bug.BugId
};
try
{
CodeDAO codeDao = new CodeDAO();
codeDao.Insert(code);
string path = "code/" + codeFileName + ".txt";
if (!File.Exists(path))
{
// Create a file to write to.
using (StreamWriter sw = File.CreateText(path))
{
sw.WriteLine(c);
}
}
inserted2 = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////Link
SourceControl sourceControl = new SourceControl
{
Link = textBox1.Text,
StartLine = Convert.ToInt32(textBox6.Text),
EndLine = Convert.ToInt32(textBox7.Text),
BugId = bug.BugId
};
SourceControlDAO sourceControlDAO = new SourceControlDAO();
try
{
sourceControlDAO.Insert(sourceControl);
inserted3 = true;
} catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
if (inserted && inserted1 && inserted2)
{
MessageBox.Show("Added");
}
else
{
MessageBox.Show("Unable to add");
}
}
}
private void executarAcao(DataGrid grid, Label lbl, int opcao, bool inteiro)
{
if (validarExibicaoTabela())
{
DataTable tabela = new DataTable();
List <Funcionario> listaFuncionario = new List <Funcionario>();
List <string> listaColunas = new List <string>();
prepararTabela(tabela, listaFuncionario, listaColunas, inteiro);
decimal mediaGeral = 0;
foreach (Funcionario func in listaFuncionario)
{
object[] linha = new object[listaColunas.Count + 2]; // +2 por causa das colunas nome e media
linha[0] = func.Nome;
decimal media = 0;
for (int i = 0; i < listaColunas.Count; i++)
{
if (opcao == OpcaoIndicador.NUM_TAREFA_POR_SPRINT)
{
TarefaBO tBO = new TarefaBO();
linha[i + 1] = tBO.RecuperarQtdeItensPorSprintPorResponsavel(listaColunas[i], func.Codigo);
}
else if (opcao == OpcaoIndicador.NUM_RELATO_CORRIGIDO_POR_SPRINT)
{
BugDAO rDAO = new BugDAO(Constantes.RELATO);
linha[i + 1] = rDAO.recuperarQtdeItensPorSprintPorResponsavel(listaColunas[i], func.Codigo);
}
else if (opcao == OpcaoIndicador.NUM_ITEM_POR_SPRINT)
{
ItemBacklogDAO ibDAO = new ItemBacklogDAO();
linha[i + 1] = ibDAO.recuperarQtdeItensBacklogPorSprintPorResponsavel(listaColunas[i], func.Codigo);
}
else if (opcao == OpcaoIndicador.COMPLEXIDADE_ITEM_POR_SPRINT)
{
// =SOMARPRODUTO(($Backlog.$E$2:$E$200=B$2)*($Backlog.$R$2:$R$200>0)*($Backlog.$I$2:$I$200))/SOMARPRODUTO(($Backlog.$E$2:$E$200=B$2)*($Backlog.$R$2:$R$200>0))
// E = Planejado Para
// R = Somatorio numero tarefas do funcionario no item de backlog
// I = Complexidade do Item
ItemBacklogDAO ibDAO = new ItemBacklogDAO();
linha[i + 1] = ibDAO.recuperarComplexidadeItensPorSprintPorResponsavel(listaColunas[i], func.Codigo);
}
else if (opcao == OpcaoIndicador.NUM_DEFEITO_CORRIGIDO_POR_SPRINT)
{
// =SOMARPRODUTO(($Backlog.$E$2:$E$200=B$2)*($Backlog.$R$2:$R$200>0)*($Backlog.$M$2:$M$200))/SOMARPRODUTO(($Backlog.$E$2:$E$200=B$2)*($Backlog.$R$2:$R$200>0))
// M = Quantidade de defeitos do Item
BugDAO dDAO = new BugDAO(Constantes.DEFEITO);
linha[i + 1] = dDAO.recuperarQtdeItensPorSprintPorResponsavel(listaColunas[i], func.Codigo);
}
else if (opcao == OpcaoIndicador.NUM_DEFEITO_CRIADO_POR_SPRINT)
{
BugBO dBO = new BugBO(Constantes.DEFEITO);
linha[i + 1] = dBO.recuperarQtdeItensPorSprintPorCriador(listaColunas[i], func.Nome);
}
//else if (opcao == OpcaoIndicador.NUM_DEFEITO_POR_ITEM_BACKLOG)
//{
// // =SOMARPRODUTO(($Backlog.$E$2:$E$200=B$2)*($Backlog.$R$2:$R$200>0)*($Backlog.$M$2:$M$200))/SOMARPRODUTO(($Backlog.$E$2:$E$200=B$2)*($Backlog.$R$2:$R$200>0))
// // M = Quantidade de defeitos do Item
// BugDAO dDAO = new BugDAO(Constantes.DEFEITO);
// linha[i + 1] = dDAO.recuperarMediaDefeitosPorSprintPorResponsavel(listaColunas[i], func.Codigo);
//}
//else if (opcao == OpcaoIndicador.NUM_TAREFA_ESTIMATIVA_MAIOR_TEMPO_GASTO)
//{
// TarefaDAO tDAO = new TarefaDAO();
// linha[i + 1] = tDAO.recuperarQtdeTarefasPorSprintTempoGastoMaiorEstimativa(listaColunas[i], func.Codigo);
//}
//else if (opcao == OpcaoIndicador.NUM_TAREFA_TEMPO_GASTO_MAIOR_24)
//{
// TarefaDAO tDAO = new TarefaDAO();
// linha[i + 1] = tDAO.recuperarQtdeTarefasTempoGastoMaior24(listaColunas[i], func.Codigo);
//}
else
{
linha[i + 1] = i;
}
media += Convert.ToDecimal(linha[i + 1]);
}
mediaGeral += Decimal.Round((media / listaColunas.Count), 2);
linha[listaColunas.Count + 1] = Decimal.Round((media / listaColunas.Count), 2);
tabela.Rows.Add(linha);
}
lbl.Content = Decimal.Round((mediaGeral / tabela.Rows.Count), 2);;
preencherGrid(grid, tabela);
}
}