private void CreateAppointment_Click(object sender, RoutedEventArgs e) { if (CheckInputs() == true) { string selTime = SelectedTime.Text; if (IsAvailable(DateTime.Parse(SelectedDate.Content.ToString()).ToString("yyyy-MM-dd"), DateTime.Parse(selTime).ToString("HH:mm:ss"), GetPriest(AssignedPriest.Text)) == false) { MsgNotAvailable(DateTime.Parse(SelectedDate.Content.ToString()).ToString("MMM dd, yyyy"), DateTime.Parse(selTime).ToString("HH:mm tt"), AssignedPriest.Text); this.Close(); } else { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //TODO try { MySqlCommand cmd = dbman.DBConnect().CreateCommand(); cmd.CommandText = "UPDATE appointments SET appointment_date = @appointment_date, appointment_time = @appointment_time, appointment_type = @appointment_type, requested_by = @requested_by, placed_by = @placed_by, remarks = @remarks, status = @status, assigned_priest = @a_priest, venue = @venue WHERE appointment_id = @aid;"; cmd.Parameters.AddWithValue("@aid", _aid); cmd.Parameters.AddWithValue("@appointment_date", DateTime.Parse(SelectedDate.Content.ToString()).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@appointment_time", DateTime.Parse(SelectedTime.Text).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@appointment_type", GetATypeID(TypeHolder.Content.ToString())); cmd.Parameters.AddWithValue("@requested_by", RequestedBy.Text); cmd.Parameters.AddWithValue("@placed_by", Application.Current.Resources["uid"].ToString()); cmd.Parameters.AddWithValue("@remarks", Remarks.Text); cmd.Parameters.AddWithValue("@status", 1); cmd.Parameters.AddWithValue("@a_priest", GetPriest(AssignedPriest.Text)); cmd.Parameters.AddWithValue("@venue", Venue.Text); cmd.Prepare(); int stat_code = cmd.ExecuteNonQuery(); dbman.DBClose(); if (stat_code > 0) { //Resync Calendar //PMS.UIComponents.Calendar cal = new UIComponents.Calendar(); //Appointments.app.CalendarHolder.Children.Clear(); //Appointments.app.CalendarHolder.Children.Add(cal); this.Close(); MsgSuccess(); } else { MsgFail(); } string tmp = pmsutil.LogScheduling(_aid, "LOGC-02"); } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } } } else { } }
private void CreateAppointment_Click(object sender, RoutedEventArgs e) { if (CheckInputs() == true) { string selTime = SelectedTime.Text; if (IsAvailable(DateTime.Parse(SelectedDate.Content.ToString()).ToString("yyyy-MM-dd"), DateTime.Parse(selTime).ToString("HH:mm:ss"), GetPriest(AssignedPriest.Text)) == false) { MsgNotAvailable(DateTime.Parse(SelectedDate.Content.ToString()).ToString("MMM dd, yyyy"), DateTime.Parse(selTime).ToString("HH:mm tt"), AssignedPriest.Text); this.Close(); } else { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //TODO try { string apmID = pmsutil.GenAppointmentID(); MySqlCommand cmd = dbman.DBConnect().CreateCommand(); cmd.CommandText = "INSERT INTO appointments(appointment_id, appointment_date, appointment_time, appointment_type, requested_by, placed_by, remarks, status, assigned_priest, venue)" + "VALUES(@appointment_id, @appointment_date, @appointment_time, @appointment_type, @requested_by, @placed_by, @remarks, @status, @a_priest, @venue)"; cmd.Parameters.AddWithValue("@appointment_id", apmID); cmd.Parameters.AddWithValue("@appointment_date", DateTime.Parse(SelectedDate.Content.ToString()).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@appointment_time", DateTime.Parse(selTime).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@appointment_type", GetATypeID(TypeHolder.Content.ToString())); cmd.Parameters.AddWithValue("@requested_by", RequestedBy.Text); cmd.Parameters.AddWithValue("@placed_by", Application.Current.Resources["uid"].ToString()); cmd.Parameters.AddWithValue("@remarks", Remarks.Text); cmd.Parameters.AddWithValue("@status", 1); cmd.Parameters.AddWithValue("@a_priest", GetPriest(AssignedPriest.Text)); cmd.Parameters.AddWithValue("@venue", Venue.Text); cmd.Prepare(); int stat_code = cmd.ExecuteNonQuery(); dbman.DBClose(); if (stat_code > 0) { this.Close(); MsgSuccess(); } else { MsgFail(); } string tmp = pmsutil.LogScheduling(apmID, "LOGC-01"); pmsutil.InsertTransaction("Liturgical Service - " + TypeHolder.Content.ToString(), "Unpaid", apmID, Convert.ToDouble(Fee.Value)); } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } } } else { } }
private void CreateMassRecord(object sender, RoutedEventArgs e) { if (TabControl1.SelectedIndex == 0) { if (CheckInputs() == true) { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //TODO try { string apmID = pmsutil.GenAppointmentID(); MySqlCommand cmd = dbman.DBConnect().CreateCommand(); string soulsof_tmp = SoulsOf.Text; if (MassType.Text == "All Souls" || MassType.Text == "Soul/s of") { soulsof_tmp = SoulsOf.Text; } else { soulsof_tmp = "NA."; } cmd.CommandText = "INSERT INTO appointments(appointment_id, appointment_date, appointment_time, appointment_type, requested_by, placed_by, remarks, status)" + "VALUES(@appointment_id, @appointment_date, @appointment_time, @appointment_type, @requested_by, @placed_by, @remarks, @status)"; cmd.Parameters.AddWithValue("@appointment_id", apmID); cmd.Parameters.AddWithValue("@appointment_date", DateTime.Parse(SelectedDate1.Text).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@appointment_time", DateTime.Parse(SelectedTime1.Text).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@appointment_type", GetATypeID(MassType.Text)); cmd.Parameters.AddWithValue("@requested_by", OfferedBy1.Text); cmd.Parameters.AddWithValue("@placed_by", Application.Current.Resources["uid"].ToString()); cmd.Parameters.AddWithValue("@remarks", soulsof_tmp); cmd.Parameters.AddWithValue("@status", 1); cmd.Prepare(); int stat_code = cmd.ExecuteNonQuery(); dbman.DBClose(); if (stat_code > 0) { _caller.SyncEvent2(); MsgSuccess(); this.Close(); } else { MsgFail(); } string tmp = pmsutil.LogScheduling(apmID, "LOGC-01"); pmsutil.InsertTransaction("Regular Serv. - " + MassType.Text, "Unpaid", apmID, Convert.ToDouble(Fee.Value)); } catch (MySqlException ex) { } this.Close(); } else { } } else { if (CheckInputs() == true) { string selTime = THours.Text + ":" + TMinutes.Text + " " + TimeMode.Text; if (IsAvailable(DateTime.Parse(SelectedDate2.Text).ToString("yyyy-MM-dd"), DateTime.Parse(selTime).ToString("HH:mm:ss"), GetPriest(AssignedPriest.Text)) == false) { MsgNotAvailable(DateTime.Parse(SelectedDate2.Text).ToString("MMM dd, yyyy"), DateTime.Parse(selTime).ToString("HH:mm tt"), AssignedPriest.Text); this.Close(); } else { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //TODO try { string apmID = pmsutil.GenAppointmentID(); MySqlCommand cmd = dbman.DBConnect().CreateCommand(); cmd.CommandText = "INSERT INTO appointments(appointment_id, appointment_date, appointment_time, appointment_type, requested_by, placed_by, remarks, status, assigned_priest)" + "VALUES(@appointment_id, @appointment_date, @appointment_time, @appointment_type, @requested_by, @placed_by, @remarks, @status, @a_priest)"; cmd.Parameters.AddWithValue("@appointment_id", apmID); cmd.Parameters.AddWithValue("@appointment_date", DateTime.Parse(SelectedDate2.Text).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@appointment_time", DateTime.Parse(selTime).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@appointment_type", GetATypeID(EventServiceType.Text)); cmd.Parameters.AddWithValue("@requested_by", OfferedBy2.Text); cmd.Parameters.AddWithValue("@placed_by", Application.Current.Resources["uid"].ToString()); cmd.Parameters.AddWithValue("@remarks", Remarks.Text); cmd.Parameters.AddWithValue("@status", 1); cmd.Parameters.AddWithValue("@a_priest", GetPriest(AssignedPriest.Text)); cmd.Prepare(); int stat_code = cmd.ExecuteNonQuery(); dbman.DBClose(); if (stat_code > 0) { _caller.SyncEvent2(); MsgSuccess(); this.Close(); } else { MsgFail(); } string tmp = pmsutil.LogScheduling(apmID, "LOGC-01"); pmsutil.InsertTransaction("Special Serv. - " + EventServiceType.Text, "Unpaid", apmID, Convert.ToDouble(Fee2.Value)); } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } } } else { } } }
private void CreateMassRecord(object sender, RoutedEventArgs e) { if (TabControl1.SelectedIndex == 0) { if (CheckInputs() == true) { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //TODO try { MySqlCommand cmd = dbman.DBConnect().CreateCommand(); string soulsof_tmp = SoulsOf.Text; if (MassType.Text == "All Souls" || MassType.Text == "Soul/s of") { soulsof_tmp = SoulsOf.Text; } else { soulsof_tmp = "NA."; } cmd.CommandText = "UPDATE appointments SET appointment_date = @appointment_date, appointment_time = @appointment_time, appointment_type = @appointment_type, requested_by = @requested_by, placed_by = @placed_by, remarks = @remarks, status = @status WHERE appointment_id = @aid;"; cmd.Parameters.AddWithValue("@aid", _aid); cmd.Parameters.AddWithValue("@appointment_date", DateTime.Parse(SelectedDate1.Text).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@appointment_time", DateTime.Parse(SelectedTime1.Text).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@appointment_type", GetATypeID(MassType.Text)); cmd.Parameters.AddWithValue("@requested_by", OfferedBy1.Text); cmd.Parameters.AddWithValue("@placed_by", Application.Current.Resources["uid"].ToString()); cmd.Parameters.AddWithValue("@remarks", soulsof_tmp); cmd.Parameters.AddWithValue("@status", 1); cmd.Prepare(); int stat_code = cmd.ExecuteNonQuery(); dbman.DBClose(); if (stat_code > 0) { _caller.SyncEvent2(); MsgSuccess(); this.Close(); } else { MsgFail(); } string tmp = pmsutil.LogScheduling(_aid, "LOGC-02"); } catch (MySqlException ex) { } this.Close(); } else { } } else { if (CheckInputs() == true) { string selTime = THours.Text + ":" + TMinutes.Text + " " + TimeMode.Text; if (IsAvailable(DateTime.Parse(SelectedDate2.Text).ToString("yyyy-MM-dd"), DateTime.Parse(selTime).ToString("HH:mm:ss"), GetPriest(AssignedPriest.Text)) == false) { MsgNotAvailable(DateTime.Parse(SelectedDate2.Text).ToString("MMM dd, yyyy"), DateTime.Parse(selTime).ToString("HH:mm tt"), AssignedPriest.Text); this.Close(); } else { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //TODO try { MySqlCommand cmd = dbman.DBConnect().CreateCommand(); cmd.CommandText = "UPDATE appointments SET appointment_date = @appointment_date, appointment_time = @appointment_time, appointment_type = @appointment_type, requested_by = @requested_by, placed_by = @placed_by, remarks = @remarks, status = @status WHERE appointment_id = @aid;"; cmd.Parameters.AddWithValue("@aid", _aid); cmd.Parameters.AddWithValue("@appointment_date", DateTime.Parse(SelectedDate2.Text).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@appointment_time", DateTime.Parse(selTime).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@appointment_type", GetATypeID(EventServiceType.Text)); cmd.Parameters.AddWithValue("@requested_by", OfferedBy2.Text); cmd.Parameters.AddWithValue("@placed_by", Application.Current.Resources["uid"].ToString()); cmd.Parameters.AddWithValue("@remarks", Remarks.Text); cmd.Parameters.AddWithValue("@status", 1); cmd.Parameters.AddWithValue("@a_priest", GetPriest(AssignedPriest.Text)); cmd.Prepare(); int stat_code = cmd.ExecuteNonQuery(); dbman.DBClose(); if (stat_code > 0) { _caller.SyncEvent2(); MsgSuccess(); this.Close(); } else { MsgFail(); } string tmp = pmsutil.LogScheduling(_aid, "LOGC-02"); } catch (MySqlException ex) { } } } else { } } }