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); }