public async Task <Boolean> RegisterCustomer(Customer customer)
{
var email = customer.Email;
customer.Pass_word = HashAndSalt.HashSalt(customer.Pass_word);
using (IDbConnection dbConnection = Connection)
{
string sQuery0 = "SELECT FirstName FROM Customer WHERE Email = @email";
dbConnection.Open();
String result = dbConnection.QueryFirstOrDefault <String>(sQuery0, new { @Email = email });
dbConnection.Close();
if (string.IsNullOrEmpty(result))
{
customer.VerifiCode = VerifiCodeGenarator.CreateRandomPassword();
customer.Validated = false;
string sQuery = "INSERT INTO Customer(FirstName,LastName,Pass_word,Email,MobileNo,VerifiCode,Validated)" +
"VALUES(@FirstName,@LastName,@Pass_word,@Email,@MobileNo,@VerifiCode,@Validated)";
dbConnection.Open();
//dbConnection.Execute(sQuery, new { customer.FirstName = FirstName , VerifiCode = vCode });
dbConnection.Execute(sQuery, customer);
Senders emailsender = new Senders();
await emailsender.SendEmailAsync("*****@*****.**", customer.VerifiCode);
return(true);
}
}
return(false);
}
public UserModel RegisterShopOwner(ShopOwner shopowner)
{
var email = shopowner.Email;
shopowner.Pass_word = HashAndSalt.HashSalt(shopowner.Pass_word);
using (IDbConnection dbConnection = Connection)
{
string sQuery0 = "SELECT FirstName FROM ShopOwner WHERE Email = @email";
dbConnection.Open();
String result = dbConnection.QueryFirstOrDefault <String>(sQuery0, new { @Email = email });
dbConnection.Close();
if (string.IsNullOrEmpty(result))
{
String VerifiCode = VerifiCodeGenarator.CreateRandomPassword();
shopowner.VerifiCode = VerifiCode;
shopowner.Validated = false;
string sQuery = "INSERT INTO ShopOwner(FirstName,LastName,Pass_word,Email,MobileNo,VerifiCode,Validated)" +
"VALUES(@FirstName,@LastName,@Pass_word,@Email,@MobileNo,@VerifiCode,@Validated)";
dbConnection.Open();
dbConnection.Execute(sQuery, shopowner);
dbConnection.Close();
SendMail(email, VerifiCode);
string sQuery1 = "SELECT ShopOwnerId from ShopOwner where Email = @email";
string ID = dbConnection.QueryFirstOrDefault <String>(sQuery1, new { @Email = email });
UserModel user = null;
user = new UserModel {
Id = ID, Name = shopowner.FirstName, Email = shopowner.Email
};
//String Token = BuildToken(user);
//return new OkObjectResult(new { token = Token });
return(user);
}
return(null);
}
/* var method = typeof(TokenCreator).GetMethod("createToken");
* var action = (Action<TokenCreator>)Delegate.CreateDelegate(typeof(Action<TokenCreator>), method);
* action(user);*/
//TokenCreator tokencreator = new TokenCreatorC();
//return tokencreator.createToken(user);
}
public async Task <IActionResult> RegisterRider(Rider rider)
{
long number;
var email = rider.Email;
rider.Pass_word = HashAndSalt.HashSalt(rider.Pass_word);
using (IDbConnection dbConnection = Connection)
{
string sQuery0 = "SELECT FirstName FROM Rider WHERE Email = @email";
dbConnection.Open();
String result = dbConnection.QueryFirstOrDefault <String>(sQuery0, new { @Email = email });
dbConnection.Close();
if (string.IsNullOrEmpty(result))
{
rider.VerifiCode = VerifiCodeGenarator.CreateRandomPassword();
rider.Validated = false;
string sQuery = "INSERT INTO Rider(FirstName,LastName,Pass_word,Email,MobileNo,VerifiCode,Validated,LicenseNo,Nic)" +
"VALUES(@FirstName,@LastName,@Pass_word,@Email,@MobileNo,@VerifiCode,@Validated,@LicenseNo,@Nic)";
dbConnection.Open();
dbConnection.Execute(sQuery, rider);
dbConnection.Close();
string sQuery1 = "SELECT RiderId FROM Rider WHERE Email = @email";
dbConnection.Open();
String result2 = dbConnection.QueryFirstOrDefault <String>(sQuery1, new { @Email = email });
number = Int64.Parse(result2);
Image toupload = new Image(rider.image, number);
Senders emailsender = new Senders();
await emailsender.SendEmail(email, rider.VerifiCode);
return(await UploadImage(toupload));
}
return(new ConflictResult());
}
}
