private void btnDismissAll_Click(object sender, EventArgs e)
{
try
{
int attendeeId;
if (UIHelper.ConfirmDeleteReminders())
{
foreach (Janus.Windows.GridEX.GridEXRow gri in gridEXNotification.GetRows())
{
if (gri.RowType == Janus.Windows.GridEX.RowType.Record)
{
attendeeId = (int)gri.Cells["AttendeeId"].Value;
atriumDB.AttendeeRow attrow = currentFM.DB.Attendee.FindByAttendeeId(attendeeId);
if (!attrow.IsNotificationDismissNull())
{
attrow.BeginEdit();
attrow.NotificationDismiss = true;
attrow.Interval = 0;
attrow.EndEdit();
}
}
}
atLogic.BusinessProcess bp = currentFM.GetBP();
bp.AddForUpdate(currentFM.DB.Attendee);
bp.Update();
this.Close();
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
private void btnDismiss_Click(object sender, EventArgs e)
{
try
{
int attendeeId;
List <DataRow> rowList = new List <DataRow>();
foreach (Janus.Windows.GridEX.GridEXSelectedItem gsi in gridEXNotification.SelectedItems)
{
if (gsi.RowType == Janus.Windows.GridEX.RowType.Record)
{
rowList.Add(((DataRowView)gsi.GetRow().DataRow).Row);
}
}
if (rowList.Count > 0)
{
foreach (DataRow dr in rowList)
{
attendeeId = (int)dr["AttendeeId"];//.ItemArray[0];
atriumDB.AttendeeRow attrow = currentFM.DB.Attendee.FindByAttendeeId(attendeeId);
if (!attrow.IsNotificationDismissNull())
{
attrow.BeginEdit();
attrow.NotificationDismiss = true;
attrow.Interval = 0;
attrow.EndEdit();
}
dr.Delete();
dr.AcceptChanges();
}
atLogic.BusinessProcess bp = currentFM.GetBP();
bp.AddForUpdate(currentFM.DB.Attendee);
bp.Update();
DataTable dt = (DataTable)bSourceAppointmentDataview.DataSource;
if (dt.Rows.Count == 0)
{
this.Close();
}
SetFormHeader(dt.Rows.Count);
Refresh();
}
else
{
this.Close();
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
protected override void AfterAdd(DataRow row)
{
atriumDB.AttendeeRow dr = (atriumDB.AttendeeRow)row;
string ObjectName = this.myAttendeeDT.TableName;
//System.Diagnostics.Debug.WriteLine(dr["ContactId"] + dr.RowState.ToString() );
dr.AttendeeId = this.myA.AtMng.PKIDGet(ObjectName, 10);
dr.FileId = myA.CurrentFileId;
dr.Accepted = false;
dr.Declined = false;
dr.Required = true;
dr.Tentative = false;
}
private void AddAttendee()
{
fContactSelect f = new fContactSelect(myFM, null, true);
f.ShowDialog();
if (f.ContactId != 0)
{
//if contact is allready an attendee ignore
if (myFM.DB.Attendee.Select("ApptId=" + apptRow.ApptId.ToString() + " and ContactId=" + f.ContactId.ToString()).Length == 0)
{
atriumDB.AttendeeRow attRow = (atriumDB.AttendeeRow)myFM.GetAttendee().Add(apptRow);
attRow.ContactId = f.ContactId;
AddAttendeeToTimeline(this.timeLine1.Fields["ContactId"], attRow);
}
}
f.Close();
}
private void AddDummyAppointmentForFileContacts(atriumDB.AttendeeRow fcr)
{
//TODO only add if contactid not in timeline table
var tx = from t in myFM.DB.TimeLine
where t.ContactId == fcr.ContactId
select t;
if (tx.Count() == 0)
{
atriumDB.TimeLineRow appr = myFM.DB.TimeLine.NewTimeLineRow();
appr.ContactId = fcr.ContactId;
appr.StartDate = DateTime.Today.AddYears(-1);
appr.EndDate = DateTime.Today.AddYears(-1);
appr.StartDateLocal = DateTime.Today.AddYears(-1);
appr.EndDateLocal = DateTime.Today.AddYears(-1);
myFM.DB.TimeLine.AddTimeLineRow(appr);
}
}
private void AddAttendeeToTimeline(TimeLineField ContactField, atriumDB.AttendeeRow atr)
{
var fcx = from fc in myFM.DB.FileContact
where fc.ContactId == atr.ContactId
select fc;
if (fcx.Count() == 1)
{
atriumDB.FileContactRow fcr = fcx.Single();
ContactField.ValueList.Add(new TimeLineValueListItem(atr.ContactId, fcr.DisplayName, 0));
}
else
{
atriumDB.ContactRow cr = myFM.GetPerson().Load(atr.ContactId);
ContactField.ValueList.Add(new TimeLineValueListItem(atr.ContactId, cr.DisplayName, 0));
//TODO find contact
}
myFM.GetAppointment().LoadByContactIdDates(atr.ContactId, RangeStartDate, RangeEndDate);
AddDummyAppointmentForFileContacts(atr);
}
private void InitReminder()
{
try
{
officeDB.OfficerRow workingas = myFM.AtMng.WorkingAsOfficer;
int OfficerId = workingas.OfficerId;
atriumDB.AttendeeRow[] attws = (atriumDB.AttendeeRow[])myFM.DB.Attendee.Select("ApptId = " + apptRow.ApptId.ToString() + " AND ContactId =" + OfficerId.ToString());
int len = attws.Length;
if (len > 0)
{
atriumDB.AttendeeRow attw = attws[0];
if (!attw.IsIntervalNull())
{
apptRow.Interval = attw.Interval;
}
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
private void btnSnooze_Click(object sender, EventArgs e)
{
try
{
int attendeeId;
List <DataRow> rowList = new List <DataRow>();
foreach (Janus.Windows.GridEX.GridEXSelectedItem gsi in gridEXNotification.SelectedItems)
{
if (gsi.RowType == Janus.Windows.GridEX.RowType.Record)
{
rowList.Add(((DataRowView)gsi.GetRow().DataRow).Row);
}
}
if (rowList.Count > 0)
{
foreach (DataRow dr in rowList)
{
attendeeId = (int)dr.ItemArray[0];
atriumDB.AttendeeRow attrow = currentFM.DB.Attendee.FindByAttendeeId(attendeeId);
atriumDB.AppointmentRow approw = attrow.AppointmentRow;
if (!attrow.IsNotificationDismissNull())
{
attrow.BeginEdit();
attrow.NotificationDismiss = false;
int SelectedValue;
bool result = Int32.TryParse(ucDDReminder.SelectedValue.ToString(), out SelectedValue);
if (result)
{
attrow.Interval = SelectedValue;
}
//
// Activate this option in 1.10
//
//TimeSpan TS = approw.StartDateLocal.Subtract(DateTime.Now);
//int SelectedValue;
//bool result = Int32.TryParse(ucDDReminder.SelectedValue.ToString(), out SelectedValue);
//if (result)
//{
// double interval = TS.TotalMinutes - SelectedValue;
// attrow.Interval = Convert.ToInt32(interval);
//}
attrow.EndEdit();
}
dr.Delete();
dr.AcceptChanges();
}
atLogic.BusinessProcess bp = currentFM.GetBP();
bp.AddForUpdate(currentFM.DB.Attendee);
bp.Update();
DataTable dt = (DataTable)bSourceAppointmentDataview.DataSource;
if (dt.Rows.Count == 0)
{
this.Close();
}
SetFormHeader(dt.Rows.Count);
Refresh();
}
else
{
this.Close();
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
protected override void AfterChange(DataColumn dc, DataRow row)
{
SST.HearingRow dr = (SST.HearingRow)row;
switch (dc.ColumnName)
{
case "ApptId":
//add all the filecontacts as attendees
//atriumDB.AppointmentRow appr = myA.FM.DB.Appointment.FindByApptId(dr.ApptId);
//foreach (SST.FilePartyRow fcr in myA.DB.FileParty)
//{
// atriumDB.AttendeeRow ar = (atriumDB.AttendeeRow)myA.FM.GetAttendee().Add(appr);
// ar.ContactId = fcr.PartyId;
// ar.Accepted = true;
//}
break;
case "HearingToCloneId":
SST.HearingRow drHearing2Clone = (SST.HearingRow)myA.DB.Hearing.Select("ApptId=" + dr.HearingToCloneId)[0];
//are attendees loaded already?
//myA.FM.GetAttendee().LoadByApptId(drHearing2Clone.ApptId);
//find new appointment
atriumDB.AppointmentRow apptRow = myA.FM.DB.Appointment.FindByApptId(dr.ApptId);
atriumDB.AppointmentRow oldApptRow = myA.FM.DB.Appointment.FindByApptId(drHearing2Clone.ApptId);
oldApptRow.ShowAsBusy = false;
//add attendees for each attendee in cloned hearing
foreach (atriumDB.AttendeeRow attendeerow in myA.FM.DB.Attendee.Select("ApptId=" + drHearing2Clone.ApptId))
{
atriumDB.AttendeeRow newAttendee = (atriumDB.AttendeeRow)myA.FM.GetAttendee().Add(apptRow);
newAttendee.ContactId = attendeerow.ContactId;
}
dr.HearingMethodId = drHearing2Clone.HearingMethodId;
apptRow.Subject = oldApptRow.Subject;
break;
case "HearingMethodId":
if (!dr.IsHearingMethodIdNull())
{
if (dr.HearingMethodId != 3) // teleconference
{
dr.SetSecurityPINNull();
}
}
break;
case "PINMode":
if (!dr.IsHearingMethodIdNull())
{
if (dr.HearingMethodId == 3) // teleconference
{
atriumDB.FileContactRow fcrTM = myA.FM.GetFileContact().GetByRole("FTM");
//SST.HearingDataTable hdt = myDAL.LoadByMemberId(fcrTM.ContactId);
DataTable dt = myA.AtMng.GetGeneralRec("select * from vddeSecurityPIN where OfficerID=" + fcrTM.ContactId.ToString());
Random random = new Random();
int PIN = 0;
if (!dr.IsPINModeNull())
{
if (!dr.IsSecurityPINNull())
{
dr.PreviousSecurityPIN = dr.SecurityPIN;
}
else
{
//see if there this member already has a PIN for the file.
DataRow[] drs = dt.Select("Fileid=" + dr.FileID.ToString());
if (drs.Length > 0)
{
dr.SecurityPIN = (int)drs[0]["SecurityPIN"];
dr.PreviousSecurityPIN = dr.SecurityPIN;
}
else
{
dr.PreviousSecurityPIN = 0;
}
}
if (dr.PINMode == 1 || dr.PINMode == 3 || dr.IsSecurityPINNull()) // generate new PIN
{
PIN = GeneratePIN(dt);
}
else // check for duplicates not on the same file
{
DataRow[] drs = dt.Select("SecurityPIN=" + dr.SecurityPIN.ToString() + " and Fileid<>" + dr.FileID.ToString());
if (drs.Length > 0)
{
PIN = GeneratePIN(dt);
}
else
{
dr.PreviousSecurityPIN = 0; //this is to force the current PIN into the member's PIN history
PIN = dr.SecurityPIN;
}
}
}
dr.SecurityPIN = PIN;
}
}
break;
}
}