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