public static void Insert(ControlEditData data) { // Create and execute the command string sql = "Insert Into " + TABLE + "(" + "IsBasic," + "Summary," + "Description," + "Src," + "IconImage," + "DisplayOnHomePage," + "SortOrder," + "ControlsID," + "ControlsGroupsID," + "OrgGroupID," + "ManagePage," + "EntireCompany," + "MustShow," ; sql = sql.Substring(0, sql.Length - 1) + ") values(" + "@IsBasic," + "@Summary," + "@Description," + "@Src," + "@IconImage," + "@DisplayOnHomePage," + "@SortOrder," + "@ControlsID," + "@ControlsGroupsID," + "@OrgGroupID," + "@ManagePage," + "@EntireCompany," + "@MustShow," ; sql = sql.Substring(0, sql.Length - 1) + ")"; SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object 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)); cmd.Parameters.Add(new SqlParameter("@Summary", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Summary", DataRowVersion.Proposed, data.Summary.DBValue)); cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue)); cmd.Parameters.Add(new SqlParameter("@Src", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Src", DataRowVersion.Proposed, data.Src.DBValue)); cmd.Parameters.Add(new SqlParameter("@IconImage", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "IconImage", DataRowVersion.Proposed, data.IconImage.DBValue)); 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)); cmd.Parameters.Add(new SqlParameter("@SortOrder", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SortOrder", DataRowVersion.Proposed, data.SortOrder.DBValue)); cmd.Parameters.Add(new SqlParameter("@ControlsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsID", DataRowVersion.Proposed, data.ControlsID.DBValue)); cmd.Parameters.Add(new SqlParameter("@ControlsGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsGroupsID", DataRowVersion.Proposed, data.ControlsGroupsID.DBValue)); cmd.Parameters.Add(new SqlParameter("@OrgGroupID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupID", DataRowVersion.Proposed, data.OrgGroupID.DBValue)); cmd.Parameters.Add(new SqlParameter("@ManagePage", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ManagePage", DataRowVersion.Proposed, data.ManagePage.DBValue)); 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)); 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 cmd.ExecuteNonQuery(); }
public static ControlEditData Load() { WhereClause w = new WhereClause(); SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true); if (!dataReader.Read()) { dataReader.Close(); throw new FinderException("Load found no rows for ControlEdit."); } ControlEditData data = GetDataObjectFromReader(dataReader); dataReader.Close(); return(data); }
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(); } }
private static ControlEditData GetDataObjectFromReader(SqlDataReader dataReader) { ControlEditData data = new ControlEditData(); if (dataReader.IsDBNull(dataReader.GetOrdinal("IsBasic"))) { data.IsBasic = BooleanType.UNSET; } else { data.IsBasic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsBasic"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Summary"))) { data.Summary = StringType.UNSET; } else { data.Summary = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Summary"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Description"))) { data.Description = StringType.UNSET; } else { data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Src"))) { data.Src = StringType.UNSET; } else { data.Src = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Src"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("IconImage"))) { data.IconImage = StringType.UNSET; } else { data.IconImage = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("IconImage"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("DisplayOnHomePage"))) { data.DisplayOnHomePage = BooleanType.UNSET; } else { data.DisplayOnHomePage = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("DisplayOnHomePage"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("SortOrder"))) { data.SortOrder = IntegerType.UNSET; } else { data.SortOrder = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SortOrder"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsID"))) { data.ControlsID = IntegerType.UNSET; } else { data.ControlsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsID"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsGroupsID"))) { data.ControlsGroupsID = IntegerType.UNSET; } else { data.ControlsGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsGroupsID"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupID"))) { data.OrgGroupID = IntegerType.UNSET; } else { data.OrgGroupID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupID"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("ManagePage"))) { data.ManagePage = StringType.UNSET; } else { data.ManagePage = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ManagePage"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("EntireCompany"))) { data.EntireCompany = BooleanType.UNSET; } else { data.EntireCompany = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("EntireCompany"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("MustShow"))) { data.MustShow = BooleanType.UNSET; } else { data.MustShow = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("MustShow"))); } return(data); }