public static int Delete <T>(string DatabaseTable, string wherePropertie, string whereValue) { string databaseString = "delete from dbo." + DatabaseTable; databaseString += " where " + wherePropertie + "=" + whereValue; return(SqlDataAccess.ExecuteDataString(databaseString)); }
public static int Create <T>(T Data, string DatabaseTable, bool autoIncrease = true, string IdString = "Id") { string databaseString = "insert into dbo." + DatabaseTable + " "; Type t = Data.GetType(); PropertyInfo[] props = t.GetProperties(); if (autoIncrease) { var pid = props.First(p => p.Name == IdString); pid.SetValue(Data, Count(Data, DatabaseTable)); } databaseString += "("; for (int i = 0; i < props.Length; i++) { databaseString += props[i].Name; if (i < props.Length - 1) { databaseString += ", "; } } databaseString += ") values ("; for (int i = 0; i < props.Length; i++) { databaseString += "'"; databaseString += props[i].GetValue(Data); databaseString += "'"; if (i < props.Length - 1) { databaseString += ", "; } } databaseString += ")"; return(SqlDataAccess.ExecuteDataString(databaseString)); }
public static int Update <T>(T Data, string DatabaseTable, string wherePropertie) { string databaseString = "update dbo." + DatabaseTable + " set "; Type t = Data.GetType(); PropertyInfo[] props = t.GetProperties(); for (int i = 0; i < props.Length; i++) { databaseString += props[i].Name + "=" + props[i].GetValue(Data); if (i < props.Length - 1) { databaseString += ", "; } } PropertyInfo whereCase = props.First(p => p.Name == wherePropertie); if (whereCase != null) { databaseString += " where " + wherePropertie + "=" + whereCase.GetValue(Data); } return(SqlDataAccess.ExecuteDataString(databaseString)); }