public UserDST Fill()
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT ");
sql.Append("USER_ID User_Id, ");
sql.Append("USER_NAME User_Name, ");
sql.Append("USER_ROLE User_Role, ");
sql.Append("USER_AREA User_Area, ");
sql.Append("USER_BLOCKED User_Blocked, ");
sql.Append("USER_ACTIVE User_Active, ");
sql.Append("USER_IMAGE User_Image, ");
sql.Append("USER_EMAIL User_Email, ");
sql.Append("USER_LASTFLOW User_Lastflow, ");
sql.Append("USER_REPORTS_TO User_Reports_To, ");
sql.Append("USER_ADDITIONAL_DATA_1 User_Additional_Data1, ");
sql.Append("USER_ADDITIONAL_DATA_2 User_Additional_Data2, ");
sql.Append("USER_ADDITIONAL_DATA_3 User_Additional_Data3, ");
sql.Append("USER_ADDITIONAL_DATA_4 User_Additional_Data4, ");
sql.Append("USER_ADDITIONAL_DATA_5 User_Additional_Data5, ");
sql.Append("USER_ADDITIONAL_DATA_6 User_Additional_Data6, ");
sql.Append("USER_ADDITIONAL_DATA_7 User_Additional_Data7, ");
sql.Append("USER_ADDITIONAL_DATA_8 User_Additional_Data8, ");
sql.Append("USER_ADDITIONAL_DATA_9 User_Additional_Data9, ");
sql.Append("USER_ADDITIONAL_DATA_10 User_Additional_Data10 ");
sql.Append(" FROM ");
sql.Append("EF_USER ");
sql.Append(" ORDER BY STEP_ID ASC ");
DBCommandWrapper dbCommandWrapper = BaseDatos.GetSqlStringCommandWrapper(sql.ToString());
UserDST dsUser = new UserDST();
BaseDatos.LoadDataSet(dbCommandWrapper, dsUser, "EF_USER");
return(dsUser);
}
public int Update(UserDST dsUser, IDbTransaction trans)
{
#region comando insert
string sql = "INSERT INTO ";
sql += "EF_USER ";
sql += "(";
sql += BaseDatos.ConfigurationName == Constantes.BDDORACLE ? "USER_ID, " : ""; //SOLO ORACLE
sql += "USER_NAME, USER_ROLE, USER_AREA, USER_BLOCKED, USER_ACTIVE, USER_IMAGE," +
" USER_EMAIL, USER_LASTFLOW, USER_REPORTS_TO, USER_ADDITIONAL_DATA_1, USER_ADDITIONAL_DATA_2" +
"USER_ADDITIONAL_DATA_3,USER_ADDITIONAL_DATA_4,USER_ADDITIONAL_DATA_5,USER_ADDITIONAL_DATA_6" +
"USER_ADDITIONAL_DATA_7, USER_ADDITIONAL_DATA_8, USER_ADDITIONAL_DATA_9, USER_ADDITIONAL_DATA_10 ) "
+ " VALUES( ";
sql += BaseDatos.ConfigurationName == Constantes.BDDORACLE ? "STEP_ID.NEXTVAL, " : ""; //SOLO ORACLE
sql += "@User_Id, @User_Name, @User_Role, @User_Area, @User_Blocked, @User_Active, @User_Image" +
"@User_Email, @User_Lastflow, @User_Reports_To, @User_Additional_Data1, " +
"@User_Additional_Data2, @User_Additional_Data3, @User_Additional_Data4," +
"@User_Additional_Data5, @User_Additional_Data6, @User_Additional_Data7, " +
"@User_Additional_Data8, @User_Additional_Data9, @User_Additional_Data10)";
DBCommandWrapper insertCommand = BaseDatos.GetSqlStringCommandWrapper(sql);
insertCommand.AddInParameter(
"@User_Name", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_NAMEColumn, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Role", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ROLEColumn, DataRowVersion.Current);
insertCommand.AddInParameter(
"@USER_AREA", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_AREAColumn, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Blocked", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_BLOCKEDColumn, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Active", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ACTIVEColumn, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Image", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_IMAGEColumn, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Email", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_EMAILColumn, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Lastflow", DbType.Int32, dsUser.EF_USER.USER_LASTFLOWColumn, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Reports_To", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_REPORTS_TOColumn, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data1", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_1Column, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data2", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_2Column, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data3", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_3Column, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data4", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_4Column, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data5", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_5Column, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data6", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_6Column, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data7", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_7Column, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data8", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_8Column, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data9", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_9Column, DataRowVersion.Current);
insertCommand.AddInParameter(
"@User_Additional_Data10", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_10Column, DataRowVersion.Current);
#endregion
#region sentencia update
sql = "UPDATE ";
sql += "EF_USER ";
sql += "SET ";
sql += " USER_NAME = @User_Name, "
+ " USER_ROLE = @User_Role, "
+ " USER_AREA = @User_Area, "
+ " USER_BLOCKED = @User_Blocked, "
+ " USER_ACTIVE = @User_Active, "
+ " USER_IMAGE = @User_Image, "
+ " USER_EMAIL = @User_Email, "
+ " USER_LASTFLOW = @User_Lastflow, "
+ " USER_REPORTS_TO = @User_Reports_To, "
+ " USER_ADDITIONAL_DATA_1 = @User_Additional_Data1, "
+ " USER_ADDITIONAL_DATA_2 = @User_Additional_Data2, "
+ " USER_ADDITIONAL_DATA_3 = @User_Additional_Data3, "
+ " USER_ADDITIONAL_DATA_4 = @User_Additional_Data4, "
+ " USER_ADDITIONAL_DATA_5 = @User_Additional_Data5, "
+ " USER_ADDITIONAL_DATA_6 = @User_Additional_Data6, "
+ " USER_ADDITIONAL_DATA_7 = @User_Additional_Data7, "
+ " USER_ADDITIONAL_DATA_8 = @User_Additional_Data8, "
+ " USER_ADDITIONAL_DATA_9 = @User_Additional_Data9, "
+ " USER_ADDITIONAL_DATA_10 = @User_Additional_Data10"
+ " WHERE "
+ " USER_ID = @User_idOriginal ";
DBCommandWrapper updateCommand = BaseDatos.GetSqlStringCommandWrapper(sql);
#endregion
#region parametros del update
sql += "USER_NAME, USER_ROLE, USER_AREA, USER_BLOCKED, USER_ACTIVE, USER_IMAGE," +
" USER_EMAIL, USER_LASTFLOW, USER_REPORTS_TO, USER_ADDITIONAL_DATA_1, USER_ADDITIONAL_DATA_2" +
"USER_ADDITIONAL_DATA_3,USER_ADDITIONAL_DATA_4,USER_ADDITIONAL_DATA_5,USER_ADDITIONAL_DATA_6" +
"USER_ADDITIONAL_DATA_7, USER_ADDITIONAL_DATA_8, USER_ADDITIONAL_DATA_9, USER_ADDITIONAL_DATA_10 ) ";
updateCommand.AddInParameter(
"@User_idOriginal ", DbType.Int32, dsUser.EF_USER.USER_IDColumn, DataRowVersion.Original);
updateCommand.AddInParameter(
"@User_Name", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_NAMEColumn, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Role", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ROLEColumn, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Area", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_AREAColumn, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Blocked", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_BLOCKEDColumn, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Active", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ACTIVEColumn, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Image", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_IMAGEColumn, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Email", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_EMAILColumn, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Lastflow", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_LASTFLOWColumn, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Reports_To", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_REPORTS_TOColumn, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data1", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_1Column, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data2", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_2Column, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data3", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_3Column, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data4", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_4Column, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data5", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_5Column, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data6", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_6Column, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data7", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_7Column, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data8", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_8Column, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data9", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_9Column, DataRowVersion.Current);
updateCommand.AddInParameter(
"@User_Additional_Data10", DbType.AnsiStringFixedLength, dsUser.EF_USER.USER_ADDITIONAL_DATA_10Column, DataRowVersion.Current);
DBCommandWrapper deleteCommand = null;
#endregion
#region sql del Delete
sql = "DELETE FROM ";
sql += "EF_USER ";
sql += "WHERE ";
sql += " USER_ID = @User_idOriginal ";
deleteCommand = BaseDatos.GetSqlStringCommandWrapper(sql);
#endregion
#region parametros del delete
deleteCommand.AddInParameter("@User_idOriginal", DbType.Int32, dsUser.EF_USER.USER_IDColumn, DataRowVersion.Original);
#endregion
if (trans == null)
{
return(BaseDatos.UpdateDataSet(dsUser, "EF_USER", insertCommand, updateCommand, deleteCommand, UpdateBehavior.Standard));
}
else
{
return(BaseDatos.UpdateDataSet(dsUser, dsUser.EF_USER.TableName, insertCommand, updateCommand, deleteCommand, trans));
}
}
