public void BindDLLs(LegalEntityOwnerView legalEntityOwnerView, ObjectContext db)
{
//Owners ddl
IPhysicalEntitiesRepository physicalEntitesRepository = new PhysicalEntitiesRepository(db);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
List <DDLHelper> owners = LegalEntityOwnerView.GetOwnersSelect(physicalEntitesRepository.GetValid(), legalEntitiesRepository.GetValidOwners()).OrderBy("Text ASC").ToList();
legalEntityOwnerView.Owners = new SelectList(owners, "Value", "Text");
//AdditionalFactors ddl
IAdditionalFactorsRepository additionalFactorsRepository = new AdditionalFactorsRepository(db);
legalEntityOwnerView.AdditionalFactors = new SelectList(additionalFactorsRepository.GetValid().OrderBy("Name ASC").ToList(), "AdditionalFactorPK", "Name");
//FulfilledFactors ddl
IFulfilledFactorsRepository fulfilledFactorsRepository = new FulfilledFactorsRepository(db);
legalEntityOwnerView.FulfilledFactors = new SelectList(fulfilledFactorsRepository.GetValid().OrderBy("Name ASC").ToList(), "FulfilledFactorPK", "Name");
//BussinesShareBurdens ddl
IBussinesShareBurdensRepository bussinesShareBurdensRepository = new BussinesShareBurdensRepository(db);
legalEntityOwnerView.BussinesShareBurdens = new SelectList(bussinesShareBurdensRepository.GetValid().OrderBy("Name ASC").ToList(), "BussinesShareBurdenPK", "Name");
//ChangeTypes ddl
IChangeTypesRepository changeTypesRepository = new ChangeTypesRepository(db);
legalEntityOwnerView.ChangeTypes = new SelectList(changeTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "ChangeTypePK", "Name");
}
public void ConvertFrom(Contract contract, ContractView contractView, ObjectContext db)
{
contractView.ContractPK = contract.ContractPK;
contractView.LegalEntityFK = contract.LegalEntityFK;
contractView.Name = contract.Name;
contractView.Number = contract.Number;
contractView.Date = contract.Date;
contractView.ContractValidityFK = contract.ContractValidityFK;
contractView.ContractBegin = contract.ContractBegin;
contractView.ContractEnd = contract.ContractEnd;
contractView.TerminationDate = contract.TerminationDate;
contractView.TerminationDescription = contract.TerminationDescription;
contractView.Terminated = contract.Terminated;
contractView.CurrencyFK = contract.CurrencyFK;
contractView.MIO = contract.MIO;
contractView.TSI = contract.TSI;
contractView.GZR = contract.GZR;
contractView.OPL = contract.OPL;
contractView.AUP = contract.AUP;
contractView.Deleted = contract.Deleted;
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)contractView.LegalEntityFK);
contractView.LegalEntityName = legalEntity.Name + " (" + legalEntity.OIB + ")";
}
public ActionResult AutocompleteLegalEntitiesOIB(string term)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
var legalEntities = legalEntitiesRepository.GetValidLegalEntities().Where(c => c.OIB.Contains(term)).OrderBy(x => x.OIB);
return(Json(legalEntities.Select(c => new { value = c.OIB, value_id = c.LegalEntityPK }), JsonRequestBehavior.AllowGet));
}
public void ConvertFrom(LegalEntityOwner legalEntityOwner, LegalEntityOwnerView legalEntityOwnerView, ObjectContext db)
{
legalEntityOwnerView.LegalEntityOwnerPK = legalEntityOwner.LegalEntityOwnerPK;
legalEntityOwnerView.LegalEntityFK = legalEntityOwner.LegalEntityFK;
legalEntityOwnerView.OwnerStringFK = legalEntityOwner.OwnerType.Trim() + "|" + legalEntityOwner.OwnerFK.ToString();
legalEntityOwnerView.AdditionalFactorFK = legalEntityOwner.AdditionalFactorFK;
legalEntityOwnerView.FulfilledFactorFK = legalEntityOwner.FulfilledFactorFK;
legalEntityOwnerView.BussinesShareBurdenFK = legalEntityOwner.BussinesShareBurdenFK;
legalEntityOwnerView.ChangeTypeFK = legalEntityOwner.ChangeTypeFK;
legalEntityOwnerView.BusinessShareAmount = legalEntityOwner.BusinessShareAmount;
legalEntityOwnerView.NominalBussinesShareAmount = legalEntityOwner.NominalBussinesShareAmount;
legalEntityOwnerView.PaidBussinesShareAmount = legalEntityOwner.PaidBussinesShareAmount;
legalEntityOwnerView.NumberOfVotes = legalEntityOwner.NumberOfVotes;
legalEntityOwnerView.EntryDate = legalEntityOwner.EntryDate;
legalEntityOwnerView.Deleted = legalEntityOwner.Deleted;
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityOwnerView.LegalEntityFK);
legalEntityOwnerView.LegalEntityName = legalEntity.Name + " (" + legalEntity.OIB + ")";
}
public ActionResult Add(int?toDoListPK)
{
ToDoListView toDoListView = new ToDoListView();
if (toDoListPK != null)
{
IToDoListsRepository toDoListsRepository = new ToDoListsRepository(db);
ToDoList toDoList = toDoListsRepository.GetToDoListByPK((int)toDoListPK);
IWorkDonesRepository workDonesRepository = new WorkDonesRepository(db);
toDoList.Finished = false;
toDoListView.ConvertFrom(toDoList, toDoListView);
var legalEntitiesSelectedValue = workDonesRepository.GetWorkDonesCreatedWithToDo((int)toDoListPK).Select(a => a.LegalEntityFK);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
toDoListView.Companies = new MultiSelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("name ASC"), "LegalEntityPK", "Name", legalEntitiesSelectedValue);
}
else
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
toDoListView.Companies = new MultiSelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("name ASC"), "LegalEntityPK", "Name");
}
return(View(toDoListView));
}
public ActionResult Add(int?legalEntityFK)
{
TempData["legalEntityFK"] = legalEntityFK;
AssessmentsView assessmentView = new AssessmentsView();
// Assessment types ddl
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentView.AssessmentTypes = new SelectList(assessmentTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "AssessmentTypePK", "Name");
//legalEntities ddl
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
if (legalEntityFK != null)
{
TempData["legalEntityFK"] = legalEntityFK;
assessmentView.LegalEntityFK = (int)legalEntityFK;
assessmentView.LegalEntityName = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityFK).Name;
}
// Assessment types
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
IAssessmentQuestionsRepository assessmentQuestionsRepository = new AssessmentQuestionsRepository(db);
assessmentView.AssessmentsTypesView = AssessmentsView.FillQuiz(assessmentTypesRepository.GetValid(), assessmentGroupsRepository, assessmentQuestionsRepository, null);
return(View(assessmentView));
}
public ActionResult Index()
{
IAssessmentsRepository assessmentsRepository = new AssessmentsRepository(db);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
IRisksRepository risksRepository = new RisksRepository(db);
int page = !String.IsNullOrWhiteSpace(Request.QueryString["page"]) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
int pageSize = !String.IsNullOrWhiteSpace(Request.QueryString["pageSize"]) ? Convert.ToInt32(Request.QueryString["pageSize"]) : Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ResultsPerPage"]);
string sortOrder = !String.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !String.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "AssessmentPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <AssessmentsView> assessments = AssessmentsView.GetHomeView(assessmentsRepository.GetValid(), legalEntitiesRepository.GetValidLegalEntities(), risksRepository.GetValid())
.OrderBy(ordering);
//legalEntities ddl
ViewBag.LegalEntities = new SelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("Name ASC").ToList(), "LegalEntityPK", "Name", Request.QueryString["legalEntityFK"]);
if (!String.IsNullOrWhiteSpace(Request.QueryString["LegalEntityFK"]))
{
int legalEntityFK = Convert.ToInt32(Request.QueryString["LegalEntityFK"]);
assessments = assessments.Where(a => a.LegalEntityFK == legalEntityFK);
}
int assessmentCount = 0;
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
assessments = assessments.Where(c => c.AssessmentComment.Contains(searchString) || c.AssessmentDate.ToString().Contains(searchString) || c.LegalEntityName.Contains(searchString));
assessmentCount = assessments.Count();
}
assessments = assessments.Page(page, pageSize);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
ViewData["numberOfRecords"] = assessmentCount;
}
else
{
ViewData["numberOfRecords"] = assessmentsRepository.GetValid().Count();
}
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("Assessment?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", assessments.ToList()));
}
}
public FileContentResult ShowLegalEntityOwnersGraph(int?legalEntityFK, string color, int?dpi)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
ILegalEntityOwnersRepository legalEntityOwnersRepository = new LegalEntityOwnersRepository(db);
IPhysicalEntitiesRepository physicalEntitiesRepository = new PhysicalEntitiesRepository(db);
List <LegalEntityOwner> filteredCoList = new List <LegalEntityOwner>();
IQueryable <LegalEntityOwner> legalEntityOwnersTable = legalEntityOwnersRepository.GetValid();
if (legalEntityFK != null)
{
List <LegalEntityOwner> coList = new List <LegalEntityOwner>();
coList = legalEntityOwnersRepository.GetFirstLegalEntityOwnersForLegalEntity((int)legalEntityFK).ToList();
foreach (var co in coList)
{
LegalEntityOwnerView.Fill(filteredCoList, legalEntityOwnersTable.ToList(), co);
}
legalEntityOwnersTable = filteredCoList.AsQueryable();
}
IQueryable <LegalEntityOwnerView> legalEntityOwners = LegalEntityOwnerView.GetLegalEntityOwnerView(legalEntityOwnersTable,
physicalEntitiesRepository.GetValid(),
legalEntitiesRepository.GetValid());
List <string> graphElements = new List <string>();
foreach (LegalEntityOwnerView item in legalEntityOwners)
{
graphElements.Add(item.OwnerFK.ToString() + "[label=\"" + item.OwnerName + "\", shape=ci, fontsize=12, fontname=arial, labelloc=t, style=filled, fillcolor=\"white\", width=1.5]");
if (legalEntityFK == item.LegalEntityFK)
{
graphElements.Add(item.LegalEntityFK.ToString() + "[label=\"" + item.LegalEntityName + "\", shape=box, fontsize=12, fontname=arial, labelloc=t, style=filled, fontcolor=\"white\", color=\"black\", width=1.5]");
}
else
{
graphElements.Add(item.LegalEntityFK.ToString() + "[label=\"" + item.LegalEntityName + "\", shape=box, fontsize=12, fontname=arial, labelloc=t, style=filled, fillcolor=\"white\", width=1.5]");
}
graphElements.Add(item.OwnerFK.ToString() + "->" + item.LegalEntityFK.ToString());
}
string graph = @"digraph Graphviz {";
graph += "[bgcolor=\"" + color + "\", dpi=\"" + dpi + "\"],";
graph += string.Join(", ", graphElements.ToArray());
graph += "}";
graph = graph.ConvertNonASCIICharacters();
byte[] imageByte = imageByte = Graphviz.RenderImage(graph, "dot", "png");;
string contentType = "image/png";
return(File(imageByte, contentType));
}
public ActionResult Add(ToDoListView toDoListView, FormCollection form)
{
if (ModelState.IsValid)
{
IToDoListsRepository toDoListsRepository = new ToDoListsRepository(db);
ToDoList toDoList = new ToDoList();
toDoListView.ConvertTo(toDoListView, toDoList);
toDoList.UserFK = SecurityHelper.GetUserPKFromCookie();
toDoList.CreationDate = DateTime.Now;
toDoListsRepository.Add(toDoList);
toDoListsRepository.SaveChanges();
string[] legalEntitiesSelectedValues = new string[500];
if (form["LegalEntityPK"] != null)
{
legalEntitiesSelectedValues = ((string)form["LegalEntityPK"]).Split(',');
}
else
{
legalEntitiesSelectedValues = null;
}
IWorkDonesRepository workDonesRepository = new WorkDonesRepository(db);
if (legalEntitiesSelectedValues != null)
{
// Add work dones
foreach (string legalEntity in legalEntitiesSelectedValues)
{
WorkDone workDone = new WorkDone();
workDone.ToDoListFK = toDoList.ToDoListPK;
workDone.LegalEntityFK = Convert.ToInt32(legalEntity);
workDone.CreatedWithToDo = true;
workDonesRepository.Add(workDone);
}
workDonesRepository.SaveChanges();
}
TempData["message"] = LayoutHelper.GetMessage("INSERT", toDoList.ToDoListPK);
return(RedirectToAction("Index", "ToDoList"));
}
else
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
toDoListView.Companies = new MultiSelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("name ASC"), "LegalEntityPK", "Name");
return(View(toDoListView));
}
}
public ActionResult Edit(int?workDonePK)
{
if (workDonePK != null)
{
IWorkDonesRepository workDonesRepository = new WorkDonesRepository(db);
WorkDone workDone = workDonesRepository.GetWorkDoneByPK((int)workDonePK);
WorkDoneView workDoneView = new WorkDoneView();
workDoneView.ConvertFrom(workDone, workDoneView);
IWorkDoneAttachmentsRepository workDoneAttachmentsRepository = new WorkDoneAttachmentsRepository(db);
IAttachmentsRepository attachmentsRepository = new AttachmentsRepository(db);
IQueryable <WorkDoneAttachmentView> workDoneAttachments = WorkDoneAttachmentView.GetWorkDoneAttachmentView(workDoneAttachmentsRepository.GetValid(), attachmentsRepository.GetValid(), workDonesRepository.GetValid())
.Where(c => c.WorkDoneFK == workDonePK).OrderBy("WorkDoneAttachmentPK DESC");
ViewBag.Attachments = workDoneAttachments.ToList();
//to do list ddl
IToDoListsRepository toDoListsRepository = new ToDoListsRepository(db);
workDoneView.ToDoLists = new SelectList(toDoListsRepository.GetValid().ToList(), "ToDoListPK", "Name");
//legalEntities ddl
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
workDoneView.LegalEntities = new SelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("Name ASC").ToList(), "LegalEntityPK", "Name");
//service type ddl
IServiceTypesRepository serviceTypesRepository = new ServiceTypesRepository(db);
workDoneView.ServiceTypes = new SelectList(serviceTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "ServiceTypePK", "Name");
//Work done ddl
IWorkTypesRepository workTypesRepository = new WorkTypesRepository(db);
workDoneView.WorkTypes = new SelectList(workTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "WorkTypePK", "Name");
//worksubtypes ddl
if (workDoneView.WorkTypeFK != null)
{
IWorkSubtypesRepository workSubtypesRepository = new WorkSubtypesRepository(db);
workDoneView.WorkSubtypes = new SelectList(workSubtypesRepository.GetValidByWorkType(Convert.ToInt32(workDoneView.WorkTypeFK)), "WorkSubtypePK", "Name", workDoneView.WorkSubtypeFK);
}
else
{
workDoneView.WorkSubtypes = new SelectList(new List <County>(), "WorkSubtypePK", "Name");
}
//hours and minutes ddl
workDoneView.Hours = GeneratorView.GenerateHours();
workDoneView.Minutes = GeneratorView.GenerateMinutes();
return(View(workDoneView));
}
else
{
return(RedirectToAction("Index", "WorkDone"));
}
}
public void ConvertFrom(LegalEntityBank LegalEntityBank, LegalEntityBankView LegalEntityBankView, ObjectContext db)
{
LegalEntityBankView.LegalEntityBankPK = LegalEntityBank.LegalEntityBankPK;
LegalEntityBankView.LegalEntityFK = LegalEntityBank.LegalEntityFK;
LegalEntityBankView.BankFK = LegalEntityBank.BankFK;
LegalEntityBankView.Iban = LegalEntityBank.Iban;
LegalEntityBankView.Deleted = LegalEntityBank.Deleted;
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)LegalEntityBankView.LegalEntityFK);
LegalEntityBankView.LegalEntityName = legalEntity.Name + " (" + legalEntity.OIB + ")";
}
public ActionResult Index()
{
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
IBanksRepository banksRepository = new BanksRepository(db);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntityBankView legalEntityBankView = new LegalEntityBankView();
int page = !String.IsNullOrWhiteSpace(Request.QueryString["page"]) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
int pageSize = !String.IsNullOrWhiteSpace(Request.QueryString["pageSize"]) ? Convert.ToInt32(Request.QueryString["pageSize"]) : Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ResultsPerPage"]);
string sortOrder = !String.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !String.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "LegalEntityBankPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <LegalEntityBankView> legalEntitiesBanks = LegalEntityBankView.GetLegalEntityBankView(legalEntitiesBanksRepository.GetValid(), banksRepository.GetValid(), legalEntitiesRepository.GetValidLegalEntities())
.OrderBy(ordering);
//legalEntities ddl
ViewBag.LegalEntities = new SelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("Name ASC").ToList(), "LegalEntityPK", "Name", Request.QueryString["legalEntityFK"]);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
legalEntitiesBanks = legalEntitiesBanks.Where(c => c.LegalEntityName.Contains(searchString) || c.BankName.Contains(searchString));
}
if (!String.IsNullOrWhiteSpace(Request.QueryString["legalEntityFK"]))
{
int legalEntityFK = Convert.ToInt32(Request.QueryString["legalEntityFK"]);
legalEntitiesBanks = legalEntitiesBanks.Where(c => c.LegalEntityFK == legalEntityFK);
}
legalEntitiesBanks = legalEntitiesBanks.Page(page, pageSize);
ViewData["numberOfRecords"] = legalEntitiesBanksRepository.GetValid().Count();
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("LegalEntityBank?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", legalEntitiesBanks.ToList()));
}
}
public ActionResult UnOwner(int?legalEntityPK)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
if (legalEntityPK != null)
{
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityPK);
legalEntity.Owner = false;
legalEntitiesRepository.SaveChanges();
}
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
public void ConvertFrom(LegalEntityLegalRepresentative legalEntityLegalRepresentative, LegalEntityLegalRepresentativeView legalEntityLegalRepresentativeView, ObjectContext db)
{
legalEntityLegalRepresentativeView.LegalEntityLegalRepresentativePK = legalEntityLegalRepresentative.LegalEntityLegalRepresentativePK;
legalEntityLegalRepresentativeView.LegalEntityFK = legalEntityLegalRepresentative.LegalEntityFK;
legalEntityLegalRepresentativeView.WayOfRepresentationFK = legalEntityLegalRepresentative.WayOfRepresentationFK;
legalEntityLegalRepresentativeView.LegalRepresentativeFK = legalEntityLegalRepresentative.LegalRepresentativeFK;
legalEntityLegalRepresentativeView.Deleted = legalEntityLegalRepresentative.Deleted;
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityLegalRepresentative.LegalEntityFK);
legalEntityLegalRepresentativeView.LegalEntityName = legalEntity.Name + " (" + legalEntity.OIB + ")";
}
public ActionResult Delete(int?legalEntityPK)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
if (legalEntityPK != null)
{
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityPK);
legalEntity.Deleted = true;
legalEntitiesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("DELETE", legalEntity.LegalEntityPK);
}
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
public ActionResult Edit(int?legalEntityPK)
{
if (legalEntityPK != null)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityPK);
LegalEntityView legalEntityView = new LegalEntityView();
legalEntityView.ConvertFrom(legalEntity, legalEntityView);
legalEntityView.BindDDLs(legalEntityView, db);
return(View(legalEntityView));
}
else
{
return(RedirectToAction("Index", "LegalEntity"));
}
}
public ActionResult Add(int?legalEntityFK)
{
LegalEntityLegalRepresentativeView legalEntityLegalRepresentativeView = new LegalEntityLegalRepresentativeView();
if (legalEntityFK != null)
{
TempData["legalEntityFK"] = legalEntityFK;
legalEntityLegalRepresentativeView.LegalEntityFK = (int)legalEntityFK;
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
legalEntityLegalRepresentativeView.LegalEntityName = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityFK).Name;
}
legalEntityLegalRepresentativeView.BindDDLs(legalEntityLegalRepresentativeView, db);
return(View(legalEntityLegalRepresentativeView));
}
public ActionResult Add(int?legalEntityFK)
{
ContractView contractView = new ContractView();
if (legalEntityFK != null)
{
TempData["legalEntityFK"] = legalEntityFK;
contractView.LegalEntityFK = (int)legalEntityFK;
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
contractView.LegalEntityName = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityFK).Name;
}
contractView.BindDDLs(contractView, db);
return(View(contractView));
}
public static List <List <LegalEntityBranchAuditView> > GetLegalEntityBranchesAuditView(ObjectContext context, int legalEntityFK)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(context);
ILegalEntityBranchesRepository legalEntityLegalEntityBranchesRepository = new LegalEntityBranchesRepository(context);
// get all legalEntity legalEntityBranches
List <LegalEntityBranchView> legalEntityBranchesList = LegalEntityBranchView.GetLegalEntityBranchView(legalEntityLegalEntityBranchesRepository.GetAll(), legalEntitiesRepository.GetValid())
.Where(c => c.LegalEntityFK == legalEntityFK)
.ToList();
List <List <LegalEntityBranchAuditView> > LegalEntityBranchesListList = new List <List <LegalEntityBranchAuditView> >();
foreach (LegalEntityBranchView legalEntityBranch in legalEntityBranchesList)
{
LegalEntityBranchesListList.Add(LegalEntityBranchAuditView.GetLegalEntityBranchAuditView(context, legalEntityBranch.LegalEntityBranchPK));
}
return(LegalEntityBranchesListList);
}
public static List <List <LegalEntityOwnerAuditView> > GetLegalEntityOwnersAuditView(ObjectContext context, int legalEntityFK)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(context);
IPhysicalEntitiesRepository physicalEntitiesRepository = new PhysicalEntitiesRepository(context);
ILegalEntityOwnersRepository legalEntityOwnersRepository = new LegalEntityOwnersRepository(context);
// get all legalEntity branches
List <LegalEntityOwnerView> legalEntityOwners = LegalEntityOwnerView.GetLegalEntityOwnerView(legalEntityOwnersRepository.GetAll(), physicalEntitiesRepository.GetValid(), legalEntitiesRepository.GetValid())
.Where(c => c.LegalEntityFK == legalEntityFK)
.ToList();
List <List <LegalEntityOwnerAuditView> > legalEntityOwnersListList = new List <List <LegalEntityOwnerAuditView> >();
foreach (LegalEntityOwnerView legalEntityOwner in legalEntityOwners)
{
legalEntityOwnersListList.Add(LegalEntityOwnerAuditView.GetLegalEntityOwnerAuditView(context, legalEntityOwner.LegalEntityOwnerPK));
}
return(legalEntityOwnersListList);
}
public static List <List <LegalEntityBankAuditView> > GetLegalEntityBanksAuditView(ObjectContext context, int legalEntityFK)
{
IBanksRepository banksRepository = new BanksRepository(context);
ILegalEntitiesRepository LegalEntitiesRepository = new LegalEntitiesRepository(context);
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(context);
// get all legalEntity bank records
List <LegalEntityBankView> legalEntitiesBanks = LegalEntityBankView.GetLegalEntityBankView(legalEntitiesBanksRepository.GetAll(), banksRepository.GetValid(), LegalEntitiesRepository.GetValidLegalEntities())
.Where(c => c.LegalEntityFK == legalEntityFK)
.ToList();
List <List <LegalEntityBankAuditView> > LegalEntityBanksListList = new List <List <LegalEntityBankAuditView> >();
foreach (LegalEntityBankView legalEntityBank in legalEntitiesBanks)
{
LegalEntityBanksListList.Add(LegalEntityBankAuditView.GetLegalEntityBankAuditView(context, legalEntityBank.LegalEntityBankPK));
}
return(LegalEntityBanksListList);
}
public ActionResult Edit(int?assessmentPK)
{
if (assessmentPK != null)
{
IAssessmentsRepository assessmentsRepository = new AssessmentsRepository(db);
Assessment assessment = assessmentsRepository.GetAssessmentByPK((int)assessmentPK);
AssessmentsView assessmentView = new AssessmentsView();
assessmentView.ConvertFrom(assessment, assessmentView);
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentView.AssessmentTypes = new SelectList(assessmentTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "AssessmentTypePK", "Name");
// Assessment types ddl
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
IAssessmentQuestionsRepository assessmentQuestionsRepository = new AssessmentQuestionsRepository(db);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)assessment.LegalEntityFK);
assessmentView.LegalEntityName = legalEntity.Name + " (" + legalEntity.OIB + ")";
FormCollection form = new FormCollection();
IAssessmentAnswersRepository assessmentAnswersRepository = new AssessmentAnswersRepository(db);
IQueryable <AssessmentAnswers> assessmentAnswers = assessmentAnswersRepository.GetAssessmentAnswersByAssessment((int)assessmentPK);
foreach (var assessmentAnswer in assessmentAnswers)
{
string answer = assessmentAnswer.AssessmentAnswer == null ? "NP": (bool)assessmentAnswer.AssessmentAnswer ? "Da" : "Ne";
form.Add("answer[" + assessmentAnswer.AssessmentQuestionFK + "]", answer);
}
assessmentView.AssessmentsTypesView = AssessmentsView.FillQuiz(assessmentTypesRepository.GetValid(), assessmentGroupsRepository, assessmentQuestionsRepository, form);
return(View(assessmentView));
}
else
{
return(RedirectToAction("Index", "Assessment"));
}
}
public static LegalEntityView GetLegalEntityReport(ObjectContext db, int legalEntityPK)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK(legalEntityPK);
LegalEntityView legalEntityView = new LegalEntityView
{
LegalEntityPK = legalEntity.LegalEntityPK,
Name = legalEntity.Name,
ShortName = legalEntity.ShortName,
OIB = legalEntity.OIB,
MB = legalEntity.MB,
MBS = legalEntity.MBS,
FormName = legalEntity.FormFK != null ? legalEntity.Form.Name : null,
Active = legalEntity.Active,
Deleted = legalEntity.Deleted
};
return(legalEntityView);
}
public ActionResult Add(int?legalEntityFK)
{
LegalEntityBranchView legalEntityBranchView = new LegalEntityBranchView();
// set default country to Croatia
legalEntityBranchView.CountryFK = 81;
//legalEntities ddl
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
if (legalEntityFK != null)
{
TempData["legalEntityFK"] = legalEntityFK;
legalEntityBranchView.LegalEntityFK = (int)legalEntityFK;
legalEntityBranchView.LegalEntityName = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityFK).Name;
}
legalEntityBranchView.BindDDLs(legalEntityBranchView, db);
return(View(legalEntityBranchView));
}
public ActionResult Add(int?toDoListFK)
{
WorkDoneView workDoneView = new WorkDoneView();
//to do list ddl
IToDoListsRepository toDoListsRepository = new ToDoListsRepository(db);
workDoneView.ToDoLists = new SelectList(toDoListsRepository.GetNotFinished().OrderBy("Name ASC").ToList(), "ToDoListPK", "Name");
//legalEntities ddl
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
workDoneView.LegalEntities = new SelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("Name ASC").ToList(), "LegalEntityPK", "Name");
//service type ddl
IServiceTypesRepository serviceTypesRepository = new ServiceTypesRepository(db);
workDoneView.ServiceTypes = new SelectList(serviceTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "ServiceTypePK", "Name");
//Work type ddl
IWorkTypesRepository workTypesRepository = new WorkTypesRepository(db);
workDoneView.WorkTypes = new SelectList(workTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "WorkTypePK", "Name");
//worksubtypes ddl
workDoneView.WorkSubtypes = new SelectList(new List <County>(), "WorkSubtypePK", "Name");
//hours and minutes ddl
workDoneView.Hours = GeneratorView.GenerateHours();
workDoneView.Minutes = GeneratorView.GenerateMinutes();
if (toDoListFK != null)
{
workDoneView.ToDoListFK = toDoListFK;
}
workDoneView.ServiceTypeFK = 1;
return(View(workDoneView));
}
public void ConvertFrom(LegalEntityBranch legalEntityBranch, LegalEntityBranchView legalEntityBranchView, ObjectContext db)
{
legalEntityBranchView.LegalEntityBranchPK = legalEntityBranch.LegalEntityBranchPK;
legalEntityBranchView.Name = legalEntityBranch.Name;
legalEntityBranchView.LegalEntityFK = legalEntityBranch.LegalEntityFK;
legalEntityBranchView.CountryFK = legalEntityBranch.CountryFK;
legalEntityBranchView.CountyFK = legalEntityBranch.CountyFK;
legalEntityBranchView.CityCommunityFK = legalEntityBranch.CityCommunityFK;
legalEntityBranchView.PostalOfficeFK = legalEntityBranch.PostalOfficeFK;
legalEntityBranchView.PlaceFK = legalEntityBranch.PlaceFK;
legalEntityBranchView.StreetName = legalEntityBranch.StreetName;
legalEntityBranchView.Phone = legalEntityBranch.Phone;
legalEntityBranchView.Fax = legalEntityBranch.Fax;
legalEntityBranchView.Mobile = legalEntityBranch.Mobile;
legalEntityBranchView.EMail = legalEntityBranch.EMail;
legalEntityBranchView.Deleted = legalEntityBranch.Deleted;
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityBranchView.LegalEntityFK);
legalEntityBranchView.LegalEntityName = legalEntity.Name + " (" + legalEntity.OIB + ")";
}
public ActionResult Edit(LegalEntityView legalEntityView, FormCollection form)
{
if (ModelState.IsValid)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityView.LegalEntityPK);
legalEntityView.ConvertTo(legalEntityView, legalEntity);
legalEntitiesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("UPDATE", legalEntity.LegalEntityPK);
return(RedirectToAction("Index", "LegalEntity", new { active = "true" }));
}
else
{
legalEntityView.BindDDLs(legalEntityView, db);
return(View(legalEntityView));
}
}
public ActionResult Edit(ToDoListView toDoListView, FormCollection form)
{
if (ModelState.IsValid)
{
IToDoListsRepository toDoListsRepository = new ToDoListsRepository(db);
ToDoList toDoList = toDoListsRepository.GetToDoListByPK((int)toDoListView.ToDoListPK);
toDoListView.ConvertTo(toDoListView, toDoList);
toDoListsRepository.SaveChanges();
string[] legalEntitiesSelectedValues = new string[500];
if (form["LegalEntityPK"] != null)
{
legalEntitiesSelectedValues = ((string)form["LegalEntityPK"]).Split(',');
}
else
{
legalEntitiesSelectedValues = null;
}
IWorkDonesRepository workDonesRepository = new WorkDonesRepository(db);
var legalEntitiesValueFromDB = workDonesRepository.GetWorkDonesCreatedWithToDo((int)toDoListView.ToDoListPK).Select(a => a.LegalEntityFK);
if (legalEntitiesSelectedValues != null)
{
// Add work dones
foreach (string legalEntity in legalEntitiesSelectedValues)
{
int legalEntityFK = Convert.ToInt32(legalEntity);
if (!legalEntitiesValueFromDB.Contains(legalEntityFK))
{
WorkDone workDone = new WorkDone();
workDone.ToDoListFK = toDoList.ToDoListPK;
workDone.LegalEntityFK = legalEntityFK;
workDone.CreatedWithToDo = true;
workDonesRepository.Add(workDone);
}
}
workDonesRepository.SaveChanges();
List <WorkDone> workDones = workDonesRepository.GetWorkDonesCreatedWithToDo((int)toDoListView.ToDoListPK).ToList();
// delete existing
foreach (WorkDone workDone in workDones)
{
int legalEntityFK = (int)workDone.LegalEntityFK;
if (!legalEntitiesSelectedValues.ToList().Contains(legalEntityFK.ToString()))
{
workDone.Deleted = true;
workDonesRepository.SaveChanges();
}
}
}
TempData["message"] = LayoutHelper.GetMessage("UPDATE", toDoList.ToDoListPK);
return(RedirectToAction("Index", "ToDoList"));
}
else
{
IWorkDonesRepository workDonesRepository = new WorkDonesRepository(db);
var legalEntitiesSelectedValue = workDonesRepository.GetWorkDonesCreatedWithToDo((int)toDoListView.ToDoListPK).Select(a => a.LegalEntityFK);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
toDoListView.Companies = new MultiSelectList(legalEntitiesRepository.GetValidLegalEntities().OrderBy("name ASC"), "LegalEntityPK", "Name", legalEntitiesSelectedValue);
return(View(toDoListView));
}
}
public static IQueryable <LegalEntity> GetLegalEntitiesReport(ObjectContext db, string ordering, string Name, string OIB, string MB, string MBS, int?BankPK, int?TaxPK, int?FormPK, int?ActivityPK, int?numberOfEmployeesFrom, int?numberOfEmployeesTo)
{
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
IBanksRepository banksRepository = new BanksRepository(db);
ILegalEntityBanksRepository legalEntitiesBanksRepository = new LegalEntityBanksRepository(db);
var banks = banksRepository.GetValid();
var legalEntitiesBanks = legalEntitiesBanksRepository.GetValid();
var allLegalEntities = legalEntitiesRepository.GetValid();
// Applying filters
IQueryable <LegalEntity> legalEntitiesFiltered = allLegalEntities; // default list
// Banks
if (BankPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByBank(db, BankPK);
}
// Tax payers
if (TaxPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByTax(TaxPK);
}
// Forms
if (FormPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByForm(FormPK);
}
// ACtivities
if (ActivityPK != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByActivity(ActivityPK);
}
// Name filter
if (!String.IsNullOrWhiteSpace(Name))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByName(Name);
}
// OIB filter
if (!String.IsNullOrWhiteSpace(OIB))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByOIB(OIB);
}
// MB filter
if (!String.IsNullOrWhiteSpace(MB))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByMB(MB);
}
// MBS filter
if (!String.IsNullOrWhiteSpace(MBS))
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByMBS(MBS);
}
// numberOfEmployees
if (numberOfEmployeesFrom != null || numberOfEmployeesTo != null)
{
legalEntitiesFiltered = legalEntitiesFiltered.GetLegalEntitiesByEmployeesRange(numberOfEmployeesFrom, numberOfEmployeesTo);
}
return(legalEntitiesFiltered);
}
public static List <LegalEntityOwnerAuditView> GetLegalEntityOwnerAuditView(ObjectContext context, int relatedEntityPK)
{
IAuditingDetailsRepository auditingDetailsRepository = new AuditingDetailsRepository(context);
IAuditingMasterRepository auditingMasterRepository = new AuditingMasterRepository(context);
var sessionTokens = (from am in auditingMasterRepository.GetAll().Where(c => c.TableName == "LegalEntityOwners")
where am.RelatedEntityPK == relatedEntityPK
select new {
AuditingMasterPK = am.AuditingMasterPK,
RelatedEntityPK = am.RelatedEntityPK,
SessionToken = am.SessionToken
}).ToList();
List <LegalEntityOwnerAuditView> legalEntityOwnerAuditViewList = new List <LegalEntityOwnerAuditView>();
foreach (var item in sessionTokens)
{
var record = auditingDetailsRepository.GetAuditingDetailByAuditingMasterPK(item.AuditingMasterPK).ToList();
LegalEntityOwnerAuditView legalEntityOwnerAuditView = new LegalEntityOwnerAuditView();
legalEntityOwnerAuditView.LegalEntityFK = record.checkInteger("LegalEntityFK");
legalEntityOwnerAuditView.OwnerFK = record.checkInteger("OwnerFK");
legalEntityOwnerAuditView.OwnerType = record.checkString("OwnerType");
legalEntityOwnerAuditView.BusinessShareAmount = record.checkDecimal("BusinessShareAmount");
legalEntityOwnerAuditView.PaidBussinesShareAmount = record.checkDecimal("PaidBussinesShareAmount");
legalEntityOwnerAuditView.NominalBussinesShareAmount = record.checkDecimal("NominalBussinesShareAmount");
legalEntityOwnerAuditView.AdditionalFactorFK = record.checkInteger("AdditionalFactorFK");
legalEntityOwnerAuditView.FulfilledFactorFK = record.checkInteger("FulfilledFactorFK");
legalEntityOwnerAuditView.BussinesShareBurdenFK = record.checkInteger("BussinesShareBurdenFK");
legalEntityOwnerAuditView.ChangeTypeFK = record.checkInteger("ChangeTypeFK");
legalEntityOwnerAuditView.NumberOfVotes = record.checkInteger("NumberOfVotes");
legalEntityOwnerAuditView.EntryDate = record.checkDate("EntryDate");
legalEntityOwnerAuditView.ChangeDate = record.checkDate("ChangeDate");
legalEntityOwnerAuditView.Deleted = record.checkBoolean("Deleted");
legalEntityOwnerAuditViewList.Add(legalEntityOwnerAuditView);
}
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(context);
IQueryable <LegalEntity> legalEntitiesTable = legalEntitiesRepository.GetValid();
IPhysicalEntitiesRepository physicalEntitiesRepository = new PhysicalEntitiesRepository(context);
IQueryable <PhysicalEntity> physicalEntitiesTable = physicalEntitiesRepository.GetValid();
IAdditionalFactorsRepository additionalFactorsRepository = new AdditionalFactorsRepository(context);
IQueryable <AdditionalFactor> additionalFactorsTable = additionalFactorsRepository.GetValid();
IFulfilledFactorsRepository fulfilledFactorsRepository = new FulfilledFactorsRepository(context);
IQueryable <FulfilledFactor> fulfilledFactorsTable = fulfilledFactorsRepository.GetValid();
IBussinesShareBurdensRepository bussinesShareBurdensRepository = new BussinesShareBurdensRepository(context);
IQueryable <BussinesShareBurden> bussinesShareBurdensTable = bussinesShareBurdensRepository.GetValid();
IChangeTypesRepository changeTypesRepository = new ChangeTypesRepository(context);
IQueryable <ChangeType> changeTypesTable = changeTypesRepository.GetValid();
IQueryable <LegalEntityOwnerAuditView> legalEntityOwnersLE =
(from t in legalEntityOwnerAuditViewList
from t1 in legalEntitiesTable.Where(tbl => tbl.LegalEntityPK == t.OwnerFK).DefaultIfEmpty()
from t2 in additionalFactorsTable.Where(tbl => tbl.AdditionalFactorPK == t.AdditionalFactorFK).DefaultIfEmpty()
from t3 in fulfilledFactorsTable.Where(tbl => tbl.FulfilledFactorPK == t.FulfilledFactorFK).DefaultIfEmpty()
from t4 in bussinesShareBurdensTable.Where(tbl => tbl.BussinesShareBurdenPK == t.BussinesShareBurdenFK).DefaultIfEmpty()
from t5 in changeTypesTable.Where(tbl => tbl.ChangeTypePK == t.ChangeTypeFK).DefaultIfEmpty()
where t.ChangeDate != null && t.OwnerType != null && t.OwnerType.Contains("le")
select new LegalEntityOwnerAuditView
{
LegalEntityOwnerPK = t.LegalEntityOwnerPK,
OwnerName = t1 != null && t1.Name != null ? t1.Name : null,
AdditionalFactorName = t2 != null && t2.Name != null ? t2.Name : null,
FulfilledFactorName = t3 != null && t3.Name != null ? t3.Name : null,
BussinesShareBurdenName = t4 != null && t4.Name != null ? t4.Name : null,
ChangeTypeName = t5 != null && t5.Name != null ? t5.Name : null,
BusinessShareAmount = t.BusinessShareAmount != null ? t.BusinessShareAmount : null,
PaidBussinesShareAmount = t.PaidBussinesShareAmount != null ? t.PaidBussinesShareAmount : null,
NominalBussinesShareAmount = t.NominalBussinesShareAmount != null ? t.NominalBussinesShareAmount : null,
NumberOfVotes = t.NumberOfVotes != null ? t.NumberOfVotes : null,
EntryDate = t.EntryDate != null ? t.EntryDate : null,
ChangeDate = t.ChangeDate != null ? t.ChangeDate : null,
Deleted = t.Deleted != null ? t.Deleted : null,
}).AsQueryable <LegalEntityOwnerAuditView>();
IQueryable <LegalEntityOwnerAuditView> legalEntityOwnersPE =
(from t in legalEntityOwnerAuditViewList
from t1 in physicalEntitiesTable.Where(tbl => tbl.PhysicalEntityPK == t.OwnerFK).DefaultIfEmpty()
from t2 in additionalFactorsTable.Where(tbl => tbl.AdditionalFactorPK == t.AdditionalFactorFK).DefaultIfEmpty()
from t3 in fulfilledFactorsTable.Where(tbl => tbl.FulfilledFactorPK == t.FulfilledFactorFK).DefaultIfEmpty()
from t4 in bussinesShareBurdensTable.Where(tbl => tbl.BussinesShareBurdenPK == t.BussinesShareBurdenFK).DefaultIfEmpty()
from t5 in changeTypesTable.Where(tbl => tbl.ChangeTypePK == t.ChangeTypeFK).DefaultIfEmpty()
where t.ChangeDate != null && t.OwnerType != null && t.OwnerType.Contains("pe")
select new LegalEntityOwnerAuditView
{
LegalEntityOwnerPK = t.LegalEntityOwnerPK,
OwnerName = t1 != null && t1.Firstname != null && t1.Lastname != null ? t1.Firstname + " " + t1.Lastname : null,
AdditionalFactorName = t2 != null && t2.Name != null ? t2.Name : null,
FulfilledFactorName = t3 != null && t3.Name != null ? t3.Name : null,
BussinesShareBurdenName = t4 != null && t4.Name != null ? t4.Name : null,
ChangeTypeName = t5 != null && t5.Name != null ? t5.Name : null,
BusinessShareAmount = t.BusinessShareAmount != null ? t.BusinessShareAmount : null,
PaidBussinesShareAmount = t.PaidBussinesShareAmount != null ? t.PaidBussinesShareAmount : null,
NominalBussinesShareAmount = t.NominalBussinesShareAmount != null ? t.NominalBussinesShareAmount : null,
NumberOfVotes = t.NumberOfVotes != null ? t.NumberOfVotes : null,
EntryDate = t.EntryDate != null ? t.EntryDate : null,
ChangeDate = t.ChangeDate != null ? t.ChangeDate : null,
Deleted = t.Deleted != null ? t.Deleted : null,
}).AsQueryable <LegalEntityOwnerAuditView>();
List <LegalEntityOwnerAuditView> legalEntityOwners = legalEntityOwnersLE.Union(legalEntityOwnersPE).OrderBy(c => c.ChangeDate).ToList();
return(legalEntityOwners);
}
