public static object AddNewAdmin(RequestModel request)
{
// Setup the connection and compiler
var connection = new MySqlConnection(ConfigurationManager.AppSettings["MySqlDBConn"].ToString());
var compiler = new MySqlCompiler();
var db = new QueryFactory(connection, compiler);
SuccessResponse successResponseModel = new SuccessResponse();
db.Connection.Open();
using (var scope = db.Connection.BeginTransaction())
{
try
{
var test = JsonConvert.DeserializeObject <Dictionary <string, dynamic> >(Convert.ToString(request.RequestData));
//check if email exists
object Email;
test.TryGetValue("AdmUserId", out Email);
string _Email = Email.ToString();
var response = db.Query("Admin").Where("AdmUserId", _Email).Get();
if (response != null && response.Count() > 0)
{
//return error
return(new SuccessResponse(null, HttpStatusCode.Conflict, "Admin already exists"));
}
object Password;
test.TryGetValue("Password", out Password);
string _Password = Password.ToString();
test.Remove("Password");
if (!string.IsNullOrEmpty(_Password))
{
//convert and add key
_Password = DBManagerUtility._encodeJWT(new Dictionary <string, string>()
{
{ "Password", _Password }
}, AppConstants.AppSecretKeyPassword);
test.Add("Password", _Password);
}
var resRegUser = db.Query("Admin").Insert(test);
scope.Commit();
bool hasData = true;//(response != null) ? true : false;
successResponseModel = new SuccessResponse("", hasData);
}
catch (Exception ex)
{
//Logger.WriteErrorLog(ex);
scope.Rollback();
return(new ErrorResponse(ex.Message, HttpStatusCode.BadRequest));
}
}
return(successResponseModel);
}
private object ValidateRequest(RequestModel request)
{
if (request == null || request.RequestMethod == null)
{
return(new ErrorResponse(Constants.Failure, HttpStatusCode.BadRequest));
}
else if (request.RequestMethod == "" /*Constants.GetOneTimeCode*/)// || request.RequestMethod == Constants.GetApplicationParameter)
{
// request.TokenHeader = StringConstants.Key.JWTSecretToken;
if (request.TokenHeader != Constants.JWTSecretToken)
{
return(new ErrorResponse(Constants.TokenInvalidSignature, HttpStatusCode.BadRequest));
}
object jsonJWT = DBManagerUtility.decodeJWT(request.TokenHeader);
if (jsonJWT.GetType() == typeof(ErrorResponse))
{
ErrorResponse error = (ErrorResponse)jsonJWT;
return(new ErrorResponse(error.ErrorMessage, error.ErrorCode));
}
return(jsonJWT);
}
else
{
if (request.TokenHeader == null)
{
return(new ErrorResponse(Constants.TokenInvalidSignature, HttpStatusCode.BadRequest));
//return ApiFailure("{}", StringConstants.Message.TokenInvalidSignature, HttpStatusCode.BadRequest, "null");
}
else
{
object jsonJWT = DBManagerUtility.decodeJWT(request.TokenHeader);
if (jsonJWT.GetType() == typeof(ErrorResponse))
{
ErrorResponse error = (ErrorResponse)jsonJWT;
return(new ErrorResponse(error.ErrorMessage, error.ErrorCode));
//return ApiFailure("{}", error.ErrorMessage, error.ErrorCode, "null");
}
if (ValidateToken(jsonJWT, request.RequestData, request.TokenHeader, request.RequestMethod))
{
return(jsonJWT);
}
else
{
//Logger._log.Error("API - Token Validation Failed: " + request.RequestMethod + "\n" + request.TokenHeader);
return(new ErrorResponse(Constants.TokenInvalidSignature, HttpStatusCode.BadRequest));
}
// return jsonJWT;
}
}
//return request;
}
public static object ValidateUser(string username, string password, string type)
{
// Setup the connection and compiler
var connection = new MySqlConnection(ConfigurationManager.AppSettings["MySqlDBConn"].ToString());
var compiler = new MySqlCompiler();
var db = new QueryFactory(connection, compiler);
try
{
password = DBManagerUtility._encodeJWT(new Dictionary <string, string>()
{
{ "Password", password }
}, AppConstants.AppSecretKeyPassword);
// You can register the QueryFactory in the IoC container
if (type == "USER")
{
object response = db.Query("User").Where(q => q.Where("Email", username).OrWhere("Username", username))
.Where("Password", password)
.Where("RegistrationConfirmation", "Y").First();
var strResponse = response.ToString().Replace("DapperRow,", "").Replace("=", ":");
Dictionary <string, string> temp = JsonConvert.DeserializeObject <Dictionary <string, string> >(strResponse);
return(temp);
}
else if (type == "ADMIN")
{
object response = db.Query("Admin").Where("AdmUserId", username).Where("Password", password).First();
var strResponse = response.ToString().Replace("DapperRow,", "").Replace("=", ":");
Dictionary <string, string> temp = JsonConvert.DeserializeObject <Dictionary <string, string> >(strResponse);
return(temp);
}
else
{
return(null);
}
}
catch (Exception)
{
//Logger.WriteErrorLog(ex);
//return new ErrorResponse(ex.Message, HttpStatusCode.BadRequest);
return(null);
}
}
public static object SendVerificationEmail(RequestModel request)
{
var test = JsonConvert.DeserializeObject <Dictionary <string, dynamic> >(Convert.ToString(request.RequestData));
SuccessResponse successResponseModel = new SuccessResponse();
try
{
if (test != null)
{
object Url;
test.TryGetValue("Url", out Url);
string _Url = Url.ToString();
object Email;
test.TryGetValue("Email", out Email);
string _Email = Email.ToString();
string encodedEmail = DBManagerUtility._encodeJWT(new Dictionary <string, string>()
{
{ "Email", _Email }
}, AppConstants.AppSecretLinkObject);
string link = Url + "?q=" + encodedEmail;
successResponseModel = new SuccessResponse(link, HttpStatusCode.OK, "Email sent successfully");
}
else
{
successResponseModel = new SuccessResponse(null, HttpStatusCode.BadRequest, "Object is null");
}
}
catch (Exception ex)
{
return(new ErrorResponse(ex.Message, HttpStatusCode.BadRequest));
}
return(successResponseModel);
}
public static object AddNewRegUser(RequestModel request)
{
// Setup the connection and compiler
var connection = new MySqlConnection(ConfigurationManager.AppSettings["MySqlDBConn"].ToString());
var compiler = new MySqlCompiler();
var db = new QueryFactory(connection, compiler);
SuccessResponse successResponseModel = new SuccessResponse();
db.Connection.Open();
using (var scope = db.Connection.BeginTransaction())
{
try
{
var test = JsonConvert.DeserializeObject <Dictionary <string, dynamic> >(Convert.ToString(request.RequestData));
object User;
test.TryGetValue("User", out User);
test.Remove("User");
object Document_SOE;
test.TryGetValue("Document_SOE", out Document_SOE);
List <string> _Document_SOE = Document_SOE as List <string>;
test.Remove("Document_SOE");
if (_Document_SOE != null && _Document_SOE.Count > 0)
{
//convert and add key
}
if (User != null)
{
Dictionary <string, object> _User = JsonConvert.DeserializeObject <Dictionary <string, object> >(User.ToString());
//check if email exists
object Email;
_User.TryGetValue("Email", out Email);
string _Email = Email.ToString();
var response = db.Query("User").Where("Email", _Email).Get();
if (response != null && response.Count() > 0)
{
//return error
return(new SuccessResponse(null, HttpStatusCode.Conflict, "Email already exists"));
}
object Password;
_User.TryGetValue("Password", out Password);
string _Password = Password.ToString();
string _PasswordUnhashed = Password.ToString();
_User.Remove("Password");
if (!string.IsNullOrEmpty(_Password))
{
//convert and add key
_Password = DBManagerUtility._encodeJWT(new Dictionary <string, string>()
{
{ "Password", _Password }
}, AppConstants.AppSecretKeyPassword);
_User.Add("Password", _Password);
}
_User.Add("RegistrationConfirmation", "Y");
_User.Add("isVerified", "N");
var query = db.Query("User").AsInsert(_User);
SqlKata.SqlResult compiledQuery = compiler.Compile(query);
//Inject the Identity in the Compiled Query SQL object
var sql = compiledQuery.Sql + "; SELECT @@IDENTITY as ID;";
//Name Binding house the values that the insert query needs
var IdentityKey = db.Select <string>(sql, compiledQuery.NamedBindings).FirstOrDefault();
test.Add("UserId", IdentityKey);
var resRegUser = db.Query("RegisteredUser").Insert(test);
scope.Commit();
//testing
Dictionary <string, string> responseData = new Dictionary <string, string>();
#region issue AuthToken
var pairs = new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("grant_type", "password"),
new KeyValuePair <string, string>("username", _Email),
new KeyValuePair <string, string> ("Password", _PasswordUnhashed),
new KeyValuePair <string, string> ("scope", "USER")
};
var content = new FormUrlEncodedContent(pairs);
ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true;
using (var client = new HttpClient())
{
var responseToken = client.PostAsync(Constants.BaseUrl + "token", content).Result;
var responseContent = responseToken.Content.ReadAsStringAsync().Result;
responseData = JsonConvert.DeserializeObject <Dictionary <string, string> >(responseContent);
}
#endregion
bool hasData = true;
successResponseModel = new SuccessResponse(responseData, hasData);
}
else
{
scope.Rollback();
}
}
catch (Exception ex)
{
//Logger.WriteErrorLog(ex);
scope.Rollback();
return(new ErrorResponse(ex.Message, HttpStatusCode.BadRequest));
}
}
return(successResponseModel);
}
public static object Verify(RequestModel request)
{
var test = JsonConvert.DeserializeObject <Dictionary <string, object> >(Convert.ToString(request.RequestData));
var connection = new MySqlConnection(ConfigurationManager.AppSettings["MySqlDBConn"].ToString());
var compiler = new MySqlCompiler();
var db = new QueryFactory(connection, compiler);
SuccessResponse successResponseModel = new SuccessResponse();
try
{
if (test != null)
{
object Token;
test.TryGetValue("Token", out Token);
string _Token = Token.ToString();
var obj = JsonConvert.DeserializeObject <Dictionary <string, object> >(DBManagerUtility._decodeJWT(_Token, AppConstants.AppSecretLinkObject) as string);
object Type;
test.TryGetValue("Type", out Type);
string _Type = Type.ToString();
object Email;
obj.TryGetValue("Email", out Email);
string _Email = Email.ToString();
var response = db.Query("User").Where("Email", _Email).First();
if (response != null)
{
if (_Type == "FPASS")
{
object newPassword;
test.TryGetValue("Password", out newPassword);
string _newPassword = newPassword.ToString();
_newPassword = DBManagerUtility._encodeJWT(new Dictionary <string, string>()
{
{ "Password", _newPassword }
}, AppConstants.AppSecretKeyPassword);
var resUser = db.Query("User").Where("Email", _Email).Update(new
{
Password = _newPassword
});
successResponseModel = new SuccessResponse(null, HttpStatusCode.OK, "Password Updated");
}
else if (_Type == "VERIFY")
{
var resUser = db.Query("User").Where("Email", _Email).Update(new
{
isVerified = "Y"
});
successResponseModel = new SuccessResponse(null, HttpStatusCode.OK, "User Verified");
}
else
{
successResponseModel = new SuccessResponse(null, HttpStatusCode.BadRequest, "Invalid Type");
}
}
else
{
successResponseModel = new SuccessResponse(null, HttpStatusCode.BadRequest, "Invalid Email");
}
}
else
{
successResponseModel = new SuccessResponse(null, HttpStatusCode.BadRequest, "Object is null");
}
}
catch (Exception ex)
{
return(new ErrorResponse(ex.Message, HttpStatusCode.BadRequest));
}
return(successResponseModel);
}
