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
{
}
}
}