public static string UpdateEventTimeCustomDate(DeltoneCRM.DataHandlers.DisplayEventHandler.ImproperCalendarEvent improperEvent) { List <int> idList = (List <int>)System.Web.HttpContext.Current.Session["idList"]; // if (idList != null && idList.Contains(improperEvent.id)) { string cs = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; var startDate = Convert.ToDateTime(improperEvent.start); var endDate = Convert.ToDateTime(improperEvent.end); // if (endDate.Date < startDate.Date) endDate = startDate.AddHours(1); improperEvent.allDay = false; new CalendarEventDAL(cs).updateEventTime(improperEvent.id, startDate, endDate, improperEvent.allDay); //allDay parameter added for FullCalendar 2.x return("updated event with id:" + improperEvent.id + " update start to: " + improperEvent.start + " update end to: " + improperEvent.end); } return("unable to update event with id: " + improperEvent.id); }
protected void Page_Load(object sender, EventArgs e) { var obj = new DeltoneCRM.DataHandlers.DisplayEventHandler.ImproperCalendarEvent(); obj.title = Request.Form["title"].ToString(); obj.description = Request.Form["description"].ToString(); obj.start = Request.Form["start"].ToString(); obj.color = Request.Form["color"].ToString(); obj.QuoteId = Request.Form["QuoteId"].ToString(); obj.companyId = Convert.ToInt32(Request.Form["companyId"].ToString()); HttpContext.Current.Session["calendarObj"] = obj; }
public static int addEvent(DeltoneCRM.DataHandlers.DisplayEventHandler.ImproperCalendarEvent improperEvent) { string cs = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; DeltoneCRM_DAL.CalendarEventDAL.CalendarEvent cevent = new DeltoneCRM_DAL.CalendarEventDAL.CalendarEvent() { title = improperEvent.title, description = improperEvent.description, start = Convert.ToDateTime(improperEvent.start), end = Convert.ToDateTime(improperEvent.end), allDay = improperEvent.allDay, color = improperEvent.color, isreminder = improperEvent.isreminder }; cevent.url = ""; // if (CheckAlphaNumeric(cevent.title) && CheckAlphaNumeric(cevent.description)) // { var userId = 0; if (HttpContext.Current.Session["LoggedUserID"] != null) { userId = Convert.ToInt32(HttpContext.Current.Session["LoggedUserID"].ToString()); } int key = new CalendarEventDAL(cs).addEvent(cevent, 0, userId); List <int> idList = (List <int>)System.Web.HttpContext.Current.Session["idList"]; if (idList != null) { idList.Add(key); } return(key); //return the primary key of the added cevent object // } return(-1); //return a negative number just to signify nothing has been added }
public static int addEvent(DeltoneCRM.DataHandlers.DisplayEventHandler.ImproperCalendarEvent improperEvent) { string cs = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; var startDate = Convert.ToDateTime(improperEvent.start); // var endateObj = Convert.ToDateTime(improperEvent.end); var endDate = startDate.AddHours(1); //if (startDate != endateObj) // endDate = endateObj; var isAllDay = false; DeltoneCRM_DAL.CalendarEventDAL.CalendarEvent cevent = new DeltoneCRM_DAL.CalendarEventDAL.CalendarEvent() { title = improperEvent.title, description = improperEvent.description, start = startDate, end = endDate, allDay = isAllDay, color = improperEvent.color }; var comId = 0; if (HttpContext.Current.Session["companyId"] != null) { comId = Convert.ToInt32(HttpContext.Current.Session["companyId"].ToString()); } cevent.url = string.Format(UrlCompany, comId); var userId = 0; if (HttpContext.Current.Session["LoggedUserID"] != null) { userId = Convert.ToInt32(HttpContext.Current.Session["LoggedUserID"].ToString()); } int key = new CalendarEventDAL(cs).addEvent(cevent, comId, userId); //List<int> idList = (List<int>)System.Web.HttpContext.Current.Session["idList"]; //if (idList != null) //{ // idList.Add(key); //} var connectionstring = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; SqlConnection conn = new SqlConnection(); conn.ConnectionString = connectionstring; var columnName = "CalendarEvent all columns Order"; var talbeName = "CalendarEvent"; var ActionType = "Event Created"; int primaryKey = key; var companyName = new DeltoneCRM_DAL.CompanyDAL(connectionstring).getCompanyNameByID(comId.ToString()); var lastString = "Event Scheduled for company " + companyName + ": " + cevent.title; new DeltoneCRM_DAL.CompanyDAL(connectionstring).CreateActionONAuditLog("", lastString, userId, conn, 0, columnName, talbeName, ActionType, primaryKey, comId); return(key); //return the primary key of the added cevent object return(-1); //return a negative number just to signify nothing has been added }