private void btnDelete_Click(object sender, EventArgs e)
{
try
{
using (CronusWebServiceSoapClient service = new CronusWebServiceSoapClient())
{
service.RemovePartner(partner);
}
foreach (Control c in this.Controls)
{
if (c is TextBox)
{
(c as TextBox).Text = null;
}
}
lblResponse.Text = "Partner was removed.";
lblResponse.Visible = true;
}
catch (Exception ex)
{
lblResponse.Text = ExceptionHandler.ConvertExceptionToMessage(ex);
lblResponse.Visible = true;
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try {
using (CronusWebServiceSoapClient service = new CronusWebServiceSoapClient())
{
if (CreateEmployeeEnabled) //Skapa ny kund
{
partner = new CRONUS_Sverige_AB_Partner()
{
Company = tbxCompanyName.Text,
Adress = tbxAddress.Text,
PhoneNumber = tbxPhoneNo.Text,
Email = tbxEmail.Text
};
service.AddPartner(partner);
lblResponse.Text = "Partner was added.";
lblResponse.Visible = true;
ToggleReadOnly(true);
}
else //Uppdatera befintlig kund
{
CRONUS_Sverige_AB_Partner updatePartner = new CRONUS_Sverige_AB_Partner()
{
Company = tbxCompanyName.Text,
Adress = tbxAddress.Text,
PhoneNumber = tbxPhoneNo.Text,
Email = tbxEmail.Text
};
service.UpdatePartner(partner, updatePartner);
lblResponse.Text = "Partner was updated.";
lblResponse.Visible = true;
}
}
}
catch (SoapException ex)
{
lblResponse.Text = "Partner could not be added. Check required fields.";
}
}
private void CbSelectedTable_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string selectedTable = this.cbSelectedTable.Text;
using (CronusWebServiceSoapClient service = new CronusWebServiceSoapClient())
{
switch (selectedTable)
{
case "All Partners":
tablesDataGridView.DataSource = service.GetAllPartners();
break;
case "Content and metadata from Employee and related tables":
tablesDataGridView.DataSource = service.GetEmployeeMetaDataAndRelated();
break;
case "Employees And Relatives":
tablesDataGridView.DataSource = service.GetEmployeesAndRelatives();
break;
case "Employee Absence(2004)":
tablesDataGridView.DataSource = service.GetEmployeesSick2004();
break;
case "Employees With Most Absence":
tablesDataGridView.DataSource = service.GetTop5EmployeesAbsent();
break;
case "All Keys":
tablesDataGridView.DataSource = service.GetAllKeys();
break;
case "All Indexes":
tablesDataGridView.DataSource = service.GetAllIndexes();
break;
case "All Table Constraints":
tablesDataGridView.DataSource = service.GetAllConstraints();
break;
case "All Tables In Database":
tablesDataGridView.DataSource = service.GetAllTablesInDB();
break;
case "All Columns From Employee-Table":
tablesDataGridView.DataSource = service.GetAllColumnsInEmployees();
break;
}
}
}
catch (Exception ex)
{
lblResponse.Text = ExceptionHandler.ConvertExceptionToMessage(ex);
lblResponse.Visible = true;
}
}
