/// <summary>
/// Functions
/// Edit a mission to the database
/// </summary>
private void Edit_MissionToDatabase()
{
//Fill parameters
m_Mission.address = Txt_Mission_Address.Text;
m_Mission.city = Cmb_Mission_City.Text;;
m_Mission.client_name = Cmb_Mission_Client.Text;
m_Mission.country = Cmb_Mission_Country.Text;
m_Mission.date_billed = Dtp_Mission_DateBilled.Text;
m_Mission.date_declined = Dtp_Mission_DateDeclined.Text;
m_Mission.date_done = Dtp_Mission_DateDone.Text;
m_Mission.description = Txt_Mission_Description.Text;
m_Mission.end_date = Cld_Mission_EndDate.SelectedDate.ToString();
m_Mission.id_client = m_ListOfIdClients[Cmb_Mission_Client.SelectedIndex];
m_Mission.start_date = Cld_Mission_StartDate.SelectedDate.ToString();
m_Mission.state = Txt_Mission_State.Text;
m_Mission.zipcode = Txt_Mission_Zipcode.Text;
//Edit in internet database
string res = m_Database_Handler.Edit_MissionToDatabase(m_Mission.address, m_Mission.city,
m_Mission.client_name, m_Mission.country, m_Mission.date_billed, m_Mission.date_creation, m_Mission.date_declined, m_Mission.date_done, m_Mission.description, m_Mission.end_date,
m_Mission.id, m_Mission.id_client, m_Mission.id_list_shifts, m_Mission.start_date, m_Mission.state, m_Mission.zipcode);
//Treat the result
if (res.Contains("OK"))
{
}
else if (res.Contains("error"))
{
//Treatment of the error
MessageBox.Show(this, res, m_Global_Handler.Resources_Handler.Get_Resources("Error"), MessageBoxButton.OK, MessageBoxImage.Error);
m_Global_Handler.Log_Handler.WriteMessage(MethodBase.GetCurrentMethod().Name, res);
return;
}
else
{
//Error connecting to web site
MessageBox.Show(this, res, m_Global_Handler.Resources_Handler.Get_Resources("Error"), MessageBoxButton.OK, MessageBoxImage.Error);
m_Global_Handler.Log_Handler.WriteMessage(MethodBase.GetCurrentMethod().Name, res);
return;
}
}
/// <summary>
/// Event
/// Click on the add button
/// </summary>
private void Btn_Shifts_Add_Click(object sender, RoutedEventArgs e)
{
try
{
//Verifications
if (Cld_Shifts_Shift_Date.SelectedDate == null)
{
MessageBox.Show(this, m_Global_Handler.Resources_Handler.Get_Resources("NoDateSelectedErrorText"),
m_Global_Handler.Resources_Handler.Get_Resources("NoDateSelectedErrorCaption"), MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (Cld_Shifts_Shift_Date.SelectedDate < Convert.ToDateTime(m_Mission.start_date) || Cld_Shifts_Shift_Date.SelectedDate > Convert.ToDateTime(m_Mission.end_date))
{
MessageBox.Show(this, m_Global_Handler.Resources_Handler.Get_Resources("BadDateSelectedErrorText"),
m_Global_Handler.Resources_Handler.Get_Resources("BadDateSelectedErrorCaption"), MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
//Fill parameters
DateTime dateSelected = (DateTime)Cld_Shifts_Shift_Date.SelectedDate;
m_Shift.date = dateSelected.ToString("dd/MM/yyyy");
m_Shift.end_time = Cmb_Shifts_Shift_EndHour_Hour.Text + ":" + Cmb_Shifts_Shift_EndHour_Min.Text;
m_Shift.start_time = Cmb_Shifts_Shift_StartHour_Hour.Text + ":" + Cmb_Shifts_Shift_StartHour_Min.Text;
m_Shift.hourly_rate = Txt_Shifts_Shift_HourlyRate.Text;
m_Shift.pause = Txt_Shifts_Shift_Pause.Text;
if (Cmb_Shifts_Shift_HostOrHostess.SelectedIndex != -1)
{
m_Shift.id_hostorhostess = m_List_IdHostsAndHostesses[Cmb_Shifts_Shift_HostOrHostess.SelectedIndex];
}
else
{
MessageBox.Show(this, m_Global_Handler.Resources_Handler.Get_Resources("NoHostSelectedErrorText"),
m_Global_Handler.Resources_Handler.Get_Resources("NoHostSelectedErrorCaption"), MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
m_Shift.id = m_Mission.id + "_" + m_Shift.date + "_" + m_Shift.start_time + "_" + m_Shift.end_time + "_" + m_Shift.id_hostorhostess;
m_Shift.id_mission = m_Mission.id;
m_Shift.suit = (bool)Chk_Shifts_Shift_Suit.IsChecked;
if (m_Mission.id_list_shifts == "")
{
m_Mission.id_list_shifts = m_Shift.id;
}
else
{
m_Mission.id_list_shifts += ";" + m_Shift.id;
}
//Add to internet database
string res = m_Database_Handler.Add_ShiftToDatabase(m_Shift.date, m_Shift.end_time, m_Shift.hourly_rate, m_Shift.id, m_Shift.id_hostorhostess, m_Shift.id_mission,
m_Shift.pause, m_Shift.start_time, m_Shift.suit);
//Treat the result
if (res.Contains("OK"))
{
//Action
m_Global_Handler.Log_Handler.WriteAction("Shift " + m_Shift.id + " added");
//Add to collection
SoftwareObjects.ShiftsCollection.Add(m_Shift);
//Add to datagrid
string hostOrHostess = Cmb_Shifts_Shift_HostOrHostess.Text.Split('\t')[1];
m_Datagrid_Missions_ShiftsCollection.Add(new m_Datagrid_Mission_Shifts(m_Shift.id, m_Shift.date, hostOrHostess, m_Shift.start_time, m_Shift.end_time));
Datagrid_Shifts.Items.Refresh();
//Edit the mission to include the id of the new shift
m_Database_Handler.Edit_MissionToDatabase(m_Mission.address, m_Mission.city,
m_Mission.client_name, m_Mission.country, m_Mission.date_billed, m_Mission.date_creation, m_Mission.date_declined, m_Mission.date_done,
m_Mission.description, m_Mission.end_date, m_Mission.id, m_Mission.id_client, m_Mission.id_list_shifts, m_Mission.start_date, m_Mission.state, m_Mission.zipcode);
}
else if (res.Contains("Error"))
{
//Treatment of the error
MessageBox.Show(this, res, m_Global_Handler.Resources_Handler.Get_Resources("Error"), MessageBoxButton.OK, MessageBoxImage.Error);
m_Global_Handler.Log_Handler.WriteMessage(MethodBase.GetCurrentMethod().Name, res);
return;
}
}
catch (Exception exception)
{
m_Global_Handler.Log_Handler.WriteException(MethodBase.GetCurrentMethod().Name, exception);
return;
}
}
