private void btnUpdate_Click(object sender, EventArgs e) { DatabaseLibrary Obj = new DatabaseLibrary(); Obj.Connection(); try { if (txtDN.Text != string.Empty && txtSD.Text != string.Empty && txtDest.Text != string.Empty) { Obj.Edit(@"UPDATE tblrspickup SET TruckIn='" + dtTruckIn.Text + "',SLoad='" + dtSLoad.Text + "',FLoad='" + dtFLoad.Text + "',DocuRec='" + dtDocRec.Text + "',TruckOut='" + dtTruckOut.Text + "',SDwell='" + txtDwell.Text + "',DNum='" + txtDN.Text + "',SDNum='" + txtSD.Text + "',Destination='" + txtDest.Text + "' WHERE TripNum='" + int.Parse(lblTNum.Text) + "'"); Obj.CloseConnection(); frm1.FillDatas(); this.Close(); } else { MessageBox.Show("Please Enter Information!", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { DatabaseLibrary Obj = new DatabaseLibrary(); Obj.Connection(); try { if (txtBodyNum.Text != string.Empty && txtPlateNum.Text != string.Empty && txtDriver.Text != string.Empty && txtHelper.Text != string.Empty && txtSource.Text != string.Empty && txtWeek.Text != string.Empty) { Obj.Edit(@"UPDATE tblrsload SET DispDate='" + dtDD.Text + "',BodyNum='" + txtBodyNum.Text + "',PlateNum='" + txtPlateNum.Text + "',Driver='" + txtDriver.Text + "',Helper='" + txtHelper.Text + "',Waybill='" + txtWaybill.Text + "',Source='" + txtSource.Text + "',Week='" + txtWeek.Text + "',ETA='" + dtETA.Text + "' WHERE TripNum='" + int.Parse(lblTNum.Text) + "'"); Obj.CloseConnection(); frm1.FillDatas(); this.Close(); } else { MessageBox.Show("Please Enter Information!", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { int tnum; CountFile(); tnum = Convert.ToInt32(nCount); DatabaseLibrary Obj = new DatabaseLibrary(); if (listView1.Items.Count == 0) { MessageBox.Show("Please Add Details!"); } else if (listView1.Items.Count != 0) { DialogResult dr = MessageBox.Show(this, "Do you want to Save?", "Confimation", MessageBoxButtons.YesNo, MessageBoxIcon.Stop); if (dr == DialogResult.Yes) { try { for (int i = 0; i < listView1.Items.Count; i++) { tnum++; Obj.Connection(); Obj.cmd = new MySqlCommand(@"INSERT INTO tblrsload(TripNum,DispDate,BodyNum,PlateNum,Driver,Helper,Waybill,Source,Week,ETA)VALUES (@TNum,@DD,@BNum,@PNum,@Drivers,@Helpers,@Wbill,@Source,@Weeks,@ETAs)", Obj.conn); Obj.cmd.Parameters.AddWithValue("@TNum", tnum); Obj.cmd.Parameters.AddWithValue("@DD", listView1.Items[i].SubItems[0].Text); Obj.cmd.Parameters.AddWithValue("@BNum", listView1.Items[i].SubItems[1].Text); Obj.cmd.Parameters.AddWithValue("@PNum", listView1.Items[i].SubItems[2].Text); Obj.cmd.Parameters.AddWithValue("@Drivers", listView1.Items[i].SubItems[3].Text); Obj.cmd.Parameters.AddWithValue("@Helpers", listView1.Items[i].SubItems[4].Text); Obj.cmd.Parameters.AddWithValue("@Wbill", listView1.Items[i].SubItems[5].Text); Obj.cmd.Parameters.AddWithValue("@Source", listView1.Items[i].SubItems[6].Text); Obj.cmd.Parameters.AddWithValue("@Weeks", listView1.Items[i].SubItems[7].Text); Obj.cmd.Parameters.AddWithValue("@ETAs", listView1.Items[i].SubItems[8].Text); Obj.cmd.ExecuteNonQuery(); Obj.Insert("INSERT INTO tblrspickup(TripNum)VALUES('" + tnum + "')"); Obj.Insert("INSERT INTO tblrsunload(TripNum)VALUES('" + tnum + "')"); Obj.Insert("INSERT INTO tblrsdoc(TripNum)VALUES('" + tnum + "')"); Obj.CloseConnection(); } frm1.FillDatas(); this.Close(); MessageBox.Show("Data Saved!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { } } }