public EditVendorPaymentsWindow(VendorPaymentData vendorPaymentToEdit)
{
InitializeComponent();
_vendorPaymentToEdit = vendorPaymentToEdit;
nameDataTB.Text = _vendorPaymentToEdit.vendorName;
addressDataTB.Text = _vendorPaymentToEdit.vendorAddress;
custIdTB.Text = _vendorPaymentToEdit.vendorId;
paymentAmountTB.Text = _vendorPaymentToEdit.paymentAmount.ToString();
}
private void EditVendorPayments(VendorPaymentData _vendorPaymentToEdit)
{
msqlConnection = new MySql.Data.MySqlClient.MySqlConnection("server=localhost;user id=root;Password=technicise;database=sptdb;persist security info=False");
try
{ //define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
msqlCommand.Connection = msqlConnection;
msqlConnection.Open();
msqlCommand.CommandText = "UPDATE vendor_payment SET payment_amount='" + _vendorPaymentToEdit.paymentAmount + "' WHERE payment_id='" + _vendorPaymentToEdit.paymentId + "'; ";
msqlCommand.ExecuteNonQuery();
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
finally
{
//always close the connection
msqlConnection.Close();
}
}
private void ConnectInsertTovendorPaymentTable(VendorPaymentData vendorDataObject)
{
//define the connection reference and initialize it
msqlConnection = new MySql.Data.MySqlClient.MySqlConnection("server=localhost;user id=root;Password=technicise;database=sptdb;persist security info=False");
try
{
//define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
//define the connection used by the command object
msqlCommand.Connection = msqlConnection;
//open the connection
msqlConnection.Open();
FeedvendorData(msqlCommand, vendorDataObject);
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
finally
{
msqlConnection.Close();
}
}
public AddNewVendorPaymentWindow()
{
InitializeComponent();
vendorPaymentData = new VendorPaymentData();
}
void FeedvendorData(MySql.Data.MySqlClient.MySqlCommand msqlCommand, VendorPaymentData cusomerDataObject)
{
//define the command text
msqlCommand.CommandText = "INSERT INTO vendor_payment(vendor_id,payment_amount,payment_date,payment_id)"
+ "VALUES (@vendor_id,@payment_amount,@payment_date,@payment_id)";
msqlCommand.Parameters.AddWithValue("@vendor_id", cusomerDataObject.vendorId);
msqlCommand.Parameters.AddWithValue("@payment_id", cusomerDataObject.paymentId);
msqlCommand.Parameters.AddWithValue("@payment_amount", cusomerDataObject.paymentAmount);
msqlCommand.Parameters.AddWithValue("@payment_date", cusomerDataObject.paymentDate);
msqlCommand.ExecuteNonQuery();
}
void addVendorPaymentWindowObject_OnAddVendorPaymentData(VendorPaymentData addVendorPaymentWindowObject)
{
addVendorPaymentWindowObject.serialNo = (_vendorPaymentCollection.Count + 1).ToString();
_vendorPaymentCollection.Add(addVendorPaymentWindowObject);
}
private void FetchVendorPaymentData()
{
msqlConnection = new MySql.Data.MySqlClient.MySqlConnection("server=localhost;user id=root;Password=technicise;database=sptdb;persist security info=False");
try
{ //define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
msqlCommand.Connection = msqlConnection;
msqlConnection.Open();
msqlCommand.CommandText = "Select vendors.vendor_id, vendors.vendor_address, vendors.ph_no,vendors.vendor_name, vendor_payment.payment_id, vendor_payment.payment_amount, vendor_payment.payment_date FROM vendors,vendor_payment WHERE vendor_payment.vendor_id = vendors.vendor_id;";
MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
_vendorPaymentCollection.Clear();
while (msqlReader.Read())
{
VendorPaymentData addVendorPaymentWindowObject = new VendorPaymentData();
addVendorPaymentWindowObject.serialNo = (_vendorPaymentCollection.Count + 1).ToString();
addVendorPaymentWindowObject.vendorId = msqlReader.GetString("vendor_id");
addVendorPaymentWindowObject.paymentId = msqlReader.GetString("payment_id");
addVendorPaymentWindowObject.vendorName = msqlReader.GetString("vendor_name");
addVendorPaymentWindowObject.vendorAddress = msqlReader.GetString("vendor_address");
addVendorPaymentWindowObject.vendorPhone = msqlReader.GetString("ph_no");
addVendorPaymentWindowObject.paymentAmount = msqlReader.GetDouble("payment_amount");
addVendorPaymentWindowObject.paymentDate = msqlReader.GetDateTime("payment_date");
_vendorPaymentCollection.Add(addVendorPaymentWindowObject);
}
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
finally
{
//always close the connection
msqlConnection.Close();
}
}
void editWindow_OnEditVendorPaymentData(VendorPaymentData returnEditedVendorPaymentData)
{
//finding the element
VendorPaymentData vData = _vendorPaymentCollection.Where(item => item.paymentId.Equals(returnEditedVendorPaymentData.paymentId)).First();
//finding the element position
int itemIdex = _vendorPaymentCollection.IndexOf(vData);
//remove the element so that the list gets refreshed
_vendorPaymentCollection.RemoveAt(itemIdex);
//insert the edited element at same position
_vendorPaymentCollection.Insert(itemIdex, returnEditedVendorPaymentData);
}
