public CffUserActivation ApproveUser(Guid mKey, Guid uKey)
{
ArgumentChecker.ThrowIfGuidEmpty(mKey, "mKey");
ArgumentChecker.ThrowIfGuidEmpty(uKey, "uKey");
CffUserActivation record = null;
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "ApproveUserAccess", CreateAccessActionParameter(mKey, uKey)))
{
CleverReader cleverReader = new CleverReader(dataReader);
while (cleverReader.Read())
{
int nStatus = cleverReader.ToInteger("Status");
if (nStatus > 0)
{ //valid - UKey must pickup from customer-id
record = new CffUserActivation(cleverReader.ToString("Name"), "", "", cleverReader.ToString("USERMAIL"), nStatus);
}
else
{ //invalid
record = new CffUserActivation("", "", "", "", nStatus);
}
}
}
}
return(record);
}
public CffUserActivation ActivateUser(Guid uid, String pKey)
{
ArgumentChecker.ThrowIfNull(pKey, "pKey");
ArgumentChecker.ThrowIfGuidEmpty(uid, "uid");
CffUserActivation record = null;
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "ActivateNewUser", CreateActivationParameter(uid, pKey)))
{
CleverReader cleverReader = new CleverReader(dataReader);
while (cleverReader.Read())
{
int nStatus = cleverReader.ToInteger("Status");
if (nStatus == 1)
{ //valid - UKey must pickup from customer-id
record = new CffUserActivation(cleverReader.ToString("Name"), cleverReader.ToString("MngtEmail"), cleverReader.ToGuid("UKey").ToString(), cleverReader.ToString("USERMAIL"), nStatus);
}
else
{ //invalid
record = new CffUserActivation("", "", "", "", nStatus);
}
}
}
}
return(record);
}
public CffUserActivation DeclineUser(Guid mKey, Guid uKey)
{
ArgumentChecker.ThrowIfGuidEmpty(mKey, "mKey");
ArgumentChecker.ThrowIfGuidEmpty(uKey, "uKey");
CffUserActivation record = null;
String userEmployeeName = "";
String userEmail = "";
using (SqlConnection connection = CreateConnection())
{
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "GetEmployeeDetailsByUID", CreateEmployeeParameter(uKey, "ALL")))
{
CleverReader cleverReader = new CleverReader(dataReader);
while (cleverReader.Read())
{
userEmployeeName = cleverReader.ToString("EmployeeName");
userEmail = cleverReader.ToString("EmailAddress");
}
}
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "DeclineUserAccess", CreateAccessActionParameter(mKey, uKey)))
{
CleverReader cleverReader = new CleverReader(dataReader);
while (cleverReader.Read())
{
int nStatus = cleverReader.ToInteger("Status");
if (nStatus >= 0)
{ //valid - UKey must pickup from customer-id
record = new CffUserActivation(userEmployeeName, "", "", userEmail, nStatus);
}
else
{ //invalid
record = new CffUserActivation("", "", "", "", nStatus);
}
}
}
}
return(record);
}
