private void button11_Click(object sender, EventArgs e) //set datagrid values to a different type of forms { if (dataGridView1.ColumnCount <= 0) { MessageBox.Show("please select the table"); } else if (dataGridView1.Columns[0].HeaderText == "MachineID") { btn_demo add = new btn_demo(); add.btnadd.Visible = false; add.btnupdate.Visible = true; add.lbl_mach_id.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString(); add.cmbtype.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString(); add.txtinstall_date.Value = Convert.ToDateTime(dataGridView1.CurrentRow.Cells[2].Value); add.txtser_date.Value = Convert.ToDateTime(dataGridView1.CurrentRow.Cells[3].Value); add.txtpur_price.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString(); add.cmbpurcom.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString(); add.txt_estlife.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString(); add.ShowDialog(); } else if (dataGridView1.Columns[0].HeaderText == "PartID") { parts add = new parts(); add.btnpart_add.Visible = false; add.btnpart_update.Visible = true; add.lbl_part_id.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); add.cmbtype.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); add.txtpur_price.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString(); add.txtqty.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString(); add.txtins_date.Value = Convert.ToDateTime(dataGridView1.CurrentRow.Cells[4].Value); add.cmbpurcom.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString(); add.ShowDialog(); } else if (dataGridView1.Columns[0].HeaderText == "ServiceNO") { service up = new service(); up.btnADD.Visible = false; up.btnupdate.Visible = true; up.lbl_service_no.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); up.txtmach_no.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); up.txtser_date.Value = Convert.ToDateTime(dataGridView1.CurrentRow.Cells[2].Value); up.txtser_per.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString(); up.txtser_cost.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString(); up.cmbstation.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString(); up.ShowDialog(); } }
private void button9_Click(object sender, EventArgs e) //go to diferent form from the same button considering the heder text { btn_demo btn = new btn_demo(); if (dataGridView1.ColumnCount <= 0) { MessageBox.Show("please select the table"); } else if (dataGridView1.Columns[0].HeaderText == "MachineID") { btn_demo add = new btn_demo(); add.Visible = true; //this.Visible = false; add.btnadd.Visible = true; add.btnupdate.Visible = false; } else if (dataGridView1.Columns[0].HeaderText == "PartID") { parts add = new parts(); add.Visible = true; this.Visible = false; add.btnpart_add.Visible = true; add.btnpart_update.Visible = false; } else if (dataGridView1.Columns[0].HeaderText == "ServiceNO") { service add = new service(); add.Visible = true; this.Visible = false; add.btnADD.Visible = true; add.btnupdate.Visible = false; } else if (dataGridView1.Columns[0].HeaderText == "RepaireNO") { Repaire add = new Repaire(); add.Visible = true; this.Visible = false; } }
public bool updateservice(string seno, string date, string machno, string serper, string sercost, string serstat) { bool status = false; if (conn.State.ToString() == "Closed") { conn.Open(); } SqlCommand newCmd3 = conn.CreateCommand(); btn_demo md = new btn_demo(); newCmd3.Connection = conn; newCmd3.CommandType = CommandType.Text; newCmd3.CommandText = "update MachineServices set ServiceDate='" + date + "',MachineID='" + machno + "',ServiceTimePeriod='" + serper + "',Cost='" + sercost + "',ServiceStation='" + serstat + "' where ServiceNO='" + seno + "' ;"; newCmd3.ExecuteNonQuery(); status = true; return(status); }
public bool updateparts(string id, string type, string purprice, int qty, string indate, string purcom, string purdate) { bool status = false; if (conn.State.ToString() == "Closed") { conn.Open(); } SqlCommand newCmd3 = conn.CreateCommand(); btn_demo md = new btn_demo(); newCmd3.Connection = conn; newCmd3.CommandType = CommandType.Text; newCmd3.CommandText = "update Part set Type='" + type + "',PurchasePrice='" + purprice + "',Quantity='" + qty + "',InstallDate='" + indate + "',PurchaseCompany='" + purcom + "',PurchaseDate='" + purdate + "' where PartID='" + id + "' ;"; newCmd3.ExecuteNonQuery(); status = true; return(status); }
public bool updatemachine(string mid, string type, string insdate, string serdate, string purprice, string purcom, int life) { bool status = false; if (conn.State.ToString() == "Closed") { conn.Open(); } SqlCommand newCmd3 = conn.CreateCommand(); btn_demo md = new btn_demo(); newCmd3.Connection = conn; newCmd3.CommandType = CommandType.Text; newCmd3.CommandText = "update Machines set Type='" + type + "',InstallDate='" + insdate + "',ServiceDate='" + serdate + "',PurchasePrice='" + purprice + "',PurchaseCompany='" + purcom + "',EstimatedLife='" + life + "' where MachineID='" + mid + "';"; newCmd3.ExecuteNonQuery(); status = true; return(status); }