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));
}
