/// <summary> /// Method to get calendar events /// </summary> /// <param name="uId">uId</param> public List <CalendarEventInfo> GetCalendarEvents(string uId) { try { SqlParameter[] parms = { new SqlParameter("@UID", SqlDbType.VarChar, 50) }; parms[0].Value = uId; var calEvents = new List <CalendarEventInfo>(); using (var rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SqlText.SQL_SELECT_CALENDAR_GETCALENDAREVENTS, parms)) { while (rdr.Read()) { var calEvent = new CalendarEventInfo(); calEvent.EventID = ComUtility.DBNullInt32Handler(rdr["EventID"]); calEvent.CalendarID = ComUtility.DBNullInt32Handler(rdr["CalendarID"]); calEvent.Title = ComUtility.DBNullStringHandler(rdr["Title"]); calEvent.StartDate = ComUtility.DBNullDateTimeHandler(rdr["StartDate"]); calEvent.EndDate = ComUtility.DBNullDateTimeHandler(rdr["EndDate"]); calEvent.IsAllDay = ComUtility.DBNullNullableBooleanHandler(rdr["IsAllDay"]); calEvent.Notes = ComUtility.DBNullStringHandler(rdr["Notes"]); calEvent.Location = ComUtility.DBNullStringHandler(rdr["Location"]); calEvent.Reminder = ComUtility.DBNullStringHandler(rdr["Reminder"]); calEvent.Url = ComUtility.DBNullStringHandler(rdr["Url"]); calEvent.IsNew = ComUtility.DBNullNullableBooleanHandler(rdr["IsNew"]); calEvent.UID = ComUtility.DBNullStringHandler(rdr["UID"]); calEvent.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["UpdateTime"]); calEvents.Add(calEvent); } } return(calEvents); } catch { throw; } }
public string AddRecord(string record) { try { var rec = (Event)JsonConvert.DeserializeObject(record, typeof(Event)); var calEvent = new CalendarEventInfo(); calEvent.CalendarID = (rec.CalendarId == null ? WebUtility.DefaultInt32 : (int)rec.CalendarId); calEvent.Title = (rec.Title == null ? WebUtility.DefaultString : rec.Title); calEvent.StartDate = (rec.StartDate == null ? WebUtility.DefaultDateTime : (DateTime)rec.StartDate); calEvent.EndDate = (rec.EndDate == null ? WebUtility.DefaultDateTime : (DateTime)rec.EndDate); calEvent.IsAllDay = rec.IsAllDay; calEvent.Notes = (rec.Notes == null ? WebUtility.DefaultString : rec.Notes); calEvent.Location = (rec.Location == null ? WebUtility.DefaultString : rec.Location); calEvent.Reminder = (rec.Reminder == null ? WebUtility.DefaultString : rec.Reminder); calEvent.Url = (rec.Url == null ? WebUtility.DefaultString : rec.Url); calEvent.IsNew = false; calEvent.UID = Page.User.Identity.Name; calEvent.UpdateTime = DateTime.Now; var calendarEntity = new BCalendar(); calendarEntity.AddCalendarEvent(calEvent); var store = RightNavCalendarPanel.EventStore; BindStoreData(store); WebUtility.ShowNotify(EnmErrType.Info, String.Format("{0}<br/>事件保存成功!", rec.Title)); } catch (Exception err) { WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name); WebUtility.ShowMessage(EnmErrType.Error, err.Message); return(err.Message); } return(String.Empty); }
/// <summary> /// Method to delete calendar event /// </summary> /// <param name="calEvent">calEvent</param> public bool DeleteCalendarEvent(CalendarEventInfo calEvent) { try { return(calDal.DeleteCalendarEvent(calEvent)); } catch { throw; } }
/// <summary> /// Method to delete calendar event /// </summary> /// <param name="calEvent">calEvent</param> public bool DeleteCalendarEvent(CalendarEventInfo calEvent) { try { using (var conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction)) { conn.Open(); var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { SqlParameter[] parms = { new SqlParameter("@EventID", SqlDbType.Int) }; parms[0].Value = calEvent.EventID; SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlText.SQL_DELETE_CALENDAR_DELETECALENDAREVENT, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } } catch { throw; } return(true); }
private ICSCalendar CreateEventICSInfo(int eventId, string user, string cal) { ICSCalendar calInfo = new ICSCalendar(); CalendarEventInfo eventInfo = GetCalendarEventInfo(eventId, user); calInfo.EventStartDateTime = eventInfo.StartTime ?? DateTime.UtcNow; calInfo.EventEndDateTime = eventInfo.EndTime ?? DateTime.UtcNow; calInfo.OrganizerName = "Rich See"; calInfo.OrganizerEmail = "*****@*****.**"; calInfo.EventDescription = eventInfo.Description; //Text to display in event info calInfo.EventSummary = eventInfo.Title; calInfo.AlarmTrigger = 30; calInfo.AlarmRepeat = 2; calInfo.AlarmDuration = 15; calInfo.AlarmDescription = eventInfo.Title; return(calInfo); }
/// <summary> /// Method to add calendar event /// </summary> /// <param name="calEvent">calEvent</param> public bool AddCalendarEvent(CalendarEventInfo calEvent) { try { using (var conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction)) { conn.Open(); var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted); try { SqlParameter[] parms = { new SqlParameter("@CalendarID", SqlDbType.Int), new SqlParameter("@Title", SqlDbType.NVarChar, 255), new SqlParameter("@StartDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@IsAllDay", SqlDbType.Bit), new SqlParameter("@Notes", SqlDbType.NVarChar, 1024), new SqlParameter("@Location", SqlDbType.NVarChar, 255), new SqlParameter("@Reminder", SqlDbType.NVarChar, 255), new SqlParameter("@Url", SqlDbType.VarChar, 255), new SqlParameter("@IsNew", SqlDbType.Bit), new SqlParameter("@UID", SqlDbType.VarChar, 50), new SqlParameter("@UpdateTime", SqlDbType.DateTime) }; if (calEvent.CalendarID != ComUtility.DefaultInt32) { parms[0].Value = calEvent.CalendarID; } else { parms[0].Value = DBNull.Value; } if (calEvent.Title != ComUtility.DefaultString) { parms[1].Value = calEvent.Title; } else { parms[1].Value = DBNull.Value; } if (calEvent.StartDate != ComUtility.DefaultDateTime) { parms[2].Value = calEvent.StartDate; } else { parms[2].Value = DBNull.Value; } if (calEvent.EndDate != ComUtility.DefaultDateTime) { parms[3].Value = calEvent.EndDate; } else { parms[3].Value = DBNull.Value; } if (calEvent.IsAllDay != ComUtility.DefaultNullableBoolean) { parms[4].Value = calEvent.IsAllDay; } else { parms[4].Value = DBNull.Value; } if (calEvent.Notes != ComUtility.DefaultString) { parms[5].Value = calEvent.Notes; } else { parms[5].Value = DBNull.Value; } if (calEvent.Location != ComUtility.DefaultString) { parms[6].Value = calEvent.Location; } else { parms[6].Value = DBNull.Value; } if (calEvent.Reminder != ComUtility.DefaultString) { parms[7].Value = calEvent.Reminder; } else { parms[7].Value = DBNull.Value; } if (calEvent.Url != ComUtility.DefaultString) { parms[8].Value = calEvent.Url; } else { parms[8].Value = DBNull.Value; } if (calEvent.IsNew != ComUtility.DefaultNullableBoolean) { parms[9].Value = calEvent.IsNew; } else { parms[9].Value = DBNull.Value; } if (calEvent.UID != ComUtility.DefaultString) { parms[10].Value = calEvent.UID; } else { parms[10].Value = DBNull.Value; } if (calEvent.UpdateTime != ComUtility.DefaultDateTime) { parms[11].Value = calEvent.UpdateTime; } else { parms[11].Value = DBNull.Value; } SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlText.SQL_INSERT_CALENDAR_ADDCALENDAREVENT, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } } catch { throw; } return(true); }