public void GetAll(MyMeta.ITable table) { string tableName = table.Name; _output.tabLevel++; _output.tabLevel++; _output.autoTabLn("/// <summary>"); _output.autoTabLn("/// GetAll and map the fields to the entity"); _output.autoTabLn("/// and add to generic queryable collection."); _output.autoTabLn("/// </summary>"); _output.autoTabLn("/// <returns></returns>"); _output.autoTabLn("public List<" + _util.BuildModelClassWithNameSpace(StringFormatter.CleanUpClassName(tableName)) + "> GetAll()"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("using (var context = DataContextFactory.CreateContext())"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("return context." + StringFormatter.CleanUpClassName(StringFormatter.MakePlural(tableName)) + ".Select(o => " + StringFormatter.CleanUpClassName(tableName) + "Mapper.ToBusinessObject(o)).ToList();"); _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.tabLevel--; }
public void Interface(MyMeta.ITable table) { string tableName = table.Name; string args = ""; GenTable genTable = new GenTable(table, _context); string str = ""; str += _util.BuildModelClassWithNameSpace(tableName) + " GetById("; for (int i = 0; i < genTable.GetPrimaryKeyNames.Length; i++) { // type + " " + key name args += genTable.GetPrimaryKeyTypes[i] + " "; args += StringFormatter.CamelCasing(genTable.GetPrimaryKeyNames[i]) + ", "; } // trim the trailing ", " args = args.Substring(0, (args.Length - 2)); str += args; str += ");"; _output.tabLevel++; _output.tabLevel++; _output.autoTabLn(str); _output.tabLevel--; _output.tabLevel--; str = ""; str += "List<" + _util.BuildModelClassWithNameSpace(tableName) + "> GetAll(string sortExpression, int startRowIndex, int maximumRows);"; _output.tabLevel++; _output.tabLevel++; _output.autoTabLn(str); _output.tabLevel--; _output.tabLevel--; }
public void GetAllWithSortingAndPaging(MyMeta.ITable table) { string tableName = table.Name; string model = _script.Settings.BusinessObjects.BusinessObjectsNamespace + "." + StringFormatter.CleanUpClassName(tableName); string entity = _script.Settings.DataOptions.DataObjectsNamespace + "." + _script.Settings.DataOptions.ORMFramework.Selected + "." + StringFormatter.CleanUpClassName(tableName); _output.tabLevel++; _output.tabLevel++; _output.autoTabLn("public List<" + model + "> GetAll(string sortExpression, int startRowIndex, int maximumRows)"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("using (var context = DataContextFactory.CreateContext())"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("IQueryable<" + entity + "> query = context." + StringFormatter.CleanUpClassName(StringFormatter.MakePlural(tableName)) + ";"); _output.autoTabLn("query = GetListSort(query, sortExpression);"); _output.autoTabLn("query = query.Skip(startRowIndex).Take(maximumRows);"); _output.autoTabLn("return query.Select(o => " + StringFormatter.CleanUpClassName(tableName) + "Mapper.ToBusinessObject(o)).ToList();"); _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.tabLevel--; }
public void GetById(MyMeta.ITable table) { string args = string.Empty; string keys = string.Empty; string tableName = table.Name; GenTable genTable = new GenTable(table, _context); _output.tabLevel++; _output.tabLevel++; _output.autoTabLn("/// <summary>"); _output.autoTabLn("/// GetById and map the fields to the Model."); _output.autoTabLn("/// </summary>"); for (int i = 0; i < genTable.GetPrimaryKeyNames.Length; i++) { _output.autoTabLn("/// <param name=\"" + StringFormatter.CamelCasing(genTable.GetPrimaryKeyNames[i]) + "\"></param>"); } _output.autoTabLn("/// <returns></returns>"); _output.autoTab("public " + _util.BuildModelClassWithNameSpace(StringFormatter.CleanUpClassName(tableName)) + " GetById("); for (int i = 0; i < genTable.GetPrimaryKeyNames.Length; i++) { // type + " " + key name args += genTable.GetPrimaryKeyTypes[i] + " "; args += StringFormatter.CamelCasing(genTable.GetPrimaryKeyNames[i]) + ", "; keys += StringFormatter.CamelCasing(genTable.GetPrimaryKeyNames[i]) + ", "; } // trim the trailing ", " args = args.Substring(0, (args.Length - 2)); keys = keys.Substring(0, (keys.Length - 2)); _output.write(args); _output.writeln(")"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("using (var context = DataContextFactory.CreateContext())"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("return " + StringFormatter.CleanUpClassName(tableName) + "Mapper.ToBusinessObject(context." + StringFormatter.MakePlural(StringFormatter.CleanUpClassName(tableName))); string[] keysSplit = keys.Split(','); foreach (string key in keysSplit) { _output.tabLevel++; _output.autoTabLn(".Where(o => o." + _util.CleanUpProperty(key) + " == " + key + ")"); } _output.autoTabLn(".SingleOrDefault());"); _output.tabLevel--; _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.tabLevel--; }
public void Update(MyMeta.ITable table) { }
public void GetAll(MyMeta.ITable table) { }
public void Insert(MyMeta.ITable table) { }
public bool IsContainColumn(ITable table, string columnName) { if (string.IsNullOrEmpty(columnName) || table == null) { return false; } columnName = columnName.ToLower(); foreach (IColumn column in table.Columns) { if (column.Name.ToLower().Equals(columnName)) { return true; } } return false; }
public string GetPrimaryColumnName(ITable table) { if (table == null) { return string.Empty; } string primryColName = ""; foreach (IColumn column in table.Columns) { if (column.IsInPrimaryKey) { if(column.Name.ToLower().Equals("id")) { return column.Name; } if(String.IsNullOrEmpty(primryColName)) { primryColName = column.Name; } } } return primryColName; }
public void GetAllWithSortingAndPaging(MyMeta.ITable table) { }
public void BuildModelClass(MyMeta.ITable table, bool useWebService) { }
public IList<string> GetFieldsDisplayAtListView(ITable table) { IList<string> returnList = new List<string>(); foreach (IColumn col in table.Columns) { string colName = col.Name.ToLower(); if (FieldsDisplayAtListView.Contains(colName) || colName.Contains("title") || colName.Contains("name") ) { returnList.Add(colName); } } if (returnList.Contains("id")) { returnList.Remove("id"); returnList.Insert(0, "id"); } if (returnList.Contains("hits")) { returnList.Remove("hits"); returnList.Insert(0, "hits"); } if (returnList.Contains("created")) { returnList.Remove("created"); returnList.Insert(0, "created"); } if (returnList.Contains("created_by")) { returnList.Remove("created_by"); returnList.Insert(0, "created_by"); } if (returnList.Contains("language")) { returnList.Remove("language"); returnList.Insert(0, "language"); } if (returnList.Contains("access")) { returnList.Remove("access"); returnList.Insert(0, "access"); } if (returnList.Contains("alias")) { returnList.Remove("alias"); returnList.Insert(0, "alias"); } if (returnList.Contains("name")) { returnList.Remove("name"); returnList.Insert(0, "name"); } if (returnList.Contains("title")) { returnList.Remove("title"); returnList.Insert(0, "title"); } if (returnList.Contains("state")) { returnList.Remove("state"); returnList.Insert(0, "state"); } if (returnList.Contains("ordering")) { returnList.Remove("ordering"); returnList.Insert(0, "ordering"); } return returnList; }
public IList<string> GetFieldsDisplayAtModalListView(ITable table) { IList<string> returnList = new List<string>(); foreach (IColumn col in table.Columns) { string colName = col.Name.ToLower(); if (FieldsDisplayAtModalListView.Contains(colName)) { returnList.Add(colName); } } if (returnList.Contains("alias")) { returnList.Remove("alias"); returnList.Insert(0, "alias"); } if (returnList.Contains("name")) { returnList.Remove("name"); returnList.Insert(0, "name"); } if (returnList.Contains("title")) { returnList.Remove("title"); returnList.Insert(0, "title"); } return returnList; }
/// <summary> /// /// </summary> /// <param name="table"></param> /// <returns>return value like: '(a.title LIKE '.$search.' OR a.alias LIKE '.$search.')'</returns> public string BuilQuerySearch(ITable table) { List<string> searchFields = new List<string>(); foreach (IColumn col in table.Columns) { if (ColumnDataTypeIsText(col) || ColumnDataTypeIsMediumText(col) || ColumnDataTypeIsVarchar(col)) { string colName = col.Name.ToLower(); foreach (string str in SearchField) { if (colName.Contains(str)) { searchFields.Add(colName); break; } } } } if (searchFields.Count == 0) { return string.Empty; } string returnValue = string.Empty; foreach (string sarchField in searchFields) { returnValue += string.Format(" OR a.{0} LIKE '.$search.' ", sarchField); } returnValue = returnValue.Substring(3); returnValue = "'(" + returnValue + ")'"; return returnValue; }
public IColumn GetColumnByColumnName(ITable table, string name) { if (string.IsNullOrEmpty(name)) { return null; } if (table == null) { return null; } foreach (IColumn cl in table.Columns) { if (cl.Name.ToLower().Equals(name.ToLower())) { return cl; } } return null; }
public bool IsContainVarcharColumn(ITable table) { foreach (IColumn col in table.Columns) { if(ColumnDataTypeIsVarchar(col)) { return true; } } return false; }
public bool IsContainPublishOptionField(ITable table) { foreach (IColumn col in table.Columns) { if(PublishOptionFields.Contains(col.Name.ToLower())) { return true; } } return false; }
public bool IsContainImageColumn(ITable table) { if (table == null) { return false; } string columnName = "image"; foreach (IColumn column in table.Columns) { if (column.Name.ToLower().Contains(columnName) || column.Name.ToLower().Contains("url") || column.Name.ToLower().Contains("path") || column.Name.ToLower().Contains("file") || column.Name.ToLower().Contains("picture") ) { return true; } } return false; }
public void Delete(MyMeta.ITable table) { }
public string GetTitleFieldName(ITable table) { foreach(string title in DefaultTitleFields) { if(IsContainColumn(table,title)) { return title; } } return GetFirstColumn(table).Name; }
public void GetById(MyMeta.ITable table) { }
public void Mapper(MyMeta.ITable table) { }
public string GetTableNameWithMeaning(ITable table) { string tableName = GetTableName(table); return Regex.Replace(tableName, "[_-]+", " "); }
public string GetTableNameForMultipleLanguage(ITable table) { string tableName = GetTableName(table); return Regex.Replace(tableName, "[_-]+", "_"); }
public IColumn GetFirstColumn(ITable table) { if (table == null) { return null; } string defualtFirst = "title"; foreach (IColumn column in table.Columns) { if (column.Name.ToLower().Equals(defualtFirst)) { return column; } } defualtFirst = "id"; foreach (IColumn column in table.Columns) { if (column.Name.ToLower().Equals(defualtFirst)) { return column; } } return table.Columns[0]; }
public string GetViewNameFromTable(ITable obj) { return obj.Name.Replace(PrefixTable, ""); }
public string GetGroupColumnNameFromTable(ITable table) { if (table == null) { return string.Empty; } foreach (string groupName in GroupColumnList) { foreach (IColumn col in table.Columns) { if (col.Name.ToLower().Equals(groupName.ToLower())) { return groupName; } } } foreach (IColumn col in table.Columns) { string returnColumnName = col.Name.ToLower(); if (returnColumnName.EndsWith("id")) { return returnColumnName; } } return string.Empty; }
public IList<IColumn> GetListColumnOrder(ITable table) { //Status Title Access Association Author Language Date Hits ID IList<IColumn> list = new List<IColumn>(); if(table == null) { return list; } foreach(IColumn cl in table.Columns) { if(cl.Name.ToLower().Equals("title") || cl.Name.ToLower().Equals("name") || cl.Name.ToLower().Equals("alias") || cl.Name.ToLower().Equals("id") ) { continue; } else { list.Add(cl); } } if (IsContainColumn(table, "id")) { IColumn aliasCl = GetColumnByColumnName(table, "id"); if (aliasCl != null) { list.Insert(0, aliasCl); } } if (IsContainColumn(table, "alias")) { IColumn aliasCl = GetColumnByColumnName(table, "alias"); if (aliasCl != null) { list.Insert(0, aliasCl); } } if (IsContainColumn(table, "name")) { IColumn aliasCl = GetColumnByColumnName(table, "name"); if (aliasCl != null) { list.Insert(0, aliasCl); } } if (IsContainColumn(table, "title")) { IColumn aliasCl = GetColumnByColumnName(table, "title"); if (aliasCl != null) { list.Insert(0, aliasCl); } } return list; }
public void Insert(MyMeta.ITable table) { string tableName = table.Name; _output.tabLevel++; _output.tabLevel++; _output.autoTabLn("/// <summary>"); _output.autoTabLn("/// Insert new " + StringFormatter.CleanUpClassName(tableName) + "."); _output.autoTabLn("/// </summary>"); _output.autoTabLn("/// <param name=\"" + StringFormatter.CamelCasing(StringFormatter.CleanUpClassName(tableName)) + "\"></param>"); _output.autoTabLn("/// <returns></returns>"); _output.autoTabLn("public void Insert(" + _util.BuildModelClassWithNameSpace(StringFormatter.CleanUpClassName(tableName)) + " model)"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("var entity = " + StringFormatter.CleanUpClassName(tableName) + "Mapper.ToEntity(model);"); _output.autoTabLn(""); _output.autoTabLn("using (var context = DataContextFactory.CreateContext())"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("try"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("context." + StringFormatter.CleanUpClassName(StringFormatter.MakePlural(tableName)) + ".InsertOnSubmit(entity);"); _output.autoTabLn("context.SubmitChanges();"); _output.tabLevel--; _output.autoTabLn("}"); _output.autoTabLn("catch (ChangeConflictException)"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("foreach (ObjectChangeConflict conflict in context.ChangeConflicts)"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("conflict.Resolve(RefreshMode.KeepCurrentValues);"); _output.tabLevel--; _output.autoTabLn("}"); _output.autoTabLn("try"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("context.SubmitChanges();"); _output.tabLevel--; _output.autoTabLn("}"); _output.autoTabLn("catch (ChangeConflictException)"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("throw new Exception(\"A concurrency error occurred!\");"); _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.autoTabLn("}"); _output.autoTabLn("catch (Exception)"); _output.autoTabLn("{"); _output.tabLevel++; _output.autoTabLn("throw new Exception(\"There was an error inserting the record!\");"); _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.autoTabLn("}"); _output.tabLevel--; _output.tabLevel--; }
public string GetTableName(ITable table) { string tableName = table.Name.Replace(PrefixTable, ""); return tableName; }