private void BtnSupplierUpdate_Click(object sender, EventArgs e) { if (ValidateText()) { SupplierDTO supDTO = new SupplierDTO(txtSupplierID.Text, txtSupplierName.Text, txtSupplierAddress.Text, txtSupplierMobile.Text); Boolean result = SupplierController.updateSupplier(supDTO); if (result) { MessageBox.Show("Supplier details updated in the database successfully.."); } else { MessageBox.Show("Error occured supplier details not updated.."); } loadTable(); clear(); } }
public static SupplierDTO searchSupplier(String supplierid) { SupplierDTO supDTO = new SupplierDTO(); try { String query = "select * from supplier where supplierid=@supplierid;"; MySqlCommand command = new MySqlCommand(query, connection); command.Parameters.AddWithValue("@supplierid", supplierid); connection.Open(); MySqlDataReader dataReader = command.ExecuteReader(); //int result = command.ExecuteNonQuery(); //using (SqlDataReader reader = command.ExecuteReader()) //int count = 0; while (dataReader.Read()) { supDTO.setSupplierid(dataReader["supplierid"].ToString()); supDTO.setName(dataReader["name"].ToString()); supDTO.setAddress(dataReader["address"].ToString()); supDTO.setMobile(dataReader["mobile"].ToString()); //Console.WriteLine(dataReader["NIC"] + " " + dataReader["Name"] + " " + dataReader["Address"]); //count++; } /*if(count==0) * MessageBox.Show("No relevant data..");*/ } catch (Exception ex) { Console.WriteLine("Error: " + ex.Message); connection.Close(); //MessageBox.Show("Error : " + ex.ToString()); return(null); } Console.Read(); connection.Close(); return(supDTO); }
private void BtnAddUser_Click(object sender, EventArgs e) { if (ValidateText()) { SupplierDTO supDTO = new SupplierDTO(); supDTO.setSupplierid(txtSupplierID.Text); supDTO.setName(txtSupplierName.Text); supDTO.setMobile(txtSupplierMobile.Text); supDTO.setAddress(txtSupplierAddress.Text); Boolean result = SupplierController.addSupplier(supDTO); if (result) { MessageBox.Show("Supplier details added to the database successfully.."); } else { MessageBox.Show("Error occured supplier not added.."); } loadTable(); clear(); } }
public static Boolean updateSupplier(SupplierDTO supDTO) { int result; try { string query = "update supplier SET name=@name, address=@address,mobile=@mobile where supplierid=@supplierid"; MySqlCommand command = new MySqlCommand(query, connection); command.Parameters.AddWithValue("@name", supDTO.getName()); command.Parameters.AddWithValue("@address", supDTO.getAddress()); command.Parameters.AddWithValue("@mobile", supDTO.getMobile()); command.Parameters.AddWithValue("@supplierid", supDTO.getSupplierid()); connection.Open(); result = command.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine("Error: " + ex.Message); connection.Close(); //MessageBox.Show("Error : " + ex.ToString()); return(false); } Console.Read(); connection.Close(); if (result > 0) { return(true); } else { return(false); } }
public static Boolean addSupplier(SupplierDTO supplierDTO) { int result = 0; try { string query = "insert into supplier (supplierid,name,address,mobile) values (@supplierid,@name,@address,@mobile)"; MySqlCommand command = new MySqlCommand(query, connection); command.Parameters.AddWithValue("@supplierid", supplierDTO.getSupplierid()); command.Parameters.AddWithValue("@name", supplierDTO.getName()); command.Parameters.AddWithValue("@address", supplierDTO.getAddress()); command.Parameters.AddWithValue("@mobile", supplierDTO.getMobile()); connection.Open(); result = command.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine("Error : " + ex.ToString()); connection.Close(); // MessageBox.Show("Error : " + ex.ToString()); return(false); } Console.Read(); connection.Close(); if (result == 1) { return(true); } else { return(false); } }