public JsonResult BankAccountInformationList(int pageIndex, int pageSize, string sortName, string sortOrder, int investorId) { FlexigridData flexgridData = new FlexigridData(); int totalRows = 0; List<AccountInformation> accountInformations = InvestorRepository.BankAccountInformationList(pageIndex, pageSize, sortName, sortOrder, ref totalRows, investorId); flexgridData.total = totalRows; flexgridData.page = pageIndex; foreach (var account in accountInformations) { flexgridData.rows.Add(new FlexigridRow { cell = new List<object> { account.AccountId, account.BankName, account.AccountNumber, account.ABANumber, account.AccountOf, account.FFC, account.FFCNumber, account.Attention, account.Swift, account.IBAN, account.Reference, account.ByOrderOf } }); } return Json(flexgridData, JsonRequestBehavior.AllowGet); }
public JsonResult ActivityTypeList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.ActivityType> activityTypes=AdminRepository.GetAllActivityTypes(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var activityType in activityTypes) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {activityType.ActivityTypeID, activityType.Name, activityType.Enabled} }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public ActionResult EditShareClassType(int id) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; DeepBlue.Models.Entity.ShareClassType shareClassType=AdminRepository.FindShareClassType(id); flexgridData.total=totalRows; flexgridData.page=0; flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {shareClassType.ShareClassTypeID, shareClassType.ShareClass, shareClassType.Enabled} }); return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult InvestmentDetailList(int pageIndex, int pageSize, string sortName, string sortOrder, int investorId) { FlexigridData flexgridData = new FlexigridData(); int totalRows = 0; List<FundInformation> fundInformations = InvestorRepository.GetInvestmentDetails(pageIndex, pageSize, sortName, sortOrder, ref totalRows, investorId); flexgridData.total = totalRows; flexgridData.page = pageIndex; foreach (var fundInformation in fundInformations) { flexgridData.rows.Add(new FlexigridRow { cell = new List<object> { fundInformation.FundName, fundInformation.InvestorType, FormatHelper.CurrencyFormat(fundInformation.TotalCommitment), FormatHelper.CurrencyFormat(fundInformation.UnfundedAmount), fundInformation.FundClose } }); } return Json(flexgridData, JsonRequestBehavior.AllowGet); }
public ActionResult ExportUnfundedCapitalCallBalanceDetail(FormCollection collection) { ExportUnfundedCapitalCallBalanceDetailModel model = new ExportUnfundedCapitalCallBalanceDetailModel(); this.TryUpdateModel(model); if (ModelState.IsValid) { string error = string.Empty; ResultModel resultModel = new ResultModel(); FlexigridData flexgridData = new FlexigridData(); int pageIndex = DataTypeHelper.ToInt32(collection["pageIndex"]); int pageSize = DataTypeHelper.ToInt32(collection["pageSize"]); string sortName = collection["sortName"]; string sortOrder = collection["sortOrder"]; int totalRows = 0; model.UnfundedCapitalCallBalanceReportDetails = ReportRepository.FindUnfundedCapitalCallBalanceReport(pageIndex, pageSize, sortName, sortOrder, ref totalRows, model.FundId, (model.StartDate ?? Convert.ToDateTime("01/01/1900")), (model.EndDate ?? DateTime.Now)); } if (model.UnfundedCapitalCallBalanceReportDetails == null) model.UnfundedCapitalCallBalanceReportDetails = new List<UnfundedCapitalCallBalanceReportDetail>(); return View(model); }
public JsonResult DocumentTypeList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.DocumentType> documentTypes=AdminRepository.GetAllDocumentTypes(pageIndex,pageSize,sortName,sortOrder,ref totalRows); if(Authentication.CurrentEntity.EntityID!=(int)ConfigUtil.SystemEntityID) { documentTypes=documentTypes.Where(e => e.EntityID==Authentication.CurrentEntity.EntityID).ToList(); } flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var documentType in documentTypes) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {documentType.DocumentTypeID, documentType.DocumentTypeName, documentType.DocumentSectionID, documentType.DocumentSection.Name } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult DealContactList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DealContactList> dealContacts=AdminRepository.GetAllDealContacts(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var dealContact in dealContacts) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { dealContact.ContactId, dealContact.ContactName, dealContact.ContactTitle, dealContact.ContactNotes, dealContact.Email, dealContact.Phone, dealContact.WebAddress } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult CustomFieldList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.CustomField> customFields=AdminRepository.GetAllCustomFields(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var customField in customFields) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { customField.CustomFieldID, customField.CustomFieldText, customField.ModuleID, customField.MODULE.ModuleName, customField.DataTypeID, customField.DataType.DataTypeName, customField.OptionalText, customField.Search} }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult CommunicationTypeList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.CommunicationType> communicationTypes=AdminRepository.GetAllCommunicationTypes(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var communicationType in communicationTypes) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { communicationType.CommunicationTypeID, communicationType.CommunicationTypeName, communicationType.CommunicationGrouping.CommunicationGroupingName, communicationType.Enabled, communicationType.CommunicationGroupingID} }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult FileTypeList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.FileType> fileTypes=AdminRepository.GetAllFileTypes(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var fileType in fileTypes) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {fileType.FileTypeID, fileType.FileTypeName, fileType.FileExtension } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public ActionResult ExportList() { FlexigridData data=new FlexigridData { page=1,total=4 }; data.rows.Add(new FlexigridRow { cell=new List<object> { (int)DeepBlue.Models.Admin.Enums.ExportExcelType.Investor,"Investors" } }); data.rows.Add(new FlexigridRow { cell=new List<object> { (int)DeepBlue.Models.Admin.Enums.ExportExcelType.AmberbrookFund,"Funds" } }); data.rows.Add(new FlexigridRow { cell=new List<object> { (int)DeepBlue.Models.Admin.Enums.ExportExcelType.UnderlyingFund,"Underlying Funds" } }); data.rows.Add(new FlexigridRow { cell=new List<object> { (int)DeepBlue.Models.Admin.Enums.ExportExcelType.UnderlyingDirect,"Underlying Directs" } }); return Json(data,JsonRequestBehavior.AllowGet); }
public JsonResult EntityMenuList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<EntityMenuModel> entityMenus=AdminRepository.GetAllEntityMenus(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var entityMenu in entityMenus) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {entityMenu.EntityMenuID, entityMenu.DisplayName, entityMenu.MenuID, entityMenu.MenuName, entityMenu.SortOrder } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult EntityList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<ENTITY> Entities=AdminRepository.GetAllEntities(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var entity in Entities) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { entity.EntityID, entity.EntityName, entity.EntityCode, entity.Enabled } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public ActionResult EditUser(int id) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; USER user=AdminRepository.FindUser(id); flexgridData.total=totalRows; flexgridData.page=0; flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { user.UserID, user.FirstName, user.LastName, user.Login, user.Email, user.Enabled, user.MiddleName, user.IsAdmin, user.PhoneNumber, user.EntityID } }); return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public ActionResult EditUnderlyingFundType(int id) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; DeepBlue.Models.Entity.UnderlyingFundType underlyingFundType=AdminRepository.FindUnderlyingFundType(id); flexgridData.total=totalRows; flexgridData.page=0; flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {underlyingFundType.UnderlyingFundTypeID, underlyingFundType.Name} }); return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public ActionResult ScheduleK1List(int pageIndex,int pageSize,string sortName,string sortOrder,int? fundID,int? underlyingFundID) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<ScheduleK1ListModel> scheduleK1s=AdminRepository.GetAllScheduleK1s(pageIndex,pageSize,sortName,sortOrder,ref totalRows,fundID,underlyingFundID); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var schedule in scheduleK1s) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { schedule.PartnersShareFormID, schedule.UnderlyingFundName, schedule.PartnershipEIN, schedule.FundName, schedule.PartnerEIN } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult CurrencyList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.Currency> currencies=AdminRepository.GetAllCurrencies(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var currency in currencies) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { currency.CurrencyID, currency.Currency1, currency.Enabled } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult FundClosingList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.FundClosing> fundClosings=AdminRepository.GetAllFundClosings(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var fundClosing in fundClosings) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {fundClosing.FundClosingID, fundClosing.Name, fundClosing.Fund.FundName, fundClosing.FundClosingDate, fundClosing.IsFirstClosing, fundClosing.FundID } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult UserList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<USER> Users=AdminRepository.GetAllUsers(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var user in Users) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { user.UserID, user.FirstName, user.LastName, user.Login, user.Email, user.Enabled, user.MiddleName, user.IsAdmin, user.PhoneNumber, user.EntityID } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult GeographyList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.Geography> geographys=AdminRepository.GetAllGeographys(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var geography in geographys) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {geography.GeographyID, geography.Geography1, geography.Enabled} }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult InvestorTypeList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<InvestorType> investorTypes=AdminRepository.GetAllInvestorTypes(pageIndex,pageSize,sortName,sortOrder,ref totalRows); if(Authentication.CurrentEntity.EntityID!=(int)ConfigUtil.SystemEntityID) { investorTypes=investorTypes.Where(e => e.EntityID==Authentication.CurrentEntity.EntityID).ToList(); } flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var invertorType in investorTypes) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { invertorType.InvestorTypeID, invertorType.InvestorTypeName, invertorType.Enabled} }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult LogList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.Log> logss=AdminRepository.GetAllLogs(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var log in logss) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> { log.Controller, log.Action, log.View, log.QueryString, log.LogText, log.LogDetails.FirstOrDefault().Detail } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public ActionResult EditCashDistributionType(int id) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; DeepBlue.Models.Entity.CashDistributionType cashDistributionType=AdminRepository.FindCashDistributionType(id); flexgridData.total=totalRows; flexgridData.page=0; flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {cashDistributionType.CashDistributionTypeID, cashDistributionType.Name, cashDistributionType.Enabled} }); return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult MenuList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.Menu> menus=AdminRepository.GetAllMenus(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var menu in menus) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {menu.MenuID, menu.DisplayName, menu.ParentMenuID, (menu.Menu2 != null ? (menu.Menu2.Menu2 != null ? menu.Menu2.Menu2.DisplayName + " -> " : string.Empty) : string.Empty) + (menu.Menu2 != null ? menu.Menu2.DisplayName : string.Empty), menu.Title, menu.URL } }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult UnfundedCapitalCallBalanceReport(FormCollection collection) { UnfundedCapitalCallBalanceModel model = new UnfundedCapitalCallBalanceModel(); this.TryUpdateModel(model, collection); string error = string.Empty; ResultModel resultModel = new ResultModel(); FlexigridData flexgridData = new FlexigridData(); int pageIndex = DataTypeHelper.ToInt32(collection["pageIndex"]); int pageSize = DataTypeHelper.ToInt32(collection["pageSize"]); string sortName = collection["sortName"]; string sortOrder = collection["sortOrder"]; int totalRows = 0; if (ModelState.IsValid) { List<UnfundedCapitalCallBalanceReportDetail> unfundedCapitalCallBalances = ReportRepository.FindUnfundedCapitalCallBalanceReport(pageIndex, pageSize, sortName, sortOrder, ref totalRows, model.FundId, (model.StartDate ?? Convert.ToDateTime("01/01/1900")), (model.EndDate ?? DateTime.Now)); flexgridData.total = totalRows; flexgridData.page = 1; foreach (var unfundedCapitalCallBalance in unfundedCapitalCallBalances) { flexgridData.rows.Add(new FlexigridRow { cell = new List<object> { unfundedCapitalCallBalance.DealNo, unfundedCapitalCallBalance.FundName, unfundedCapitalCallBalance.UnfundedAmount } }); } } else { foreach (var values in ModelState.Values.ToList()) { foreach (var err in values.Errors.ToList()) { if (string.IsNullOrEmpty(err.ErrorMessage) == false) { error += err.ErrorMessage + "\n"; } } } } return Json(new { Error = error, Data = flexgridData, page = pageIndex, total = totalRows }, JsonRequestBehavior.AllowGet); }
public JsonResult ModuleList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.MODULE> modules=AdminRepository.GetAllModules(pageIndex,pageSize,sortName,sortOrder,ref totalRows); flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var module in modules) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {module.ModuleID, module.ModuleName} }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult InvestorLibraryList(int pageIndex, int pageSize, string sortName, string sortOrder, int? investorId, int? fundId) { ResultModel resultModel = new ResultModel(); List<InvertorLibraryInformation> investorLibrary = null; int totalRows = 0; int leftPageIndex = 0; int rightPageIndex = 0; int totalPages = 0; FlexigridData flexgridData = new FlexigridData(); List<InvestorList> investorLists = new List<InvestorList>(); investorLibrary = InvestorRepository.GetInvestorLibraryList(pageIndex, pageSize, sortName, sortOrder, ref totalRows, investorId, fundId); flexgridData.total = totalRows; flexgridData.page = pageIndex; foreach (var fund in investorLibrary) { flexgridData.rows.Add(new FlexigridRow { cell = new List<object> { new { fund.FundName, fund.FundID, fund.TotalCommitted } } }); foreach (var fundInformation in fund.FundInformations) { InvestorList investor = investorLists.FirstOrDefault(fundInvestor => fundInvestor.InvestorID == fundInformation.InvestorID); if (investor == null) { investorLists.Add(new InvestorList { FundID = fund.FundID, InvestorID = fundInformation.InvestorID, InvestorName = fundInformation.InvestorName }); } } } investorLists.Sort(); totalPages = Convert.ToInt32(Math.Ceiling(decimal.Divide((decimal)totalRows, (decimal)pageSize))); if (totalPages > pageIndex) { rightPageIndex = pageIndex + 1; } if (pageIndex > 1) { leftPageIndex = pageIndex - 1; } return Json(new { FlexGridData = flexgridData, Investors = investorLists, LeftPageIndex = leftPageIndex, RightPageIndex = rightPageIndex, Library = investorLibrary }, JsonRequestBehavior.AllowGet); }
public JsonResult ReportingFrequencyList(int pageIndex,int pageSize,string sortName,string sortOrder) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; List<DeepBlue.Models.Entity.ReportingFrequency> reportingFrequencys=AdminRepository.GetAllReportingFrequencies(pageIndex,pageSize,sortName,sortOrder,ref totalRows); if(Authentication.CurrentEntity.EntityID!=(int)ConfigUtil.SystemEntityID) { reportingFrequencys=reportingFrequencys.Where(e => e.EntityID==Authentication.CurrentEntity.EntityID).ToList(); } flexgridData.total=totalRows; flexgridData.page=pageIndex; foreach(var reportingFrequency in reportingFrequencys) { flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {reportingFrequency.ReportingFrequencyID, reportingFrequency.ReportingFrequency1, reportingFrequency.Enabled} }); } return Json(flexgridData,JsonRequestBehavior.AllowGet); }
public JsonResult ContactInformationList(int pageIndex, int pageSize, string sortName, string sortOrder, int investorId) { FlexigridData flexgridData = new FlexigridData(); int totalRows = 0; List<ContactInformation> contactInformations = InvestorRepository.ContactInformationList(pageIndex, pageSize, sortName, sortOrder, ref totalRows, investorId); flexgridData.total = totalRows; flexgridData.page = pageIndex; foreach (var contact in contactInformations) { flexgridData.rows.Add(new FlexigridRow { cell = new List<object> { contact.ContactId, contact.InvestorContactId, contact.AddressId, contact.ContactAddressId, contact.Person, contact.Designation, contact.Phone, contact.Fax, contact.Email, contact.WebAddress, contact.Address1, contact.Address2, contact.City, contact.Country, contact.CountryName, contact.State, contact.StateName, contact.Zip, contact.DistributionNotices, contact.Financials, contact.K1, contact.InvestorLetters } }); } return Json(flexgridData, JsonRequestBehavior.AllowGet); }
public ActionResult EditReportingFrequency(int id) { FlexigridData flexgridData=new FlexigridData(); int totalRows=0; DeepBlue.Models.Entity.ReportingFrequency reportingFrequency=AdminRepository.FindReportingFrequency(id); flexgridData.total=totalRows; flexgridData.page=0; flexgridData.rows.Add(new FlexigridRow { cell=new List<object> {reportingFrequency.ReportingFrequencyID, reportingFrequency.ReportingFrequency1, reportingFrequency.Enabled} }); return Json(flexgridData,JsonRequestBehavior.AllowGet); }