public AddSchedule()
{
InitializeComponent();
dtpDateStart.Value = DateTime.Now.Date;
dtpDateEnd.Value = DateTime.Now.Date;
dtpTimeStart.Value = DateTime.Now;
dtpTimeEnd.Value = DateTime.Now;
Draggable drag = new Draggable(this);
drag.makeDraggable(panelControl);
DataTable dt = dh.getMinisters(MinisterStatus.Active);
cmbMinister.Items.Add(string.Empty);//Added empty item to cmbMinister
foreach (DataRow r in dt.Rows)
{
ComboboxContent cc = new ComboboxContent(int.Parse(r["ministerID"].ToString()), r["name"].ToString());
cmbMinister.Items.Add(cc);
}
cmbScheduleType.SelectedIndex = 0;
cmbMinister.SelectedIndex = 0;
}
private void loadMinisters()
{
DataTable dt = dh.getMinisters(MinisterStatus.Active);
ComboboxContent empty = new ComboboxContent(-1, "");
cmbMinister.Items.Add(empty);
foreach (DataRow r in dt.Rows)
{
ComboboxContent cc = new ComboboxContent(int.Parse(r["ministerID"].ToString()), r["name"].ToString());
cmbMinister.Items.Add(cc);
}
if (operation == OperationType.Edit)
{
int index = 0;
int ministerID = Convert.ToInt32(row["ministerID"].ToString());
//MessageBox.Show(string.Format("MinisterID is {0}: ", sacramentMinisterID.ToString()));
foreach (ComboboxContent cc in cmbMinister.Items)
{
//Console.WriteLine(string.Format("cc.id == sacramentMinisterID - {0} == {1}; Index is {2}", cc.id, sacramentMinisterID, index));
if (cc != null && cc.id == ministerID)
{
cmbMinister.SelectedIndex = index;
break;
}
index++;
}
}
}
/// <summary>
/// Loads ministers into a combobox
/// </summary>
private void loadMinisters()
{
DataTable dt;
if (type == SacramentType.Confirmation)
{//Only Archbishop and Mosignor can perform confirmation
dt = dh.getMinisters(MinistryType.Archbishop, MinisterStatus.Active);
DataTable dt2 = dh.getMinisters(MinistryType.Mosignor, MinisterStatus.Active);
dt.Merge(dt2);
}
else
{//All ministers can perform baptism
dt = dh.getMinisters(MinisterStatus.Active);
}
ComboboxContent empty = new ComboboxContent(-1, "");
MinisterCBox.Items.Add(empty); //First item of ministerCBox is empty
foreach (DataRow r in dt.Rows)
{
int ministerID = int.Parse(r["ministerID"].ToString());
ComboboxContent cc = new ComboboxContent(ministerID, r["name"].ToString());
//MessageBox.Show("Minister = " + r["name"].ToString());
MinisterCBox.Items.Add(cc);
}
MinisterCBox.SelectedIndex = 0;
//If Operation is Edit, then load sacrament minister
if (operation == OperationType.Edit)
{
int sacramentMinisterID = Convert.ToInt32(row["ministerID"].ToString());
int index = 0;
//MessageBox.Show(string.Format("MinisterID is {0}: ", sacramentMinisterID.ToString()));
foreach (ComboboxContent cc in MinisterCBox.Items)
{
//Console.WriteLine(string.Format("cc.id == sacramentMinisterID - {0} == {1}; Index is {2}", cc.id, sacramentMinisterID, index));
if (cc != null && cc.id == sacramentMinisterID)
{
MinisterCBox.SelectedIndex = index;
break;
}
index++;
}
}
}
public AdvanceSearch(SacramentType t)
{
InitializeComponent();
DataTable dt = dh.getMinisters();
this.t = t;
Draggable drag = new Draggable(this);
drag.makeDraggable(panel2);
foreach (DataRow dr in dt.Rows)
{
ComboboxContent cc = new ComboboxContent(int.Parse(dr["ministerID"].ToString()), dr["name"].ToString());
cmbMinister.Items.Add(cc);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
if (t == SacramentType.Marriage)
{
this.filter = string.Format(@"(groomName LIKE '%{0}%' OR brideName LIKE '%{0}%') AND ", name);
if (cbBetweenDates.Checked)
{
this.filter += string.Format("AND marriageDate >= '{0}' AND marriageDate <= '{1}'", dtpFrom.Value.ToString("yyyy-MM-dd"), dtpTo.Value.ToString("yyyy-MM-dd"));
}
}
else if (t == SacramentType.Baptism)
{
//MessageBox.Show(string.Format("{0}, {1}, {2}", registry, page, record));
this.filter = string.Format(@"(firstName LIKE '%{0}%' OR midName LIKE '%{0}%' OR lastName LIKE '%{0}%' OR suffix LIKE '%{0}%') AND ", name);
if (cbBetweenDates.Checked)
{
this.filter += string.Format("AND baptismDate >= '{0}' AND baptismDate <= '{1}'", dtpFrom.Value.ToString("yyyy-MM-dd"), dtpTo.Value.ToString("yyyy-MM-dd"));
}
}
else
{
this.filter = string.Format(@"(firstName LIKE '%{0}%' OR midName LIKE '%{0}%' OR lastName LIKE '%{0}%' OR suffix LIKE '%{0}%') AND ", name);
if (cbBetweenDates.Checked)
{
this.filter += string.Format("AND confirmationDate >= '{0}' AND confirmationDate <= '{1}'", dtpFrom.Value.ToString("yyyy-MM-dd"), dtpTo.Value.ToString("yyyy-MM-dd"));
}
}
this.filter += getReferenceFilter();
if (cmbMinister.SelectedIndex != -1)
{
ComboboxContent cc = cmbMinister.SelectedItem as ComboboxContent;
string minister = string.Format("AND ministerID = '{0}'", cc.id);
this.filter += minister;
}
this.DialogResult = DialogResult.OK;
this.Close();
}
public AddSchedule(ScheduleType t, CalendarEvent ev)
{
InitializeComponent();
this.ev = ev;
dtpDateStart.Value = ev.item.StartDate;
dtpDateEnd.Value = ev.item.EndDate;
dtpTimeStart.Value = ev.item.StartDate;
dtpTimeEnd.Value = ev.item.EndDate;
cmbScheduleType.SelectedIndex = (int)t;
cmbScheduleType.Enabled = false;
txtTitle.Text = ev.item.Text;
txtDetails.Text = ev.details;
if (t == ScheduleType.Appointment)
{
DataTable dt = dh.getMinisters(MinisterStatus.Active);
foreach (DataRow r in dt.Rows)
{
ComboboxContent cc = new ComboboxContent(int.Parse(r["ministerID"].ToString()), r["name"].ToString());
cmbMinister.Items.Add(cc);
}
foreach (ComboboxContent c in cmbMinister.Items)
{
if (c.id == ev.ministerID)
{
cmbMinister.SelectedIndex = cmbMinister.Items.IndexOf(c);
break;
}
}
}
else if (t == ScheduleType.BloodDonation)
{
txtVenue.Text = ev.venue;
}
}
