private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
qp.AddSupplier(bunifuMaterialTextbox1.Text, bunifuMaterialTextbox2.Text);
this.suppliersTableAdapter.Fill(this.cMSDataSet1SS.Suppliers);
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
qp.UpdateCT(bunifuMaterialTextbox1.Text, bunifuMaterialTextbox2.Text, bunifuMaterialTextbox6.Text, bunifuMaterialTextbox3.Text, bunifuMaterialTextbox4.Text, bunifuMaterialTextbox5.Text, bunifuMaterialTextbox7.Text, bunifuMaterialTextbox8.Text);
CMS.Form7.refreshcheck = 100;
}
private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
{
QProject qp = new QProject();
qp.Budgetbalance(comboBox1.SelectedItem.ToString());
bunifuMaterialTextbox3.Text = qp.bdgblnce;
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
byte[] img = null;
FileStream fs = new FileStream(imgloc, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
img = br.ReadBytes((int)fs.Length);
title = bunifuMaterialTextbox1.Text;
orgname = bunifuMaterialTextbox2.Text;
tender = bunifuMaterialTextbox3.Text;
entrydate = bunifuDatepicker1.Value.ToShortDateString();
status = comboBox1.SelectedItem.ToString();
type = bunifuMaterialTextbox4.Text;
duration = bunifuMaterialTextbox6.Text;
comment = bunifuMaterialTextbox5.Text;
budget = Convert.ToInt32(bunifuMaterialTextbox7.Text);
if (title == string.Empty || orgname == null || tender == null || entrydate == null || status == null || duration == null || budget == 0)
{
DialogResult DDR = MessageBox.Show("Fields are Empty!", "Dynamic Engineering", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
qp.AddProject(title, orgname, tender, entrydate, status, type, duration, comment, budget, img);
CMS.Project.refreshcheck = 100;
}
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
qp.UpdateProject(bunifuMaterialTextbox1.Text, bunifuMaterialTextbox2.Text, bunifuMaterialTextbox3.Text, bunifuMaterialTextbox7.Text, bunifuMaterialTextbox8.Text, bunifuMaterialTextbox4.Text, bunifuMaterialTextbox6.Text, bunifuMaterialTextbox5.Text, Convert.ToInt64(bunifuMaterialTextbox9.Text));
CMS.Project.refreshcheck = 100;
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
user = bunifuMaterialTextbox1.Text;
pass = textBox1.Text;
QProject qp = new QProject();
qp.LoginCheck(user, pass);
bunifuMaterialTextbox1.Text = "";
textBox1.Text = "";
}
private void bunifuFlatButton3_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Are you sure you want to Delete?", "WARNING!", MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Stop);
if (dr == DialogResult.Yes)
{
QProject qp = new QProject();
qp.DeleteBudget(idbbb);
this.budgetTableAdapter.Fill(this.budgetDS.Budget);
}
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
pname = bunifuMaterialTextbox2.Text;
quantity = Convert.ToInt32(bunifuMaterialTextbox3.Text);
value = Convert.ToInt32(bunifuMaterialTextbox7.Text);
comment = bunifuMaterialTextbox5.Text;
type = comboBox1.SelectedItem.ToString();
qp.AddMaterial(pname, quantity, value, comment, type);
CMS.Material.refreshcheck = 100;
}
private void bunifuFlatButton3_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Are you sure you want to Delete?", "WARNING!", MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Stop);
if (dr == DialogResult.Yes)
{
QProject qp = new QProject();
qp.DeleteContask(idconstructing);
this.constructTaskTableAdapter1.Fill(this.cMSDataSet1CS.ConstructTask);
}
}
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
user = bunifuMaterialTextbox1.Text;
pass = textBox1.Text;
QProject qp = new QProject();
qp.LoginCheck(user, pass);
bunifuMaterialTextbox1.Text = "";
textBox1.Text = "";
}
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
title = comboBox1.SelectedItem.ToString();
balance = Convert.ToInt32(bunifuMaterialTextbox3.Text);
credit = Convert.ToInt32(bunifuMaterialTextbox4.Text);
debit = Convert.ToInt32(bunifuMaterialTextbox6.Text);
status = bunifuMaterialTextbox5.Text;
date = bunifuDatepicker1.Value.ToShortDateString();
balance = balance + credit;
balance = balance - debit;
qp.Addbudget(title, balance, credit, debit, status, date);
CMS.Budget.refreshcheck = 100;
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
int Rowcount = dataGridView1.Rows.Count;
if (comboBox2.SelectedItem != null)
{
try
{
for (int i = 0; i < (Rowcount + 1); i++)
{
material = dataGridView1.Rows[i].Cells[1].Value.ToString();
quantitydg = dataGridView1.Rows[i].Cells[2].Value.ToString();
budget = budget + Convert.ToInt64(dataGridView1.Rows[i].Cells[3].Value.ToString());
qp.addpurchase(material, quantitydg);
qp.purchases(budget, comboBox2.SelectedItem.ToString(), bunifuDatepicker2.Value.ToShortDateString());
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
foreach (DataGridViewRow Datarow in dataGridView1.Rows)
{
if (Datarow.Cells[0].Value != null && Datarow.Cells[1].Value != null && Datarow.Cells[2].Value != null && Datarow.Cells[3].Value != null)
{
supplier = supplier + Datarow.Cells[0].Value.ToString() + " ";
materialname = materialname + Datarow.Cells[1].Value.ToString() + " ";
materialcount = materialcount + Datarow.Cells[2].Value.ToString() + " ";
price = price + Datarow.Cells[3].Value.ToString() + " ";
}
}
qp.Addpurchasing(comboBox2.SelectedItem.ToString(), bunifuDatepicker1.Value.ToShortDateString(), comboBox1.SelectedItem.ToString(), bunifuDatepicker2.Value.ToShortDateString(), supplier, materialname, materialcount, price);
CMS.Purchase.refreshcheck = 100;
}
else
{
MessageBox.Show("Fields are empty!");
}
}
private void bunifuFlatButton3_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
DialogResult DDR = MessageBox.Show("Are you sure you want to Delete?", "Delete Supplier", MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Stop);
if (DDR == DialogResult.Yes)
{
qp.DeleteSupplier(idsupplier);
}
try
{
this.suppliersTableAdapter.Fill(this.cMSDataSet1SS.Suppliers);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
private void bunifuFlatButton3_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
DialogResult DDR = MessageBox.Show("Are you sure you want to Delete?", "Delete Project", MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Stop);
if (DDR == DialogResult.Yes)
{
qp.DeleteProject(iddd);
}
try
{
this.projectContractTableAdapter.FillData(this.pCDS.ProjectContract);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
QProject qp = new QProject();
int Rowcount = dataGridView1.Rows.Count;
if (comboBox2.SelectedItem != null)
{
try
{
for (int i = 0; i < (Rowcount + 1); i++)
{
material = dataGridView1.Rows[i].Cells[0].Value.ToString();
quantitydg = dataGridView1.Rows[i].Cells[1].Value.ToString();
qp.addconttask(material, quantitydg);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
foreach (DataGridViewRow Datarow in dataGridView1.Rows)
{
if (Datarow.Cells[0].Value != null && Datarow.Cells[1].Value != null && Datarow.Cells[2].Value != null)
{
materialname = materialname + Datarow.Cells[0].Value.ToString() + " ";
materialcount = materialcount + Datarow.Cells[1].Value.ToString();
labourcount = labourcount + Datarow.Cells[2].Value.ToString();
}
}
qp.conttask(comboBox2.SelectedItem.ToString(), bunifuDatepicker1.Value.ToShortDateString(), bunifuDatepicker2.Value.ToShortDateString(), comboBox1.SelectedItem.ToString(), materialcount, labourcount, materialname);
CMS.Form7.refreshcheck = 100;
}
else
{
MessageBox.Show("Fields are empty!");
}
}
