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(); }