public RegisterUserCode HashClearTextPassword(string UserName)
{
BorrowerDAL dal = new BorrowerDAL(_connection);
Borrower b = dal.BorrowerFindByName(UserName);
if (b == null)
{
return(RegisterUserCode.UserNameNotFound);
}
BorrowerSecuredDAL sdal = new BorrowerSecuredDAL(_connection);
BorrowerSecured sb = sdal.BorrowerSecuredFindByID(b.BorrowerID);
if (sb == null)
{
return(RegisterUserCode.SecuredDataNotFound);
}
// when using cleartext the SALT Field contains "ClearText" instead of salt
// the cleartext password in in HASH
if (sb.Salt == "ClearText")
{
string salt = System.Web.Helpers.Crypto.GenerateSalt(20);
// when using cleartext, the HASH field contains the cleartext password
string pw = sb.Hash + salt;
string hash = System.Web.Helpers.Crypto.HashPassword(pw);
sdal.BorrowerSecuredUpdateJust(b.BorrowerID, hash, salt);
}
else
{
return(RegisterUserCode.SecuredAlready);
}
return(RegisterUserCode.Success);
}
public RegisterUserCode RegisterUser(string UserName, string EMail,
DateTime DOB, string Password)
{
BorrowerDAL dal = new BorrowerDAL(_connection);
Borrower theBorrower = dal.BorrowerFindByName(UserName);
if (theBorrower != null)
{
return(RegisterUserCode.UserNameExists);
}
theBorrower = dal.BorrowerFindByEmail(EMail);
if (theBorrower != null)
{
return(RegisterUserCode.EMailExists);
}
int BorrowerID = dal.BorrowerCreate(UserName, EMail, DOB, MagicConstants.DefaultRole);
BorrowerSecuredDAL securedDal = new BorrowerSecuredDAL(_connection);
string salt = System.Web.Helpers.Crypto.GenerateSalt(20);
string hashed = System.Web.Helpers.Crypto.HashPassword(Password + salt);
securedDal.BorrowerSecuredUpdateJust(BorrowerID, hashed, salt);
return(RegisterUserCode.Success);
}
public int BorrowerCreate(
string Name,
string EMail,
DateTime?DOB,
int RoleID)
{
BorrowerDAL dal = new BorrowerDAL(_connection);
return(dal.BorrowerCreate(Name, EMail, DOB, RoleID));
}
public int BorrowerUpdateJust(
int BorrowerID,
string Name,
string EMail,
DateTime?DOB,
int RoleID)
{
BorrowerDAL dal = new BorrowerDAL(_connection);
return(dal.BorrowerUpdateJust(BorrowerID, Name, EMail, DOB, RoleID));
}
public int BorrowerUpdateSafe(
int BorrowerID,
string oldName,
string oldEMail,
DateTime?oldDOB,
int oldRoleID,
string newName,
string newEMail,
DateTime?newDOB,
int newRoleID)
{
BorrowerDAL dal = new BorrowerDAL(_connection);
return(dal.BorrowerUpdateSafe(BorrowerID,
oldName, oldEMail, oldDOB, oldRoleID,
newName, newEMail, newDOB, newRoleID));
}
public void BorrowerTest()
{
// arrange
BorrowerDAL dal = new BorrowerDAL(MagicSetup.Connection);
// act create
int rv1 = dal.BorrowerCreate("Test1", "Email", null, 1);
Assert.IsTrue(rv1 > 0, $"BorrowerCreate failed rv = {rv1}");
Borrower a = dal.BorrowerFindByID(rv1);
Assert.IsNotNull(a, $"BorrowerFindByID for ID {rv1} (just created) returned null");
Assert.IsTrue(a.BorrowerName == "Test1", $"BorrowerName was expected to be 'Test1' but found {a.BorrowerName}");
Assert.IsFalse(a.BorrowerDOB.HasValue, $"BorrowerDOB was expected to be null, but had a value");
Assert.IsTrue(a.RoleID == 1, $"Borrowerroleid was expected to be '1' but was actually '{a.RoleID}'");
int countofBorrowers = dal.BorrowerObtainCount();
Assert.IsTrue(countofBorrowers > 0, $"BorrowersObtainCount should be greater than 0 it is {countofBorrowers}");
List <Borrower> Borrowers = dal.BorrowersGetAll();
Assert.IsTrue(Borrowers.Count == countofBorrowers, $"BorrowersGetAll should have brought back {countofBorrowers} records, but it only found {Borrowers.Count}");
DateTime now = DateTime.Now;
int number = dal.BorrowerUpdateJust(rv1, "Test1New", "EMail1", now, 2);
Assert.IsTrue(number == 1, $"BorrowerUpdateJust was expected to return 1, but actually returned {number}");
a = dal.BorrowerFindByID(rv1);
Assert.IsNotNull(a, $"BorrowerFindByID for ID {rv1} (just updated) returned null");
Assert.IsTrue(a.BorrowerName == "Test1New", $"BorrowerName after update was expected to be 'Test1New' but was actually '{a.BorrowerName}'");
Assert.IsTrue(a.BorrowerDOB.HasValue, "BorrowerDOB was expected to have a value, but was null");
Assert.IsTrue(a.RoleID == 2, $"BorrowerRoleID was expected to be 'newLocation1' but was actually '{a.RoleID}'");
number = dal.BorrowerUpdateSafe(rv1, "Test1New", "EMail1", now, 2, "1", "EMail2", null, 3);
Assert.IsTrue(number == 1, $"BorrowerUpdateSafe was expected to return 1 but actually returned {number}");
a = dal.BorrowerFindByID(rv1);
Assert.IsNotNull(a, $"BorrowerFindByID for ID {rv1} (just safe updated) returned null");
Assert.IsTrue(a.BorrowerName == "1", $"Borrowername after safeupdate was expected to be '1', but was '{a.BorrowerName}");
Assert.IsFalse(a.BorrowerDOB.HasValue, $"BorrowerDOB after safeupdate was expected to be null, but was not");
Assert.IsTrue(a.RoleID == 3, $"BorrowerRoleID after saftupdate was expected to be '3' but was actually '{a.RoleID}'");
number = dal.BorrowerUpdateSafe(rv1, "1", "EMail2", now, 2, "3", "EMail3", null, 4);
Assert.IsTrue(number == 0, $"Borrowerupdatesafe was expected to return 0, but it actually returned {number}");
dal.BorrowerDelete(rv1);
}
public IController CreateController(System.Web.Routing.RequestContext requestContext, string controllerName)
{
Type controllerType = Type.GetType(string.Concat(_controllerNamespace, ".", controllerName, "Controller"));
dynamic service = new CustomerProductDAL();
switch (controllerName)
{
case "CustomerProducts":
{
service = new CustomerProductDAL();
break;
}
case "Orders":
{
service = new OrderDAL();
break;
}
case "Home":
{
service = new DashBoardDAL();
break;
}
case "Categories":
{
service = new CategoryDAL();
break;
}
case "Products":
{
service = new ProductDAL();
break;
}
case "BulkBuys":
{
service = new BulkBuyDAL();
break;
}
case "Buyers":
{
service = new BuyerDAL();
break;
}
case "Sellers":
{
service = new SellerDAL();
break;
}
case "Borrowers":
{
service = new BorrowerDAL();
break;
}
case "ProductTypes":
{
service = new ProductTypeDAL();
break;
}
case "Customers":
{
service = new CustomerDAL();
break;
}
case "Account":
{
service = new AccountDAL();
break;
}
case "Manage":
{
service = new ManageDAL();
break;
}
case "Vendors":
{
service = new VendorDAL();
break;
}
}
IController controller = Activator.CreateInstance(controllerType, new[] { service }) as Controller;
return(controller);
}
public void BorrowerDelete(int BorrowerID)
{
BorrowerDAL dal = new BorrowerDAL(_connection);
dal.BorrowerDelete(BorrowerID);
}
public List <Borrower> BorrowerGetAll(int skip = 0, int take = 0)
{
BorrowerDAL dal = new BorrowerDAL(_connection);
return(dal.BorrowersGetAll(skip, take));
}
public Borrower BorrowerFindByID(int BorrowerID)
{
BorrowerDAL dal = new BorrowerDAL(_connection);
return(dal.BorrowerFindByID(BorrowerID));
}
