private void btn_next_Click(object sender, EventArgs e) { // Increment row and fetch next _row++; List <List <string> > formData = _database.FetchData("dealerinstalledoptions"); _primaryKey = formData[_row][0]; text_optId.Text = formData[_row][0]; text_optDes.Text = formData[_row][1]; text_optCost.Text = formData[_row][2]; if (_row > 0) // check if there is previous { btn_prev.Enabled = true; } if (formData.Count == _row + 1) //check if remaining next's { btn_next.Enabled = false; } if (_row == 0) // on re-entering data set reset update button. { btn_update_insert.Text = "Update"; btn_new.Enabled = true; _updateFlag = true; } }
private void LoadData() { List <List <string> > formData = _database.FetchData("vehicles"); int rows = formData.Count; if (formData.Count >= _row) { text_serialNumber.Text = formData[_row][0]; text_name.Text = formData[_row][1]; text_model.Text = formData[_row][2]; text_year.Text = formData[_row][3]; text_make.Text = formData[_row][4]; text_baseCost.Text = formData[_row][5]; _primaryKey = formData[_row][0]; // determined if avalible List <string> primaryKey = new List <string>(); primaryKey.Add(_primaryKey); formData = _database.FetchData("vehicles", primaryKey); if (formData.Count > 0) // vehicle is sold because there is an invoice with vehicle avalible { lbl_sold.Text = "SOLD"; lbl_sold.ForeColor = Color.Red; } else { lbl_sold.Text = "AVALIBE"; lbl_sold.ForeColor = Color.Green; } } if (_row == 0) // check if there is previous { btn_prev.Enabled = false; } else { btn_prev.Enabled = true; } if (rows > _row + 1) //check if remaining next's { btn_next.Enabled = true; } else { btn_next.Enabled = false; } }
public FormDealerInstalledOptions() { InitializeComponent(); _database = new IODatabase(".\\SQLEXPRESS", "HTVDatabase"); _row = 0; // Load first row List <List <string> > formData = _database.FetchData("dealerinstalledoptions"); if (formData.Count >= _row) { text_optId.Text = formData[_row][0]; text_optDes.Text = formData[_row][1]; text_optCost.Text = formData[_row][2]; _primaryKey = formData[_row][0]; } // Disable Previous & Next if only one row btn_prev.Enabled = false; if (formData.Count == _row + 1) { btn_next.Enabled = false; } _updateFlag = true; }
public FormCustomers() { InitializeComponent(); _database = new IODatabase(".\\SQLEXPRESS", "HTVDatabase"); _row = 0; // Load first row List <List <string> > formData = _database.FetchData("customers"); if (formData.Count >= _row) { lbl_custID.Text = formData[_row][0]; text_custName.Text = formData[_row][1]; text_custAddress.Text = formData[_row][2]; text_phonePrimary.Text = formData[_row][3]; text_phoneSecondary.Text = formData[_row][4]; _primaryKey = formData[_row][0]; // Load purchace history table List <string> primaryKey = new List <string>(); primaryKey.Add(_primaryKey); formData = _database.FetchData("customers", primaryKey); for (int i = 0; i < formData.Count; i++) { DataGridViewRow dataRow = (DataGridViewRow)data_purchaceHist.Rows[0].Clone(); dataRow.Cells[0].Value = formData[i][0]; dataRow.Cells[1].Value = formData[i][1]; dataRow.Cells[2].Value = formData[i][2]; dataRow.Cells[3].Value = formData[i][3]; dataRow.Cells[4].Value = formData[i][4]; data_purchaceHist.Rows.Add(dataRow); } } // Disable Previous & Next if only one row btn_prev.Enabled = false; if (formData.Count == _row + 1) { btn_next.Enabled = false; } }
public FormSales() { InitializeComponent(); _database = new IODatabase(".\\SQLEXPRESS", "HTVDatabase"); _row = 0; // Load first row List <List <string> > formData = _database.FetchData("sales"); if (formData.Count >= _row) { text_saleId.Text = formData[_row][0]; date_of_sale.Text = formData[_row][1]; comb_custID.Text = formData[_row][2]; comb_vehicleID.Text = formData[_row][3]; text_negotiatedPrice.Text = formData[_row][4]; // picture signature load text_salesAgentID.Text = formData[_row][6]; _primaryKey = formData[_row][0]; _customerID = formData[_row][2]; _vehicleID = formData[_row][3]; _salesAgentID = formData[_row][6]; List <string> primaryKeys = new List <string>(); primaryKeys.Add(_primaryKey); primaryKeys.Add(_customerID); primaryKeys.Add(_vehicleID); primaryKeys.Add(_salesAgentID); // Load customer information. formData = _database.FetchData("sales_customer", primaryKeys); text_custName.Text = formData[0][0]; text_custAddress.Text = formData[0][1]; text_custPhone.Text = formData[0][2]; text_custSecondary.Text = formData[0][3]; // Load vehicle information formData = _database.FetchData("sales_vehicle", primaryKeys); text_vehicleName.Text = formData[0][0]; text_vehicleMake.Text = formData[0][1]; text_vehicleModel.Text = formData[0][2]; text_vehicleCost.Text = formData[0][3]; text_vehicleYear.Text = formData[0][4]; // Load sales agent information formData = _database.FetchData("sales_agent", primaryKeys); text_salesAgent.Text = formData[0][0]; // Load dealer insalled addons formData = _database.FetchData("sales_dealerInstalled", primaryKeys); for (int i = 0; i < formData.Count; i++) { DataGridViewRow dataRow = (DataGridViewRow)data_installedAddons.Rows[0].Clone(); dataRow.Cells[0].Value = formData[i][0]; dataRow.Cells[1].Value = formData[i][1]; dataRow.Cells[2].Value = formData[i][2]; data_installedAddons.Rows.Add(dataRow); } // Load trade in vehicles /* * formData = _database.FetchData("sales_tradeIn", primaryKeys); * for (int i = 0; i < formData.Count; i++) * { * DataGridViewRow dataRow = (DataGridViewRow)data_tradeIn.Rows[0].Clone(); * dataRow.Cells[0].Value = formData[i][0]; * dataRow.Cells[1].Value = formData[i][1]; * dataRow.Cells[2].Value = formData[i][2]; * dataRow.Cells[3].Value = formData[i][3]; * dataRow.Cells[4].Value = formData[i][4]; * dataRow.Cells[5].Value = formData[i][5]; * dataRow.Cells[6].Value = formData[i][6]; * data_tradeIn.Rows.Add(dataRow); * } */ } // Disable Previous & Next if only one row btn_prev.Enabled = false; if (formData.Count == _row + 1) { btn_next.Enabled = false; } }