public static bool Member_ActiveMember(string userName, string eMail)
{
string cmdSql = string.Format("UPDATE {0} SET ACTIVE = 'Y' WHERE USER_NAME='{1}' AND EMAIL='{2}'", TABLE_MEMBER, userName, eMail);
MySqlDbAccess.ExecuteNonQueryInt(cmdSql, false);
return(true);
}
public static int Member_Register(clsMember m)
{
MySqlInsert ins = new MySqlInsert(TABLE_MEMBER);
foreach (var prop in m.GetType().GetProperties())
{
ins.Add(prop.Name, prop.GetValue(m, null));
}
string cmdSql = ins.ToString();
return(MySqlDbAccess.ExecuteNonQueryInt(cmdSql, false));
}
public static int Painter_SaveStep(clsPainter p)
{
MySqlInsert ins = new MySqlInsert(TABLE_PAINTER);
foreach (var prop in p.GetType().GetProperties())
{
ins.Add(prop.Name, prop.GetValue(p, null));
}
string cmdSql = ins.ToString();
return(MySqlDbAccess.ExecuteNonQueryInt(cmdSql, false));
}
public static int Member_Update(clsMember m)
{
MySqlUpdate update = new MySqlUpdate(TABLE_MEMBER);
foreach (var prop in m.GetType().GetProperties())
{
update.Add(prop.Name, prop.GetValue(m, null));
}
update.Remove("verify");
string cmdSql = update.ToString() + " WHERE USER_NAME='" + m.user_name + "'";
return(MySqlDbAccess.ExecuteNonQueryInt(cmdSql, false));
}
