private void cancel_button_Click(object sender, EventArgs e) { Job_Order_Details g = new Job_Order_Details(); g.Show(); this.Hide(); }
private void labor_fee_button_Click(object sender, EventArgs e) { for (int a = 0; a < labor_view.Rows.Count; a++) { if (Convert.ToString(labor_view.Rows[a].Cells[1].Value) == string.Empty) { } else { Conn.Open(); MySqlCommand cmd2 = new MySqlCommand("set foreign_key_checks=0; update job_order_services set labor_fee=@labf, subtotal_job_order=(service_fee + @labf) where job_order_services_id=@jid; set foreign_key_checks=1;", Conn); cmd2.Parameters.AddWithValue("@labf", labor_view.Rows[a].Cells[2].Value); cmd2.Parameters.AddWithValue("@jid", labor_view.Rows[a].Cells[3].Value); cmd2.ExecuteNonQuery(); Conn.Close(); } } Conn.Open(); MySqlCommand cmd = Conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select subtotal_job_order from job_order_services where job_order_id_serv_fk ='" + Job_Order_Details.jobid + "'"; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(dt); views.DataSource = dt; foreach (DataGridViewRow row in views.Rows) { if (row.IsNewRow) { continue; } int sum = 0; for (int i = 0; i < views.Rows.Count; i++) { sum += Convert.ToInt32(views.Rows[i].Cells[0].Value); } newans = sum; } string q = "set foreign_key_checks=0; update job_order set total_amount='" + newans + "' where job_order_id='" + Job_Order_Details.jobid + "'; set foreign_key_checks=1;"; main.CUD_Statement(q); string q2 = "set foreign_key_checks=0; insert into job_order_payment (balance, jp_job_order_id) values('" + newans + "','" + Job_Order_Details.jobid + "'); set foreign_key_checks=1;"; main.CUD_Statement(q2); Conn.Close(); Job_Order_Details g = new Job_Order_Details(); g.Show(); this.Hide(); }
private void released_view_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex > -1) { txtid.Text = released_view.Rows[e.RowIndex].Cells["job_order_id"].Value.ToString(); if (released_view.Rows.Count > 0) { Job_Order_Details g = new Job_Order_Details(); jid = txtid.Text; g.Show(); this.Hide(); } } }