public void CreateCalendarTable(string tableName) { calendarObject cObj = new calendarObject(); StringBuilder sbElements = new StringBuilder(); { bool justCreated = true; foreach (sqliteBase sElement in cObj.values) { if (justCreated) { justCreated = false; } else { sbElements.Append(", "); } sbElements.Append(sElement.valueName + " " + sElement.dataType); } } string sql_command = "CREATE TABLE " + tableName + " ( " + sbElements.ToString() + ")"; SQLiteCommandsExecuter.executeNonQuery(sql_command, Core.AppCore.dCore.M_dbConnection); }
public static void AddNewElement(string tableSource) { Add_Project inputDialog = new Add_Project() { Style = (Style)App.Current.Resources["BlankWindow"], Height = 500, Width = 600 }; if (tableSource != "") { inputDialog.parentTable = tableSource; } if (inputDialog.ShowDialog().Value) { try { calendarObject obj = inputDialog.CalendarObject; Core.AppCore.dCore.CalendarObjectManager.AddCalendarObject(obj); } catch (Exception ex) { ex.Source = "SQL_lite_database_search_wpf.UI.UIObjectManager.addNewElement(string)"; Usefull_Tools.ErrorHandeler.printOut(ex); } calendarContentChanged?.Invoke(); } }
public CalendarObjectView(calendarObject cObj) { InitializeComponent(); CalendarObject = cObj; LoadCommponements(); }
public calendarObject GetCalendarObject(int objectID, string tableName) { string sql = "select * from " + tableName + " where (" + elementID + "=" + objectID + ") order by _rowid_ ASC LIMIT 1"; SQLiteDataReader reader = SQLiteCommandsExecuter.executeDataReader(sql, Core.AppCore.dCore.M_dbConnection); calendarObject cObjects = ReaderToCobj(reader, tableName); return(cObjects); }
public ElementColorPicker(calendarObject cObj) { CalendarObject = cObj; currentColors.Add(cObj.color.value); InitializeComponent(); loadColors(); }
public void addProject(Project prj) { AppCore.projects.Add(prj); calendarObject c = prj; AppCore.dCore.calendarObjectManager.addCalendarObject(c); AppCore.dCore.calendarObjectManager.createCalendarTable(prj.projectTableName); }
// update or save, the same thing public void UpdateCalendarObject(calendarObject cObj) { calendarObject old = GetCalendarObject(cObj.elementID.value, cObj.tableName); for (int i = 0; i < cObj.values.Length; i++) { if (cObj.values[i].Equals(old.values[i]) == false) { UpdateCalendarObject(cObj.values[i], cObj.elementID.value, cObj.tableName); } } }
public void DeleteCalendarObject(calendarObject cObj, bool deleteAssociatedTable = true) { if (deleteAssociatedTable) { if (cObj.isRepository.value) { DeleteCalendarTable(cObj.projectTableName.value); } } DeleteCalendarObject(cObj.elementID.value, cObj.tableName); }
public static bool isDateBetween(calendarObject element, DateTime startDate, DateTime endDate) { if (element.isDateUsed.value == true) { bool superior = isOneOfSlectedDateBetween(element.startTime.value, startDate, endDate); bool inferior = isOneOfSlectedDateBetween(element.endTime.value, startDate, endDate); if (superior || inferior) { return(true); } } return(false); }
public SmallCalendarView(calendarObject cObj) { InitializeComponent(); CalendarObject = cObj; this.Background = new SolidColorBrush(cObj.color.value); this.UITbName.Text = cObj.name.value; if (cObj.description.value != "" && cObj.description.value != null) { this.ToolTip = cObj.description.value; } }
public static calendarObject ChangeCalendarObjectColor(calendarObject cObj) { ElementColorPicker inputDialog = new ElementColorPicker(cObj) { Style = (Style)App.Current.Resources["BlankWindow"] }; if (inputDialog.ShowDialog().Value) { cObj = inputDialog.CalendarObject; Core.AppCore.dCore.CalendarObjectManager.UpdateCalendarObject(cObj.color, cObj.elementID.value, cObj.tableName); calendarContentChanged?.Invoke(); } return(cObj); }
public static calendarObject ChangeCalendarObject(calendarObject cObj) { Add_Project inputDialog = new Add_Project(cObj) { Style = (Style)App.Current.Resources["BlankWindow"] }; if (inputDialog.ShowDialog().Value) { cObj = inputDialog.UICalendarInformation.CalendarObject; // update Core.AppCore.dCore.CalendarObjectManager.UpdateCalendarObject(cObj); calendarContentChanged?.Invoke(); } return(cObj); }
public static bool isDateBetween(calendarObject element, DateTime day) { if (element.isDateUsed.value == true) { double startDate = element.startTime.value.Date.ToOADate(); double endDate = element.endTime.value.Date.ToOADate(); double testDate = day.Date.Date.ToOADate(); bool superior = (startDate <= testDate); bool inferior = (testDate <= endDate); if (superior && inferior) { return(true); } } return(false); }
/// <summary> /// Add the calendar object to the table and create it associated projecttablename if needed /// </summary> /// <param name="cObj"></param> public void AddCalendarObject(calendarObject cObj, bool createAssociatedTable = false) { try { if (cObj.tableName == null) { throw new ArgumentNullException(); } // associate project table name : // ============ if (cObj.isRepository.value) { if ((cObj.isRepository.value && createAssociatedTable) || (cObj.projectTableName.value == null || cObj.projectTableName.value == "")) { cObj.projectTableName.value = "Element_" + Guid.NewGuid().ToString("n") + "_Tasks"; } // else just use the current table name CreateCalendarTable(cObj.projectTableName.value); } Request.RequestBuilder rb = new Request.RequestBuilder(cObj.tableName); foreach (sqliteBase sb in cObj.values) { rb.addElement(sb.valueName, sb.baseValue); } SQLiteCommand cmd = Request.CommandBuilder.getCommand(rb, Core.AppCore.dCore.M_dbConnection); cmd.ExecuteNonQuery(); } catch (Exception ex) { ex.Source = "SQL_lite_database_search_wpf.Core.DatabaseManager.ObjectsManager.CalendarObjectManager.addCalendarObject"; Usefull_Tools.ErrorHandeler.printOut(ex); } }
public calendarObject ReaderToCobj(SQLiteDataReader reader, string tableName, bool useReaderRead = true) { if (useReaderRead) { reader.Read(); } if (reader != null) { bool hasRows = reader.HasRows; calendarObject obj = new calendarObject(); for (int i = 0; i < obj.values.Length; i++) { obj.values[i].baseValue = reader[obj.values[i].valueName]; } obj.tableName = tableName; return(obj); } return(null); }
public Add_Project(calendarObject cObj) { InitializeComponent(); UICalendarInformation.CalendarObject = cObj; }
private void UIMenuChangeItem_Click(object sender, RoutedEventArgs e) { CalendarObject = UI.UIObjectManager.ChangeCalendarObject(CalendarObject); LoadCommponements(); }