public ActionResult Register(Accounts acc)
{
if (ModelState.IsValid)
{
var db = new ConstructionEntities();
var row = new Users();
row.Username = acc.Username;
row.Password = acc.Password;
row.ConfirmPass = acc.ConfirmPass;
row.FirstName = acc.FirstName;
row.LastName = acc.LastName;
row.Email = acc.Email;
row.Phone = acc.Phone;
//row.Admin = false;
db.Users.Add(row);
var rowsCount = db.SaveChanges();
ModelState.Clear();
Session["userId"] = row.Id.ToString();
Session["user"] = row.Username.ToString();
return(RedirectToAction("Welcome", "Home"));
//ViewBag.Message = acc.Username + " has been successfully registered";
// return Redirect("/home/index");
}
return(View(acc));
}
public void SetUp()
{
//arrange
_db = new ConstructionEntities();
//act
PropertyNames = (from prop in _db.dimProperties select prop.PropName).ToList();
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new UnitRenovationRepository(_entities);
_deleteTarget = _entities.UnitRenoes.Where(r => r.OrigCompletionDate == null).ToList()[0];
Func<Contexts.UnitReno, bool> expression = (r => r.hUnitRenoGrp == _deleteTarget.hUnitRenoGrp && r.hUnit == _deleteTarget.hUnit);
_target.Delete(expression);
_results = _entities.UnitRenoes.Where(expression);
}
public ActionResult Reference(References rf)
{
var DbContext = new ConstructionEntities();
var row = new Reference();
row.Reference1 = rf.Reference;
row.Referee = rf.Referee;
DbContext.Reference.Add(row);
var rowsCount = DbContext.SaveChanges();
return(RedirectToAction("Reference", "Reference"));
}
public ActionResult playtime()
{
var context = new ConstructionEntities();
var container = new ConstructionPrice();
//this will return multiple rows eg dispaly all users in the company
var listOfQuotes = new List <ConstructionPrice>();
listOfQuotes = context.ConstructionPrice.ToList();
var vm = new TestVM();
vm.list = listOfQuotes;
return(View(vm));
}
public void Context()
{
_newGrp = new UnitRenoGrp
{
hProp = 23,
RenoGrpName = "when_deleting_existing",
RenoGrpDesc = "Test description",
LeadContractor = "Test Lead Contractor"
};
_entities = new ConstructionEntities();
_target = new UnitRenovationGroupRepository(_entities);
Func<UnitRenoGrp, bool> existingEntityExpression = (existingGrp =>
existingGrp.RenoGrpName == _newGrp.RenoGrpName &&
existingGrp.hProp == _newGrp.hProp &&
existingGrp.RenoGrpDesc == _newGrp.RenoGrpDesc &&
existingGrp.LeadContractor == _newGrp.LeadContractor);
//remove existing data context
var existing = _entities.UnitRenoGrps.Where(existingEntityExpression).ToList();
if (existing.Any())
{
existing.ForEach(rg =>
{
_entities.UnitRenoGrps.Attach(rg);
_entities.UnitRenoGrps.Remove(rg);
});
_entities.SaveChanges();
}
//create a new entity to delete
_entities.UnitRenoGrps.Add(_newGrp);
_entities.SaveChanges();
var saveTarget = _entities.UnitRenoGrps.Where(existingEntityExpression).ToList()[0];
saveTarget.ArchiveFlag = true;
//delete the entity
_target.Delete(existingEntityExpression);
_result = _entities.UnitRenoGrps.Where(existingEntityExpression).ToList()[0];
}
public ActionResult ConstructionBuilder()
{
//this will return 1 row from db with id 0f 2
var context = new ConstructionEntities();
var container = new ConstructionPrice();
container = context.ConstructionPrice.Where(m => m.Id == 2).FirstOrDefault();
//this will return multiple rows eg dispaly all users in the company
var listOfQuotes = new List <ConstructionPrice>();
listOfQuotes = context.ConstructionPrice.ToList();
var vm = new ConWork();
return(View(vm));
}
public ActionResult Login(Accounts user)
{
//using (MyDbContext db = new MyDbContext())
//{
var context = new ConstructionEntities();
var row = new Users();
row = context.Users.Where(u => u.Username == user.Username).Where(u => u.Password == user.Password).FirstOrDefault();
if (row != null)
{
Session["userId"] = row.Id.ToString();
Session["user"] = row.Username.ToString();
return(RedirectToAction("Welcome", "Home"));
}
else
{
ModelState.AddModelError("", "Username or Password is incorrect");
}
return(View());
//}
}
public ActionResult Reference()
{
//this will return 1 row from db with id 0f 2
var context = new ConstructionEntities();
var container = new Reference();
container = context.Reference.Where(m => m.Id == 1).FirstOrDefault();
//this will return multiple rows eg dispaly all users in the company
var listOfRefs = new List <Reference>();
listOfRefs = context.Reference.ToList();
var vm = new RefVM();
vm.list = listOfRefs;
return(View(vm));
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new AppSettingRepository(_entities);
_results = _target.Retrieve(setting => setting.key == "ApplicationCaption").ToList();
}
public ActionResult ConstructionBuilder(ConWork vm)
{
var DbContext = new ConstructionEntities();
var row = new ConstructionPrice();
decimal DemCostPrice = 50;
decimal SiteClearCost = 50;
vm.PreConTotal = (vm.DemMetre * DemCostPrice) + (vm.SiteClearMetre * SiteClearCost);
decimal SubStruc = 120;
vm.StructureCost = (vm.FloorLength * SubStruc) * vm.Stories;
decimal BuildSize = vm.FloorLength * vm.Stories;
decimal Walls;
//int Roof = 100;
if (vm.ExternalWall == "brick")
{
Walls = 450 * BuildSize;
}
else if (vm.ExternalWall == "stone")
{
Walls = 500 * BuildSize;
}
else if (vm.ExternalWall == "wood")
{
Walls = 325 * BuildSize;
}
else
{
Walls = 0;
}
vm.SuperStructCost = Walls; //+ (Roof + vm.RoofStructure);
decimal door = 400;
decimal window = 600;
decimal Rooftiles;
if (vm.RoofTiles == "crt")
{
Rooftiles = 500 * vm.FloorLength;
}
else if (vm.RoofTiles == "nsrt")
{
Rooftiles = 700 * vm.FloorLength;
}
else if (vm.RoofTiles == "crt2")
{
Rooftiles = 550 * vm.FloorLength;
}
else if (vm.RoofTiles == "asrt")
{
Rooftiles = 400 * vm.FloorLength;
}
else
{
Rooftiles = 0;
}
vm.ExternalCost = (door * vm.NoDoors) + (window * vm.NoWindows) + Rooftiles;
decimal plumbingCost;
decimal heatingCost;
decimal electricCost;
decimal plasteringCost;
decimal decorCost;
if (vm.Plumbing == true)
{
plumbingCost = 100 * BuildSize;
}
else
{
plumbingCost = 0;
}
if (vm.Heating == true)
{
heatingCost = 100 * BuildSize;
}
else
{
heatingCost = 0;
}
if (vm.Electrics == true)
{
electricCost = 100 * BuildSize;
}
else
{
electricCost = 0;
}
if (vm.Plastering == true)
{
plasteringCost = 100 * BuildSize;
}
else
{
plasteringCost = 0;
}
if (vm.Decor == true)
{
decorCost = 100 * BuildSize;
}
else
{
decorCost = 0;
}
decimal PatioCost = 50;
decimal DriveWayCost = 50;
vm.ServicesCost = plumbingCost + heatingCost + electricCost + plasteringCost + decorCost + (PatioCost * vm.PatioMetre) + (DriveWayCost * vm.DriveWayMetre);
vm.Extra = 250 * BuildSize;
vm.TotalCost = vm.PreConTotal + vm.StructureCost + vm.SuperStructCost + vm.ExternalCost + vm.ServicesCost + vm.Extra;
row.Demolition = vm.Demolition;
row.DemMetre = vm.DemMetre;
row.SiteClear = vm.SiteClear;
row.SiteClearMetre = vm.SiteClearMetre;
row.PreConTotal = vm.PreConTotal;
row.Stories = vm.Stories;
row.FloorLength = vm.FloorLength;
row.StructureCost = vm.StructureCost;
row.ExternalWall = vm.ExternalWall;
row.RoofStructure = vm.RoofStructure;
row.SuperStructCost = vm.SuperStructCost;
row.RoofTiles = vm.RoofTiles;
row.NoDoors = vm.NoDoors;
row.NoWindows = vm.NoWindows;
row.ExternalCost = vm.ExternalCost;
row.Plumbing = vm.Plumbing;
row.Heating = vm.Heating;
row.Electrics = vm.Electrics;
row.Plastering = vm.Plastering;
row.Decor = vm.Decor;
row.Patio = vm.Patio;
row.PatioMetre = vm.PatioMetre;
row.DriveWay = vm.DriveWay;
row.DriveWayMetre = vm.DriveWayMetre;
row.ServicesCost = vm.ServicesCost;
row.Extra = vm.Extra;
row.TotalCost = vm.TotalCost;
int UserVal = Convert.ToInt32(Session["userId"]);
row.UserId = UserVal;
DbContext.ConstructionPrice.Add(row);
var rowsCount = DbContext.SaveChanges();
return(RedirectToAction("ConstructionBuilderSummary", "ConstructionSummary"));
//return View(vm);
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new UnitRenovationGroupRepository(_entities);
_results = _target.Retrieve(rg => rg.ArchiveFlag != true).ToList();
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new UserToPropRepository(_entities);
_results = _target.Retrieve(relation => relation.AdminFlag).ToList();
}
public void Context()
{
var newRenovation = new Contexts.UnitReno
{
hUnitRenoGrp = 1,
hUnit = 16,
EstPrice = 1500
};
_unitRenovations = new List<Contexts.UnitReno> {newRenovation};
_entities = new ConstructionEntities();
//remove existing context before test run
if (_entities.UnitRenoes.Any(existingRenovation =>
existingRenovation.hUnitRenoGrp == newRenovation.hUnitRenoGrp
&& existingRenovation.hUnit == newRenovation.hUnit))
{
_entities.UnitRenoes.Attach(newRenovation);
_entities.UnitRenoes.Remove(newRenovation);
_entities.SaveChanges();
}
_target = new UnitRenovationRepository(_entities);
_target.Save(_unitRenovations);
_results = _target.Retrieve((r => r.EstPrice == newRenovation.EstPrice)).ToList();
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new UnitRenovationRepository(_entities);
_updateTarget = _entities.UnitRenoes.Where(r => r.OrigCompletionDate != null).ToList()[0];
_originalPrice = _updateTarget.EstPrice;
_updateTarget.EstPrice += 1;
_target.Save(new List<Contexts.UnitReno> { _updateTarget });
_result = _entities.UnitRenoes.Where(r => r.hUnitRenoGrp == _updateTarget.hUnitRenoGrp && r.hUnit == _updateTarget.hUnit).ToList().First();
}
public void Context()
{
var newGrp = new UnitRenoGrp
{
hProp = 1,
RenoGrpName = "when_saving_new",
RenoGrpDesc = "Test description",
LeadContractor = "Test Lead Contractor"
};
var newGroups = new List<UnitRenoGrp> { newGrp };
Func<UnitRenoGrp, bool> expression =
(existingGrp => existingGrp.RenoGrpName == newGrp.RenoGrpName &&
existingGrp.hProp == newGrp.hProp &&
existingGrp.RenoGrpDesc == newGrp.RenoGrpDesc &&
existingGrp.LeadContractor == newGrp.LeadContractor &&
existingGrp.ArchiveFlag == newGrp.ArchiveFlag);
_entities = new ConstructionEntities();
//remove existing context before test run
var existing = _entities.UnitRenoGrps.Where(expression).ToList();
if (existing.Any())
{
existing.ForEach(rg =>
{
_entities.UnitRenoGrps.Attach(rg);
_entities.UnitRenoGrps.Remove(rg);
});
_entities.SaveChanges();
}
_target = new UnitRenovationGroupRepository(_entities);
_target.Save(newGroups);
_result = _target.Retrieve(expression).ToList()[0];
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new UserRepository(_entities);
_results = _target.Retrieve(prop => prop.UserEmail != null).ToList();
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new UnitRenovationRepository(_entities);
_results = _target.Retrieve(reno => reno.OrigCompletionDate != null).ToList();
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new PropertyRepository(_entities);
_results = _target.Retrieve(prop => prop.NumUnits > 5).ToList();
}
public void Context()
{
_entities = new ConstructionEntities();
_target = new UnitInfoRepository(_entities);
_results = _target.Retrieve(unit => unit.GroupId == 2).ToList();
}
