public static string CreateDeleteCommand(IDBConnectionStateGettable actualPage, string primaryKey, string nameOfPrimaryKey) { string commandToReturn = "DELETE FROM "; commandToReturn += actualPage.GetTableDescriptionToSql(); commandToReturn += " WHERE " + nameOfPrimaryKey + " = '" + primaryKey + "'"; return(commandToReturn); }
public static string CreateUpdateCommand(IDBConnectionStateGettable actualPage, string primaryKey, string nameOfPrimaryKey, List <string> fieldsToUpdate, List <string> valueToSet) { string commandToReturn = "UPDATE " + actualPage.GetTableDescriptionToSql() + " SET " + fieldsToUpdate[0] + "='" + valueToSet[0] + "' WHERE " + nameOfPrimaryKey + " = '" + primaryKey + "'"; if (commandToReturn.Contains(@"'NULL'")) { commandToReturn = commandToReturn.Replace(@"'NULL'", "NULL"); } return(commandToReturn); }
//Dziala! /// <summary> /// Creates a command string which show actual table and sort it. /// </summary> /// <param name="actualPage">Actual view</param> /// <param name="orderBy">order by (optional)</param> /// <param name="sortCriterium"></param> /// <returns></returns> public static string CreateCommand(IDBConnectionStateGettable actualPage, string orderBy = null, SortCriteria sortCriterium = SortCriteria.Ascending) { string actualTableSqlDescription = actualPage.GetTableDescriptionToSql(); string commandToReturn = "SELECT * FROM "; commandToReturn += actualTableSqlDescription; if (!string.IsNullOrEmpty(orderBy)) { commandToReturn = CreateCommand(commandToReturn, orderBy, sortCriterium); } return(commandToReturn); }
public static string CreateNewRecordCommand(IDBConnectionStateGettable actualPage, List <string> valuesList, List <string> columnNames) { string commandToReturn = "INSERT INTO " + actualPage.GetTableDescriptionToSql() + " ("; string lastColumn = columnNames.Last(); string lastValue = valuesList.Last(); foreach (string column in columnNames) { commandToReturn += column; if (column == lastColumn) { commandToReturn += ") VALUES ("; } else { commandToReturn += ", "; } } foreach (object value in valuesList) { if (value.ToString() == "NULL") { commandToReturn += value; } else { commandToReturn += "'" + value + "'"; } if (value.ToString() == lastValue) { commandToReturn += ")"; } else { commandToReturn += ", "; } } return(commandToReturn); }