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