public User GetSigningUserByEmail(string emailAddress)
{
try
{
using (CraveatsDbContext craveatsDbContext = new CraveatsDbContext())
{
DBCommonUtility dBCommonUtility = new DBCommonUtility();
string sqlCmdParamString = "";
SqlParameter[] sqlParameters = dBCommonUtility.GetSqlParameters(
new object[] {
emailAddress
},
out sqlCmdParamString
, true);
StringBuilder sbRawSQL = new StringBuilder("exec GetSigningUserByEmail");
sbRawSQL.AppendFormat(" {0}", sqlCmdParamString.Trim());
User newUser = craveatsDbContext.User.SqlQuery(
sql: sbRawSQL.ToString(),
parameters: sqlParameters
).FirstOrDefault();
return(newUser);
}
}
catch (Exception e) {
throw e;
}
}
internal int?RegisterNew(string email, string hashedPassword, string role)
{
try {
Common.UserTypeEnum registeringRole = Common.CommonUtility.GetEnumValueFromDescription <Common.UserTypeEnum>(role);
if (!(registeringRole.HasFlag(Common.UserTypeEnum.CraveatsDiner) ||
registeringRole.HasFlag(Common.UserTypeEnum.PartnerRestaurant)))
{
throw new InvalidOperationException("Requested role could not be used in this context.");
}
using (CraveatsDbContext craveatsDbContext = new CraveatsDbContext()) {
DBCommonUtility dBCommonUtility = new DBCommonUtility();
string sqlCmdParamString = "";
SqlParameter[] sqlParameters = dBCommonUtility.GetSqlParameters(
new object[] {
email,
hashedPassword,
(int)registeringRole
},
out sqlCmdParamString
, true);
StringBuilder sbRawSQL = new StringBuilder("exec RegisterNewActiveUser");
sbRawSQL.AppendFormat(" {0}", sqlCmdParamString.Trim());
User newUser = craveatsDbContext.User.SqlQuery(
sql: sbRawSQL.ToString(),
parameters: sqlParameters
).FirstOrDefault();
return(newUser?.Id);
}
}
catch (Exception e) {
throw e;
}
}
private static SessionTracking EditSessionTracking(SessionTracking sessionTracking)
{
SessionTracking savedSessionTracking = null;
try
{
using (CraveatsDbContext craveatsDbContext = new CraveatsDbContext()) {
DBCommonUtility dBCommonUtility = new DBCommonUtility();
string sqlCmdParamString = "";
SqlParameter[] sqlParameters = dBCommonUtility.GetSqlParameters(
new object[] {
sessionTracking.SessionID,
sessionTracking.IPAddress,
sessionTracking.UserId,
null,
sessionTracking.LoggedInAt,
sessionTracking.LoggedOutAt
},
out sqlCmdParamString
, true);
StringBuilder sbRawSQL = new StringBuilder("exec EditSessionTracking");
sbRawSQL.AppendFormat(" {0}", sqlCmdParamString.Trim());
savedSessionTracking = craveatsDbContext.Database.SqlQuery <SessionTracking>(
sql: sbRawSQL.ToString(),
parameters: sqlParameters
).FirstOrDefault();
}
}
catch (Exception exception)
{
throw exception;
}
return(savedSessionTracking);
}
