/// <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; } }