public List <Facility> GetUnassignedFacilities()
{
try
{
List <Facility> returnFacilities = new List <Facility>();
using (ApplicationUnit unit = new ApplicationUnit())
{
List <Facility> facilities = unit.Facilities.ExecuteStoredProc("GetUnassignedFacilities").ToList();
foreach (var facility in facilities)
{
returnFacilities.Add(new Facility
{
Id = facility.Id,
Name = facility.Name,
ClientCode = facility.ClientCode,
SettlementType = facility.SettlementType,
Zoning = facility.Zoning,
IDPicture = facility.IDPicture,
Status = facility.Status,
DeedsInfo = facility.DeedsInfo,
ResposiblePerson = facility.ResposiblePerson,
Location = facility.Location,
CreatedDate = facility.CreatedDate,
ModifiedDate = facility.ModifiedDate
});
}
return(returnFacilities);
}
}
catch (Exception ex)
{
ErrorHandling.LogError(ex.StackTrace, "GetUnassignedFacilities");
throw ex;
}
}
public Dictionary <string, string> GenerateAllReport()
{
//List<string> list = new List<string>();
Dictionary <string, string> dictionary = new Dictionary <string, string>();
FacilityReport facilityReport = new FacilityReport();
ApplicationUnit unit = new ApplicationUnit();
List <Facility> facilities = unit.Facilities.GetAll()
.Include(b => b.Buildings)
.Include(d => d.DeedsInfo)
.Include(c => c.Portfolio)
.Include(p => p.ResposiblePerson)
.Include(l => l.Location)
.ToList();
List <Facility> facilitiffes = facilities.Where(f => f.Status == "Submitted").ToList();
int i = 0;
foreach (var facility in facilitiffes)
{
if (i < 30)
{
Model.OriginalData dbOriginalData = unit.OriginalDatas.GetAll().Where(o => o.VENUS_CODE.Trim().ToLower() == facility.ClientCode.Trim().ToLower()).FirstOrDefault();
string facilityLocation = facilityReport.GenerateFacilityReport(facility, dbOriginalData);
dictionary.Add(facilityLocation, facility.ClientCode);
i++;
}
}
return(dictionary);
}
private List <Facility> GetSubmittedFacilities()
{
using (ApplicationUnit unit = new ApplicationUnit())
{
var dbfacilities = unit.Facilities.GetAll()
.Include(b => b.Buildings)
.Include(d => d.DeedsInfo)
.Include(p => p.ResposiblePerson)
.Include("Location.GPSCoordinates")
.Include("Location.BoundryPolygon")
.Where(ss => ss.Status == "Submitted")
.ToList();
List <Facility> facilities = new List <Facility>();
foreach (var item in dbfacilities)
{
facilities.Add(new Facility
{
ClientCode = item.ClientCode,
SettlementType = item.SettlementType,
Zoning = item.Zoning,
Region = item.Location.Region
});
}
return(facilities);
}
}
public string GenerateOneReport(string clientCode)
{
FacilityReport facilityReport = new FacilityReport();
ApplicationUnit unit = new ApplicationUnit();
List <Facility> facilities = unit.Facilities.GetAll()
.Include(b => b.Buildings)
.Include(d => d.DeedsInfo)
.Include(c => c.Portfolio)
.Include(p => p.ResposiblePerson)
.Include(l => l.Location)
.ToList();
Facility facility = facilities.Where(f => f.ClientCode.Trim().ToLower() == clientCode.Trim().ToLower()).FirstOrDefault();
Model.OriginalData dbOriginalData = unit.OriginalDatas.GetAll().Where(o => o.VENUS_CODE.Trim().ToLower() == facility.ClientCode.Trim().ToLower()).FirstOrDefault();
int i = 0;
if (facility != null)
{
string facilityLocation = facilityReport.GenerateFacilityReport(facility, dbOriginalData);
return(facilityLocation);
}
else
{
return(null);
}
}
public IEnumerable <Portfolio> GetPortfolios()
{
try
{
List <Portfolio> returnPortfolio = new List <Portfolio>();
using (ApplicationUnit unit = new ApplicationUnit())
{
IEnumerable <Portfolio> portfolios = unit.Portfolios.GetAll()
.Include(c => c.Client).Include(f => f.Facilities).ToList();
foreach (var portfolio in portfolios)
{
returnPortfolio.Add(new Portfolio
{
Client = portfolio.Client,
Id = portfolio.Id,
Name = portfolio.Name
});
}
return(returnPortfolio);
}
}
catch (Exception ex)
{
throw ex;
}
}
public Portfolio AddPortfolio(Portfolio portfolio)
{
try
{
using (ApplicationUnit unit = new ApplicationUnit())
{
Client client = unit.Clients.GetAll()
.FirstOrDefault(u => u.Id == portfolio.Client.Id);
Portfolio hasPortfolio = unit.Portfolios.GetAll()
.FirstOrDefault(u => u.Name.ToLower() == portfolio.Name.ToLower());
if (hasPortfolio == null)
{
portfolio.Client = client;
unit.Portfolios.Add(portfolio);
unit.SaveChanges();
return(portfolio);
}
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public Facility AddFacility(Facility facility)
{
try
{
using (ApplicationUnit unit = new ApplicationUnit())
{
Portfolio portfolio = unit.Portfolios.GetAll()
.FirstOrDefault(p => p.Id == facility.Portfolio.Id);
Facility hasFacility = unit.Facilities.GetAll()
.FirstOrDefault(u => u.Name.ToLower() == facility.Name.ToLower());
if (hasFacility == null)
{
facility.CreatedDate = DateTime.Now;
facility.ModifiedDate = DateTime.Now;
facility.Portfolio = portfolio;
facility.Status = "New";
unit.Facilities.Add(facility);
unit.SaveChanges();
return(facility);
}
return(null);
}
}
catch (Exception ex)
{
ErrorHandling.LogError(ex.StackTrace, "AddFacility");
throw ex;
}
}
public User Login(string username, string password)
{
try
{
using (ApplicationUnit unit = new ApplicationUnit())
{
User loginUser = unit.Users.GetAll()
.FirstOrDefault(usr => usr.Username.ToLower() == username.ToLower());
if (loginUser != null)
{
string decriptedPassword = EncryptString.Decrypt(loginUser.Password, "THEPROJECT");
if (decriptedPassword == password)
{
Task addTask = new Task(() => LogAuditTrail("Login", string.Format("Successful Login {0}", loginUser.Username), loginUser.Id, loginUser.Id));
addTask.Start();
return(loginUser);
}
}
return(null);
}
}
catch (Exception ex)
{
ErrorHandling.LogError(ex.StackTrace, "AddBuilding");
throw ex;
}
}
private List <Facility> GetFacilities()
{
using (ApplicationUnit unit = new ApplicationUnit())
{
var dbfacilities = unit.Facilities.GetAll()
.Include(b => b.Buildings)
.Include(d => d.DeedsInfo)
.Include(p => p.ResposiblePerson)
.Include("Location.GPSCoordinates")
.Include("Location.BoundryPolygon")
.ToList();
List <Facility> facilities = new List <Facility>();
foreach (var item in dbfacilities)
{
double utiliatonStatusTotal = item.Buildings.Sum(b => Convert.ToDouble(b.Status));
facilities.Add(new Facility
{
ClientCode = item.ClientCode,
SettlementType = item.SettlementType,
Zoning = item.Zoning,
Region = item.Location.Region,
NoOfImprovements = item.Buildings.Count,
ImprovementsSize = item.Buildings.Sum(b => b.ImprovedArea),
//OccupationStatus = item.Buildings.Count != 0 ? Convert.ToDouble(item.Status) : Convert.ToDouble(item.Status),
OccupationStatus = utiliatonStatusTotal,
Status = item.Status
});
}
return(facilities);
}
}
private string GetUsagePercentage(List <Facility> SubmittedFacilities)
{
using (ApplicationUnit unit = new ApplicationUnit())
{
var str = "vacant";
var dbfacilities = unit.OriginalDatas.GetAll().Select(f => f).ToList();
if (SubmittedFacilities.Count > 0)
{
var newfacilities = new List <Model.OriginalData>();
foreach (var item in SubmittedFacilities)
{
var facility = dbfacilities.Where(f => f.VENUS_CODE.ToLower().Trim() == item.ClientCode.ToLower().Trim()).FirstOrDefault();
if (facility != null)
{
newfacilities.Add(facility);
}
}
dbfacilities = newfacilities;
}
int UsageCount = 0;
foreach (var item in dbfacilities)
{
if (item.Usage_Descrip.ToLower().Trim().Contains(str))
{
UsageCount = UsageCount + 1;
}
}
decimal div = decimal.Divide(UsageCount, dbfacilities.Count);
string percentage = String.Format("{0:.##}", (div * 100));
return(percentage = percentage.Replace(",", "."));
}
}
private Location GetLocation(Location location, ref ApplicationUnit unit)
{
if (location != null)
{
Location loc = unit.Locations.GetAll()
.Include(gps => gps.GPSCoordinates)
.Include(bp => bp.BoundryPolygon)
.FirstOrDefault(p => p.Id == location.Id);
if (loc != null)
{
if (location.BoundryPolygon != null)
{
foreach (var newPolygon in location.BoundryPolygon)
{
BoundryPolygon polygon = loc.BoundryPolygon.FirstOrDefault(d => d.Id == newPolygon.Id);
if (polygon != null)
{
polygon.Latitude = newPolygon.Latitude;
polygon.Longitude = newPolygon.Longitude;
}
}
}
foreach (var polygon in loc.BoundryPolygon)
{
polygon.Location = null;
}
return(loc);
}
}
return(location);
}
public List <User> GetUsers()
{
using (ApplicationUnit unit = new ApplicationUnit())
{
List <User> users = unit.Users.GetAll().ToList();
return(users);
}
}
public List <Client> GetClients()
{
using (ApplicationUnit unit = new ApplicationUnit())
{
List <Client> clients = unit.Clients.GetAll().ToList();
return(clients);
}
}
public List <Portfolio> GetPotfoliosbyClientId(int clientId)
{
using (ApplicationUnit unit = new ApplicationUnit())
{
List <Portfolio> clients = unit.Portfolios.GetAll()
.Where(cl => cl.Client.Id == clientId).ToList();
return(clients);
}
}
private void CreateEditBoundryPolygon(List <BoundryPolygon> boundryPolygons, ref ApplicationUnit unit, Location location)
{
foreach (var boundryPolygon in boundryPolygons)
{
boundryPolygon.Location = location;
location.BoundryPolygon.Add(boundryPolygon);
}
unit.SaveChanges();
}
public QuizzOverviewQueryableCreator(
ApplicationUnit uow,
QuizzOverviewQueryParam query,
User currentUser)
{
_query = query;
_queryable = uow.Quizzes.GetAll()
.Where(q => q.IsDeleted == false);
_currentUser = currentUser;
}
private void Create(ref ApplicationUnit unit, DeedsInfo deedsInfo)
{
////deedsInfo.CreatedDate = DateTime.Now;
//Facility updateFacility = unit.Facilities.GetAll().FirstOrDefault(fc => fc.Id == deedsInfo.FacilityId);
//if (updateFacility != null)
//{
// updateFacility.DeedsInfo = deedsInfo;
// unit.Facilities.Update(updateFacility);
// unit.SaveChanges();
//}
}
/// <summary>
/// Log error
/// </summary>
/// <param name="errorLog"></param>
/// <returns></returns>
public async Task Log(ErrorLog errorLog)
{
ApplicationUnit unit = new ApplicationUnit();
Model.ErrorLog errorLogd = new Model.ErrorLog();
errorLogd.ErrorMessage = errorLog.ErrorMessage;
errorLogd.Source = errorLog.Source;
errorLogd.Date = errorLog.Date;
unit.ErrorLogs.Add(errorLogd);
unit.SaveChanges();
}
private async void RefreshCommandExecute()
{
this.Products.Clear();
this._applicationUnit.Dispose();
this._applicationUnit = new ApplicationUnit();
foreach (var product in await this._applicationUnit.Products.GetAllAsync())
{
Products.Add(product);
}
}
private void Create(ref ApplicationUnit unit, Person resposiblePerson)
{
//resposiblePerson.CreatedDate = DateTime.Now;
//Facility updateFacility = unit.Facilities.GetAll().FirstOrDefault(fc => fc.Id == resposiblePerson.FacilityId);
//if (updateFacility != null)
//{
// updateFacility.ResposiblePerson = resposiblePerson;
// unit.Facilities.Update(updateFacility);
// unit.SaveChanges();
//}
}
private void CreateEditGPSCoordinates(GPSCoordinate GPSCoordinates, ref ApplicationUnit unit)
{
if (GPSCoordinates.Id != 0)
{
unit.GPSCoordinates.Update(GPSCoordinates);
}
else
{
unit.GPSCoordinates.Add(GPSCoordinates);
}
unit.SaveChanges();
}
private DeedsInfo GetDeedsInfo(DeedsInfo deedsInfo, ref ApplicationUnit unit)
{
if (deedsInfo != null)
{
DeedsInfo deeds = unit.DeedsInfos.GetAll().FirstOrDefault(p => p.Id == deedsInfo.Id);
if (deeds != null)
{
return(deeds);
}
}
return(deedsInfo);
}
public Person GetPersonById(int id)
{
try
{
ApplicationUnit unit = new ApplicationUnit();
return(unit.People.GetById(id));
}
catch (Exception ex)
{
ErrorHandling.LogError(ex.StackTrace, "GetBuildings");
throw ex;
}
}
private Person GetReposiblePerson(Person resposiblePerson, ref ApplicationUnit unit)
{
if (resposiblePerson != null)
{
Person person = unit.People.GetAll().FirstOrDefault(p => p.EmailAddress == resposiblePerson.EmailAddress);
if (person != null)
{
return(person);
}
}
return(resposiblePerson);
}
public Location GetLocationById(int id)
{
try
{
ApplicationUnit unit = new ApplicationUnit();
return(unit.Locations.GetById(id));
}
catch (Exception ex)
{
ErrorHandling.LogError(ex.StackTrace, "GetLocation");
throw ex;
}
}
private GPSCoordinate GPSCoordinates(GPSCoordinate gpsCoordinate, ref ApplicationUnit unit)
{
if (gpsCoordinate != null)
{
GPSCoordinate gps = unit.GPSCoordinates.GetAll()
.FirstOrDefault(p => p.Id == gpsCoordinate.Id);
if (gps != null)
{
return(gps);
}
}
return(gpsCoordinate);
}
public DeedsInfo GetDeedsInfoById(int id)
{
try
{
ApplicationUnit unit = new ApplicationUnit();
return(unit.DeedsInfos.GetById(id));
}
catch (Exception ex)
{
ErrorHandling.LogError(ex.StackTrace, "GetDeedsInfo");
throw ex;
}
}
public static void LogError(string errorMessase, string source)
{
using (ApplicationUnit unit = new ApplicationUnit())
{
ErrorLog errorLog = new ErrorLog
{
Date = DateTime.Now,
ErrorMessage = errorMessase,
Source = source
};
unit.ErrorLogs.Add(errorLog);
unit.SaveChanges();
}
}
private void Update(ref ApplicationUnit unit, Person resposiblePerson)
{
//Facility updateFacility = unit.Facilities.GetAll().FirstOrDefault(fc => fc.Id == resposiblePerson.FacilityId);
//if (updateFacility != null)
//{
// updateFacility.ResposiblePerson.FullName = resposiblePerson.FullName;
// updateFacility.ResposiblePerson.Designation = resposiblePerson.Designation;
// updateFacility.ResposiblePerson.PhoneNumber = resposiblePerson.PhoneNumber;
// updateFacility.ResposiblePerson.EmailAddress = resposiblePerson.EmailAddress;
// //updateFacility.ResposiblePerson.ModifiedUserId = resposiblePerson.ModifiedUserId;
// //updateFacility.ResposiblePerson.ModifiedDate = DateTime.Now;
// unit.Facilities.Update(updateFacility);
// unit.SaveChanges();
//}
}
private void Update(ref ApplicationUnit unit, DeedsInfo deedsInfo)
{
//Facility updateFacility = unit.Facilities.GetAll().FirstOrDefault(fc => fc.Id == deedsInfo.FacilityId);
//if (updateFacility != null)
//{
// updateFacility.DeedsInfo.ErFNumber = deedsInfo.ErFNumber;
// updateFacility.DeedsInfo.TitleDeedNumber = deedsInfo.TitleDeedNumber;
// updateFacility.DeedsInfo.Extent = deedsInfo.Extent;
// updateFacility.DeedsInfo.OwnerInfomation = deedsInfo.OwnerInfomation;
// updateFacility.DeedsInfo.ModifiedUserId = deedsInfo.ModifiedUserId;
// updateFacility.DeedsInfo.ModifiedDate = DateTime.Now;
// unit.Facilities.Update(updateFacility);
// unit.SaveChanges();
//}
}
public HttpResponseMessage UpdateBuilding(Building building)
{
ApplicationUnit unit = new ApplicationUnit();
try
{
Building updateBudilng = unit.Buildings.GetAll().FirstOrDefault(fc => fc.Id == building.Id);
if (updateBudilng != null)
{
updateBudilng.BuildingName = building.BuildingName.Trim();
updateBudilng.BuildingNumber = building.BuildingNumber.Trim();
updateBudilng.BuildingType = building.BuildingType.Trim();
updateBudilng.BuildingStandard = building.BuildingStandard.Trim();
updateBudilng.Status = building.Status.Trim();
updateBudilng.GPSCoordinates = GPSCoordinates(building.GPSCoordinates, ref unit);
updateBudilng.NumberOfFloors = building.NumberOfFloors;
updateBudilng.FootPrintArea = building.FootPrintArea;
updateBudilng.ImprovedArea = building.ImprovedArea;
updateBudilng.Heritage = building.Heritage;
updateBudilng.OccupationYear = building.OccupationYear;
updateBudilng.DisabledAccess = building.DisabledAccess.Trim();
updateBudilng.DisabledComment = building.DisabledComment.Trim();
updateBudilng.ConstructionDescription = building.ConstructionDescription;
updateBudilng.Photo = building.Photo;
updateBudilng.ModifiedDate = DateTime.Now;
unit.Buildings.Update(updateBudilng);
unit.SaveChanges();
int userId = updateBudilng.ModifiedUserId != null ? updateBudilng.ModifiedUserId.Value : 0;
Task updateTask = new Task(() => LogAuditTrail("Building", "Update", userId, updateBudilng.Id));
updateTask.Start();
building.Facility = null;
return(Request.CreateResponse(HttpStatusCode.OK, new
{
content = building
}));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
unit.Dispose();
ErrorHandling.LogError(ex.StackTrace, "UpdateBuilding");
return(Request.CreateResponse(ex));
}
}
public ProductExplorerViewModel(IEventAggregator eventAggregator, ISaveFileService saveFileService)
{
if (DesignerProperties.GetIsInDesignMode(new DependencyObject())) return;
this._eventAggregator = eventAggregator;
this._saveFileService = saveFileService;
this._applicationUnit = new ApplicationUnit();
this.Products = new ObservableCollection<Product>(this._applicationUnit.Products.GetAll().ToList());
this.Products.CollectionChanged += (s,e) => RaiseCanExecuteCommands();
this.DeleteProductCommand = new RelayCommand(DeleteProductCommandExecute, DeleteProductCommandCanExecute);
this.SaveChangesCommand = new RelayCommand(SaveChangesCommandExecute);
this.RefreshCommand = new RelayCommand(RefreshCommandExecute);
this.SaveAsCSVCommand = new RelayCommand(SaveAsCSVCommandExecute, SaveAsCSVCommandCanExecute);
this.RegisterCommand(this.DeleteProductCommand);
this.RegisterCommand(this.SaveAsCSVCommand);
}
