public MoveAppointmentWindowPopup(string AptID, DateTime date)
{
string sysFormat = CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern;
_aid = AptID;
InitializeComponent();
SelectedDate.Content = date.ToString(sysFormat);
GetFixedTimeSchedules();
FetchPriests();
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM appointments WHERE appointment_id = @aid LIMIT 1;";
cmd.Parameters.AddWithValue("@aid", AptID);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
FetchMassFee(GetAType(db_reader.GetString("appointment_type")));
TypeHolder.Content = GetAType(db_reader.GetString("appointment_type"));
RequestedBy.Text = db_reader.GetString("requested_by");
Venue.Text = db_reader.GetString("venue");
Remarks.Text = db_reader.GetString("remarks");
for (int i = 0; i < SelectedTime.Items.Count; i++)
{
if (SelectedTime.Items[i].ToString() == DateTime.Parse(db_reader.GetString("appointment_time")).ToString("hh:mm tt"))
{
SelectedTime.SelectedIndex = i;
}
}
}
//close Connection
dbman.DBClose();
}
else
{
}
}
private void GetResidingPriests()
{
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM residing_priests WHERE priest_name != 'NA';";
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
Signatory.Items.Add(db_reader.GetString("priest_name"));
}
//close Connection
dbman.DBClose();
}
else
{
}
}
private void ArchiveItems(object sender, DoWorkEventArgs e)
{
string uid = Application.Current.Resources["uid"].ToString();
string[] dt = pmsutil.GetServerDateTime().Split(null);
cDate = Convert.ToDateTime(dt[0]);
cTime = DateTime.Parse(dt[1] + " " + dt[2]);
curDate = cDate.ToString("yyyy-MM-dd");
curTime = cTime.ToString("HH:mm:ss");
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
//TODO
try
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"INSERT INTO archives(book_number, date_archived, time_archived, archived_by)" +
"VALUES(@book_number, @date_archived, @time_archived, @archived_by)";
cmd.Parameters.AddWithValue("@book_number", bookNum);
cmd.Parameters.AddWithValue("@date_archived", curDate);
cmd.Parameters.AddWithValue("@time_archived", curTime);
cmd.Parameters.AddWithValue("@archived_by", uid);
cmd.Prepare();
int stat_code = cmd.ExecuteNonQuery();
dbman = new DBConnectionManager();
//TODO
try
{
//Phase 1.2
cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"UPDATE registers SET status = @status WHERE book_number = @book_number;";
cmd.Parameters.AddWithValue("@book_number", bookNum);
cmd.Parameters.AddWithValue("@status", "Archived");
cmd.Prepare();
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
//return 0;
}
stat_code2 = stat_code;
dbman.DBClose();
Phase2();
//return stat_code;
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
//return 0;
}
}
private string CountEntries(int bookNum)
{
string ret = "0";
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM records WHERE book_number = @book_number;";
cmd.Parameters.AddWithValue("@book_number", bookNum);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("COUNT(*)");
}
//close Connection
dbman.DBClose();
}
return ret;
}
private async void CancelTransaction_Click(object sender, RoutedEventArgs e)
{
if (TransactionItemsContainer.SelectedItem == null)
{
MsgNoItemSelected();
}
else
{
Transaction ti = (Transaction)TransactionItemsContainer.SelectedItem;
//Label transactionID = (Label)ti.FindName("IDLabel");
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM transactions WHERE transaction_id = @transaction_id LIMIT 1;";
cmd.Parameters.AddWithValue("@transaction_id", ti.TransactionID);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Paid")
{
MsgAlreadyPaid();
}
else if (db_reader.GetString("status") == "Cancelled")
{
MsgCancelled();
}
else
{
var metroWindow = (Application.Current.MainWindow as MetroWindow);
await metroWindow.ShowChildWindowAsync(new CancelPaymentWindow(this, ti.TransactionID));
}
}
}
else
{
}
}
}
private string GetRegisterType(int bookNum)
{
string ret = "0";
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM registers WHERE book_number = @book_number;";
cmd.Parameters.AddWithValue("@book_number", bookNum);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("book_type");
}
//close Connection
dbman.DBClose();
}
return(ret);
}
private void GetFixedTimeSchedules()
{
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM timeslots WHERE status = 'Active';";
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
SelectedTime.Items.Add(DateTime.Parse(db_reader.GetString("timeslot")).ToString("HH:mm tt"));
}
//close Connection
dbman.DBClose();
}
else
{
}
}
private string GetKeyValue(string key_name)
{
dbman = new DBConnectionManager();
string ret = "";
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM settings WHERE key_name = @key_name LIMIT 1;";
cmd.Parameters.AddWithValue("@key_name", key_name);
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("key_value");
}
}
else
{
}
dbman.DBClose();
return(ret);
}
private void FetchPriests()
{
AssignedPriest.Items.Clear();
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM residing_priests WHERE priest_status = 'Active';";
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
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"), db_reader.GetString("priest_id")) == false)
{
ComboBoxItem ci = new ComboBoxItem();
ci.IsEnabled = false;
ci.Content = db_reader.GetString("priest_name");
AssignedPriest.Items.Add(ci);
}
else
{
ComboBoxItem ci = new ComboBoxItem();
ci.IsEnabled = true;
ci.Content = db_reader.GetString("priest_name");
AssignedPriest.Items.Add(ci);
}
}
//close Connection
dbman.DBClose();
}
else
{
}
}
/// <summary>
/// Fetches default confirmation stipend value.
/// </summary>
private void FetchMassFee(string type)
{
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT fee FROM appointment_types WHERE appointment_type = @type;";
cmd.Parameters.AddWithValue("@type", type);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
Fee.Value = db_reader.GetDouble("fee");
}
//close Connection
dbman.DBClose();
}
else
{
Fee.Value = 0f;
}
}
private string GetBNum(string rid)
{
string ret = "";
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT book_number FROM records WHERE record_id = @rid LIMIT 1;";
cmd.Parameters.AddWithValue("@rid", rid);
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("book_number");
}
//close Connection
dbman.DBClose();
}
else
{
}
return(ret);
}
private void UpdateFee2()
{
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT fee FROM appointment_types WHERE appointment_type = @type;";
cmd.Parameters.AddWithValue("@type", EventServiceType.Text);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
Fee2.Value = db_reader.GetDouble("fee");
Console.WriteLine(">> " + db_reader.GetDouble("fee"));
}
//close Connection
dbman.DBClose();
}
else
{
Fee.Value = 0f;
}
}
/// <summary>
/// Onclick event for the Cancel Request Button. Cancels a request.
/// </summary>
private void RequestCancelled_Click(object sender, EventArgs e, string reqID)
{
try
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "UPDATE requests SET status = @new_status WHERE request_id = @request_id;";
cmd.Parameters.AddWithValue("@new_status", "Cancelled");
cmd.Parameters.AddWithValue("@request_id", reqID);
cmd.Prepare();
cmd.ExecuteNonQuery();
SyncTransactions();
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
}
/// <summary>
/// Inserts the request to the database.
/// </summary>
private int InsertEntry()
{
int ret = 0;
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
using (MySqlConnection conn2 = new MySqlConnection(dbman.GetConnStr()))
{
conn2.Open();
MySqlCommand cmd = conn2.CreateCommand();
cmd.CommandText = "SELECT * FROM records, registers WHERE records.record_id = @rid AND records.book_number = registers.book_number LIMIT 1;";
cmd.Parameters.AddWithValue("@rid", recordID);
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Archived")
{
using (MySqlConnection conn3 = new MySqlConnection(dbman.GetConnStr()))
{
conn3.Open();
try
{
MySqlCommand cmd2 = conn3.CreateCommand();
cmd2.CommandText =
"UPDATE records SET page_number = @page_number, entry_number = @entry_number, record_date = @record_date, recordholder_fullname = @recordholder_fullname, parent1_fullname = @parent1_fullname, parent2_fullname = @parent2_fullname WHERE record_id = @record_id;";
cmd2.Parameters.AddWithValue("@record_id", recordID);
cmd2.Parameters.AddWithValue("@page_number", pageNum);
cmd2.Parameters.AddWithValue("@entry_number", entryNum);
cmd2.Parameters.AddWithValue("@record_date", deathDate);
cmd2.Parameters.AddWithValue("@recordholder_fullname", fullName);
cmd2.Parameters.AddWithValue("@parent1_fullname", parent1);
cmd2.Parameters.AddWithValue("@parent2_fullname", parent2);
cmd2.Prepare();
int stat_code = cmd2.ExecuteNonQuery();
conn3.Close();
conn3.Open();
string path = @"\archive.db";
pmsutil = new PMSUtil();
if (pmsutil.CheckArchiveDrive(path) != "dc")
{
SQLiteConnectionStringBuilder connectionString = new SQLiteConnectionStringBuilder
{
FailIfMissing = true,
DataSource = pmsutil.CheckArchiveDrive(path)
};
//Copy the selected register's record to the archive drive
using (SQLiteConnection connection = new SQLiteConnection(connectionString.ToString()))
{
// open the connection:
connection.Open();
SQLiteCommand command = new SQLiteCommand(null, connection)
{
CommandText = "UPDATE burial_records SET burial_date = @burial_date, age = @age, status = @status, residence = @residence, residence2 = @residence2, sacrament = @sacrament, cause_of_death = @cause_of_death, place_of_interment = @place_of_interment, stipend = @stipend, minister = @minister, remarks = @remarks WHERE record_id = @record_id;"
};
command.Parameters.Add(new SQLiteParameter("@record_id", recordID));
command.Parameters.Add(new SQLiteParameter("@record_id", recordID));
command.Parameters.Add(new SQLiteParameter("@burial_date", burialDate));
command.Parameters.Add(new SQLiteParameter("@age", age));
command.Parameters.Add(new SQLiteParameter("@status", status));
command.Parameters.Add(new SQLiteParameter("@residence", residence1));
command.Parameters.Add(new SQLiteParameter("@residence2", residence2));
command.Parameters.Add(new SQLiteParameter("@sacrament", sacrament));
command.Parameters.Add(new SQLiteParameter("@cause_of_death", causeOfDeath));
command.Parameters.Add(new SQLiteParameter("@place_of_interment", intermentPlace));
command.Parameters.Add(new SQLiteParameter("@stipend", stipend));
command.Parameters.Add(new SQLiteParameter("@minister", minister));
command.Parameters.Add(new SQLiteParameter("@remarks", remarks));
// Call Prepare after setting the Commandtext and Parameters.
command.Prepare();
command.ExecuteNonQuery();
}
}
else
{
}
conn3.Close();
string tmp = pmsutil.LogRecord(recordID, "LOGC-02");
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
return(0);
}
}
}
else
{
using (MySqlConnection conn3 = new MySqlConnection(dbman.GetConnStr()))
{
conn3.Open();
try
{
string recID = pmsutil.GenRecordID();
MySqlCommand cmd2 = dbman.DBConnect().CreateCommand();
cmd2.CommandText =
"UPDATE records SET page_number = @page_number, entry_number = @entry_number, record_date = @record_date, recordholder_fullname = @recordholder_fullname, parent1_fullname = @parent1_fullname, parent2_fullname = @parent2_fullname WHERE record_id = @record_id;";
cmd2.Prepare();
cmd2.Parameters.AddWithValue("@record_id", recordID);
cmd2.Parameters.AddWithValue("@page_number", pageNum);
cmd2.Parameters.AddWithValue("@entry_number", entryNum);
cmd2.Parameters.AddWithValue("@record_date", deathDate);
cmd2.Parameters.AddWithValue("@recordholder_fullname", fullName);
cmd2.Parameters.AddWithValue("@parent1_fullname", parent1);
cmd2.Parameters.AddWithValue("@parent2_fullname", parent2);
int stat_code = cmd2.ExecuteNonQuery();
conn3.Close();
conn3.Open();
cmd2 = dbman.DBConnect().CreateCommand();
cmd2.CommandText =
"UPDATE burial_records SET burial_date = @burial_date, age = @age, status = @status, residence = @residence, residence2 = @residence2, sacrament = @sacrament, cause_of_death = @cause_of_death, place_of_interment = @place_of_interment, stipend = @stipend, minister = @minister, remarks = @remarks WHERE record_id = @record_id;";
cmd2.Prepare();
cmd2.Parameters.AddWithValue("@record_id", recordID);
cmd2.Parameters.AddWithValue("@burial_date", burialDate);
cmd2.Parameters.AddWithValue("@age", age);
cmd2.Parameters.AddWithValue("@status", status);
cmd2.Parameters.AddWithValue("@residence", residence1);
cmd2.Parameters.AddWithValue("@residence2", residence2);
cmd2.Parameters.AddWithValue("@sacrament", sacrament);
cmd2.Parameters.AddWithValue("@cause_of_death", causeOfDeath);
cmd2.Parameters.AddWithValue("@place_of_interment", intermentPlace);
cmd2.Parameters.AddWithValue("@stipend", stipend);
cmd2.Parameters.AddWithValue("@minister", minister);
cmd2.Parameters.AddWithValue("@remarks", remarks);
stat_code = cmd2.ExecuteNonQuery();
conn3.Close();
string tmp = pmsutil.LogRecord(recordID, "LOGC-02");
return(stat_code);
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
return(0);
}
}
}
}
}
}
}
return(ret);
}
}
private void Phase2()
{
SQLiteConnectionStringBuilder connectionString = new SQLiteConnectionStringBuilder
{
FailIfMissing = true,
DataSource = arcDrivePath
};
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM registers, records WHERE registers.book_number = records.book_number AND registers.book_number = @book_number;";
cmd.Parameters.AddWithValue("@book_number", bookNum);
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("book_type") == "Baptismal")
{
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd_tmp = dbman.DBConnect().CreateCommand();
cmd_tmp.CommandText = "SELECT * FROM records, baptismal_records WHERE records.record_id = baptismal_records.record_id AND records.book_number = @book_number;";
cmd_tmp.Parameters.AddWithValue("@book_number", bookNum);
MySqlDataReader db_readertmp = cmd_tmp.ExecuteReader();
while (db_readertmp.Read())
{
//Copy the selected register's record to the archive drive
using (SQLiteConnection connection = new SQLiteConnection(connectionString.ToString()))
{
// open the connection:
connection.Open();
SQLiteCommand command = new SQLiteCommand(null, connection)
{
CommandText = "INSERT INTO baptismal_records (record_id, birthday, legitimacy, place_of_birth, sponsor1, sponsor2, stipend, minister, remarks) VALUES (@record_id, @birthday, @legitimacy, @place_of_birth, @sponsor1, @sponsor2, @stipend, @minister, @remarks);"
};
command.Parameters.Add(new SQLiteParameter("@record_id", db_readertmp.GetString("record_id")));
command.Parameters.Add(new SQLiteParameter("@birthday", db_readertmp.GetString("birthday")));
command.Parameters.Add(new SQLiteParameter("@legitimacy", db_readertmp.GetString("legitimacy")));
command.Parameters.Add(new SQLiteParameter("@place_of_birth", db_readertmp.GetString("place_of_birth")));
command.Parameters.Add(new SQLiteParameter("@sponsor1", db_readertmp.GetString("sponsor1")));
command.Parameters.Add(new SQLiteParameter("@sponsor2", db_readertmp.GetString("sponsor2")));
command.Parameters.Add(new SQLiteParameter("@stipend", db_readertmp.GetFloat("stipend")));
command.Parameters.Add(new SQLiteParameter("@minister", db_readertmp.GetString("minister")));
command.Parameters.Add(new SQLiteParameter("@remarks", db_readertmp.GetString("remarks")));
// Call Prepare after setting the Commandtext and Parameters.
command.Prepare();
command.ExecuteNonQuery();
//Delete the copied records
MySqlCommand cmd_tmp2 = dbman.DBConnect().CreateCommand();
cmd_tmp2.CommandText = "DELETE FROM baptismal_records WHERE record_id = @record_id;";
cmd_tmp2.Parameters.AddWithValue("@record_id", db_readertmp.GetString("record_id"));
cmd_tmp2.ExecuteNonQuery();
}
}
}
}
else if (db_reader.GetString("book_type") == "Confirmation")
{
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd_tmp = dbman.DBConnect().CreateCommand();
cmd_tmp.CommandText = "SELECT * FROM records, confirmation_records WHERE records.record_id = confirmation_records.record_id AND records.book_number = @book_number;";
cmd_tmp.Parameters.AddWithValue("@book_number", bookNum);
MySqlDataReader db_readertmp = cmd_tmp.ExecuteReader();
while (db_readertmp.Read())
{
//Copy the selected register's record to the archive drive
using (SQLiteConnection connection = new SQLiteConnection(connectionString.ToString()))
{
// open the connection:
connection.Open();
SQLiteCommand command = new SQLiteCommand(null, connection)
{
CommandText = "INSERT INTO confirmation_records (record_id, age, parochia, place_of_baptism, sponsor, sponsor2, stipend, minister, remarks) VALUES (@record_id, @age, @parochia, @place_of_baptism, @sponsor, @sponsor2, @stipend, @minister, @remarks);"
};
command.Parameters.Add(new SQLiteParameter("@record_id", db_readertmp.GetString("record_id")));
command.Parameters.Add(new SQLiteParameter("@age", db_readertmp.GetInt32("age")));
command.Parameters.Add(new SQLiteParameter("@parochia", db_readertmp.GetString("parochia")));
command.Parameters.Add(new SQLiteParameter("@place_of_baptism", db_readertmp.GetString("place_of_baptism")));
command.Parameters.Add(new SQLiteParameter("@sponsor", db_readertmp.GetString("sponsor")));
command.Parameters.Add(new SQLiteParameter("@sponsor2", db_readertmp.GetString("sponsor2")));
command.Parameters.Add(new SQLiteParameter("@stipend", db_readertmp.GetFloat("stipend")));
command.Parameters.Add(new SQLiteParameter("@minister", db_readertmp.GetString("minister")));
command.Parameters.Add(new SQLiteParameter("@remarks", db_readertmp.GetString("remarks")));
// Call Prepare after setting the Commandtext and Parameters.
command.Prepare();
command.ExecuteNonQuery();
//Delete the copied records
MySqlCommand cmd_tmp2 = dbman.DBConnect().CreateCommand();
cmd_tmp2.CommandText = "DELETE FROM confirmation_records WHERE record_id = @record_id;";
cmd_tmp2.Parameters.AddWithValue("@record_id", db_readertmp.GetString("record_id"));
cmd_tmp2.ExecuteNonQuery();
}
}
}
}
else if (db_reader.GetString("book_type") == "Matrimonial")
{
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd_tmp = dbman.DBConnect().CreateCommand();
cmd_tmp.CommandText = "SELECT * FROM records, matrimonial_records WHERE records.record_id = matrimonial_records.record_id AND records.book_number = @book_number;";
cmd_tmp.Parameters.AddWithValue("@book_number", bookNum);
MySqlDataReader db_readertmp = cmd_tmp.ExecuteReader();
while (db_readertmp.Read())
{
//Copy the selected register's record to the archive drive
using (SQLiteConnection connection = new SQLiteConnection(connectionString.ToString()))
{
// open the connection:
connection.Open();
SQLiteCommand command = new SQLiteCommand(null, connection)
{
CommandText = "INSERT INTO matrimonial_records (record_id, recordholder2_fullname, parent1_fullname2, parent2_fullname2, status1, status2, age1, age2, place_of_origin1, place_of_origin2, residence1, residence2, witness1, witness2, witness1address, witness2address, stipend, minister, remarks) VALUES (@record_id, @recordholder2_fullname, @parent1_fullname2, @parent2_fullname2, @status1, @status2, @age1, @age2, @place_of_origin1, @place_of_origin2, @residence1, @residence2, @witness1, @witness2, @witness1address, @witness2address, @stipend, @minister, @remarks);"
};
command.Parameters.Add(new SQLiteParameter("@record_id", db_readertmp.GetString("record_id")));
command.Parameters.Add(new SQLiteParameter("@recordholder2_fullname", db_readertmp.GetString("recordholder2_fullname")));
command.Parameters.Add(new SQLiteParameter("@parent1_fullname2", db_readertmp.GetString("parent1_fullname2")));
command.Parameters.Add(new SQLiteParameter("@parent2_fullname2", db_readertmp.GetString("parent2_fullname2")));
command.Parameters.Add(new SQLiteParameter("@status1", db_readertmp.GetString("status1")));
command.Parameters.Add(new SQLiteParameter("@status2", db_readertmp.GetString("status2")));
command.Parameters.Add(new SQLiteParameter("@age1", db_readertmp.GetInt32("age1")));
command.Parameters.Add(new SQLiteParameter("@age2", db_readertmp.GetInt32("age2")));
command.Parameters.Add(new SQLiteParameter("@place_of_origin1", db_readertmp.GetString("place_of_origin1")));
command.Parameters.Add(new SQLiteParameter("@place_of_origin2", db_readertmp.GetString("place_of_origin2")));
command.Parameters.Add(new SQLiteParameter("@residence1", db_readertmp.GetString("residence1")));
command.Parameters.Add(new SQLiteParameter("@residence2", db_readertmp.GetString("residence2")));
command.Parameters.Add(new SQLiteParameter("@witness1", db_readertmp.GetString("witness1")));
command.Parameters.Add(new SQLiteParameter("@witness2", db_readertmp.GetString("witness2")));
command.Parameters.Add(new SQLiteParameter("@witness1address", db_readertmp.GetString("witness1address")));
command.Parameters.Add(new SQLiteParameter("@witness2address", db_readertmp.GetString("witness2address")));
command.Parameters.Add(new SQLiteParameter("@stipend", db_readertmp.GetFloat("stipend")));
command.Parameters.Add(new SQLiteParameter("@minister", db_readertmp.GetString("minister")));
command.Parameters.Add(new SQLiteParameter("@remarks", db_readertmp.GetString("remarks")));
// Call Prepare after setting the Commandtext and Parameters.
command.Prepare();
command.ExecuteNonQuery();
//Delete the copied records
MySqlCommand cmd_tmp2 = dbman.DBConnect().CreateCommand();
cmd_tmp2.CommandText = "DELETE FROM matrimonial_records WHERE record_id = @record_id;";
cmd_tmp2.Parameters.AddWithValue("@record_id", db_readertmp.GetString("record_id"));
cmd_tmp2.ExecuteNonQuery();
}
}
}
}
else if (db_reader.GetString("book_type") == "Burial")
{
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd_tmp = dbman.DBConnect().CreateCommand();
cmd_tmp.CommandText = "SELECT * FROM records, burial_records WHERE records.record_id = burial_records.record_id AND records.book_number = @book_number;";
cmd_tmp.Parameters.AddWithValue("@book_number", bookNum);
MySqlDataReader db_readertmp = cmd_tmp.ExecuteReader();
while (db_readertmp.Read())
{
//Copy the selected register's record to the archive drive
using (SQLiteConnection connection = new SQLiteConnection(connectionString.ToString()))
{
// open the connection:
connection.Open();
SQLiteCommand command = new SQLiteCommand(null, connection)
{
CommandText = "INSERT INTO burial_records (record_id, burial_date, age, status, residence, residence2, sacrament, cause_of_death, place_of_interment, stipend, minister, remarks) VALUES (@record_id, @burial_date, @age, @status, @residence, @residence2, @sacrament, @cause_of_death, @place_of_interment, @stipend, @minister, @remarks);"
};
command.Parameters.Add(new SQLiteParameter("@record_id", db_readertmp.GetString("record_id")));
command.Parameters.Add(new SQLiteParameter("@burial_date", db_readertmp.GetString("burial_date")));
command.Parameters.Add(new SQLiteParameter("@age", db_readertmp.GetInt32("age")));
command.Parameters.Add(new SQLiteParameter("@status", db_readertmp.GetString("status")));
command.Parameters.Add(new SQLiteParameter("@residence", db_readertmp.GetString("residence")));
command.Parameters.Add(new SQLiteParameter("@residence2", db_readertmp.GetString("residence2")));
command.Parameters.Add(new SQLiteParameter("@sacrament", db_readertmp.GetString("sacrament")));
command.Parameters.Add(new SQLiteParameter("@cause_of_death", db_readertmp.GetString("cause_of_death")));
command.Parameters.Add(new SQLiteParameter("@place_of_interment", db_readertmp.GetString("place_of_interment")));
command.Parameters.Add(new SQLiteParameter("@stipend", db_readertmp.GetFloat("stipend")));
command.Parameters.Add(new SQLiteParameter("@minister", db_readertmp.GetString("minister")));
command.Parameters.Add(new SQLiteParameter("@remarks", db_readertmp.GetString("remarks")));
// Call Prepare after setting the Commandtext and Parameters.
command.Prepare();
command.ExecuteNonQuery();
//Delete the copied records
MySqlCommand cmd_tmp2 = dbman.DBConnect().CreateCommand();
cmd_tmp2.CommandText = "DELETE FROM burial_records WHERE record_id = @record_id;";
cmd_tmp2.Parameters.AddWithValue("@record_id", db_readertmp.GetString("record_id"));
cmd_tmp2.ExecuteNonQuery();
}
}
}
}
}
//close Connection
dbman.DBClose();
}
}
private void SaveButton_Click(object sender, RoutedEventArgs e)
{
dbman = new DBConnectionManager();
double baptismalFee = Convert.ToDouble(BaptismalPrintFee.Value);
double confirmationFee = Convert.ToDouble(ConfirmationPrintFee.Value);
double matrimonialFee = Convert.ToDouble(MatrimonialPrintFee.Value);
double burialFee = Convert.ToDouble(BurialPrintFee.Value);
double burialStipend = Convert.ToDouble(BurialStipend.Value);
double matrimonialStipend = Convert.ToDouble(MatrimonialStipend.Value);
double confirmationStipend = Convert.ToDouble(ConfirmationStipend.Value);
double baptismalStipend = Convert.ToDouble(BaptismalStipend.Value);
if (dbman.DBConnect().State == ConnectionState.Open)
{
//TODO
try
{
string key_name = "Print Fee Baptismal";
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"UPDATE settings SET key_value = @key_value WHERE key_name = @key_name;";
cmd.Parameters.AddWithValue("@key_value", baptismalFee);
cmd.Parameters.AddWithValue("@key_name", key_name);
cmd.Prepare();
int stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
cmd = dbman.DBConnect().CreateCommand();
key_name = "Print Fee Confirmation";
cmd.CommandText =
"UPDATE settings SET key_value = @key_value WHERE key_name = @key_name;";
cmd.Parameters.AddWithValue("@key_value", confirmationFee);
cmd.Parameters.AddWithValue("@key_name", key_name);
cmd.Prepare();
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
cmd = dbman.DBConnect().CreateCommand();
key_name = "Print Fee Matrimonial";
cmd.CommandText =
"UPDATE settings SET key_value = @key_value WHERE key_name = @key_name;";
cmd.Parameters.AddWithValue("@key_value", matrimonialFee);
cmd.Parameters.AddWithValue("@key_name", key_name);
cmd.Prepare();
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
cmd = dbman.DBConnect().CreateCommand();
key_name = "Print Fee Burial";
cmd.CommandText =
"UPDATE settings SET key_value = @key_value WHERE key_name = @key_name;";
cmd.Parameters.AddWithValue("@key_value", burialFee);
cmd.Parameters.AddWithValue("@key_name", key_name);
cmd.Prepare();
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
cmd = dbman.DBConnect().CreateCommand();
key_name = "Baptismal Stipend";
cmd.CommandText =
"UPDATE settings SET key_value = @key_value WHERE key_name = @key_name;";
cmd.Parameters.AddWithValue("@key_value", baptismalStipend);
cmd.Parameters.AddWithValue("@key_name", key_name);
cmd.Prepare();
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
cmd = dbman.DBConnect().CreateCommand();
key_name = "Confirmation Stipend";
cmd.CommandText =
"UPDATE settings SET key_value = @key_value WHERE key_name = @key_name;";
cmd.Parameters.AddWithValue("@key_value", confirmationStipend);
cmd.Parameters.AddWithValue("@key_name", key_name);
cmd.Prepare();
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
cmd = dbman.DBConnect().CreateCommand();
key_name = "Matrimonial Stipend";
cmd.CommandText =
"UPDATE settings SET key_value = @key_value WHERE key_name = @key_name;";
cmd.Parameters.AddWithValue("@key_value", matrimonialStipend);
cmd.Parameters.AddWithValue("@key_name", key_name);
cmd.Prepare();
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
cmd = dbman.DBConnect().CreateCommand();
key_name = "Burial Stipend";
cmd.CommandText =
"UPDATE settings SET key_value = @key_value WHERE key_name = @key_name;";
cmd.Parameters.AddWithValue("@key_value", burialStipend);
cmd.Parameters.AddWithValue("@key_name", key_name);
cmd.Prepare();
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
////string tmp = pmsutil.LogRecord(recordID, "LOGC-02");
SyncValues();
//InfoArea1.Foreground = new SolidColorBrush(Colors.Green);
//InfoArea1.Content = "Password successfully changed!";
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
}
else
{
}
}
internal void SyncAccounts()
{
accounts = new ObservableCollection <Account>();
accounts_final = new ObservableCollection <Account>();
ComboBoxItem ci = (ComboBoxItem)ItemsPerPage.SelectedItem;
int itemsPerPage = Convert.ToInt32(ci.Content);
int page = 1;
int count = 0;
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
//AccountsItemContainer.Items.Clear();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM accounts, accounts_info WHERE accounts.account_id = accounts_info.account_id;";
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
string acc_type;
acc_type = pmsutil.GetAccountType(db_reader.GetString("account_id"));
accounts.Add(new Account()
{
AccountID = db_reader.GetString("account_id"),
Username = db_reader.GetString("user_name"),
Role = acc_type,
EmpName = db_reader.GetString("name"),
CreationDate = DateTime.Parse(db_reader.GetString("date_created")).ToString("MMM dd, yyyy"),
CreationTime = DateTime.Parse(db_reader.GetString("time_created")).ToString("hh:mm tt"),
Page = page
});
count++;
if (count == itemsPerPage)
{
page++;
count = 0;
}
}
int temp = 1;
foreach (var cur in accounts)
{
if (cur.Page == CurrentPage.Value)
{
accounts_final.Add(new Account()
{
No = temp,
AccountID = cur.AccountID,
Username = cur.Username,
Role = cur.Role,
EmpName = cur.EmpName,
CreationDate = cur.CreationDate,
CreationTime = cur.CreationTime,
Page = cur.Page
});
temp++;
}
}
//close Connection
dbman.DBClose();
//AccountsItemContainer.Items.Clear();
AccountsItemContainer.Items.Refresh();
AccountsItemContainer.ItemsSource = accounts_final;
AccountsItemContainer.Items.Refresh();
}
else
{
}
}
private void PopulateFields(string aid)
{
//DUMMY DATA CHANGE THIS
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM appointments WHERE appointment_id = @aid LIMIT 1;";
cmd.Parameters.AddWithValue("@aid", aid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (IsCustom(aid) == false)
{
Tab1.IsEnabled = true;
Tab2.IsEnabled = false;
TabControl1.SelectedIndex = 0;
for (int i = 0; i < MassType.Items.Count; i++)
{
var item = (string)MassType.Items[i];
if (db_reader.GetString("appointment_type") == GetATypeID(item))
{
MassType.SelectedIndex = i;
}
}
SoulsOf.Text = db_reader.GetString("remarks");
for (int i = 0; i < AssignedPriest.Items.Count; i++)
{
var item = (ComboBoxItem)AssignedPriest.Items[i];
if (db_reader.GetString("assigned_priest") == GetPriest(item.Content.ToString()))
{
AssignedPriest.SelectedIndex = i;
}
}
OfferedBy1.Text = db_reader.GetString("requested_by");
for (int i = 0; i < SelectedTime1.Items.Count; i++)
{
var item = (string)SelectedTime1.Items[i];
if (DateTime.Parse(db_reader.GetString("appointment_time")).ToString("hh:mm tt") == item)
{
SelectedTime1.SelectedIndex = i;
}
}
}
else
{
Tab1.IsEnabled = false;
Tab2.IsEnabled = true;
TabControl1.SelectedIndex = 1;
for (int i = 0; i < AssignedPriest.Items.Count; i++)
{
var item = (ComboBoxItem)AssignedPriest.Items[i];
if (db_reader.GetString("assigned_priest") == GetPriest(item.Content.ToString()))
{
AssignedPriest.SelectedIndex = i;
}
}
for (int i = 0; i < EventServiceType.Items.Count; i++)
{
var item = (string)EventServiceType.Items[i];
if (db_reader.GetString("appointment_type") == GetATypeID(item))
{
EventServiceType.SelectedIndex = i;
}
}
Remarks.Text = db_reader.GetString("remarks");
OfferedBy2.Text = db_reader.GetString("requested_by");
for (int i = 0; i < THours.Items.Count; i++)
{
var item = (string)THours.Items[i];
if (DateTime.Parse(db_reader.GetString("appointment_time")).ToString("hh") == item)
{
THours.SelectedIndex = i;
}
}
for (int i = 0; i < TMinutes.Items.Count; i++)
{
var item = (string)TMinutes.Items[i];
if (DateTime.Parse(db_reader.GetString("appointment_time")).ToString("mm") == item)
{
TMinutes.SelectedIndex = i;
}
}
for (int i = 0; i < TimeMode.Items.Count; i++)
{
var item = (ComboBoxItem)TimeMode.Items[i];
if (DateTime.Parse(db_reader.GetString("appointment_time")).ToString("tt") == item.Content.ToString())
{
TimeMode.SelectedIndex = i;
}
}
}
}
//close Connection
dbman.DBClose();
}
else
{
}
}
private void DoWork(object sender, DoWorkEventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = ((DataView)databap.ItemsSource).ToTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
bool doProceed = false;
//Check inputs
for (int _tmp = 0; _tmp < 12; _tmp++)
{
if (String.IsNullOrEmpty(dt.Rows[i][i].ToString()) == true)
{
doProceed = false;
}
else
{
doProceed = true;
}
}
if (doProceed == true)
{
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
PBar.Visibility = Visibility.Visible;
CancelButton1.IsEnabled = false;
ConfirmBtn.IsEnabled = false;
string recID = pmsutil.GenRecordID();
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"INSERT INTO records(record_id, book_number, page_number, entry_number, record_date, recordholder_fullname, parent1_fullname, parent2_fullname)" +
"VALUES(@record_id, @book_number, @page_number, @entry_number, @record_date, @recordholder_fullname, @parent1_fullname, @parent2_fullname)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@record_id", recID);
cmd.Parameters.AddWithValue("@book_number", _bookNum);
cmd.Parameters.AddWithValue("@page_number", PageNum.Value);
cmd.Parameters.AddWithValue("@entry_number", Convert.ToInt32(dt.Rows[i][0].ToString()));
cmd.Parameters.AddWithValue("@record_date", dt.Rows[i][1].ToString());
cmd.Parameters.AddWithValue("@recordholder_fullname", dt.Rows[i][2].ToString());
cmd.Parameters.AddWithValue("@parent1_fullname", dt.Rows[i][6].ToString());
cmd.Parameters.AddWithValue("@parent2_fullname", dt.Rows[i][7].ToString());
int stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"INSERT INTO baptismal_records(record_id, birthday, legitimacy, place_of_birth, sponsor1, sponsor2, stipend, minister, remarks)" +
"VALUES(@record_id, @birthday, @legitimacy, @place_of_birth, @sponsor1, @sponsor2, @stipend, @minister, @remarks)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@record_id", recID);
cmd.Parameters.AddWithValue("@birthday", dt.Rows[i][3].ToString());
cmd.Parameters.AddWithValue("@legitimacy", dt.Rows[i][4].ToString());
cmd.Parameters.AddWithValue("@place_of_birth", dt.Rows[i][5].ToString());
cmd.Parameters.AddWithValue("@sponsor1", dt.Rows[i][8].ToString());
cmd.Parameters.AddWithValue("@sponsor2", dt.Rows[i][9].ToString());
cmd.Parameters.AddWithValue("@stipend", Convert.ToDouble(dt.Rows[i][10].ToString()));
cmd.Parameters.AddWithValue("@minister", dt.Rows[i][11].ToString());
cmd.Parameters.AddWithValue("@remarks", dt.Rows[i][12].ToString());
stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
string tmp = pmsutil.LogRecord(recID, "LOGC-01");
//return stat_code;
_statcode = stat_code;
PBar.Visibility = Visibility.Hidden;
CancelButton1.IsEnabled = true;
ConfirmBtn.IsEnabled = true;
});
}
else
{
_statcode = 601;
}
}
else
{
}
}
}
this.Close();
}
catch
{
}
}
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
{
}
}
}
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
{
}
}
}
/// <summary>
/// Creates the AddRequestForm Window and Initializes DB Param.
/// </summary>
public PrintMatrimonialRecordEntryWindow(string targRecord)
{
pmsutil = new PMSUtil();
recordID = targRecord;
InitializeComponent();
GetResidingPriests();
CheckAccess(targRecord);
PrintingFee.Value = Convert.ToDouble(pmsutil.GetPrintFee("Matrimonial"));
recordID = targRecord;
Stipend.Value = FetchMatrimonialStipend();
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM matrimonial_records, records WHERE records.record_id = @record_id AND records.record_id = matrimonial_records.record_id LIMIT 1;";
cmd.Parameters.AddWithValue("@record_id", targRecord);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
bookNum = db_reader.GetInt32("book_number");
EntryNum.Value = Convert.ToDouble(db_reader.GetString("entry_number"));
PageNum.Value = Convert.ToDouble(db_reader.GetString("page_number"));
MarriageDate.Text = db_reader.GetString("record_date");
Age1.Value = Convert.ToDouble(db_reader.GetString("age1"));
Age2.Value = Convert.ToDouble(db_reader.GetString("age2"));
Status1.Text = db_reader.GetString("status1");
Status2.Text = db_reader.GetString("status2");
FullName1.Text = db_reader.GetString("recordholder_fullname");
FullName2.Text = db_reader.GetString("recordholder2_fullname");
Hometown1.Text = db_reader.GetString("place_of_origin1");
Hometown2.Text = db_reader.GetString("place_of_origin2");
Residence1.Text = db_reader.GetString("residence1");
Residence2.Text = db_reader.GetString("residence2");
Stipend.Value = Convert.ToDouble(db_reader.GetString("stipend"));
Parent1.Text = db_reader.GetString("parent1_fullname");
Parent2.Text = db_reader.GetString("parent2_fullname");
Parent3.Text = db_reader.GetString("parent1_fullname2");
Parent4.Text = db_reader.GetString("parent2_fullname2");
Sponsor1.Text = db_reader.GetString("witness1");
Sponsor2.Text = db_reader.GetString("witness2");
Residence3.Text = db_reader.GetString("witness1address");
Residence4.Text = db_reader.GetString("witness2address");
Minister.Text = db_reader.GetString("minister");
Remarks.Text = db_reader.GetString("remarks");
}
//close Connection
dbman.DBClose();
}
else
{
}
Suggestions1.Visibility = Visibility.Hidden;
Suggestions2.Visibility = Visibility.Hidden;
Suggestions3.Visibility = Visibility.Hidden;
Suggestions4.Visibility = Visibility.Hidden;
Suggestions5.Visibility = Visibility.Hidden;
Suggestions6.Visibility = Visibility.Hidden;
Suggestions7.Visibility = Visibility.Hidden;
}
private async void DoWork(object sender, DoWorkEventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = ((DataView)databur.ItemsSource).ToTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
bool doProceed = false;
//Check inputs
for (int _tmp = 0; _tmp < 12; _tmp++)
{
if (String.IsNullOrEmpty(dt.Rows[i][i].ToString()) == true)
{
doProceed = false;
}
else
{
doProceed = true;
}
}
if (doProceed == true)
{
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
string recID = pmsutil.GenRecordID();
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"INSERT INTO records(record_id, book_number, page_number, entry_number, record_date, recordholder_fullname, parent1_fullname, parent2_fullname)" +
"VALUES(@record_id, @book_number, @page_number, @entry_number, @record_date, @recordholder_fullname, @parent1_fullname, @parent2_fullname)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@record_id", recID);
cmd.Parameters.AddWithValue("@book_number", _bookNum);
cmd.Parameters.AddWithValue("@page_number", PageNum.Value);
cmd.Parameters.AddWithValue("@entry_number", dt.Rows[i][0].ToString());
cmd.Parameters.AddWithValue("@record_date", dt.Rows[i][1].ToString());
cmd.Parameters.AddWithValue("@recordholder_fullname", dt.Rows[i][3].ToString());
cmd.Parameters.AddWithValue("@parent1_fullname", dt.Rows[i][6].ToString());
cmd.Parameters.AddWithValue("@parent2_fullname", dt.Rows[i][7].ToString());
int stat_code = cmd.ExecuteNonQuery();
dbman.DBClose();
//Phase 2
cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO burial_records(record_id, burial_date, age, status, residence, residence2, sacrament, cause_of_death, place_of_interment, stipend, minister, remarks)" +
"VALUES(@record_id, @burial_date, @age, @status, @residence, @residence2, @sacrament, @cause_of_death, @place_of_interment, @stipend, @minister, @remarks)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@record_id", recID);
cmd.Parameters.AddWithValue("@burial_date", dt.Rows[i][2].ToString());
cmd.Parameters.AddWithValue("@age", dt.Rows[i][4].ToString());
cmd.Parameters.AddWithValue("@status", dt.Rows[i][5].ToString());
cmd.Parameters.AddWithValue("@residence", dt.Rows[i][8].ToString());
cmd.Parameters.AddWithValue("@residence2", dt.Rows[i][9].ToString());
cmd.Parameters.AddWithValue("@sacrament", dt.Rows[i][10].ToString());
cmd.Parameters.AddWithValue("@cause_of_death", dt.Rows[i][11].ToString());
cmd.Parameters.AddWithValue("@place_of_interment", dt.Rows[i][12].ToString());
cmd.Parameters.AddWithValue("@stipend", dt.Rows[i][13].ToString());
cmd.Parameters.AddWithValue("@minister", dt.Rows[i][14].ToString());
cmd.Parameters.AddWithValue("@remarks", dt.Rows[i][15].ToString());
stat_code = cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
string dirID = pmsutil.GenDirectoryID();
cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO burial_directory(directory_id, record_id, block, lot, plot, relative_contact_number)" +
"VALUES(@directory_id, @record_id, @block, @lot, @plot, @relative_contact_number)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@directory_id", dirID);
cmd.Parameters.AddWithValue("@record_id", recID);
cmd.Parameters.AddWithValue("@block", dt.Rows[i][16].ToString());
cmd.Parameters.AddWithValue("@lot", dt.Rows[i][17].ToString());
cmd.Parameters.AddWithValue("@plot", dt.Rows[i][18].ToString());
cmd.Parameters.AddWithValue("@relative_contact_number", dt.Rows[i][19].ToString());
stat_code = cmd.ExecuteNonQuery();
conn.Close();
_statcode = stat_code;
string tmp = pmsutil.LogRecord(recID, "LOGC-01");
//return stat_code;
});
}
else
{
_statcode = 601;
}
}
else
{
}
}
}
this.Close();
}
catch
{
}
}
public ViewHistoryWindow(string recordID)
{
InitializeComponent();
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT * FROM records_log, accounts WHERE record_id = @record_id;";
cmd.Parameters.AddWithValue("@record_id", recordID);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
history = new ObservableCollection <HistoryItem>();
while (db_reader.Read())
{
if (db_reader.GetString("log_code") == "LOGC-01")
{
history.Add(new HistoryItem()
{
Details = "Recorded by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt"),
Purpose = "NA"
});
}
else if (db_reader.GetString("log_code") == "LOGC-02")
{
history.Add(new HistoryItem()
{
Details = "Edited by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt"),
Purpose = "NA"
});
}
else if (db_reader.GetString("log_code") == "LOGC-03")
{
history.Add(new HistoryItem()
{
Details = "Certificate printed by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("hh:mm tt"),
Purpose = "For Reference"
});
}
else if (db_reader.GetString("log_code") == "LOGC-04")
{
history.Add(new HistoryItem()
{
Details = "Certificate printed by " + pmsutil.GetUsername(db_reader.GetString("log_creator")),
Date = DateTime.Parse(db_reader.GetString("log_date")).ToString("MMM dd, yyyy"),
Time = DateTime.Parse(db_reader.GetString("log_time")).ToString("HH:mm tt"),
Purpose = "For Marriage"
});
}
}
//close Connection
dbman.DBClose();
}
else
{
}
HistoryContainer2.ItemsSource = history;
}
private void DoWork(object sender, DoWorkEventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = ((DataView)datamat.ItemsSource).ToTable();
//MessageBox.Show(dt.Rows[0][0].ToString());
for (int i = 0; i < dt.Rows.Count; i++)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
bool doProceed = false;
//Check inputs
for (int _tmp = 0; _tmp < 12; _tmp++)
{
if (String.IsNullOrEmpty(dt.Rows[i][i].ToString()) == true)
{
doProceed = false;
}
else
{
doProceed = true;
}
}
if (doProceed == true)
{
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
string recID = pmsutil.GenRecordID();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO records(record_id, book_number, page_number, entry_number, record_date, recordholder_fullname, parent1_fullname, parent2_fullname)" +
"VALUES(@record_id, @book_number, @page_number, @entry_number, @record_date, @recordholder_fullname, @parent1_fullname, @parent2_fullname)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@record_id", recID);
cmd.Parameters.AddWithValue("@book_number", _bookNum);
cmd.Parameters.AddWithValue("@page_number", PageNum.Value);
cmd.Parameters.AddWithValue("@entry_number", Convert.ToInt32(dt.Rows[i][0].ToString()));
cmd.Parameters.AddWithValue("@record_date", dt.Rows[i][1].ToString());
cmd.Parameters.AddWithValue("@recordholder_fullname", dt.Rows[i][2].ToString());
cmd.Parameters.AddWithValue("@parent1_fullname", dt.Rows[i][12].ToString());
cmd.Parameters.AddWithValue("@parent2_fullname", dt.Rows[i][13].ToString());
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
//Phase 2
cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"INSERT INTO matrimonial_records(record_id, recordholder2_fullname, parent1_fullname2, parent2_fullname2, status1, status2, age1, age2, place_of_origin1, place_of_origin2, residence1, residence2, witness1, witness2, witness1address, witness2address, stipend, minister, remarks)" +
"VALUES(@record_id, @recordholder2_fullname, @parent1_fullname2, @parent2_fullname2, @status1, @status2, @age1, @age2, @place_of_origin1, @place_of_origin2, @residence1, @residence2, @witness1, @witness2, @witness1address, @witness2address, @stipend, @minister, @remarks)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@record_id", recID);
cmd.Parameters.AddWithValue("@recordholder2_fullname", dt.Rows[i][3].ToString());
cmd.Parameters.AddWithValue("@parent1_fullname2", dt.Rows[i][14].ToString());
cmd.Parameters.AddWithValue("@parent2_fullname2", dt.Rows[i][15].ToString());
cmd.Parameters.AddWithValue("@status1", dt.Rows[i][6].ToString());
cmd.Parameters.AddWithValue("@status2", dt.Rows[i][7].ToString());
cmd.Parameters.AddWithValue("@age1", dt.Rows[i][4].ToString());
cmd.Parameters.AddWithValue("@age2", dt.Rows[i][5].ToString());
cmd.Parameters.AddWithValue("@place_of_origin1", dt.Rows[i][8].ToString());
cmd.Parameters.AddWithValue("@place_of_origin2", dt.Rows[i][9].ToString());
cmd.Parameters.AddWithValue("@residence1", dt.Rows[i][10].ToString());
cmd.Parameters.AddWithValue("@residence2", dt.Rows[i][11].ToString());
cmd.Parameters.AddWithValue("@witness1", dt.Rows[i][16].ToString());
cmd.Parameters.AddWithValue("@witness2", dt.Rows[i][17].ToString());
cmd.Parameters.AddWithValue("@witness1address", dt.Rows[i][18].ToString());
cmd.Parameters.AddWithValue("@witness2address", dt.Rows[i][19].ToString());
cmd.Parameters.AddWithValue("@stipend", Convert.ToDouble(dt.Rows[i][20].ToString()));
cmd.Parameters.AddWithValue("@minister", dt.Rows[i][21].ToString());
cmd.Parameters.AddWithValue("@remarks", dt.Rows[i][22].ToString());
stat_code = cmd.ExecuteNonQuery();
conn.Close();
string tmp = pmsutil.LogRecord(recID, "LOGC-01");
_statcode = stat_code;
//return stat_code;
});
}
else
{
_statcode = 601;
}
}
else
{
}
}
}
this.Close();
}
catch
{
}
}
