private void AgentBookings_Load(object sender, EventArgs e)
{
listView1.Items.Clear();
List <Agent> agentList;
try
{
agentList = CampusDatabase.GetAgent();
if (agentList.Count > 0)
{
//MessageBox.Show("good", "OK");
for (int i = 0; i < agentList.Count; i++)
{
Agent agent = agentList[i];
listView1.Items.Add(agent.AgentName);
listView1.Items[i].SubItems.Add(agent.OfficeLocation);
listView1.Items[i].SubItems.Add(agent.NumSales.ToString());
listView1.Items[i].SubItems.Add(agent.TotalSales.ToString());
}
}
else
{
MessageBox.Show("There are no any agents.", "Alert");
}
}
catch (Exception e1)
{ MessageBox.Show(e1.Message, e1.GetType().ToString()); }
}
private void AddAgent_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'cAMPUSDataSet.OFFICE' table. You can move, or remove it, as needed.
this.oFFICETableAdapter.Fill(this.cAMPUSDataSet.OFFICE);
listView1.Items.Clear();
List <Agent> agentList;
try
{
agentList = CampusDatabase.GetAgent();
if (agentList.Count > 0)
{
//MessageBox.Show("good", "OK");
for (int i = 0; i < agentList.Count; i++)
{
Agent agent = agentList[i];
listView1.Items.Add(agent.AgentName);
listView1.Items[i].SubItems.Add(agent.OfficeLocation);
listView1.Items[i].SubItems.Add(agent.NumSales.ToString());
listView1.Items[i].SubItems.Add(agent.TotalSales.ToString());
}
}
else
{
MessageBox.Show("There are no any agents.", "Alert");
}
}
catch (Exception e1)
{ MessageBox.Show(e1.Message, e1.GetType().ToString()); }
}
private void butSearch_Click(object sender, EventArgs e)
{
List <Sale> sales = CampusDatabase.GetSale(Convert.ToInt32(cbAgent.SelectedValue), Convert.ToInt32(cbDestination.SelectedValue), textBox1.Text, textBox2.Text);
SearchResults resultForm = new SearchResults(sales);
resultForm.Show();
}
private void butDelete_Click(object sender, EventArgs e)
{
//the saleId store in subitem[5] of listView1
CampusDatabase.DeleteSale(Convert.ToInt32(listView1.Items[0].SubItems[5].Text));
MessageBox.Show("the sale has been deleted!", "Alert");
this.Close();
}
private void bSubmit_Click(object sender, EventArgs e)
{
CampusDatabase.AddAgent(txtAgentName.Text, Convert.ToInt32(cbOfficeLocation.SelectedValue));
//cannot convert from object to int
//cbOfficeLocation.SelectedValuea is an object data type;
//CampusDatabase.AddAgent(txtAgentName.Text, cbOfficeLocation.SelectedValue);
txtAgentName.Clear();
MessageBox.Show("Agent Added!", "Alert");
//refresh form1
this.AddAgent_Load(this, null);
}
private void SearchSales_Load(object sender, EventArgs e)
{
cbAgent.Items.Clear();
cbDestination.Items.Clear();
List <Agent> agentList = CampusDatabase.GetAgent();
List <Destination> destinationList = CampusDatabase.GetDestination();
try
{
if (agentList.Count > 0)
{
agentList.Insert(0, new Asisgnment6.Agent()
{
AgentID = 0, AgentName = "All Agents"
});
cbAgent.DataSource = agentList;
cbAgent.DisplayMember = "AgentName";
cbAgent.ValueMember = "AgentId";
}
else
{
MessageBox.Show("There are no agents", "Alert");
}
if (destinationList.Count > 0)
{
destinationList.Insert(0, new Asisgnment6.Destination()
{
DestinationId = 0, DestinationName = "All Destinations"
});
cbDestination.DataSource = destinationList;
cbDestination.DisplayMember = "DestinationName";
cbDestination.ValueMember = "DestinationId";
}
else
{
MessageBox.Show("There are no Destinations", "Alert");
}
}
catch (Exception e1)
{
MessageBox.Show(e1.Message, e1.GetType().ToString());
}
}
private void UpdateSale_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'cAMPUSDataSet8.AGENT' table. You can move, or remove it, as needed.
this.aGENTTableAdapter1.Fill(this.cAMPUSDataSet8.AGENT);
// TODO: This line of code loads data into the 'cAMPUSDataSet7.AGENT' table. You can move, or remove it, as needed.
this.aGENTTableAdapter.Fill(this.cAMPUSDataSet7.AGENT);
// TODO: This line of code loads data into the 'cAMPUSDataSet6.DESTINATION' table. You can move, or remove it, as needed.
this.dESTINATIONTableAdapter.Fill(this.cAMPUSDataSet6.DESTINATION);
Sale sale = CampusDatabase.GetSale(saleId);
listView1.Items.Clear();
try
{
//display the sale on listView1
if (sale != null)
{
listView1.Items.Add(sale.SaleDate.ToShortDateString());
listView1.Items[0].SubItems.Add(sale.Amount.ToString());
listView1.Items[0].SubItems.Add(sale.DestinationName);
listView1.Items[0].SubItems.Add(sale.AgentName);
listView1.Items[0].SubItems.Add(sale.OfficeLocation);
listView1.Items[0].SubItems.Add(sale.SaleId.ToString());
cbAgent.SelectedValue = sale.AgentKey;
cbDestinaiton.SelectedValue = sale.DestinationKey;
}
else
{
MessageBox.Show("the sale ID is not exist.", "Alert");
}
}
catch (Exception e1)
{ MessageBox.Show(e1.Message, e1.GetType().ToString()); }
//show amount
txtAmount.Text = sale.Amount.ToString();
//show date
labDate.Text = sale.SaleDate.ToLongDateString();
//showdate
monthCalendar1.SetDate(sale.SaleDate);
}
private void bSubmit_Click(object sender, EventArgs e)
{
CampusDatabase.AddSale(monthCalendar1.SelectionStart, Convert.ToInt32(cbAgent.SelectedValue), Convert.ToInt32(cbDestinaiton.SelectedValue), Convert.ToDecimal(txtAmount.Text));
txtAmount.Clear();
MessageBox.Show("New Sale Added!", "Alert");
}
private void butUpdate_Click(object sender, EventArgs e)
{
CampusDatabase.UpdateSale(saleId, monthCalendar1.SelectionStart, Convert.ToInt32(cbAgent.SelectedValue), Convert.ToInt32(cbDestinaiton.SelectedValue), Convert.ToDecimal(txtAmount.Text));
MessageBox.Show("the sale has been updated!", "Alert");
this.Close();
}