public IEnumerable SelectMethodHandler()
{
Appointments.Clear();
OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM SCHEDULEAPPTS";
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
CustomAppointment newAppt = new CustomAppointment();
newAppt.ALLDAY = dr["ALLDAY"] is System.DBNull ? false : Convert.ToBoolean(dr["ALLDAY"]);
newAppt.DESCRIPTION = dr["DESCRIPTION"] is System.DBNull ? "" : dr["DESCRIPTION"].ToString();
newAppt.ENDDATE = dr["ENDDATE"] is System.DBNull ? DateTime.MinValue : Convert.ToDateTime(dr["ENDDATE"]);
newAppt.LABEL = dr["LABEL"] is System.DBNull ? 0 : Convert.ToInt32(dr["LABEL"]);
newAppt.LOCATION = dr["LOCATION"] is System.DBNull ? "" : dr["LOCATION"].ToString();
newAppt.RECURRENCEINFO = dr["RECURRENCEINFO"] is System.DBNull ? "" : dr["RECURRENCEINFO"].ToString();
newAppt.REMINDERINFO = dr["REMINDERINFO"] is System.DBNull ? "" : dr["REMINDERINFO"].ToString();
newAppt.RESOURCEID = dr["RESOURCEID"] is System.DBNull ? 0 : Convert.ToInt32(dr["RESOURCEID"]);
newAppt.STARTDATE = dr["STARTDATE"] is System.DBNull ? DateTime.MinValue : Convert.ToDateTime(dr["STARTDATE"]);
newAppt.STATUS = dr["STATUS"] is System.DBNull ? 0 : Convert.ToInt32(dr["STATUS"]);
newAppt.SUBJECT = dr["SUBJECT"] is System.DBNull ? "" : dr["SUBJECT"].ToString();
newAppt.TYPE = dr["TYPE"] is System.DBNull ? 0 : Convert.ToInt32(dr["TYPE"]);
newAppt.UNIQUEID = dr["UNIQUEID"] is System.DBNull ? 0 : Convert.ToInt32(dr["UNIQUEID"]);
Appointments.Add(newAppt);
}
return(Appointments);
}
public object InsertMethodHandler(CustomAppointment customAppt)
{
int newAppointmentId = Appointments.Count;
OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO SCHEDULEAPPTS (UNIQUEID, TYPE, STARTDATE, ENDDATE, ALLDAY, SUBJECT, LOCATION, DESCRIPTION, STATUS, LABEL, RESOURCEID, REMINDERINFO, RECURRENCEINFO) VALUES (:UNIQUEID, :TYPE, :STARTDATE, :ENDDATE, :ALLDAY, :SUBJECT, :LOCATION, :DESCRIPTION, :STATUS, :LABEL, :RESOURCEID, :REMINDERINFO, :RECURRENCEINFO)";
cmd.Parameters.Add("UNIQUEID", newAppointmentId);
cmd.Parameters.Add("TYPE", customAppt.TYPE);
cmd.Parameters.Add("STARTDATE", customAppt.STARTDATE);
cmd.Parameters.Add("ENDDATE", customAppt.ENDDATE);
cmd.Parameters.Add("ALLDAY", customAppt.ALLDAY);
cmd.Parameters.Add("SUBJECT", customAppt.SUBJECT);
cmd.Parameters.Add("LOCATION", customAppt.LOCATION);
cmd.Parameters.Add("DESCRIPTION", customAppt.DESCRIPTION);
cmd.Parameters.Add("STATUS", customAppt.STATUS);
cmd.Parameters.Add("LABEL", customAppt.LABEL);
cmd.Parameters.Add("RESOURCEID", customAppt.RESOURCEID == null ? 0 : customAppt.RESOURCEID);
cmd.Parameters.Add("REMINDERINFO", customAppt.REMINDERINFO == null ? "" : customAppt.REMINDERINFO);
cmd.Parameters.Add("RECURRENCEINFO", customAppt.RECURRENCEINFO == null ? "" : customAppt.RECURRENCEINFO);
cmd.ExecuteNonQuery();
return(newAppointmentId);
}
public void DeleteMethodHandler(CustomAppointment customAppt)
{
CustomAppointment currentAppt = GetSourceAppointment(customAppt.Id);
if (customAppt != null)
{
Appointments.Remove(customAppt);
}
}
public void DeleteMethodHandler(CustomAppointment customAppt)
{
OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "DELETE FROM SCHEDULEAPPTS WHERE UNIQUEID = :UNIQUEID";
cmd.Parameters.Add("UNIQUEID", customAppt.UNIQUEID);
cmd.ExecuteNonQuery();
}
private CustomAppointment CreateCustomAppointment(string subject, object resourceId, int status, int label, string userName)
{
CustomAppointment apt = new CustomAppointment();
apt.Subject = subject;
apt.OwnerId = resourceId;
apt.StartTime = DateTime.Today.AddHours(label);
apt.EndTime = apt.StartTime.AddHours(2);
apt.Status = status;
apt.Label = label;
apt.AppointmentUser = userName;
return(apt);
}
private CustomAppointment CreateCustomAppointment(string subject, object resourceId, int status, int label)
{
CustomAppointment apt = new CustomAppointment();
apt.Subject = subject;
apt.OwnerId = resourceId;
Random rnd = RandomInstance;
int rangeInMinutes = 60 * 24;
apt.StartTime = DateTime.Today + TimeSpan.FromMinutes(rnd.Next(0, rangeInMinutes));
apt.EndTime = apt.StartTime + TimeSpan.FromMinutes(rnd.Next(0, rangeInMinutes / 4));
apt.Status = status;
apt.Label = label;
return(apt);
}
public object InsertMethodHandler(CustomAppointment customAppt)
{
int lastId = 0;
foreach (CustomAppointment item in Appointments)
{
if (Convert.ToInt32(item.Id) > lastId)
{
lastId = Convert.ToInt32(item.Id);
}
}
customAppt.Id = lastId + 1;
Appointments[Appointments.Count - 1].Id = customAppt.Id;
return(customAppt.Id);
}
public void UpdateMethodHandler(CustomAppointment customAppt)
{
CustomAppointment currentAppt = GetSourceAppointment(customAppt.Id);
if (customAppt != null)
{
currentAppt.AllDay = customAppt.AllDay;
currentAppt.Description = customAppt.Description;
currentAppt.EndTime = customAppt.EndTime;
currentAppt.EventType = customAppt.EventType;
currentAppt.Id = customAppt.Id;
currentAppt.Label = customAppt.Label;
currentAppt.Location = customAppt.Location;
currentAppt.OwnerId = customAppt.OwnerId;
currentAppt.RecurrenceInfo = customAppt.RecurrenceInfo;
currentAppt.ReminderInfo = customAppt.ReminderInfo;
currentAppt.StartTime = customAppt.StartTime;
currentAppt.Status = customAppt.Status;
currentAppt.Subject = customAppt.Subject;
}
}
public void UpdateMethodHandler(CustomAppointment customAppt)
{
OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE SCHEDULEAPPTS SET TYPE = :TYPE, STARTDATE = :STARTDATE, ENDDATE = :ENDDATE, ALLDAY = :ALLDAY, SUBJECT = :SUBJECT, LOCATION = :LOCATION, DESCRIPTION = :DESCRIPTION, STATUS = :STATUS, LABEL = :LABEL, RESOURCEID = :RESOURCEID, REMINDERINFO = :REMINDERINFO, RECURRENCEINFO = :RECURRENCEINFO WHERE UNIQUEID = :UNIQUEID";
cmd.Parameters.Add("UNIQUEID", customAppt.UNIQUEID);
cmd.Parameters.Add("TYPE", customAppt.TYPE);
cmd.Parameters.Add("STARTDATE", customAppt.STARTDATE);
cmd.Parameters.Add("ENDDATE", customAppt.ENDDATE);
cmd.Parameters.Add("ALLDAY", customAppt.ALLDAY);
cmd.Parameters.Add("SUBJECT", customAppt.SUBJECT);
cmd.Parameters.Add("LOCATION", customAppt.LOCATION);
cmd.Parameters.Add("DESCRIPTION", customAppt.DESCRIPTION);
cmd.Parameters.Add("STATUS", customAppt.STATUS);
cmd.Parameters.Add("LABEL", customAppt.LABEL);
cmd.Parameters.Add("RESOURCEID", customAppt.RESOURCEID == null ? 0 : customAppt.RESOURCEID);
cmd.Parameters.Add("REMINDERINFO", customAppt.REMINDERINFO == null ? "" : customAppt.REMINDERINFO);
cmd.Parameters.Add("RECURRENCEINFO", customAppt.RECURRENCEINFO == null ? "" : customAppt.RECURRENCEINFO);
cmd.ExecuteNonQuery();
}