public static int InsertObject(object obj, DALBaseProvider provider, string spName) { try { DbCommand storedProcCommand = ((Database)SqlDatabaseHelper.database).GetStoredProcCommand(spName); SqlDatabaseHelper.AddParameterForObject(obj, provider, storedProcCommand); ((Database)SqlDatabaseHelper.database).ExecuteNonQuery(storedProcCommand); return((int)((Database)SqlDatabaseHelper.database).GetParameterValue(storedProcCommand, SqlDatabaseHelper.GetPrimaryKeyColumn(provider.TableName))); } catch (Exception ex) { throw ex; } }
public STScreensController() { dal = new DALBaseProvider("STScreens", typeof(STScreensInfo)); }
public STModuleToUserGroupSectionsController() { dal = new DALBaseProvider("STModuleToUserGroupSections", typeof(STModuleToUserGroupSectionsInfo)); }
public ADUserGroupSectionsController() { dal = new DALBaseProvider("ADUserGroupSections", typeof(ADUserGroupSectionsInfo)); }
public STToolbarFunctionsController() { dal = new DALBaseProvider("STToolbarFunctions", typeof(STToolbarFunctionsInfo)); }
public GENumberingsController() { dal = new DALBaseProvider("GENumberings", typeof(GENumberingsInfo)); }
public GELookupColumnsController() { dal = new DALBaseProvider("GELookupColumns", typeof(GELookupColumnsInfo)); }
public static void SetValueToIDStringColumn(object obj, DALBaseProvider provider, int iObjectID) { string primaryKeyColumn = SqlDatabaseHelper.GetPrimaryKeyColumn(provider.TableName); provider.ObjectType.GetProperty(primaryKeyColumn + "String")?.SetValue(obj, (object)iObjectID.ToString(), (object[])null); }
public ADUsersController() { dal = new DALBaseProvider("ADUsers", typeof(ADUsersInfo)); }
public BaseBusinessController(Type objType) { this.dal = new DALBaseProvider(objType.Name.Substring(0, objType.Name.Length - 4), objType); }
public BaseBusinessController(string strTableName, Type objType) { this.dal = new DALBaseProvider(strTableName, objType); }
public BaseBusinessController() { this.dal = new DALBaseProvider(); }
public static void AddParameterForObject(object obj, DALBaseProvider provider, DbCommand cmd) { try { SqlDatabaseHelper.lstTableColumnNames.Clear(); DataSet allTableColumns = SqlDatabaseHelper.GetAllTableColumns(provider.TableName); if (allTableColumns.Tables.Count > 0) { foreach (DataRow row in (InternalDataCollectionBase)allTableColumns.Tables[0].Rows) { SqlDatabaseHelper.lstTableColumnNames.Add(row["COLUMN_NAME"].ToString()); } } PropertyInfo[] properties = provider.ObjectType.GetProperties(); for (int index = 0; index < properties.Length; ++index) { if (SqlDatabaseHelper.lstTableColumnNames.IndexOf(properties[index].Name) >= 0) { object obj1 = properties[index].GetValue(obj, (object[])null); if (properties[index].PropertyType.Equals(typeof(int))) { if ((properties[index].Name == provider.TableName.Substring(0, provider.TableName.Length - 1) + "ID" || properties[index].Name == provider.TableName + "ID") && cmd.CommandText.Contains("_Insert")) { SqlDatabaseHelper.database.AddOutParameter(cmd, properties[index].Name, SqlDbType.Int, 4); } else { SqlDatabaseHelper.database.AddInParameter(cmd, properties[index].Name, SqlDbType.Int, obj1); } } else if (properties[index].PropertyType.Equals(typeof(bool))) { SqlDatabaseHelper.database.AddInParameter(cmd, properties[index].Name, SqlDbType.Bit, obj1); } else if (properties[index].PropertyType.Equals(typeof(short))) { SqlDatabaseHelper.database.AddInParameter(cmd, properties[index].Name, SqlDbType.SmallInt, obj1); } else if (properties[index].PropertyType.Equals(typeof(byte))) { SqlDatabaseHelper.database.AddInParameter(cmd, properties[index].Name, SqlDbType.TinyInt, obj1); } else if (properties[index].PropertyType.Equals(typeof(double))) { if (double.IsInfinity((double)obj1)) { obj1 = (object)0.0; } SqlDatabaseHelper.database.AddInParameter(cmd, properties[index].Name, SqlDbType.Float, obj1); } else if (properties[index].PropertyType.Equals(typeof(Decimal))) { ((Database)SqlDatabaseHelper.database).AddParameter(cmd, properties[index].Name, DbType.Decimal, 24, ParameterDirection.Input, true, (byte)18, (byte)5, properties[index].Name, DataRowVersion.Default, obj1); } else if (properties[index].PropertyType.Equals(typeof(string)) || properties[index].PropertyType.Equals(typeof(string))) { SqlDatabaseHelper.database.AddInParameter(cmd, properties[index].Name, SqlDbType.NVarChar, obj1); } else if (properties[index].PropertyType.Equals(typeof(DateTime))) { if ((DateTime)obj1 == DateTime.MinValue) { obj1 = (object)DateTime.MaxValue; } SqlDatabaseHelper.database.AddInParameter(cmd, properties[index].Name, SqlDbType.DateTime, obj1); } else if (properties[index].PropertyType.Equals(typeof(byte[]))) { SqlDatabaseHelper.database.AddInParameter(cmd, properties[index].Name, SqlDbType.VarBinary, obj1); } } } } catch (Exception ex) { throw ex; } }
public static object GetPrimaryColumnValue(object obj, DALBaseProvider provider) { string primaryKeyColumn = SqlDatabaseHelper.GetPrimaryKeyColumn(provider.TableName); return(provider.ObjectType.GetProperty(primaryKeyColumn).GetValue(obj, (object[])null)); }
public STModulesController() { dal = new DALBaseProvider("STModules", typeof(STModulesInfo)); }
public AAColumnAliasController() { dal = new DALBaseProvider("AAColumnAlias", typeof(AAColumnAliasInfo)); }
public STToolbarsController() { dal = new DALBaseProvider("STToolbarsInfo", typeof(STToolbarsInfo)); }
public ADConfigValuesController() { dal = new DALBaseProvider("ADConfigValues", typeof(ADConfigValuesInfo)); }