private void InitializeComponent() { WebConfigData config = new WebConfigData(); config.LoadSettings(Server.MapPath("config\\VsWebServiceApp.config")); DBconn = new VsDbMysqlConnect(config.data["HostIP"], config.data["ConnectionString"]); }
private void InitializeComponent() { WebConfigData config = new WebConfigData(); config.LoadSettings(Server.MapPath("config\\VsWebServiceApp.config")); DBconn = new VsDbMysqlConnect(config.data["HostIP"], config.data["ConnectionString"]); }
public string getConfig() { WebConfigData config = new WebConfigData(); config.LoadSettings(Server.MapPath("config\\VsWebServiceApp.config")); return(config.data["HostIP"] + config.data["ConnectionString"]); }
public static WebConfigData Load(IdType webConfigID) { WhereClause w = new WhereClause(); w.And("WebConfigID", webConfigID.DBValue); SqlDataReader dataReader = GetListReader(DatabaseEnum.INTERNET, TABLE, w, null, true); if (!dataReader.Read()) { dataReader.Close(); throw new FinderException("Load found no rows for WebConfig."); } WebConfigData data = GetDataObjectFromReader(dataReader); dataReader.Close(); return(data); }
public static WebConfigData FindActiveEntry(DateType createDate, BooleanType active) { OrderByClause sort = new OrderByClause("CreateDate, Active"); WhereClause filter = new WhereClause(); filter.And("CreateDate", createDate.DBValue); filter.And("Active", !active.IsValid ? active.DBValue : active.DBValue.Equals("Y") ? 1 : 0); SqlDataReader dataReader = GetListReader(DatabaseEnum.INTERNET, TABLE, filter, sort, true); if (!dataReader.Read()) { dataReader.Close(); throw new FinderException("WebConfigData.FindActiveEntry found no rows."); } WebConfigData data = GetDataObjectFromReader(dataReader); dataReader.Close(); return(data); }
public static IdType Insert(WebConfigData data) { // Create and execute the command string sql = "Insert Into " + TABLE + "(" + "CreateDate," + "LeftNavBGColor," + "HeaderTextColor," + "MainPic," + "LeftNavPic," + "Active," ; sql = sql.Substring(0, sql.Length - 1) + ") values(" + "@CreateDate," + "@LeftNavBGColor," + "@HeaderTextColor," + "@MainPic," + "@LeftNavPic," + "@Active," ; sql = sql.Substring(0, sql.Length - 1) + ");select Scope_Identity() Id"; SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTERNET, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object cmd.Parameters.Add(new SqlParameter("@CreateDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "CreateDate", DataRowVersion.Proposed, data.CreateDate.DBValue)); cmd.Parameters.Add(new SqlParameter("@LeftNavBGColor", SqlDbType.NVarChar, 12, ParameterDirection.Input, false, 0, 0, "LeftNavBGColor", DataRowVersion.Proposed, data.LeftNavBGColor.DBValue)); cmd.Parameters.Add(new SqlParameter("@HeaderTextColor", SqlDbType.NVarChar, 12, ParameterDirection.Input, false, 0, 0, "HeaderTextColor", DataRowVersion.Proposed, data.HeaderTextColor.DBValue)); cmd.Parameters.Add(new SqlParameter("@MainPic", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "MainPic", DataRowVersion.Proposed, data.MainPic.DBValue)); cmd.Parameters.Add(new SqlParameter("@LeftNavPic", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "LeftNavPic", DataRowVersion.Proposed, data.LeftNavPic.DBValue)); 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 SqlDataReader returnValue = cmd.ExecuteReader(); returnValue.Read(); int returnId = (int)(returnValue.GetDecimal(0)); returnValue.Close(); // Set the output paramter value(s) return(new IdType(returnId)); }
public string getConfig() { WebConfigData config = new WebConfigData(); config.LoadSettings(Server.MapPath("config\\VsWebServiceApp.config")); return config.data["HostIP"] + config.data["ConnectionString"]; }
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(); } }
private static WebConfigData GetDataObjectFromReader(SqlDataReader dataReader) { WebConfigData data = new WebConfigData(); if (dataReader.IsDBNull(dataReader.GetOrdinal("WebConfigID"))) { data.WebConfigID = IdType.UNSET; } else { data.WebConfigID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("WebConfigID"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("CreateDate"))) { data.CreateDate = DateType.UNSET; } else { data.CreateDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("CreateDate"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("LeftNavBGColor"))) { data.LeftNavBGColor = StringType.UNSET; } else { data.LeftNavBGColor = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LeftNavBGColor"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("HeaderTextColor"))) { data.HeaderTextColor = StringType.UNSET; } else { data.HeaderTextColor = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("HeaderTextColor"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("MainPic"))) { data.MainPic = StringType.UNSET; } else { data.MainPic = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("MainPic"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("LeftNavPic"))) { data.LeftNavPic = StringType.UNSET; } else { data.LeftNavPic = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LeftNavPic"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Active"))) { data.Active = BooleanType.UNSET; } else { data.Active = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("Active"))); } return(data); }