/// <summary>
/// Updates an exsiting Page.
/// </summary>
public static void UpdateUserHis(UserHis his)
{
LoadProviders();
_provider.UpdateUserHis(his);
}
/// <summary>
/// Deletes the specified Page from the current provider.
/// </summary>
public static void DeleteUserHis(UserHis his)
{
LoadProviders();
_provider.DeleteUserHis(his);
}
/// <summary>
/// Persists a new Page in the current provider.
/// </summary>
public static void InsertUserHis(UserHis his)
{
LoadProviders();
_provider.InsertUserHis(his);
}
/// <summary>
/// Updates AuthorProfile to database
/// </summary>
/// <param name="profile"></param>
public override void UpdateUserHis(UserHis his)
{
//DeleteUserHis(his);
// Save
string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = connString;
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
string sqlQuery = "INSERT INTO " + tablePrefix + "UserHis (UserName,EventType,EventValue,EventDate,EventDes) " +
"VALUES (@user, @EventType,@EventValue,@EventDate,@EventDes)";
if (parmPrefix != "@")
sqlQuery = sqlQuery.Replace("@", parmPrefix);
cmd.CommandText = sqlQuery;
cmd.Parameters.Clear();
DbParameter dpUser = provider.CreateParameter();
dpUser.ParameterName = parmPrefix + "user";
dpUser.Value = his.Id;
cmd.Parameters.Add(dpUser);
DbParameter dpEventType = provider.CreateParameter();
dpEventType.ParameterName = parmPrefix + "EventType";
dpEventType.Value = his.EventType;
cmd.Parameters.Add(dpEventType);
DbParameter dpValue = provider.CreateParameter();
dpValue.ParameterName = parmPrefix + "EventValue";
dpValue.Value = his.EventValue;
cmd.Parameters.Add(dpValue);
DbParameter dpEventDate = provider.CreateParameter();
dpEventDate.ParameterName = parmPrefix + "EventDate";
dpEventDate.Value = his.EventDate;
cmd.Parameters.Add(dpEventDate);
DbParameter dpEventDes = provider.CreateParameter();
dpEventDes.ParameterName = parmPrefix + "EventDes";
dpEventDes.Value = his.EventDes;
cmd.Parameters.Add(dpEventDes);
cmd.ExecuteNonQuery();
}
}
}
/// <summary>
/// Remove AuthorProfile from database
/// </summary>
/// <param name="profile"></param>
public override void DeleteUserHis(UserHis his)
{
string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = connString;
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
string sqlQuery = "DELETE FROM " + tablePrefix + "UserHis " +
"WHERE UserName = "******"name";
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
DbParameter dpName = provider.CreateParameter();
dpName.ParameterName = parmPrefix + "name";
dpName.Value = his.Id;
cmd.Parameters.Add(dpName);
cmd.ExecuteNonQuery();
}
}
}
/// <summary>
/// Adds AuthorProfile to database
/// </summary>
/// <param name="profile"></param>
public override void InsertUserHis(UserHis his)
{
UpdateUserHis(his);
}
/// <summary>
/// Loads AuthorProfile from database
/// </summary>
/// <param name="id">username</param>
/// <returns></returns>
public override UserHis SelectUserHis(string id)
{
UserHis his = new UserHis(id);
// Retrieve Profile data from Db
string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = connString;
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
string sqlQuery = "SELECT EventType, EventValue,EventDate,EventDes FROM " + tablePrefix + "UserHis " +
"WHERE UserName = "******"name";
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
DbParameter dpName = provider.CreateParameter();
dpName.ParameterName = parmPrefix + "name";
dpName.Value = id;
cmd.Parameters.Add(dpName);
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
his.EventType = rdr.GetString(0);
his.EventValue = rdr.GetString(1);
his.EventDate = rdr.GetDateTime(2);
if (!rdr.IsDBNull(3))
{
his.EventDes = rdr.GetString(3);
}
}
}
}
}
return his;
}
/// <summary>
/// Updates an exsiting Page.
/// </summary>
public static void UpdateUserHis(UserHis his)
{
LoadProviders();
_provider.UpdateUserHis(his);
}
/// <summary>
/// Deletes the specified Page from the current provider.
/// </summary>
public static void DeleteUserHis(UserHis his)
{
LoadProviders();
_provider.DeleteUserHis(his);
}
/// <summary> /// Deletes a UserHis from the data store specified by the provider. /// </summary> public abstract void DeleteUserHis(UserHis his);
/// <summary>
/// Persists a new Page in the current provider.
/// </summary>
public static void InsertUserHis(UserHis his)
{
LoadProviders();
_provider.InsertUserHis(his);
}
/// <summary> /// Updates an existing UserHis in the data store specified by the provider. /// </summary> public abstract void UpdateUserHis(UserHis his);
/// <summary> /// Inserts a new UserHis into the data store specified by the provider. /// </summary> public abstract void InsertUserHis(UserHis his);
/// <summary> /// Deletes a UserHis from the data store specified by the provider. /// </summary> public abstract void DeleteUserHis(UserHis his);
/// <summary> /// Updates an existing UserHis in the data store specified by the provider. /// </summary> public abstract void UpdateUserHis(UserHis his);
/// <summary> /// Inserts a new UserHis into the data store specified by the provider. /// </summary> public abstract void InsertUserHis(UserHis his);
