public static void RemoveStock(string argStockCode, string argUserId)
{
string query = "EXEC spRemoveUserStock @argCode = '" + argStockCode + "'" +
", @argUserId = '" + argUserId + "'";
SQLAdapter.Execute(query);
}
public static void SaveLog(string argLogMessage, string argUsername = "******")
{
string lcQuery = "EXEC spSaveLog @argLogMessage = '" +
argLogMessage + "'" +
", @argUsername = '******'";
SQLAdapter.Execute(lcQuery);
}
public static void SaveUser(string argUsername, string argPassword)
{
string query = "EXEC spSaveUser @argId = '" +
SecurityHelper.CreateMD5(argUsername + argPassword + Constants.UserIdPrivateSecurityKey) + "'" +
", @argUserName = '******'" +
", @argPassword = '******'";
SQLAdapter.Execute(query);
}
public static void RemoveUser(string argUserId)
{
string query = "DELETE FROM tblUsers WHERE Id = '" + argUserId + "'";
SQLAdapter.Execute(query);
}