public static void Update(GroupData data)
{
// Create and execute the command
GroupData oldData = Load(data.GroupId);
string sql = "Update " + TABLE + " set ";
if (!oldData.GroupName.Equals(data.GroupName))
{
sql = sql + "GroupName=@GroupName,";
}
WhereClause w = new WhereClause();
w.And("GroupId", data.GroupId.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.GroupId.Equals(data.GroupId))
{
cmd.Parameters.Add(new SqlParameter("@GroupId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "GroupId", DataRowVersion.Proposed, data.GroupId.DBValue));
}
if (!oldData.GroupName.Equals(data.GroupName))
{
cmd.Parameters.Add(new SqlParameter("@GroupName", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "GroupName", DataRowVersion.Proposed, data.GroupName.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(KnowledgebasesArticlesCountViewData data)
{
// Create and execute the command
KnowledgebasesArticlesCountViewData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
sql = sql + "KnowledgebasesID=@KnowledgebasesID,";
}
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.ArticlesCount.Equals(data.ArticlesCount))
{
sql = sql + "ArticlesCount=@ArticlesCount,";
}
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
sql = sql + "OrgGroupsID=@OrgGroupsID,";
}
if (!oldData.IsPublic.Equals(data.IsPublic))
{
sql = sql + "IsPublic=@IsPublic,";
}
WhereClause w = new WhereClause();
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesID", DataRowVersion.Proposed, data.KnowledgebasesID.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 150, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.ArticlesCount.Equals(data.ArticlesCount))
{
cmd.Parameters.Add(new SqlParameter("@ArticlesCount", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ArticlesCount", DataRowVersion.Proposed, data.ArticlesCount.DBValue));
}
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
}
if (!oldData.IsPublic.Equals(data.IsPublic))
{
cmd.Parameters.Add(new SqlParameter("@IsPublic", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsPublic", DataRowVersion.Proposed, !data.IsPublic.IsValid ? data.IsPublic.DBValue : data.IsPublic.DBValue.Equals("Y") ? 1 : 0));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(OrgDepartmentsData data)
{
// Create and execute the command
OrgDepartmentsData oldData = Load(data.OrgDepartmentsID);
string sql = "Update " + TABLE + " set ";
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.Active.Equals(data.Active))
{
sql = sql + "Active=@Active,";
}
if (!oldData.OrgDivisionsID.Equals(data.OrgDivisionsID))
{
sql = sql + "OrgDivisionsID=@OrgDivisionsID,";
}
if (!oldData.GLAccount.Equals(data.GLAccount))
{
sql = sql + "GLAccount=@GLAccount,";
}
WhereClause w = new WhereClause();
w.And("OrgDepartmentsID", data.OrgDepartmentsID.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.OrgDepartmentsID.Equals(data.OrgDepartmentsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgDepartmentsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgDepartmentsID", DataRowVersion.Proposed, data.OrgDepartmentsID.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.Active.Equals(data.Active))
{
cmd.Parameters.Add(new SqlParameter("@Active", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "Active", DataRowVersion.Proposed, !data.Active.IsValid ? data.Active.DBValue : data.Active.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.OrgDivisionsID.Equals(data.OrgDivisionsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgDivisionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgDivisionsID", DataRowVersion.Proposed, data.OrgDivisionsID.DBValue));
}
if (!oldData.GLAccount.Equals(data.GLAccount))
{
cmd.Parameters.Add(new SqlParameter("@GLAccount", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "GLAccount", DataRowVersion.Proposed, data.GLAccount.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(DirectoriesData data)
{
// Create and execute the command
DirectoriesData oldData = Load(data.Id);
string sql = "Update " + TABLE + " set ";
if (!oldData.Name.Equals(data.Name))
{
sql = sql + "Name=@Name,";
}
if (!oldData.Path.Equals(data.Path))
{
sql = sql + "Path=@Path,";
}
if (!oldData.IsPublic.Equals(data.IsPublic))
{
sql = sql + "IsPublic=@IsPublic,";
}
if (!oldData.OrgGroupID.Equals(data.OrgGroupID))
{
sql = sql + "OrgGroupID=@OrgGroupID,";
}
WhereClause w = new WhereClause();
w.And("Id", data.Id.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.Id.Equals(data.Id))
{
cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Id", DataRowVersion.Proposed, data.Id.DBValue));
}
if (!oldData.Name.Equals(data.Name))
{
cmd.Parameters.Add(new SqlParameter("@Name", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Name", DataRowVersion.Proposed, data.Name.DBValue));
}
if (!oldData.Path.Equals(data.Path))
{
cmd.Parameters.Add(new SqlParameter("@Path", SqlDbType.VarChar, 150, ParameterDirection.Input, false, 0, 0, "Path", DataRowVersion.Proposed, data.Path.DBValue));
}
if (!oldData.IsPublic.Equals(data.IsPublic))
{
cmd.Parameters.Add(new SqlParameter("@IsPublic", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsPublic", DataRowVersion.Proposed, !data.IsPublic.IsValid ? data.IsPublic.DBValue : data.IsPublic.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.OrgGroupID.Equals(data.OrgGroupID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupID", DataRowVersion.Proposed, data.OrgGroupID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(ControlsGroupsData data)
{
// Create and execute the command
ControlsGroupsData oldData = Load(data.ControlsGroupsID);
string sql = "Update " + TABLE + " set ";
if (!oldData.ControlsID.Equals(data.ControlsID))
{
sql = sql + "ControlsID=@ControlsID,";
}
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
sql = sql + "OrgGroupsID=@OrgGroupsID,";
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
sql = sql + "SortOrder=@SortOrder,";
}
if (!oldData.DisplayOnHomePage.Equals(data.DisplayOnHomePage))
{
sql = sql + "DisplayOnHomePage=@DisplayOnHomePage,";
}
WhereClause w = new WhereClause();
w.And("ControlsGroupsID", data.ControlsGroupsID.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.ControlsGroupsID.Equals(data.ControlsGroupsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlsGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsGroupsID", DataRowVersion.Proposed, data.ControlsGroupsID.DBValue));
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsID", DataRowVersion.Proposed, data.ControlsID.DBValue));
}
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
cmd.Parameters.Add(new SqlParameter("@SortOrder", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SortOrder", DataRowVersion.Proposed, data.SortOrder.DBValue));
}
if (!oldData.DisplayOnHomePage.Equals(data.DisplayOnHomePage))
{
cmd.Parameters.Add(new SqlParameter("@DisplayOnHomePage", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "DisplayOnHomePage", DataRowVersion.Proposed, !data.DisplayOnHomePage.IsValid ? data.DisplayOnHomePage.DBValue : data.DisplayOnHomePage.DBValue.Equals("Y") ? 1 : 0));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Delete()
{
// Create and execute the command
string sql = "Delete From " + TABLE;
WhereClause w = new WhereClause();
sql += w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
// Execute the query and return the result
cmd.ExecuteNonQuery();
}
public static void Update(SessionInformationData data)
{
// Create and execute the command
SessionInformationData oldData = Load(data.SessionId);
string sql = "Update " + TABLE + " set ";
if (!oldData.SessionId.Equals(data.SessionId))
{
sql = sql + "SessionId=@SessionId,";
}
if (!oldData.DemoId.Equals(data.DemoId))
{
sql = sql + "DemoId=@DemoId,";
}
if (!oldData.UserId.Equals(data.UserId))
{
sql = sql + "UserId=@UserId,";
}
if (!oldData.DateCreated.Equals(data.DateCreated))
{
sql = sql + "DateCreated=@DateCreated,";
}
WhereClause w = new WhereClause();
w.And("SessionId", data.SessionId.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.SessionId.Equals(data.SessionId))
{
cmd.Parameters.Add(new SqlParameter("@SessionId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SessionId", DataRowVersion.Proposed, data.SessionId.DBValue));
}
if (!oldData.DemoId.Equals(data.DemoId))
{
cmd.Parameters.Add(new SqlParameter("@DemoId", SqlDbType.Char, 7, ParameterDirection.Input, false, 0, 0, "DemoId", DataRowVersion.Proposed, data.DemoId.DBValue));
}
if (!oldData.UserId.Equals(data.UserId))
{
cmd.Parameters.Add(new SqlParameter("@UserId", SqlDbType.Char, 15, ParameterDirection.Input, false, 0, 0, "UserId", DataRowVersion.Proposed, data.UserId.DBValue));
}
if (!oldData.DateCreated.Equals(data.DateCreated))
{
cmd.Parameters.Add(new SqlParameter("@DateCreated", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateCreated", DataRowVersion.Proposed, data.DateCreated.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Delete(IdType knowledgebasesSectionsArticlesID)
{
// Create and execute the command
string sql = "Delete From " + TABLE;
WhereClause w = new WhereClause();
w.And("KnowledgebasesSectionsArticlesID", knowledgebasesSectionsArticlesID.DBValue);
sql += w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
// Execute the query and return the result
cmd.ExecuteNonQuery();
}
public static void Delete(IdType eventId)
{
// Create and execute the command
string sql = "Delete From " + TABLE;
WhereClause w = new WhereClause();
w.And("Event_Id", eventId.DBValue);
sql += w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
// Execute the query and return the result
cmd.ExecuteNonQuery();
}
public static void Update(SeeAlsoKnowledgebasesSectionsArtclesData data)
{
// Create and execute the command
SeeAlsoKnowledgebasesSectionsArtclesData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.KnowledgebasesSectionsArticlesID.Equals(data.KnowledgebasesSectionsArticlesID))
{
sql = sql + "KnowledgebasesSectionsArticlesID=@KnowledgebasesSectionsArticlesID,";
}
if (!oldData.Title.Equals(data.Title))
{
sql = sql + "Title=@Title,";
}
if (!oldData.Id.Equals(data.Id))
{
sql = sql + "Id=@Id,";
}
if (!oldData.SeeAlsoID.Equals(data.SeeAlsoID))
{
sql = sql + "SeeAlsoID=@SeeAlsoID,";
}
WhereClause w = new WhereClause();
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.KnowledgebasesSectionsArticlesID.Equals(data.KnowledgebasesSectionsArticlesID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesSectionsArticlesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesSectionsArticlesID", DataRowVersion.Proposed, data.KnowledgebasesSectionsArticlesID.DBValue));
}
if (!oldData.Title.Equals(data.Title))
{
cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar, 250, ParameterDirection.Input, false, 0, 0, "Title", DataRowVersion.Proposed, data.Title.DBValue));
}
if (!oldData.Id.Equals(data.Id))
{
cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Id", DataRowVersion.Proposed, data.Id.DBValue));
}
if (!oldData.SeeAlsoID.Equals(data.SeeAlsoID))
{
cmd.Parameters.Add(new SqlParameter("@SeeAlsoID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SeeAlsoID", DataRowVersion.Proposed, data.SeeAlsoID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(NewsArticlesLocationsNameData data)
{
// Create and execute the command
NewsArticlesLocationsNameData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.NewsArticlesLocationsID.Equals(data.NewsArticlesLocationsID))
{
sql = sql + "NewsArticlesLocationsID=@NewsArticlesLocationsID,";
}
if (!oldData.NewsArticlesID.Equals(data.NewsArticlesID))
{
sql = sql + "NewsArticlesID=@NewsArticlesID,";
}
if (!oldData.OrgLocationsID.Equals(data.OrgLocationsID))
{
sql = sql + "OrgLocationsID=@OrgLocationsID,";
}
WhereClause w = new WhereClause();
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.NewsArticlesLocationsID.Equals(data.NewsArticlesLocationsID))
{
cmd.Parameters.Add(new SqlParameter("@NewsArticlesLocationsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "NewsArticlesLocationsID", DataRowVersion.Proposed, data.NewsArticlesLocationsID.DBValue));
}
if (!oldData.NewsArticlesID.Equals(data.NewsArticlesID))
{
cmd.Parameters.Add(new SqlParameter("@NewsArticlesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "NewsArticlesID", DataRowVersion.Proposed, data.NewsArticlesID.DBValue));
}
if (!oldData.OrgLocationsID.Equals(data.OrgLocationsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgLocationsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgLocationsID", DataRowVersion.Proposed, data.OrgLocationsID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(NewEmployeeRequestData data)
{
// Create and execute the command
NewEmployeeRequestData oldData = Load(data.Id);
string sql = "Update " + TABLE + " set ";
if (!oldData.HireDate.Equals(data.HireDate))
{
sql = sql + "HireDate=@HireDate,";
}
if (!oldData.Text.Equals(data.Text))
{
sql = sql + "Text=@Text,";
}
if (!oldData.EmployeeID.Equals(data.EmployeeID))
{
sql = sql + "EmployeeID=@EmployeeID,";
}
WhereClause w = new WhereClause();
w.And("Id", data.Id.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.Id.Equals(data.Id))
{
cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Id", DataRowVersion.Proposed, data.Id.DBValue));
}
if (!oldData.HireDate.Equals(data.HireDate))
{
cmd.Parameters.Add(new SqlParameter("@HireDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "HireDate", DataRowVersion.Proposed, data.HireDate.DBValue));
}
if (!oldData.Text.Equals(data.Text))
{
cmd.Parameters.Add(new SqlParameter("@Text", SqlDbType.Text, 0, ParameterDirection.Input, false, 0, 0, "Text", DataRowVersion.Proposed, data.Text.DBValue));
}
if (!oldData.EmployeeID.Equals(data.EmployeeID))
{
cmd.Parameters.Add(new SqlParameter("@EmployeeID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "EmployeeID", DataRowVersion.Proposed, data.EmployeeID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(UserRoleData data)
{
// Create and execute the command
UserRoleData oldData = Load(data.UserRoleId);
string sql = "Update " + TABLE + " set ";
if (!oldData.UserId.Equals(data.UserId))
{
sql = sql + "UserId=@UserId,";
}
if (!oldData.RoleId.Equals(data.RoleId))
{
sql = sql + "RoleId=@RoleId,";
}
if (!oldData.PermitDeny.Equals(data.PermitDeny))
{
sql = sql + "PermitDeny=@PermitDeny,";
}
WhereClause w = new WhereClause();
w.And("UserRoleId", data.UserRoleId.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.UserRoleId.Equals(data.UserRoleId))
{
cmd.Parameters.Add(new SqlParameter("@UserRoleId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "UserRoleId", DataRowVersion.Proposed, data.UserRoleId.DBValue));
}
if (!oldData.UserId.Equals(data.UserId))
{
cmd.Parameters.Add(new SqlParameter("@UserId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "UserId", DataRowVersion.Proposed, data.UserId.DBValue));
}
if (!oldData.RoleId.Equals(data.RoleId))
{
cmd.Parameters.Add(new SqlParameter("@RoleId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "RoleId", DataRowVersion.Proposed, data.RoleId.DBValue));
}
if (!oldData.PermitDeny.Equals(data.PermitDeny))
{
cmd.Parameters.Add(new SqlParameter("@PermitDeny", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "PermitDeny", DataRowVersion.Proposed, data.PermitDeny.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(GroupNewsArticlesInfoData data)
{
// Create and execute the command
GroupNewsArticlesInfoData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
sql = sql + "OrgGroupsID=@OrgGroupsID,";
}
if (!oldData.ArticleCount.Equals(data.ArticleCount))
{
sql = sql + "ArticleCount=@ArticleCount,";
}
if (!oldData.LastModified.Equals(data.LastModified))
{
sql = sql + "LastModified=@LastModified,";
}
WhereClause w = new WhereClause();
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
}
if (!oldData.ArticleCount.Equals(data.ArticleCount))
{
cmd.Parameters.Add(new SqlParameter("@ArticleCount", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ArticleCount", DataRowVersion.Proposed, data.ArticleCount.DBValue));
}
if (!oldData.LastModified.Equals(data.LastModified))
{
cmd.Parameters.Add(new SqlParameter("@LastModified", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "LastModified", DataRowVersion.Proposed, data.LastModified.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
/// <summary>
/// Returns a list of objects which match the values for the fields specified.
/// </summary>
/// <param name="TournamentId">A field value to be matched.</param>
/// <param name="Key">A field value to be matched.</param>
/// <returns>The list of TournamentFeeDAO objects found.</returns>
public static IList FindByUserIdAndRolePattern(IdType tournamentId, StringType key)
{
OrderByClause sort = new OrderByClause("TournamentId, Key");
WhereClause filter = new WhereClause("TournamentId = @TournamentId and Key like @Key");
String sql = "Select * from " + VIEW + filter.FormatSql() + sort.FormatSql();
SqlCommand cmd = GetSqlCommand(CONNECTION_STRING_KEY, sql, CommandType.Text);
cmd.Parameters.Add(new SqlParameter("@TournamentId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, "TournamentId", DataRowVersion.Proposed, tournamentId.DBValue));
cmd.Parameters.Add(new SqlParameter("@Key", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Key", DataRowVersion.Proposed, key.DBValue));
SqlDataReader dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
IList list = new ArrayList();
while (dataReader.Read())
{
list.Add(GetDataObjectFromReader(dataReader));
}
dataReader.Close();
return(list);
}
public static void Update(GroupKnowledgebasesSubscriptionsData data)
{
// Create and execute the command
GroupKnowledgebasesSubscriptionsData oldData = Load(data.Id);
string sql = "Update " + TABLE + " set ";
if (!oldData.OrgGroupID.Equals(data.OrgGroupID))
{
sql = sql + "OrgGroupID=@OrgGroupID,";
}
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
sql = sql + "KnowledgebasesID=@KnowledgebasesID,";
}
WhereClause w = new WhereClause();
w.And("Id", data.Id.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.Id.Equals(data.Id))
{
cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Id", DataRowVersion.Proposed, data.Id.DBValue));
}
if (!oldData.OrgGroupID.Equals(data.OrgGroupID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupID", DataRowVersion.Proposed, data.OrgGroupID.DBValue));
}
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesID", DataRowVersion.Proposed, data.KnowledgebasesID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(MenuViewData data)
{
// Create and execute the command
MenuViewData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.ParentMenuItemsID.Equals(data.ParentMenuItemsID))
{
sql = sql + "ParentMenuItemsID=@ParentMenuItemsID,";
}
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.Url.Equals(data.Url))
{
sql = sql + "url=@url,";
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
sql = sql + "SortOrder=@SortOrder,";
}
if (!oldData.Target.Equals(data.Target))
{
sql = sql + "Target=@Target,";
}
if (!oldData.DateStart.Equals(data.DateStart))
{
sql = sql + "DateStart=@DateStart,";
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
sql = sql + "DateEnd=@DateEnd,";
}
if (!oldData.NodeImgSrc.Equals(data.NodeImgSrc))
{
sql = sql + "NodeImgSrc=@NodeImgSrc,";
}
if (!oldData.MenuItemsID.Equals(data.MenuItemsID))
{
sql = sql + "MenuItemsID=@MenuItemsID,";
}
WhereClause w = new WhereClause();
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.ParentMenuItemsID.Equals(data.ParentMenuItemsID))
{
cmd.Parameters.Add(new SqlParameter("@ParentMenuItemsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ParentMenuItemsID", DataRowVersion.Proposed, data.ParentMenuItemsID.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.Url.Equals(data.Url))
{
cmd.Parameters.Add(new SqlParameter("@url", SqlDbType.VarChar, 300, ParameterDirection.Input, false, 0, 0, "url", DataRowVersion.Proposed, data.Url.DBValue));
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
cmd.Parameters.Add(new SqlParameter("@SortOrder", SqlDbType.TinyInt, 0, ParameterDirection.Input, false, 0, 0, "SortOrder", DataRowVersion.Proposed, data.SortOrder.DBValue));
}
if (!oldData.Target.Equals(data.Target))
{
cmd.Parameters.Add(new SqlParameter("@Target", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "Target", DataRowVersion.Proposed, data.Target.DBValue));
}
if (!oldData.DateStart.Equals(data.DateStart))
{
cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
}
if (!oldData.NodeImgSrc.Equals(data.NodeImgSrc))
{
cmd.Parameters.Add(new SqlParameter("@NodeImgSrc", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "NodeImgSrc", DataRowVersion.Proposed, data.NodeImgSrc.DBValue));
}
if (!oldData.MenuItemsID.Equals(data.MenuItemsID))
{
cmd.Parameters.Add(new SqlParameter("@MenuItemsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "MenuItemsID", DataRowVersion.Proposed, data.MenuItemsID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(EmployeeOtherControlsSubscriptionsViewData data)
{
// Create and execute the command
EmployeeOtherControlsSubscriptionsViewData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.Src.Equals(data.Src))
{
sql = sql + "Src=@Src,";
}
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.ClassSrc.Equals(data.ClassSrc))
{
sql = sql + "ClassSrc=@ClassSrc,";
}
if (!oldData.ClassDescription.Equals(data.ClassDescription))
{
sql = sql + "ClassDescription=@ClassDescription,";
}
if (!oldData.AllowUnsubscribe.Equals(data.AllowUnsubscribe))
{
sql = sql + "AllowUnsubscribe=@AllowUnsubscribe,";
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
sql = sql + "SortOrder=@SortOrder,";
}
if (!oldData.OrgEmployeesID.Equals(data.OrgEmployeesID))
{
sql = sql + "OrgEmployeesID=@OrgEmployeesID,";
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
sql = sql + "ControlsID=@ControlsID,";
}
if (!oldData.ControlSubscriptionsID.Equals(data.ControlSubscriptionsID))
{
sql = sql + "ControlSubscriptionsID=@ControlSubscriptionsID,";
}
WhereClause w = new WhereClause();
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.Src.Equals(data.Src))
{
cmd.Parameters.Add(new SqlParameter("@Src", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Src", DataRowVersion.Proposed, data.Src.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.ClassSrc.Equals(data.ClassSrc))
{
cmd.Parameters.Add(new SqlParameter("@ClassSrc", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ClassSrc", DataRowVersion.Proposed, data.ClassSrc.DBValue));
}
if (!oldData.ClassDescription.Equals(data.ClassDescription))
{
cmd.Parameters.Add(new SqlParameter("@ClassDescription", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "ClassDescription", DataRowVersion.Proposed, data.ClassDescription.DBValue));
}
if (!oldData.AllowUnsubscribe.Equals(data.AllowUnsubscribe))
{
cmd.Parameters.Add(new SqlParameter("@AllowUnsubscribe", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "AllowUnsubscribe", DataRowVersion.Proposed, !data.AllowUnsubscribe.IsValid ? data.AllowUnsubscribe.DBValue : data.AllowUnsubscribe.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
cmd.Parameters.Add(new SqlParameter("@SortOrder", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SortOrder", DataRowVersion.Proposed, data.SortOrder.DBValue));
}
if (!oldData.OrgEmployeesID.Equals(data.OrgEmployeesID))
{
cmd.Parameters.Add(new SqlParameter("@OrgEmployeesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgEmployeesID", DataRowVersion.Proposed, data.OrgEmployeesID.DBValue));
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsID", DataRowVersion.Proposed, data.ControlsID.DBValue));
}
if (!oldData.ControlSubscriptionsID.Equals(data.ControlSubscriptionsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlSubscriptionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlSubscriptionsID", DataRowVersion.Proposed, data.ControlSubscriptionsID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(ControlEditData data)
{
// Create and execute the command
ControlEditData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.IsBasic.Equals(data.IsBasic))
{
sql = sql + "IsBasic=@IsBasic,";
}
if (!oldData.Summary.Equals(data.Summary))
{
sql = sql + "Summary=@Summary,";
}
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.Src.Equals(data.Src))
{
sql = sql + "Src=@Src,";
}
if (!oldData.IconImage.Equals(data.IconImage))
{
sql = sql + "IconImage=@IconImage,";
}
if (!oldData.DisplayOnHomePage.Equals(data.DisplayOnHomePage))
{
sql = sql + "DisplayOnHomePage=@DisplayOnHomePage,";
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
sql = sql + "SortOrder=@SortOrder,";
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
sql = sql + "ControlsID=@ControlsID,";
}
if (!oldData.ControlsGroupsID.Equals(data.ControlsGroupsID))
{
sql = sql + "ControlsGroupsID=@ControlsGroupsID,";
}
if (!oldData.OrgGroupID.Equals(data.OrgGroupID))
{
sql = sql + "OrgGroupID=@OrgGroupID,";
}
if (!oldData.ManagePage.Equals(data.ManagePage))
{
sql = sql + "ManagePage=@ManagePage,";
}
if (!oldData.EntireCompany.Equals(data.EntireCompany))
{
sql = sql + "EntireCompany=@EntireCompany,";
}
if (!oldData.MustShow.Equals(data.MustShow))
{
sql = sql + "MustShow=@MustShow,";
}
WhereClause w = new WhereClause();
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.IsBasic.Equals(data.IsBasic))
{
cmd.Parameters.Add(new SqlParameter("@IsBasic", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsBasic", DataRowVersion.Proposed, !data.IsBasic.IsValid ? data.IsBasic.DBValue : data.IsBasic.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.Summary.Equals(data.Summary))
{
cmd.Parameters.Add(new SqlParameter("@Summary", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Summary", DataRowVersion.Proposed, data.Summary.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.Src.Equals(data.Src))
{
cmd.Parameters.Add(new SqlParameter("@Src", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Src", DataRowVersion.Proposed, data.Src.DBValue));
}
if (!oldData.IconImage.Equals(data.IconImage))
{
cmd.Parameters.Add(new SqlParameter("@IconImage", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "IconImage", DataRowVersion.Proposed, data.IconImage.DBValue));
}
if (!oldData.DisplayOnHomePage.Equals(data.DisplayOnHomePage))
{
cmd.Parameters.Add(new SqlParameter("@DisplayOnHomePage", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "DisplayOnHomePage", DataRowVersion.Proposed, !data.DisplayOnHomePage.IsValid ? data.DisplayOnHomePage.DBValue : data.DisplayOnHomePage.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
cmd.Parameters.Add(new SqlParameter("@SortOrder", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SortOrder", DataRowVersion.Proposed, data.SortOrder.DBValue));
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsID", DataRowVersion.Proposed, data.ControlsID.DBValue));
}
if (!oldData.ControlsGroupsID.Equals(data.ControlsGroupsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlsGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsGroupsID", DataRowVersion.Proposed, data.ControlsGroupsID.DBValue));
}
if (!oldData.OrgGroupID.Equals(data.OrgGroupID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupID", DataRowVersion.Proposed, data.OrgGroupID.DBValue));
}
if (!oldData.ManagePage.Equals(data.ManagePage))
{
cmd.Parameters.Add(new SqlParameter("@ManagePage", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ManagePage", DataRowVersion.Proposed, data.ManagePage.DBValue));
}
if (!oldData.EntireCompany.Equals(data.EntireCompany))
{
cmd.Parameters.Add(new SqlParameter("@EntireCompany", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "EntireCompany", DataRowVersion.Proposed, !data.EntireCompany.IsValid ? data.EntireCompany.DBValue : data.EntireCompany.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.MustShow.Equals(data.MustShow))
{
cmd.Parameters.Add(new SqlParameter("@MustShow", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "MustShow", DataRowVersion.Proposed, !data.MustShow.IsValid ? data.MustShow.DBValue : data.MustShow.DBValue.Equals("Y") ? 1 : 0));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(KnowledgebasesSectionsArticlesData data)
{
// Create and execute the command
KnowledgebasesSectionsArticlesData oldData = Load(data.KnowledgebasesSectionsArticlesID);
string sql = "Update " + TABLE + " set ";
if (!oldData.Title.Equals(data.Title))
{
sql = sql + "Title=@Title,";
}
if (!oldData.DateStart.Equals(data.DateStart))
{
sql = sql + "DateStart=@DateStart,";
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
sql = sql + "DateEnd=@DateEnd,";
}
if (!oldData.ParentID.Equals(data.ParentID))
{
sql = sql + "ParentID=@ParentID,";
}
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
sql = sql + "KnowledgebasesID=@KnowledgebasesID,";
}
if (!oldData.HasChild.Equals(data.HasChild))
{
sql = sql + "HasChild=@HasChild,";
}
if (!oldData.PrevKnowledgebasesSectionsID.Equals(data.PrevKnowledgebasesSectionsID))
{
sql = sql + "PrevKnowledgebasesSectionsID=@PrevKnowledgebasesSectionsID,";
}
if (!oldData.NextKnowledgebasesSectionsID.Equals(data.NextKnowledgebasesSectionsID))
{
sql = sql + "NextKnowledgebasesSectionsID=@NextKnowledgebasesSectionsID,";
}
if (!oldData.ListInParentArticle.Equals(data.ListInParentArticle))
{
sql = sql + "ListInParentArticle=@ListInParentArticle,";
}
if (!oldData.IncludeSummaryinParent.Equals(data.IncludeSummaryinParent))
{
sql = sql + "IncludeSummaryinParent=@IncludeSummaryinParent,";
}
if (!oldData.Sort.Equals(data.Sort))
{
sql = sql + "Sort=@Sort,";
}
if (!oldData.IsSection.Equals(data.IsSection))
{
sql = sql + "IsSection=@IsSection,";
}
if (!oldData.IsTemp.Equals(data.IsTemp))
{
sql = sql + "IsTemp=@IsTemp,";
}
WhereClause w = new WhereClause();
w.And("KnowledgebasesSectionsArticlesID", data.KnowledgebasesSectionsArticlesID.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.KnowledgebasesSectionsArticlesID.Equals(data.KnowledgebasesSectionsArticlesID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesSectionsArticlesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesSectionsArticlesID", DataRowVersion.Proposed, data.KnowledgebasesSectionsArticlesID.DBValue));
}
if (!oldData.Title.Equals(data.Title))
{
cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar, 250, ParameterDirection.Input, false, 0, 0, "Title", DataRowVersion.Proposed, data.Title.DBValue));
}
if (!oldData.DateStart.Equals(data.DateStart))
{
cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
}
if (!oldData.ParentID.Equals(data.ParentID))
{
cmd.Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ParentID", DataRowVersion.Proposed, data.ParentID.DBValue));
}
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesID", DataRowVersion.Proposed, data.KnowledgebasesID.DBValue));
}
if (!oldData.HasChild.Equals(data.HasChild))
{
cmd.Parameters.Add(new SqlParameter("@HasChild", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "HasChild", DataRowVersion.Proposed, !data.HasChild.IsValid ? data.HasChild.DBValue : data.HasChild.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.PrevKnowledgebasesSectionsID.Equals(data.PrevKnowledgebasesSectionsID))
{
cmd.Parameters.Add(new SqlParameter("@PrevKnowledgebasesSectionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "PrevKnowledgebasesSectionsID", DataRowVersion.Proposed, data.PrevKnowledgebasesSectionsID.DBValue));
}
if (!oldData.NextKnowledgebasesSectionsID.Equals(data.NextKnowledgebasesSectionsID))
{
cmd.Parameters.Add(new SqlParameter("@NextKnowledgebasesSectionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "NextKnowledgebasesSectionsID", DataRowVersion.Proposed, data.NextKnowledgebasesSectionsID.DBValue));
}
if (!oldData.ListInParentArticle.Equals(data.ListInParentArticle))
{
cmd.Parameters.Add(new SqlParameter("@ListInParentArticle", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "ListInParentArticle", DataRowVersion.Proposed, !data.ListInParentArticle.IsValid ? data.ListInParentArticle.DBValue : data.ListInParentArticle.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.IncludeSummaryinParent.Equals(data.IncludeSummaryinParent))
{
cmd.Parameters.Add(new SqlParameter("@IncludeSummaryinParent", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IncludeSummaryinParent", DataRowVersion.Proposed, !data.IncludeSummaryinParent.IsValid ? data.IncludeSummaryinParent.DBValue : data.IncludeSummaryinParent.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.Sort.Equals(data.Sort))
{
cmd.Parameters.Add(new SqlParameter("@Sort", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Sort", DataRowVersion.Proposed, data.Sort.DBValue));
}
if (!oldData.IsSection.Equals(data.IsSection))
{
cmd.Parameters.Add(new SqlParameter("@IsSection", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsSection", DataRowVersion.Proposed, !data.IsSection.IsValid ? data.IsSection.DBValue : data.IsSection.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.IsTemp.Equals(data.IsTemp))
{
cmd.Parameters.Add(new SqlParameter("@IsTemp", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsTemp", DataRowVersion.Proposed, !data.IsTemp.IsValid ? data.IsTemp.DBValue : data.IsTemp.DBValue.Equals("Y") ? 1 : 0));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(EventData data)
{
// Create and execute the command
EventData oldData = Load(data.EventId);
string sql = "Update " + TABLE + " set ";
if (!oldData.EventId.Equals(data.EventId))
{
sql = sql + "Event_Id=@Event_Id,";
}
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.InternalAccess.Equals(data.InternalAccess))
{
sql = sql + "Internal=@Internal,";
}
if (!oldData.ExternalAccess.Equals(data.ExternalAccess))
{
sql = sql + "External=@External,";
}
if (!oldData.CloseDate.Equals(data.CloseDate))
{
sql = sql + "CloseDate=@CloseDate,";
}
if (!oldData.StartDate.Equals(data.StartDate))
{
sql = sql + "StartDate=@StartDate,";
}
if (!oldData.DemoItemId.Equals(data.DemoItemId))
{
sql = sql + "DemoItemId=@DemoItemId,";
}
if (!oldData.GuestItemId.Equals(data.GuestItemId))
{
sql = sql + "GuestItemId=@GuestItemId,";
}
if (!oldData.MaxRegistrations.Equals(data.MaxRegistrations))
{
sql = sql + "MaxRegistrations=@MaxRegistrations,";
}
if (!oldData.Warning.Equals(data.Warning))
{
sql = sql + "Warning=@Warning,";
}
if (!oldData.MinDemoLevel.Equals(data.MinDemoLevel))
{
sql = sql + "MinDemoLevel=@MinDemoLevel,";
}
if (!oldData.SpouseOnly.Equals(data.SpouseOnly))
{
sql = sql + "SpouseOnly=@SpouseOnly,";
}
if (!oldData.MaxGuests.Equals(data.MaxGuests))
{
sql = sql + "MaxGuests=@MaxGuests,";
}
if (!oldData.AskTerms.Equals(data.AskTerms))
{
sql = sql + "AskTerms=@AskTerms,";
}
if (!oldData.AskColor.Equals(data.AskColor))
{
sql = sql + "AskColor=@AskColor,";
}
if (!oldData.DemoFirstNameOnly.Equals(data.DemoFirstNameOnly))
{
sql = sql + "DemoFirstNameOnly=@DemoFirstNameOnly,";
}
if (!oldData.AskDemoMobility.Equals(data.AskDemoMobility))
{
sql = sql + "AskDemoMobility=@AskDemoMobility,";
}
if (!oldData.AskDemoHearing.Equals(data.AskDemoHearing))
{
sql = sql + "AskDemoHearing=@AskDemoHearing,";
}
if (!oldData.JointDemoOnly.Equals(data.JointDemoOnly))
{
sql = sql + "JointDemoOnly=@JointDemoOnly,";
}
if (!oldData.ShowFinalSplash.Equals(data.ShowFinalSplash))
{
sql = sql + "ShowFinalSplash=@ShowFinalSplash,";
}
if (!oldData.NoGuestMeal.Equals(data.NoGuestMeal))
{
sql = sql + "NoGuestMeal=@NoGuestMeal,";
}
if (!oldData.DependentEvent.Equals(data.DependentEvent))
{
sql = sql + "DependentEvent=@DependentEvent,";
}
if (!oldData.AllowCheckPayment.Equals(data.AllowCheckPayment))
{
sql = sql + "AllowCheckPayment=@AllowCheckPayment,";
}
if (!oldData.NoGuestPeriod.Equals(data.NoGuestPeriod))
{
sql = sql + "NoGuestPeriod=@NoGuestPeriod,";
}
if (!oldData.CountryCode.Equals(data.CountryCode))
{
sql = sql + "CountryCode=@CountryCode,";
}
if (!oldData.EventType.Equals(data.EventType))
{
sql = sql + "EventType=@EventType,";
}
if (!oldData.EventDate.Equals(data.EventDate))
{
sql = sql + "EventDate=@EventDate,";
}
if (!oldData.GLPostedDate.Equals(data.GLPostedDate))
{
sql = sql + "GLPostedDate=@GLPostedDate,";
}
if (!oldData.CancelFeeItemId.Equals(data.CancelFeeItemId))
{
sql = sql + "CancelFeeItemId=@CancelFeeItemId,";
}
if (!oldData.GuestCancelFeeItemId.Equals(data.GuestCancelFeeItemId))
{
sql = sql + "GuestCancelFeeItemId=@GuestCancelFeeItemId,";
}
WhereClause w = new WhereClause();
w.And("Event_Id", data.EventId.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.EventId.Equals(data.EventId))
{
cmd.Parameters.Add(new SqlParameter("@Event_Id", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "EventId", DataRowVersion.Proposed, data.EventId.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.Char, 80, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.InternalAccess.Equals(data.InternalAccess))
{
cmd.Parameters.Add(new SqlParameter("@Internal", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "InternalAccess", DataRowVersion.Proposed, data.InternalAccess.DBValue));
}
if (!oldData.ExternalAccess.Equals(data.ExternalAccess))
{
cmd.Parameters.Add(new SqlParameter("@External", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ExternalAccess", DataRowVersion.Proposed, data.ExternalAccess.DBValue));
}
if (!oldData.CloseDate.Equals(data.CloseDate))
{
cmd.Parameters.Add(new SqlParameter("@CloseDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "CloseDate", DataRowVersion.Proposed, data.CloseDate.DBValue));
}
if (!oldData.StartDate.Equals(data.StartDate))
{
cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "StartDate", DataRowVersion.Proposed, data.StartDate.DBValue));
}
if (!oldData.DemoItemId.Equals(data.DemoItemId))
{
cmd.Parameters.Add(new SqlParameter("@DemoItemId", SqlDbType.Char, 20, ParameterDirection.Input, false, 0, 0, "DemoItemId", DataRowVersion.Proposed, data.DemoItemId.DBValue));
}
if (!oldData.GuestItemId.Equals(data.GuestItemId))
{
cmd.Parameters.Add(new SqlParameter("@GuestItemId", SqlDbType.Char, 20, ParameterDirection.Input, false, 0, 0, "GuestItemId", DataRowVersion.Proposed, data.GuestItemId.DBValue));
}
if (!oldData.MaxRegistrations.Equals(data.MaxRegistrations))
{
cmd.Parameters.Add(new SqlParameter("@MaxRegistrations", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "MaxRegistrations", DataRowVersion.Proposed, data.MaxRegistrations.DBValue));
}
if (!oldData.Warning.Equals(data.Warning))
{
cmd.Parameters.Add(new SqlParameter("@Warning", SqlDbType.VarChar, 5000, ParameterDirection.Input, false, 0, 0, "Warning", DataRowVersion.Proposed, data.Warning.DBValue));
}
if (!oldData.MinDemoLevel.Equals(data.MinDemoLevel))
{
cmd.Parameters.Add(new SqlParameter("@MinDemoLevel", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "MinDemoLevel", DataRowVersion.Proposed, data.MinDemoLevel.DBValue));
}
if (!oldData.SpouseOnly.Equals(data.SpouseOnly))
{
cmd.Parameters.Add(new SqlParameter("@SpouseOnly", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SpouseOnly", DataRowVersion.Proposed, data.SpouseOnly.DBValue));
}
if (!oldData.MaxGuests.Equals(data.MaxGuests))
{
cmd.Parameters.Add(new SqlParameter("@MaxGuests", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "MaxGuests", DataRowVersion.Proposed, data.MaxGuests.DBValue));
}
if (!oldData.AskTerms.Equals(data.AskTerms))
{
cmd.Parameters.Add(new SqlParameter("@AskTerms", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "AskTerms", DataRowVersion.Proposed, data.AskTerms.DBValue));
}
if (!oldData.AskColor.Equals(data.AskColor))
{
cmd.Parameters.Add(new SqlParameter("@AskColor", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "AskColor", DataRowVersion.Proposed, data.AskColor.DBValue));
}
if (!oldData.DemoFirstNameOnly.Equals(data.DemoFirstNameOnly))
{
cmd.Parameters.Add(new SqlParameter("@DemoFirstNameOnly", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "DemoFirstNameOnly", DataRowVersion.Proposed, data.DemoFirstNameOnly.DBValue));
}
if (!oldData.AskDemoMobility.Equals(data.AskDemoMobility))
{
cmd.Parameters.Add(new SqlParameter("@AskDemoMobility", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "AskDemoMobility", DataRowVersion.Proposed, data.AskDemoMobility.DBValue));
}
if (!oldData.AskDemoHearing.Equals(data.AskDemoHearing))
{
cmd.Parameters.Add(new SqlParameter("@AskDemoHearing", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "AskDemoHearing", DataRowVersion.Proposed, data.AskDemoHearing.DBValue));
}
if (!oldData.JointDemoOnly.Equals(data.JointDemoOnly))
{
cmd.Parameters.Add(new SqlParameter("@JointDemoOnly", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "JointDemoOnly", DataRowVersion.Proposed, data.JointDemoOnly.DBValue));
}
if (!oldData.ShowFinalSplash.Equals(data.ShowFinalSplash))
{
cmd.Parameters.Add(new SqlParameter("@ShowFinalSplash", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "ShowFinalSplash", DataRowVersion.Proposed, data.ShowFinalSplash.DBValue));
}
if (!oldData.NoGuestMeal.Equals(data.NoGuestMeal))
{
cmd.Parameters.Add(new SqlParameter("@NoGuestMeal", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "NoGuestMeal", DataRowVersion.Proposed, data.NoGuestMeal.DBValue));
}
if (!oldData.DependentEvent.Equals(data.DependentEvent))
{
cmd.Parameters.Add(new SqlParameter("@DependentEvent", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "DependentEvent", DataRowVersion.Proposed, data.DependentEvent.DBValue));
}
if (!oldData.AllowCheckPayment.Equals(data.AllowCheckPayment))
{
cmd.Parameters.Add(new SqlParameter("@AllowCheckPayment", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "AllowCheckPayment", DataRowVersion.Proposed, data.AllowCheckPayment.DBValue));
}
if (!oldData.NoGuestPeriod.Equals(data.NoGuestPeriod))
{
cmd.Parameters.Add(new SqlParameter("@NoGuestPeriod", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "NoGuestPeriod", DataRowVersion.Proposed, data.NoGuestPeriod.DBValue));
}
if (!oldData.CountryCode.Equals(data.CountryCode))
{
cmd.Parameters.Add(new SqlParameter("@CountryCode", SqlDbType.Char, 2, ParameterDirection.Input, false, 0, 0, "CountryCode", DataRowVersion.Proposed, data.CountryCode.DBValue));
}
if (!oldData.EventType.Equals(data.EventType))
{
cmd.Parameters.Add(new SqlParameter("@EventType", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "EventType", DataRowVersion.Proposed, data.EventType.DBValue));
}
if (!oldData.EventDate.Equals(data.EventDate))
{
cmd.Parameters.Add(new SqlParameter("@EventDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "EventDate", DataRowVersion.Proposed, data.EventDate.DBValue));
}
if (!oldData.GLPostedDate.Equals(data.GLPostedDate))
{
cmd.Parameters.Add(new SqlParameter("@GLPostedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "GLPostedDate", DataRowVersion.Proposed, data.GLPostedDate.DBValue));
}
if (!oldData.CancelFeeItemId.Equals(data.CancelFeeItemId))
{
cmd.Parameters.Add(new SqlParameter("@CancelFeeItemId", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "CancelFeeItemId", DataRowVersion.Proposed, data.CancelFeeItemId.DBValue));
}
if (!oldData.GuestCancelFeeItemId.Equals(data.GuestCancelFeeItemId))
{
cmd.Parameters.Add(new SqlParameter("@GuestCancelFeeItemId", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "GuestCancelFeeItemId", DataRowVersion.Proposed, data.GuestCancelFeeItemId.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(MustShowControlViewData data)
{
// Create and execute the command
MustShowControlViewData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.Src.Equals(data.Src))
{
sql = sql + "Src=@Src,";
}
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.Summary.Equals(data.Summary))
{
sql = sql + "Summary=@Summary,";
}
if (!oldData.ClassSrc.Equals(data.ClassSrc))
{
sql = sql + "ClassSrc=@ClassSrc,";
}
if (!oldData.MustShow.Equals(data.MustShow))
{
sql = sql + "MustShow=@MustShow,";
}
if (!oldData.DateStart.Equals(data.DateStart))
{
sql = sql + "DateStart=@DateStart,";
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
sql = sql + "DateEnd=@DateEnd,";
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
sql = sql + "ControlsID=@ControlsID,";
}
WhereClause w = new WhereClause();
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.Src.Equals(data.Src))
{
cmd.Parameters.Add(new SqlParameter("@Src", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Src", DataRowVersion.Proposed, data.Src.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.Summary.Equals(data.Summary))
{
cmd.Parameters.Add(new SqlParameter("@Summary", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Summary", DataRowVersion.Proposed, data.Summary.DBValue));
}
if (!oldData.ClassSrc.Equals(data.ClassSrc))
{
cmd.Parameters.Add(new SqlParameter("@ClassSrc", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ClassSrc", DataRowVersion.Proposed, data.ClassSrc.DBValue));
}
if (!oldData.MustShow.Equals(data.MustShow))
{
cmd.Parameters.Add(new SqlParameter("@MustShow", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "MustShow", DataRowVersion.Proposed, !data.MustShow.IsValid ? data.MustShow.DBValue : data.MustShow.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.DateStart.Equals(data.DateStart))
{
cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsID", DataRowVersion.Proposed, data.ControlsID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(EmployeeManagerNotesData data)
{
// Create and execute the command
EmployeeManagerNotesData oldData = Load(data.Id);
string sql = "Update " + TABLE + " set ";
if (!oldData.ChangeEmployeeName.Equals(data.ChangeEmployeeName))
{
sql = sql + "ChangeEmployeeName=@ChangeEmployeeName,";
}
if (!oldData.IsAutomated.Equals(data.IsAutomated))
{
sql = sql + "IsAutomated=@IsAutomated,";
}
if (!oldData.NoteDate.Equals(data.NoteDate))
{
sql = sql + "NoteDate=@NoteDate,";
}
if (!oldData.Notes.Equals(data.Notes))
{
sql = sql + "Notes=@Notes,";
}
if (!oldData.Type.Equals(data.Type))
{
sql = sql + "Type=@Type,";
}
if (!oldData.EmployeeID.Equals(data.EmployeeID))
{
sql = sql + "EmployeeID=@EmployeeID,";
}
WhereClause w = new WhereClause();
w.And("Id", data.Id.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.Id.Equals(data.Id))
{
cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Id", DataRowVersion.Proposed, data.Id.DBValue));
}
if (!oldData.ChangeEmployeeName.Equals(data.ChangeEmployeeName))
{
cmd.Parameters.Add(new SqlParameter("@ChangeEmployeeName", SqlDbType.VarChar, 150, ParameterDirection.Input, false, 0, 0, "ChangeEmployeeName", DataRowVersion.Proposed, data.ChangeEmployeeName.DBValue));
}
if (!oldData.IsAutomated.Equals(data.IsAutomated))
{
cmd.Parameters.Add(new SqlParameter("@IsAutomated", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsAutomated", DataRowVersion.Proposed, !data.IsAutomated.IsValid ? data.IsAutomated.DBValue : data.IsAutomated.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.NoteDate.Equals(data.NoteDate))
{
cmd.Parameters.Add(new SqlParameter("@NoteDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "NoteDate", DataRowVersion.Proposed, data.NoteDate.DBValue));
}
if (!oldData.Notes.Equals(data.Notes))
{
cmd.Parameters.Add(new SqlParameter("@Notes", SqlDbType.VarChar, 300, ParameterDirection.Input, false, 0, 0, "Notes", DataRowVersion.Proposed, data.Notes.DBValue));
}
if (!oldData.Type.Equals(data.Type))
{
cmd.Parameters.Add(new SqlParameter("@Type", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Type", DataRowVersion.Proposed, data.Type.DBValue));
}
if (!oldData.EmployeeID.Equals(data.EmployeeID))
{
cmd.Parameters.Add(new SqlParameter("@EmployeeID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "EmployeeID", DataRowVersion.Proposed, data.EmployeeID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(OrgLocationsData data)
{
// Create and execute the command
OrgLocationsData oldData = Load(data.OrgLocationsID);
string sql = "Update " + TABLE + " set ";
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.Address1.Equals(data.Address1))
{
sql = sql + "Address1=@Address1,";
}
if (!oldData.Address2.Equals(data.Address2))
{
sql = sql + "Address2=@Address2,";
}
if (!oldData.City.Equals(data.City))
{
sql = sql + "City=@City,";
}
if (!oldData.State.Equals(data.State))
{
sql = sql + "State=@State,";
}
if (!oldData.Country.Equals(data.Country))
{
sql = sql + "Country=@Country,";
}
if (!oldData.PostCode.Equals(data.PostCode))
{
sql = sql + "PostCode=@PostCode,";
}
if (!oldData.Prefix.Equals(data.Prefix))
{
sql = sql + "Prefix=@Prefix,";
}
if (!oldData.Image.Equals(data.Image))
{
sql = sql + "Image=@Image,";
}
WhereClause w = new WhereClause();
w.And("OrgLocationsID", data.OrgLocationsID.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.OrgLocationsID.Equals(data.OrgLocationsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgLocationsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgLocationsID", DataRowVersion.Proposed, data.OrgLocationsID.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.Address1.Equals(data.Address1))
{
cmd.Parameters.Add(new SqlParameter("@Address1", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Address1", DataRowVersion.Proposed, data.Address1.DBValue));
}
if (!oldData.Address2.Equals(data.Address2))
{
cmd.Parameters.Add(new SqlParameter("@Address2", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Address2", DataRowVersion.Proposed, data.Address2.DBValue));
}
if (!oldData.City.Equals(data.City))
{
cmd.Parameters.Add(new SqlParameter("@City", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "City", DataRowVersion.Proposed, data.City.DBValue));
}
if (!oldData.State.Equals(data.State))
{
cmd.Parameters.Add(new SqlParameter("@State", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "State", DataRowVersion.Proposed, data.State.DBValue));
}
if (!oldData.Country.Equals(data.Country))
{
cmd.Parameters.Add(new SqlParameter("@Country", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Country", DataRowVersion.Proposed, data.Country.DBValue));
}
if (!oldData.PostCode.Equals(data.PostCode))
{
cmd.Parameters.Add(new SqlParameter("@PostCode", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, "PostCode", DataRowVersion.Proposed, data.PostCode.DBValue));
}
if (!oldData.Prefix.Equals(data.Prefix))
{
cmd.Parameters.Add(new SqlParameter("@Prefix", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "Prefix", DataRowVersion.Proposed, data.Prefix.DBValue));
}
if (!oldData.Image.Equals(data.Image))
{
cmd.Parameters.Add(new SqlParameter("@Image", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Image", DataRowVersion.Proposed, data.Image.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
/// <summary>
/// Returns a list of objects which match the values for the fields specified.
/// </summary>
/// <param name="Name">A field value to be matched.</param>
/// <returns>The list of TournamentDAO objects found.</returns>
public static IList FindByName(StringType name, Int32 limit)
{
OrderByClause sort = new OrderByClause("Name");
WhereClause filter = new WhereClause("Name like @Name + '%'");
String sql = "Select top " + limit.ToString() + " * from " + VIEW + filter.FormatSql() + sort.FormatSql();
SqlCommand cmd = GetSqlCommand(CONNECTION_STRING_KEY, sql, CommandType.Text);
cmd.Parameters.Add(new SqlParameter("@Name", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Name", DataRowVersion.Proposed, name.DBValue));
SqlDataReader dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
IList list = new ArrayList();
while (dataReader.Read())
{
list.Add(GetDataObjectFromReader(dataReader));
}
dataReader.Close();
return(list);
}
public static void Update(OrderDtlData data)
{
// Create and execute the command
OrderDtlData oldData = Load(data.OrderDetailId);
string sql = "Update " + TABLE + " set ";
if (!oldData.OrderDetailId.Equals(data.OrderDetailId))
{
sql = sql + "Order_Detail_Id=@Order_Detail_Id,";
}
if (!oldData.OrderNo.Equals(data.OrderNo))
{
sql = sql + "Orderno=@Orderno,";
}
if (!oldData.TypeOrd.Equals(data.TypeOrd))
{
sql = sql + "Type_Ord=@Type_Ord,";
}
if (!oldData.ItemId.Equals(data.ItemId))
{
sql = sql + "Item_Id=@Item_Id,";
}
if (!oldData.ItemDescrip.Equals(data.ItemDescrip))
{
sql = sql + "Item_Descrip=@Item_Descrip,";
}
if (!oldData.BinNo.Equals(data.BinNo))
{
sql = sql + "Bin_No=@Bin_No,";
}
if (!oldData.QtyOrdered.Equals(data.QtyOrdered))
{
sql = sql + "Qty_Ordered=@Qty_Ordered,";
}
if (!oldData.QtyPicked.Equals(data.QtyPicked))
{
sql = sql + "Qty_Picked=@Qty_Picked,";
}
if (!oldData.QtyShipped.Equals(data.QtyShipped))
{
sql = sql + "Qty_Shipped=@Qty_Shipped,";
}
if (!oldData.ShippingNo.Equals(data.ShippingNo))
{
sql = sql + "Shipping_No=@Shipping_No,";
}
if (!oldData.ItemPrice.Equals(data.ItemPrice))
{
sql = sql + "Item_Price=@Item_Price,";
}
if (!oldData.Subtotal.Equals(data.Subtotal))
{
sql = sql + "Subtotal=@Subtotal,";
}
if (!oldData.Personal.Equals(data.Personal))
{
sql = sql + "Personal=@Personal,";
}
if (!oldData.TaxExempt.Equals(data.TaxExempt))
{
sql = sql + "Tax_Exempt=@Tax_Exempt,";
}
if (!oldData.TaxExemptNo.Equals(data.TaxExemptNo))
{
sql = sql + "Tax_Exempt_No=@Tax_Exempt_No,";
}
if (!oldData.ShipDate.Equals(data.ShipDate))
{
sql = sql + "Ship_Date=@Ship_Date,";
}
if (!oldData.Kit.Equals(data.Kit))
{
sql = sql + "Kit=@Kit,";
}
if (!oldData.GuestIdOld.Equals(data.GuestIdOld))
{
sql = sql + "Guest_Id_Old=@Guest_Id_Old,";
}
if (!oldData.ComponentId.Equals(data.ComponentId))
{
sql = sql + "Component_Id=@Component_Id,";
}
if (!oldData.GuestId.Equals(data.GuestId))
{
sql = sql + "Guest_Id=@Guest_Id,";
}
if (!oldData.Xxxsave.Equals(data.Xxxsave))
{
sql = sql + "Xxxsave=@Xxxsave,";
}
if (!oldData.StartkitCategory.Equals(data.StartkitCategory))
{
sql = sql + "Startkit_Category=@Startkit_Category,";
}
if (!oldData.GLPostedDate.Equals(data.GLPostedDate))
{
sql = sql + "GLPostedDate=@GLPostedDate,";
}
if (!oldData.Revenue.Equals(data.Revenue))
{
sql = sql + "Revenue=@Revenue,";
}
if (!oldData.DiscountAmount.Equals(data.DiscountAmount))
{
sql = sql + "DiscountAmount=@DiscountAmount,";
}
if (!oldData.QtyCanceled.Equals(data.QtyCanceled))
{
sql = sql + "QtyCanceled=@QtyCanceled,";
}
if (!oldData.CanceledDate.Equals(data.CanceledDate))
{
sql = sql + "CanceledDate=@CanceledDate,";
}
if (!oldData.ChargeForItem.Equals(data.ChargeForItem))
{
sql = sql + "ChargeForItem=@ChargeForItem,";
}
if (!oldData.ErrorCode.Equals(data.ErrorCode))
{
sql = sql + "ErrorCode=@ErrorCode,";
}
if (!oldData.ErrorDepartment.Equals(data.ErrorDepartment))
{
sql = sql + "ErrorDepartment=@ErrorDepartment,";
}
if (!oldData.WaitReturnBeginDate.Equals(data.WaitReturnBeginDate))
{
sql = sql + "WaitReturnBeginDate=@WaitReturnBeginDate,";
}
if (!oldData.WaitReturnDueDate.Equals(data.WaitReturnDueDate))
{
sql = sql + "WaitReturnDueDate=@WaitReturnDueDate,";
}
if (!oldData.WaitReturnReceivedDate.Equals(data.WaitReturnReceivedDate))
{
sql = sql + "WaitReturnReceivedDate=@WaitReturnReceivedDate,";
}
if (!oldData.ItemNotes.Equals(data.ItemNotes))
{
sql = sql + "ItemNotes=@ItemNotes,";
}
if (!oldData.SaveAsShipped.Equals(data.SaveAsShipped))
{
sql = sql + "SaveAsShipped=@SaveAsShipped,";
}
if (!oldData.PurchasedDate.Equals(data.PurchasedDate))
{
sql = sql + "PurchasedDate=@PurchasedDate,";
}
WhereClause w = new WhereClause();
w.And("Order_Detail_Id", data.OrderDetailId.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.OrderDetailId.Equals(data.OrderDetailId))
{
cmd.Parameters.Add(new SqlParameter("@Order_Detail_Id", SqlDbType.VarChar, 11, ParameterDirection.Input, false, 0, 0, "OrderDetailId", DataRowVersion.Proposed, data.OrderDetailId.DBValue));
}
if (!oldData.OrderNo.Equals(data.OrderNo))
{
cmd.Parameters.Add(new SqlParameter("@Orderno", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, "OrderNo", DataRowVersion.Proposed, data.OrderNo.DBValue));
}
if (!oldData.TypeOrd.Equals(data.TypeOrd))
{
cmd.Parameters.Add(new SqlParameter("@Type_Ord", SqlDbType.VarChar, 4, ParameterDirection.Input, false, 0, 0, "TypeOrd", DataRowVersion.Proposed, data.TypeOrd.DBValue));
}
if (!oldData.ItemId.Equals(data.ItemId))
{
cmd.Parameters.Add(new SqlParameter("@Item_Id", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "ItemId", DataRowVersion.Proposed, data.ItemId.DBValue));
}
if (!oldData.ItemDescrip.Equals(data.ItemDescrip))
{
cmd.Parameters.Add(new SqlParameter("@Item_Descrip", SqlDbType.VarChar, 60, ParameterDirection.Input, false, 0, 0, "ItemDescrip", DataRowVersion.Proposed, data.ItemDescrip.DBValue));
}
if (!oldData.BinNo.Equals(data.BinNo))
{
cmd.Parameters.Add(new SqlParameter("@Bin_No", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "BinNo", DataRowVersion.Proposed, data.BinNo.DBValue));
}
if (!oldData.QtyOrdered.Equals(data.QtyOrdered))
{
cmd.Parameters.Add(new SqlParameter("@Qty_Ordered", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyOrdered", DataRowVersion.Proposed, data.QtyOrdered.DBValue));
}
if (!oldData.QtyPicked.Equals(data.QtyPicked))
{
cmd.Parameters.Add(new SqlParameter("@Qty_Picked", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyPicked", DataRowVersion.Proposed, data.QtyPicked.DBValue));
}
if (!oldData.QtyShipped.Equals(data.QtyShipped))
{
cmd.Parameters.Add(new SqlParameter("@Qty_Shipped", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyShipped", DataRowVersion.Proposed, data.QtyShipped.DBValue));
}
if (!oldData.ShippingNo.Equals(data.ShippingNo))
{
cmd.Parameters.Add(new SqlParameter("@Shipping_No", SqlDbType.Float, 0, ParameterDirection.Input, false, 0, 0, "ShippingNo", DataRowVersion.Proposed, data.ShippingNo.DBValue));
}
if (!oldData.ItemPrice.Equals(data.ItemPrice))
{
cmd.Parameters.Add(new SqlParameter("@Item_Price", SqlDbType.Float, 0, ParameterDirection.Input, false, 0, 0, "ItemPrice", DataRowVersion.Proposed, data.ItemPrice.DBValue));
}
if (!oldData.Subtotal.Equals(data.Subtotal))
{
cmd.Parameters.Add(new SqlParameter("@Subtotal", SqlDbType.Float, 0, ParameterDirection.Input, false, 0, 0, "Subtotal", DataRowVersion.Proposed, data.Subtotal.DBValue));
}
if (!oldData.Personal.Equals(data.Personal))
{
cmd.Parameters.Add(new SqlParameter("@Personal", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "Personal", DataRowVersion.Proposed, !data.Personal.IsValid ? data.Personal.DBValue : data.Personal.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.TaxExempt.Equals(data.TaxExempt))
{
cmd.Parameters.Add(new SqlParameter("@Tax_Exempt", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "TaxExempt", DataRowVersion.Proposed, !data.TaxExempt.IsValid ? data.TaxExempt.DBValue : data.TaxExempt.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.TaxExemptNo.Equals(data.TaxExemptNo))
{
cmd.Parameters.Add(new SqlParameter("@Tax_Exempt_No", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "TaxExemptNo", DataRowVersion.Proposed, data.TaxExemptNo.DBValue));
}
if (!oldData.ShipDate.Equals(data.ShipDate))
{
cmd.Parameters.Add(new SqlParameter("@Ship_Date", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "ShipDate", DataRowVersion.Proposed, data.ShipDate.DBValue));
}
if (!oldData.Kit.Equals(data.Kit))
{
cmd.Parameters.Add(new SqlParameter("@Kit", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Kit", DataRowVersion.Proposed, data.Kit.DBValue));
}
if (!oldData.GuestIdOld.Equals(data.GuestIdOld))
{
cmd.Parameters.Add(new SqlParameter("@Guest_Id_Old", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "GuestIdOld", DataRowVersion.Proposed, data.GuestIdOld.DBValue));
}
if (!oldData.ComponentId.Equals(data.ComponentId))
{
cmd.Parameters.Add(new SqlParameter("@Component_Id", SqlDbType.Char, 11, ParameterDirection.Input, false, 0, 0, "ComponentId", DataRowVersion.Proposed, data.ComponentId.DBValue));
}
if (!oldData.GuestId.Equals(data.GuestId))
{
cmd.Parameters.Add(new SqlParameter("@Guest_Id", SqlDbType.VarChar, 7, ParameterDirection.Input, false, 0, 0, "GuestId", DataRowVersion.Proposed, data.GuestId.DBValue));
}
if (!oldData.Xxxsave.Equals(data.Xxxsave))
{
cmd.Parameters.Add(new SqlParameter("@Xxxsave", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Xxxsave", DataRowVersion.Proposed, data.Xxxsave.DBValue));
}
if (!oldData.StartkitCategory.Equals(data.StartkitCategory))
{
cmd.Parameters.Add(new SqlParameter("@Startkit_Category", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "StartkitCategory", DataRowVersion.Proposed, data.StartkitCategory.DBValue));
}
if (!oldData.GLPostedDate.Equals(data.GLPostedDate))
{
cmd.Parameters.Add(new SqlParameter("@GLPostedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "GLPostedDate", DataRowVersion.Proposed, data.GLPostedDate.DBValue));
}
if (!oldData.Revenue.Equals(data.Revenue))
{
cmd.Parameters.Add(new SqlParameter("@Revenue", SqlDbType.Money, 0, ParameterDirection.Input, false, 0, 0, "Revenue", DataRowVersion.Proposed, data.Revenue.DBValue));
}
if (!oldData.DiscountAmount.Equals(data.DiscountAmount))
{
cmd.Parameters.Add(new SqlParameter("@DiscountAmount", SqlDbType.Money, 0, ParameterDirection.Input, false, 0, 0, "DiscountAmount", DataRowVersion.Proposed, data.DiscountAmount.DBValue));
}
if (!oldData.QtyCanceled.Equals(data.QtyCanceled))
{
cmd.Parameters.Add(new SqlParameter("@QtyCanceled", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "QtyCanceled", DataRowVersion.Proposed, data.QtyCanceled.DBValue));
}
if (!oldData.CanceledDate.Equals(data.CanceledDate))
{
cmd.Parameters.Add(new SqlParameter("@CanceledDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "CanceledDate", DataRowVersion.Proposed, data.CanceledDate.DBValue));
}
if (!oldData.ChargeForItem.Equals(data.ChargeForItem))
{
cmd.Parameters.Add(new SqlParameter("@ChargeForItem", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "ChargeForItem", DataRowVersion.Proposed, !data.ChargeForItem.IsValid ? data.ChargeForItem.DBValue : data.ChargeForItem.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.ErrorCode.Equals(data.ErrorCode))
{
cmd.Parameters.Add(new SqlParameter("@ErrorCode", SqlDbType.VarChar, 4, ParameterDirection.Input, false, 0, 0, "ErrorCode", DataRowVersion.Proposed, data.ErrorCode.DBValue));
}
if (!oldData.ErrorDepartment.Equals(data.ErrorDepartment))
{
cmd.Parameters.Add(new SqlParameter("@ErrorDepartment", SqlDbType.VarChar, 3, ParameterDirection.Input, false, 0, 0, "ErrorDepartment", DataRowVersion.Proposed, data.ErrorDepartment.DBValue));
}
if (!oldData.WaitReturnBeginDate.Equals(data.WaitReturnBeginDate))
{
cmd.Parameters.Add(new SqlParameter("@WaitReturnBeginDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "WaitReturnBeginDate", DataRowVersion.Proposed, data.WaitReturnBeginDate.DBValue));
}
if (!oldData.WaitReturnDueDate.Equals(data.WaitReturnDueDate))
{
cmd.Parameters.Add(new SqlParameter("@WaitReturnDueDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "WaitReturnDueDate", DataRowVersion.Proposed, data.WaitReturnDueDate.DBValue));
}
if (!oldData.WaitReturnReceivedDate.Equals(data.WaitReturnReceivedDate))
{
cmd.Parameters.Add(new SqlParameter("@WaitReturnReceivedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "WaitReturnReceivedDate", DataRowVersion.Proposed, data.WaitReturnReceivedDate.DBValue));
}
if (!oldData.ItemNotes.Equals(data.ItemNotes))
{
cmd.Parameters.Add(new SqlParameter("@ItemNotes", SqlDbType.VarChar, 8000, ParameterDirection.Input, false, 0, 0, "ItemNotes", DataRowVersion.Proposed, data.ItemNotes.DBValue));
}
if (!oldData.SaveAsShipped.Equals(data.SaveAsShipped))
{
cmd.Parameters.Add(new SqlParameter("@SaveAsShipped", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "SaveAsShipped", DataRowVersion.Proposed, !data.SaveAsShipped.IsValid ? data.SaveAsShipped.DBValue : data.SaveAsShipped.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.PurchasedDate.Equals(data.PurchasedDate))
{
cmd.Parameters.Add(new SqlParameter("@PurchasedDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "PurchasedDate", DataRowVersion.Proposed, data.PurchasedDate.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(AllEmployeeWithGroupInfoViewData data)
{
// Create and execute the command
AllEmployeeWithGroupInfoViewData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.OrgEmployeesID.Equals(data.OrgEmployeesID))
{
sql = sql + "OrgEmployeesID=@OrgEmployeesID,";
}
if (!oldData.FirstName.Equals(data.FirstName))
{
sql = sql + "FirstName=@FirstName,";
}
if (!oldData.LastName.Equals(data.LastName))
{
sql = sql + "LastName=@LastName,";
}
if (!oldData.EmployeeTitle.Equals(data.EmployeeTitle))
{
sql = sql + "EmployeeTitle=@EmployeeTitle,";
}
if (!oldData.DepartmentName.Equals(data.DepartmentName))
{
sql = sql + "DepartmentName=@DepartmentName,";
}
if (!oldData.LocationName.Equals(data.LocationName))
{
sql = sql + "LocationName=@LocationName,";
}
if (!oldData.PhoneNumber.Equals(data.PhoneNumber))
{
sql = sql + "PhoneNumber=@PhoneNumber,";
}
if (!oldData.PhoneDescription.Equals(data.PhoneDescription))
{
sql = sql + "PhoneDescription=@PhoneDescription,";
}
if (!oldData.Email.Equals(data.Email))
{
sql = sql + "Email=@Email,";
}
if (!oldData.DateHired.Equals(data.DateHired))
{
sql = sql + "DateHired=@DateHired,";
}
if (!oldData.DateTerminated.Equals(data.DateTerminated))
{
sql = sql + "DateTerminated=@DateTerminated,";
}
if (!oldData.Manager.Equals(data.Manager))
{
sql = sql + "Manager=@Manager,";
}
if (!oldData.EmployeeNumber.Equals(data.EmployeeNumber))
{
sql = sql + "EmployeeNumber=@EmployeeNumber,";
}
if (!oldData.Style.Equals(data.Style))
{
sql = sql + "Style=@Style,";
}
if (!oldData.IsActive.Equals(data.IsActive))
{
sql = sql + "IsActive=@IsActive,";
}
if (!oldData.NTUserAccount.Equals(data.NTUserAccount))
{
sql = sql + "NTUserAccount=@NTUserAccount,";
}
WhereClause w = new WhereClause();
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.OrgEmployeesID.Equals(data.OrgEmployeesID))
{
cmd.Parameters.Add(new SqlParameter("@OrgEmployeesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgEmployeesID", DataRowVersion.Proposed, data.OrgEmployeesID.DBValue));
}
if (!oldData.FirstName.Equals(data.FirstName))
{
cmd.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "FirstName", DataRowVersion.Proposed, data.FirstName.DBValue));
}
if (!oldData.LastName.Equals(data.LastName))
{
cmd.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "LastName", DataRowVersion.Proposed, data.LastName.DBValue));
}
if (!oldData.EmployeeTitle.Equals(data.EmployeeTitle))
{
cmd.Parameters.Add(new SqlParameter("@EmployeeTitle", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "EmployeeTitle", DataRowVersion.Proposed, data.EmployeeTitle.DBValue));
}
if (!oldData.DepartmentName.Equals(data.DepartmentName))
{
cmd.Parameters.Add(new SqlParameter("@DepartmentName", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "DepartmentName", DataRowVersion.Proposed, data.DepartmentName.DBValue));
}
if (!oldData.LocationName.Equals(data.LocationName))
{
cmd.Parameters.Add(new SqlParameter("@LocationName", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "LocationName", DataRowVersion.Proposed, data.LocationName.DBValue));
}
if (!oldData.PhoneNumber.Equals(data.PhoneNumber))
{
cmd.Parameters.Add(new SqlParameter("@PhoneNumber", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, "PhoneNumber", DataRowVersion.Proposed, data.PhoneNumber.DBValue));
}
if (!oldData.PhoneDescription.Equals(data.PhoneDescription))
{
cmd.Parameters.Add(new SqlParameter("@PhoneDescription", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "PhoneDescription", DataRowVersion.Proposed, data.PhoneDescription.DBValue));
}
if (!oldData.Email.Equals(data.Email))
{
cmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "Email", DataRowVersion.Proposed, data.Email.DBValue));
}
if (!oldData.DateHired.Equals(data.DateHired))
{
cmd.Parameters.Add(new SqlParameter("@DateHired", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateHired", DataRowVersion.Proposed, data.DateHired.DBValue));
}
if (!oldData.DateTerminated.Equals(data.DateTerminated))
{
cmd.Parameters.Add(new SqlParameter("@DateTerminated", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateTerminated", DataRowVersion.Proposed, data.DateTerminated.DBValue));
}
if (!oldData.Manager.Equals(data.Manager))
{
cmd.Parameters.Add(new SqlParameter("@Manager", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Manager", DataRowVersion.Proposed, data.Manager.DBValue));
}
if (!oldData.EmployeeNumber.Equals(data.EmployeeNumber))
{
cmd.Parameters.Add(new SqlParameter("@EmployeeNumber", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "EmployeeNumber", DataRowVersion.Proposed, data.EmployeeNumber.DBValue));
}
if (!oldData.Style.Equals(data.Style))
{
cmd.Parameters.Add(new SqlParameter("@Style", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Style", DataRowVersion.Proposed, data.Style.DBValue));
}
if (!oldData.IsActive.Equals(data.IsActive))
{
cmd.Parameters.Add(new SqlParameter("@IsActive", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsActive", DataRowVersion.Proposed, !data.IsActive.IsValid ? data.IsActive.DBValue : data.IsActive.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.NTUserAccount.Equals(data.NTUserAccount))
{
cmd.Parameters.Add(new SqlParameter("@NTUserAccount", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "NTUserAccount", DataRowVersion.Proposed, data.NTUserAccount.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(WebConfigData data)
{
// Create and execute the command
WebConfigData oldData = Load(data.WebConfigID);
string sql = "Update " + TABLE + " set ";
if (!oldData.CreateDate.Equals(data.CreateDate))
{
sql = sql + "CreateDate=@CreateDate,";
}
if (!oldData.LeftNavBGColor.Equals(data.LeftNavBGColor))
{
sql = sql + "LeftNavBGColor=@LeftNavBGColor,";
}
if (!oldData.HeaderTextColor.Equals(data.HeaderTextColor))
{
sql = sql + "HeaderTextColor=@HeaderTextColor,";
}
if (!oldData.MainPic.Equals(data.MainPic))
{
sql = sql + "MainPic=@MainPic,";
}
if (!oldData.LeftNavPic.Equals(data.LeftNavPic))
{
sql = sql + "LeftNavPic=@LeftNavPic,";
}
if (!oldData.Active.Equals(data.Active))
{
sql = sql + "Active=@Active,";
}
WhereClause w = new WhereClause();
w.And("WebConfigID", data.WebConfigID.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTERNET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.WebConfigID.Equals(data.WebConfigID))
{
cmd.Parameters.Add(new SqlParameter("@WebConfigID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "WebConfigID", DataRowVersion.Proposed, data.WebConfigID.DBValue));
}
if (!oldData.CreateDate.Equals(data.CreateDate))
{
cmd.Parameters.Add(new SqlParameter("@CreateDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "CreateDate", DataRowVersion.Proposed, data.CreateDate.DBValue));
}
if (!oldData.LeftNavBGColor.Equals(data.LeftNavBGColor))
{
cmd.Parameters.Add(new SqlParameter("@LeftNavBGColor", SqlDbType.NVarChar, 12, ParameterDirection.Input, false, 0, 0, "LeftNavBGColor", DataRowVersion.Proposed, data.LeftNavBGColor.DBValue));
}
if (!oldData.HeaderTextColor.Equals(data.HeaderTextColor))
{
cmd.Parameters.Add(new SqlParameter("@HeaderTextColor", SqlDbType.NVarChar, 12, ParameterDirection.Input, false, 0, 0, "HeaderTextColor", DataRowVersion.Proposed, data.HeaderTextColor.DBValue));
}
if (!oldData.MainPic.Equals(data.MainPic))
{
cmd.Parameters.Add(new SqlParameter("@MainPic", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "MainPic", DataRowVersion.Proposed, data.MainPic.DBValue));
}
if (!oldData.LeftNavPic.Equals(data.LeftNavPic))
{
cmd.Parameters.Add(new SqlParameter("@LeftNavPic", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "LeftNavPic", DataRowVersion.Proposed, data.LeftNavPic.DBValue));
}
if (!oldData.Active.Equals(data.Active))
{
cmd.Parameters.Add(new SqlParameter("@Active", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "Active", DataRowVersion.Proposed, !data.Active.IsValid ? data.Active.DBValue : data.Active.DBValue.Equals("Y") ? 1 : 0));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(NewsArticlesData data)
{
// Create and execute the command
NewsArticlesData oldData = Load(data.NewsArticlesID);
string sql = "Update " + TABLE + " set ";
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
sql = sql + "OrgGroupsID=@OrgGroupsID,";
}
if (!oldData.Title.Equals(data.Title))
{
sql = sql + "Title=@Title,";
}
if (!oldData.Summary.Equals(data.Summary))
{
sql = sql + "Summary=@Summary,";
}
if (!oldData.Text.Equals(data.Text))
{
sql = sql + "Text=@Text,";
}
if (!oldData.DateCreated.Equals(data.DateCreated))
{
sql = sql + "DateCreated=@DateCreated,";
}
if (!oldData.DateModified.Equals(data.DateModified))
{
sql = sql + "DateModified=@DateModified,";
}
if (!oldData.DateStart.Equals(data.DateStart))
{
sql = sql + "DateStart=@DateStart,";
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
sql = sql + "DateEnd=@DateEnd,";
}
if (!oldData.OrgEmployeesID.Equals(data.OrgEmployeesID))
{
sql = sql + "OrgEmployeesID=@OrgEmployeesID,";
}
if (!oldData.IsArchived.Equals(data.IsArchived))
{
sql = sql + "IsArchived=@IsArchived,";
}
if (!oldData.AllowDiscussion.Equals(data.AllowDiscussion))
{
sql = sql + "AllowDiscussion=@AllowDiscussion,";
}
if (!oldData.IsNew.Equals(data.IsNew))
{
sql = sql + "IsNew=@IsNew,";
}
if (!oldData.IsPublic.Equals(data.IsPublic))
{
sql = sql + "IsPublic=@IsPublic,";
}
if (!oldData.LastModifiedOrgEmployeesID.Equals(data.LastModifiedOrgEmployeesID))
{
sql = sql + "LastModifiedOrgEmployeesID=@LastModifiedOrgEmployeesID,";
}
if (!oldData.NewsImage.Equals(data.NewsImage))
{
sql = sql + "NewsImage=@NewsImage,";
}
if (!oldData.TemplateType.Equals(data.TemplateType))
{
sql = sql + "TemplateType=@TemplateType,";
}
WhereClause w = new WhereClause();
w.And("NewsArticlesID", data.NewsArticlesID.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.NewsArticlesID.Equals(data.NewsArticlesID))
{
cmd.Parameters.Add(new SqlParameter("@NewsArticlesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "NewsArticlesID", DataRowVersion.Proposed, data.NewsArticlesID.DBValue));
}
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
}
if (!oldData.Title.Equals(data.Title))
{
cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Title", DataRowVersion.Proposed, data.Title.DBValue));
}
if (!oldData.Summary.Equals(data.Summary))
{
cmd.Parameters.Add(new SqlParameter("@Summary", SqlDbType.VarChar, 500, ParameterDirection.Input, false, 0, 0, "Summary", DataRowVersion.Proposed, data.Summary.DBValue));
}
if (!oldData.Text.Equals(data.Text))
{
cmd.Parameters.Add(new SqlParameter("@Text", SqlDbType.Text, 0, ParameterDirection.Input, false, 0, 0, "Text", DataRowVersion.Proposed, data.Text.DBValue));
}
if (!oldData.DateCreated.Equals(data.DateCreated))
{
cmd.Parameters.Add(new SqlParameter("@DateCreated", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateCreated", DataRowVersion.Proposed, data.DateCreated.DBValue));
}
if (!oldData.DateModified.Equals(data.DateModified))
{
cmd.Parameters.Add(new SqlParameter("@DateModified", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateModified", DataRowVersion.Proposed, data.DateModified.DBValue));
}
if (!oldData.DateStart.Equals(data.DateStart))
{
cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
}
if (!oldData.OrgEmployeesID.Equals(data.OrgEmployeesID))
{
cmd.Parameters.Add(new SqlParameter("@OrgEmployeesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgEmployeesID", DataRowVersion.Proposed, data.OrgEmployeesID.DBValue));
}
if (!oldData.IsArchived.Equals(data.IsArchived))
{
cmd.Parameters.Add(new SqlParameter("@IsArchived", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsArchived", DataRowVersion.Proposed, !data.IsArchived.IsValid ? data.IsArchived.DBValue : data.IsArchived.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.AllowDiscussion.Equals(data.AllowDiscussion))
{
cmd.Parameters.Add(new SqlParameter("@AllowDiscussion", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "AllowDiscussion", DataRowVersion.Proposed, !data.AllowDiscussion.IsValid ? data.AllowDiscussion.DBValue : data.AllowDiscussion.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.IsNew.Equals(data.IsNew))
{
cmd.Parameters.Add(new SqlParameter("@IsNew", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsNew", DataRowVersion.Proposed, !data.IsNew.IsValid ? data.IsNew.DBValue : data.IsNew.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.IsPublic.Equals(data.IsPublic))
{
cmd.Parameters.Add(new SqlParameter("@IsPublic", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsPublic", DataRowVersion.Proposed, !data.IsPublic.IsValid ? data.IsPublic.DBValue : data.IsPublic.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.LastModifiedOrgEmployeesID.Equals(data.LastModifiedOrgEmployeesID))
{
cmd.Parameters.Add(new SqlParameter("@LastModifiedOrgEmployeesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "LastModifiedOrgEmployeesID", DataRowVersion.Proposed, data.LastModifiedOrgEmployeesID.DBValue));
}
if (!oldData.NewsImage.Equals(data.NewsImage))
{
cmd.Parameters.Add(new SqlParameter("@NewsImage", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "NewsImage", DataRowVersion.Proposed, data.NewsImage.DBValue));
}
if (!oldData.TemplateType.Equals(data.TemplateType))
{
cmd.Parameters.Add(new SqlParameter("@TemplateType", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "TemplateType", DataRowVersion.Proposed, data.TemplateType.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static void Update(KnowledgebasesArticleTextData data)
{
// Create and execute the command
KnowledgebasesArticleTextData oldData = Load(data.KnowledgebasesArticlesTextID);
string sql = "Update " + TABLE + " set ";
if (!oldData.KnowledgebasesSectionsArticlesID.Equals(data.KnowledgebasesSectionsArticlesID))
{
sql = sql + "KnowledgebasesSectionsArticlesID=@KnowledgebasesSectionsArticlesID,";
}
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
sql = sql + "KnowledgebasesID=@KnowledgebasesID,";
}
if (!oldData.Text.Equals(data.Text))
{
sql = sql + "Text=@Text,";
}
if (!oldData.StartDate.Equals(data.StartDate))
{
sql = sql + "StartDate=@StartDate,";
}
if (!oldData.EndDate.Equals(data.EndDate))
{
sql = sql + "EndDate=@EndDate,";
}
if (!oldData.Keywords.Equals(data.Keywords))
{
sql = sql + "Keywords=@Keywords,";
}
WhereClause w = new WhereClause();
w.And("KnowledgebasesArticlesTextID", data.KnowledgebasesArticlesTextID.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.KnowledgebasesArticlesTextID.Equals(data.KnowledgebasesArticlesTextID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesArticlesTextID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesArticlesTextID", DataRowVersion.Proposed, data.KnowledgebasesArticlesTextID.DBValue));
}
if (!oldData.KnowledgebasesSectionsArticlesID.Equals(data.KnowledgebasesSectionsArticlesID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesSectionsArticlesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesSectionsArticlesID", DataRowVersion.Proposed, data.KnowledgebasesSectionsArticlesID.DBValue));
}
if (!oldData.KnowledgebasesID.Equals(data.KnowledgebasesID))
{
cmd.Parameters.Add(new SqlParameter("@KnowledgebasesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "KnowledgebasesID", DataRowVersion.Proposed, data.KnowledgebasesID.DBValue));
}
if (!oldData.Text.Equals(data.Text))
{
cmd.Parameters.Add(new SqlParameter("@Text", SqlDbType.Text, 0, ParameterDirection.Input, false, 0, 0, "Text", DataRowVersion.Proposed, data.Text.DBValue));
}
if (!oldData.StartDate.Equals(data.StartDate))
{
cmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "StartDate", DataRowVersion.Proposed, data.StartDate.DBValue));
}
if (!oldData.EndDate.Equals(data.EndDate))
{
cmd.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "EndDate", DataRowVersion.Proposed, data.EndDate.DBValue));
}
if (!oldData.Keywords.Equals(data.Keywords))
{
cmd.Parameters.Add(new SqlParameter("@Keywords", SqlDbType.VarChar, 300, ParameterDirection.Input, false, 0, 0, "Keywords", DataRowVersion.Proposed, data.Keywords.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}