private void uxEmployeeEmailTxtBox_TextChanged(object sender, EventArgs e)
{
string employeeEmail = uxEmployeeEmailTxtBox.Text;
int dealershipId;
Group14Connection g14 = new Group14Connection();
var employeeData = g14.GetEmployeeFromEmail(employeeEmail);
if (employeeData == null)
{
dealershipId = -1;
}
else
{
bool success = Int32.TryParse(employeeData.Tables[0].Rows[0].ItemArray[2].ToString(), out dealershipId);
if (!success)
{
dealershipId = -1;
}
}
employeeLocationId = dealershipId;
string dealershipName = "";
var dealershipData = g14.GetDealershipInformation(dealershipId);
if (dealershipData != null)
{
dealershipName = dealershipData.Tables[0].Rows[0].ItemArray[1].ToString();
}
uxEmployeeLocationLbl.Text = "Employee Location: " + dealershipName;
updatePurchaseAvailability();
}
private void uxDataGrid_SelectionChanged(object sender, EventArgs e)
{
DataGridViewRow row = uxDataGrid.SelectedRows.Count == 0 ? null : uxDataGrid.SelectedRows[0];
if (row != null && row.Cells != null && row.Cells[0].Value != null)
{
uxMake.Text = row.Cells[1].Value.ToString();
uxModel.Text = row.Cells[2].Value.ToString();
uxYear.Text = row.Cells[3].Value.ToString();
uxAskPrice.Text = row.Cells[4].Value.ToString();
uxColor.Text = row.Cells[5].Value.ToString();
uxMilage.Text = row.Cells[6].Value.ToString();
uxOwnerCount.Text = row.Cells[8].Value.ToString();
Group14Connection g14 = new Group14Connection();
int dealershipId;
bool success = Int32.TryParse(row.Cells[7].Value.ToString(), out dealershipId);
if (!success)
{
dealershipId = -1;
}
carLocationId = dealershipId;
string dealershipName = "";
var dealershipData = g14.GetDealershipInformation(dealershipId);
if (dealershipData != null)
{
dealershipName = dealershipData.Tables[0].Rows[0].ItemArray[1].ToString();
}
label15.Text = "Location: " + dealershipName;
}
updatePurchaseAvailability();
}
private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
label7.Text = "Make: " + dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
label8.Text = "Model: " + dataGridView1.SelectedRows[0].Cells[4].Value.ToString();
label9.Text = "Color: " + dataGridView1.SelectedRows[0].Cells[5].Value.ToString();
label10.Text = "Year: " + dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
label11.Text = "Milage: " + dataGridView1.SelectedRows[0].Cells[6].Value.ToString();
label12.Text = "Owner Count: " + dataGridView1.SelectedRows[0].Cells[7].Value.ToString();
label13.Text = "Ask Price: " + dataGridView1.SelectedRows[0].Cells[8].Value.ToString();
Group14Connection g14 = new Group14Connection();
int carId = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value);
var carData = g14.GetCarFeatures(carId);
string features = "";
if (carData != null && carData.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < carData.Tables[0].Rows.Count; i++)
{
features += carData.Tables[0].Rows[i].ItemArray[0] + "\n";
}
}
else
{
features = "NA";
}
label14.Text = "Features: " + features;
int dealershipId;
bool success = Int32.TryParse(dataGridView1.SelectedRows[0].Cells[1].Value.ToString(), out dealershipId);
if (!success)
{
dealershipId = -1;
}
carLocationId = dealershipId;
var dealershipData = g14.GetDealershipInformation(dealershipId);
string dealershipName = dealershipData.Tables[0].Rows[0].ItemArray[1].ToString();
label15.Text = "Location: " + dealershipName;
updatePurchaseAvailability();
}
}