Exemplo n.º 1
0
        public ActionResult EditProject(Guid id)
        {
            ProjectDonor pd = projectService.GetProjectDonorById(id);

            Models.Project project = new Models.Project();
            project.Id                = pd.Id.ToString();
            project.EntityProject     = pd.Project;
            project.ProjectNumber     = pd.ProjectNumber;
            project.CurrencyId        = pd.CurrencyId.ToString();
            project.ProjectManagerId  = pd.ProjectManagerId;
            project.DonorId           = pd.DonorId.ToString();
            project.StartDate         = (DateTime)pd.StartDate;
            project.EndDate           = (DateTime)pd.EndDate;
            project.OverrunAdjustment = pd.OverrunAdjustment;
            _donors            = projectService.GetDonors(countryProg.Id);
            _currencies        = projectService.GetCurrencies(countryProg.Id);
            project.StaffList  = new SelectList(staffService.GetStaffByCountryProgramme(countryProg.Id), "StaffId", "StaffName");
            project.Donors     = new SelectList(_donors, "Id", "Name");
            project.Currencies = new SelectList(_currencies, "Id", "Name", pd.CurrencyId);
            ViewBag.FormHeader = "Project: " + pd.ProjectNumber;
            ViewBag.ButtonText = Resources.BudgetController_String_SaveProject;
            ViewBag.EditMode   = 1;
            ViewBag.Id         = id;
            List <BudgetCategory> bcList = budgetService.GetBudgetCategories(pd);

            if (bcList.Count > 0)
            {
                ViewBag.HasBudget = 1;
            }
            else
            {
                ViewBag.HasBudget = 0;
            }
            return(View("CreateProject", project));
        }
Exemplo n.º 2
0
        public ActionResult SaveCategory(Models.BudgetCategory bc)
        {
            ProjectDonor   pd             = projectService.GetProjectDonorById(bc.EntityBudgetCategory.ProjectDonorId.Value);
            BudgetCategory budgetCategory = budgetService.GetBudgetCategoryByNumber(bc.Number, pd.Id);

            if (bc.BudgetCategoryId == null || bc.BudgetCategoryId.Trim() == "")
            {
                if (budgetCategory == null)
                {
                    budgetService.CreateBudgetCategory(bc.EntityBudgetCategory, pd);
                }
                else
                {
                    ViewBag.ActionStatus = 0;
                    ViewBag.StatusMsg    = string.Format(Resources.BudgetController_String_CategoryExists, bc.EntityBudgetCategory.Number);
                }
            }
            else
            {
                if (budgetCategory == null)
                {
                    budgetService.UpdateBudgetCategory(bc.EntityBudgetCategory);
                }
                else if (budgetCategory != null && budgetCategory.Id == bc.EntityBudgetCategory.Id)
                {
                    budgetService.UpdateBudgetCategory(bc.EntityBudgetCategory);
                }
                else
                {
                    ViewBag.ActionStatus = 0;
                    ViewBag.StatusMsg    = string.Format(Resources.BudgetController_String_CategoryExists, bc.EntityBudgetCategory.Number);
                }
            }
            return(CategoryList(pd.Id));
        }
Exemplo n.º 3
0
 public List <ProjectBudget> GetBudgetLinesNotInBudget(ProjectDonor pd, BudgetCategory bc)
 {
     try
     {
         List <ProjectBudget> budgetLineList = new List <ProjectBudget>();
         using (var context = new SCMSEntities())
         {
             var budgetLines = context.ProjectBudgets.Where(b => b.BudgetCategory.ProjectDonorId == pd.Id).ToList <ProjectBudget>();
             var subLines    = context.ProjectBudgets.Where(s => s.BudgetCategoryId == bc.Id).ToList <ProjectBudget>();
             foreach (var subLine in subLines)
             {
                 if (!SubLineExistsInBudgetLines(subLine, budgetLines))
                 {
                     budgetLineList.Add(subLine);
                 }
             }
         }
         //sort bl
         budgetLineList = SCMS.Utils.BudgetLineSorter.SortBudgetLine(budgetLineList);
         return(budgetLineList);
     }
     catch (Exception ex)
     {
         return(new List <ProjectBudget>());
     }
 }
Exemplo n.º 4
0
 public List <ProjectBudget> GetProjectBLByCategory(ProjectDonor pd, BudgetCategory bc)
 {
     try
     {
         List <ProjectBudget> projectBL = new List <ProjectBudget>();
         using (var context = new SCMSEntities())
         {
             var budgetLines = context.ProjectBudgets.Where(b => b.BudgetCategory.ProjectDonorId == pd.Id).ToList <ProjectBudget>();
             var subLines    = context.ProjectBudgets.Where(s => s.BudgetCategoryId == bc.Id).ToList <ProjectBudget>();
             foreach (var budgetLine in budgetLines)
             {
                 var curr = budgetLine.BudgetCategory.ProjectDonor.Currency;
                 if (BudgetLineExistsInCategory(budgetLine, subLines))
                 {
                     projectBL.Add(budgetLine);
                 }
             }
         }
         projectBL = SCMS.Utils.BudgetLineSorter.SortBudgetLine(projectBL);
         return(projectBL);
     }
     catch (Exception ex)
     {
         return(new List <ProjectBudget>());
     }
 }
Exemplo n.º 5
0
        public ActionResult LoadAddPPItemsToPO(Guid poId, Guid?pdId = null)
        {
            PurchaseOrder   po    = poService.GetPurchaseOrderById(poId);
            ProjectDonor    pd    = pdId.HasValue ? orService.GetProjectDonorById(pdId.Value) : orService.GetProjectNosWithPP().FirstOrDefault();
            ProcurementPlan model = pd != null?ppService.GetProcurementPlanByProjectId(pd.Id) : null;

            if (model == null || !model.IsAuthorized)
            {
                model            = new ProcurementPlan();
                model.PPItemList = new List <ProcurementPlanItem>();
            }
            else
            {
                model.PPItemList = model.ProcurementPlanItems.Where(p => (p.Quantity - p.ProcuredAmount) > 0).OrderBy(p => p.Item.Name).ToList();
                foreach (ProcurementPlanItem ppItem in model.PPItemList)
                {
                    ppItem.UnitCost        = Math.Round(exchangeRateService.GetForeignCurrencyValue(po.CurrencyId, ppItem.CurrencyId, ppItem.UnitCost, countryProg.Id), 2);
                    ppItem.QuantityToOrder = ppItem.Quantity - ppItem.ProcuredAmount;
                    ppItem.TotalCost       = Math.Round((ppItem.UnitCost * ppItem.QuantityToOrder), 2);
                }
            }
            model.PurchaseOrderId = poId;
            model.ProjectId       = pd != null ? pd.ProjectId : Guid.Empty;
            model.Projects        = new SelectList(orService.GetProjectsWithPP(), "Id", "Name", pd != null ? pd.ProjectId : Guid.Empty);
            model.ProjectDonors   = new SelectList(orService.GetProjectNosWithPP(pd != null ? pd.ProjectId : Guid.Empty), "Id", "ProjectNumber", model.ProjectDonorId);
            return(View("AddPPItemsToPO", model));
        }
Exemplo n.º 6
0
        public ActionResult ViewBudget(Guid id)
        {
            ProjectDonor           pd    = projectService.GetProjectDonorById(id);
            List <Models.Category> model = Models.BudgetExtension.PrepareBudgetModel(budgetService, exchangeRateService, currencyService, countryProg, pd, pd.Currency);

            return(RenderBudgetView(model, pd));
        }
Exemplo n.º 7
0
 public List <ProjectBudget> GetBudgetLinesByGLCode(GeneralLedger gl, ProjectDonor pd)
 {
     using (var context = new SCMSEntities())
     {
         var pbList = context.ProjectBudgets.Where(b => b.GeneralLedger.Id == gl.Id && b.BudgetCategory.ProjectDonorId == pd.Id).ToList();
         pbList = SCMS.Utils.BudgetLineSorter.SortBudgetLine(pbList);
         return(pbList);
     }
 }
Exemplo n.º 8
0
        public ActionResult ApprovalSettings(Guid Id)
        {
            ProjectDonor    pd           = projectService.GetProjectDonorById(Id);
            List <Approver> approverList = staffService.GetProjectApprovers(Id);

            UserSession.CurrentSession.ProjectDonorId = Id;
            ViewBag.FormHeader = Resources.Global_String_Project + ": " + pd.ProjectNumber + " - " + Resources.Approver_Index_ApprovalSettings;
            ViewBag.Id         = pd.Id;
            return(View("ApprovalSettings", approverList));
        }
Exemplo n.º 9
0
        public ActionResult CreateCategory(Guid id)
        {
            ProjectDonor pd = projectService.GetProjectDonorById(id);

            budgetCategory = new Models.BudgetCategory();
            budgetCategory.EntityBudgetCategory = new BudgetCategory();
            budgetCategory.EntityBudgetCategory.ProjectDonorId = pd.Id;
            ViewBag.FormHeader = Resources.BudgetController_String_NewBudgetCategory;
            ViewBag.ButtonText = Resources.BudgetController_String_AddCategory;
            return(View(budgetCategory));
        }
Exemplo n.º 10
0
 public ProjectDonor GetProjectDonorById(Guid projectDonorId)
 {
     using (var context = new SCMSEntities())
     {
         ProjectDonor pd = (ProjectDonor)context.ProjectDonors.Where(p => p.Id == projectDonorId).FirstOrDefault();
         Project pj = pd.Project;
         Donor d = pd.Donor;
         Currency c = pd.Currency;
         Person person = pd.Staff.Person;
         return pd;
     }
 }
Exemplo n.º 11
0
        public ActionResult Detail(ProjectDonor pdModel)
        {
            ProjectDonor pDonor = this.projectService.GetProjectDonorById(pdModel.Id);
            Currency displayCurrency = currencyService.GetCurrency((Guid)pdModel.CurrencyId);
            if (displayCurrency == null)
                displayCurrency = pDonor.Currency;

            List<Models.Category> categories = Models.BudgetExtension.PrepareBudgetModel(budSvc, exchangeRateService, currencyService, countryProg, pDonor, displayCurrency);
            Dictionary<String, String> data = new Dictionary<string, string>();

            data.Add("{START-DATE}", pDonor.StartDate.ToString("dd/MM/yyyy"));
            data.Add("{END-DATE}", pDonor.EndDate.ToString("dd/MM/yyyy"));

            data.Add("{PROJECT}", pDonor.Project.Name);
            data.Add("{DONOR}", pDonor.Donor.Name);
            data.Add("{CURRENCY}", displayCurrency.ShortName);
            data.Add("{BUDGET_NUM}", pDonor.ProjectNumber);

            data.Add("{TOTAL_BUDGET}", categories[categories.Count - 1].TotalBudget.ToString("#,##0.00"));
            data.Add("{TOTAL_COMMITTED}", ND2S(categories[categories.Count - 1].TotalCommitted));
            data.Add("{ACTUAL_POSTED}", ND2S(categories[categories.Count - 1].TotalPosted));
            data.Add("{REMAINING_FUNDS}", ND2S(categories[categories.Count - 1].RemainingBalance));

            data.Add("{GENERATED}", DateTime.Now.ToString("f"));

            String tbody = "";
            for (int k = 0; k < categories.Count - 1; k++)
            {
                tbody += "<tr style=\"background-color: #EAF1DD; font-weight:bold;\"><td class='central'><b>" + categories[k].Number + "</b></td>";
                tbody += "<td><b>" + categories[k].Name + "</b></td>";
                tbody += "<td class='east'><b>" + categories[k].TotalBudget.ToString("#,##0.00") + "</b></td>";
                tbody += "<td class='east'><b>" + ND2S(categories[k].TotalCommitted) + "</b></td>";
                tbody += "<td class='east'><b>" + ND2S(categories[k].TotalPosted) + "</b></td>";
                tbody += "<td class='east'><b>" + ND2S(categories[k].RemainingBalance) + "</b></td></tr>";

                foreach (SCMS.UI.Models.BudgetLine b in categories[k].BudgetLines)
                {
                    tbody += "<tr><td class='central'>" + b.LineNumber + "</td>";
                    tbody += "<td>" + b.Description + "</td>";
                    tbody += "<td class='east'>" + b.TotalBudget.ToString("#,##0.00") + "</td>";
                    tbody += "<td class='east'>" + ND2S(b.TotalCommitted) + "</td>";
                    tbody += "<td class='east'>" + ND2S(b.TotalPosted) + "</td>";
                    tbody += "<td class='east'>" + ND2S(b.RemainingBalance) + "</td></tr>";
                }
            }

            data.Add("{DETAIL}", tbody);

            Byte[] output = WkHtml2Pdf.CreateReport(data, "project-budget.html");//= new Byte[1];;//

            return File(output, "application/pdf", "ProjectB_" + DateTime.Now.FormatDDMMMYYYYHHmm());
        }
Exemplo n.º 12
0
        public ActionResult ViewBudgetInCurr(ProjectDonor pdModel)
        {
            ProjectDonor pd = projectService.GetProjectDonorById(pdModel.Id);
            Currency     displayCurrency = currencyService.GetCurrency((Guid)pdModel.CurrencyId);

            if (displayCurrency == null)
            {
                displayCurrency = pd.Currency;
            }
            List <Models.Category> model = Models.BudgetExtension.PrepareBudgetModel(budgetService, exchangeRateService, currencyService, countryProg, pd, displayCurrency);

            return(RenderBudgetView(model, pd));
        }
Exemplo n.º 13
0
 public List <ProjectBudget> GetProjectBugdetLines(ProjectDonor pd)
 {
     try
     {
         using (var context = new SCMSEntities())
         {
             var pbList = context.ProjectBudgets.Where(pb => pb.BudgetCategory.ProjectDonorId == pd.Id).ToList <ProjectBudget>();
             pbList = SCMS.Utils.BudgetLineSorter.SortBudgetLine(pbList);
             return(pbList);
         }
     }
     catch (Exception ex)
     {
         return(new List <ProjectBudget>());
     }
 }
Exemplo n.º 14
0
 public List <BudgetCategory> GetBudgetCategories(ProjectDonor pd)
 {
     try
     {
         using (var context = new SCMSEntities())
         {
             var list = context.BudgetCategories.Where(b => b.ProjectDonorId == pd.Id).OrderBy(b => b.Number).ToList <BudgetCategory>();
             list = SCMS.Utils.BudgetLineSorter.SortCategory(list);
             return(list);
         }
     }
     catch (Exception ex)
     {
         return(new List <BudgetCategory>());
     }
 }
Exemplo n.º 15
0
 public void DeleteBudgetLine(ProjectBudget budgetLine, ref ProjectDonor pd)
 {
     try
     {
         using (var context = new SCMSEntities())
         {
             var pb            = context.ProjectBudgets.First(b => b.Id == budgetLine.Id);
             var dummyCurrency = pd.Currency;
             var dummyDonor    = pd.Donor;
             context.ProjectBudgets.Remove(pb);
             context.SaveChanges();
         }
     }
     catch (Exception ex)
     {
     }
 }
Exemplo n.º 16
0
        private List <Models.MBCategoryLink> ConstructGLCodesList(ProjectDonor pd, List <MasterBudgetCategory> mbList)
        {
            Models.MBCategoryLink        mbLink;
            List <Models.MBCategoryLink> mbLinkList = new List <Models.MBCategoryLink>();

            foreach (MasterBudgetCategory mbc in mbList)
            {
                mbLink = new Models.MBCategoryLink();
                mbLink.EntityMasterBudgetCateogry = mbc;
                mbLink.ProjectBudgetLines         = PopulateMBCategoryBudgetLines(mbc, pd, mbList);
                if (mbLink.ProjectBudgetLines.Count > 0)
                {
                    mbLinkList.Add(mbLink);
                }
            }
            return(mbLinkList);
        }
Exemplo n.º 17
0
        public ActionResult LinkToMB(Guid id)
        {
            ProjectDonor pd = projectService.GetProjectDonorById(id);
            List <MasterBudgetCategory>  mbcList    = masterBudgetService.GetMasterBudgetCategories(countryProg);
            List <GeneralLedger>         glList     = budgetService.GetGeneralLedgers(countryProg.Id);
            List <Models.Category>       categories = ConstructCategoriesList(pd, glList);
            List <Models.MBCategoryLink> mbLinks    = ConstructGLCodesList(pd, mbcList);

            Models.MasterBudgetLinker mbLinker = new Models.MasterBudgetLinker();
            mbLinker.BudgetCaterogies       = categories;
            mbLinker.MasterBudgetCategories = mbLinks;
            mbLinker.Id       = pd.Id.ToString();
            ViewBag.ProjectNo = pd.ProjectNumber;
            ViewBag.Currency  = pd.Currency.ShortName;
            ViewBag.Donor     = pd.Donor.Name;
            return(View("LinkToMB", mbLinker));
        }
Exemplo n.º 18
0
        /// <summary>
        /// Used for display views with the SCMS.UI.Models.SubLine class
        /// </summary>
        /// <param name="bc"></param>
        /// <returns></returns>
        private List <Models.BudgetLine> GetCategorySubLines(BudgetCategory bc, ProjectDonor pd)
        {
            List <Models.BudgetLine> subLines = new List <Models.BudgetLine>();
            List <ProjectBudget>     bsl      = budgetService.GetBudgetLinesNotInBudget(pd, bc);

            Models.BudgetLine subLine;
            foreach (ProjectBudget item in bsl)
            {
                subLine = new Models.BudgetLine();
                subLine.EntityBudgetLine     = item;
                subLine.SubLineId            = item.Id;
                subLine.BudgetCategoryId     = bc.Id.ToString();
                subLine.BudgetCategoryNumber = bc.Number;
                subLines.Add(subLine);
            }
            return(subLines);
        }
Exemplo n.º 19
0
 private ActionResult RenderBudgetView(List <Models.Category> categories, ProjectDonor pd)
 {
     //If budget has no sublines, then we can't render the edit budget page.
     if (categories.Count == 0)
     {
         return(CategoryList(pd.Id));
     }
     ViewBag.ProjectId      = pd.Id.ToString();
     ViewBag.ProjectNo      = pd.ProjectNumber;
     ViewBag.StartDate      = pd.StartDate.ToString("dd/MM/yyyy");
     ViewBag.EndDate        = pd.EndDate.ToString("dd/MM/yyyy");
     ViewBag.Currency       = pd.Currency.ShortName;
     ViewBag.Donor          = pd.Donor.Name;
     ViewBag.DonorId        = pd.Id;
     ViewBag.ProjectName    = pd.Project.Name;
     ViewBag.ProjectManager = pd.Staff.Person.FirstName + " " + pd.Staff.Person.OtherNames;
     ViewBag.AllowedOverrun = pd.OverrunAdjustment.HasValue ? pd.OverrunAdjustment.Value.ToString("#,##0.00") + "%" : "NOT SET";
     return(View("ViewBudget", categories));
 }
Exemplo n.º 20
0
        private List <Models.Category> ConstructCategoriesList(ProjectDonor pd, List <GeneralLedger> glList)
        {
            List <BudgetCategory> bcList = budgetService.GetBudgetCategories(pd);

            Models.Category        modelBC;
            List <Models.Category> categories = new List <Models.Category>();

            foreach (BudgetCategory bc in bcList)
            {
                modelBC = new Models.Category();
                modelBC.EntityBudgetCategory = bc;
                modelBC.Id          = bc.Id.ToString();
                modelBC.BudgetLines = PopulateCategoryBudgetLines(modelBC.EntityBudgetCategory, glList);
                if (modelBC.BudgetLines.Count > 0)
                {
                    categories.Add(modelBC);
                }
            }
            return(categories);
        }
Exemplo n.º 21
0
        public ActionResult SaveLinkToMB(Models.MasterBudgetLinker mbl)
        {
            string[]     x  = Request.Form.GetValues("projectId");
            ProjectDonor pd = projectService.GetProjectDonorById(new Guid(x[0]));

            if (mbl.BudgetCaterogies != null)
            {
                foreach (Models.Category cat in mbl.BudgetCaterogies)
                {
                    foreach (Models.BudgetLine bl in cat.BudgetLines)
                    {
                        if (bl.GeneralLedgerId.HasValue)
                        {
                            budgetService.LinkBudgetLineToMasterBudget(bl.BudgetLineId, bl.GeneralLedgerId);
                        }
                    }
                }
            }
            ModelState.Clear();
            return(LinkToMB(pd.Id));
        }
Exemplo n.º 22
0
 public void AddBudgetLines(ProjectDonor pd, List <ProjectBudget> budget)
 {
     try
     {
         using (var context = new SCMSEntities())
         {
             foreach (ProjectBudget pb in budget)
             {
                 var newBgt = new ProjectBudget();
                 newBgt.Id             = pb.Id;
                 newBgt.TotalBudget    = pb.TotalBudget;
                 newBgt.TotalCommitted = newBgt.TotalPosted = 0;
                 context.ProjectBudgets.Add(newBgt);
             }
             context.SaveChanges();
         }
     }
     catch (Exception ex)
     {
     }
 }
Exemplo n.º 23
0
 public void CreateBudgetCategory(BudgetCategory budgetCategory, ProjectDonor pd)
 {
     try
     {
         using (var context = new SCMSEntities())
         {
             var bc = new BudgetCategory();
             bc.Id             = Guid.NewGuid();
             bc.Name           = budgetCategory.Name;
             bc.Number         = budgetCategory.Number;
             bc.Description    = budgetCategory.Description;
             bc.ProjectDonorId = pd.Id;
             context.BudgetCategories.Add(bc);
             context.SaveChanges();
             ClearProjectDonorList();
         }
     }
     catch (Exception ex)
     {
     }
 }
Exemplo n.º 24
0
 /// <summary>
 /// Saves budget. It only affects the TotalBudget amount
 /// </summary>
 /// <param name="pd"></param>
 /// <param name="budget"></param>
 public void SaveBudgetLines(ProjectDonor pd, List <ProjectBudget> budgetLines)
 {
     try
     {
         using (var context = new SCMSEntities())
         {
             foreach (var bl in budgetLines)
             {
                 var budgetLine = context.ProjectBudgets.FirstOrDefault(b => b.Id == bl.Id);
                 if (budgetLine == null)
                 {
                     continue;
                 }
                 budgetLine.TotalBudget = bl.TotalBudget;
             }
             context.SaveChanges();
             ClearProjectBudgetList();
         }
     }
     catch (Exception ex)
     {
     }
 }
Exemplo n.º 25
0
 public void CreateProjectDonor(Project project, DateTime startDate, DateTime endDate, Guid projectManagerId, string donorId, string currencyId, double? overrunAdjustment, ref string pdId)
 {
     if (ProjectNumberExits(project.ProjectNumber, null))
     {
         pdId = null;
         return;
     }
     using (var context = new SCMSEntities())
     {
         ProjectDonor pd = new ProjectDonor();
         pd.Id = Guid.NewGuid();
         pd.StartDate = startDate;
         pd.EndDate = endDate;
         pd.ProjectId = project.Id;
         pd.ProjectManagerId = projectManagerId;
         pd.DonorId = new Guid(donorId);
         pd.CurrencyId = new Guid(currencyId);
         pd.ProjectNumber = project.ProjectNumber;
         pd.OverrunAdjustment = overrunAdjustment;
         context.ProjectDonors.Add(pd);
         context.SaveChanges();
         pdId = pd.Id.ToString();
     }
 }
Exemplo n.º 26
0
        public ActionResult CategoryList(Guid id)
        {
            ProjectDonor pd = projectService.GetProjectDonorById(id);

            Models.BudgetCategory modelBC;
            decimal totalBudget;
            List <BudgetCategory> bcList = budgetService.GetBudgetCategories(pd);

            budgetCategories = new List <Models.BudgetCategory>();
            foreach (BudgetCategory bc in bcList)
            {
                modelBC = new Models.BudgetCategory();
                modelBC.EntityBudgetCategory = bc;
                modelBC.BudgetCategoryId     = bc.Id.ToString();
                modelBC.SubLines             = PopulateCategorySubLines(modelBC.EntityBudgetCategory, out totalBudget);
                modelBC.TotalBudget          = totalBudget;
                budgetCategories.Add(modelBC);
            }
            ViewBag.ProjectNo = pd.ProjectNumber;
            ViewBag.Donor     = pd.Donor.Name;
            ViewBag.Currency  = pd.Currency.ShortName;
            ViewBag.Id        = pd.Id.ToString();
            return(View("CategoryList", budgetCategories));
        }
Exemplo n.º 27
0
        private List <Models.BudgetLine> PopulateMBCategoryBudgetLines(MasterBudgetCategory mbc, ProjectDonor pd, List <MasterBudgetCategory> mbcList)
        {
            List <Models.BudgetLine> blList = new List <Models.BudgetLine>();

            Models.BudgetLine    bl;
            List <ProjectBudget> budgetLines = budgetService.GetBudgetLinesByMBCategory(mbc, pd);

            foreach (ProjectBudget budgetLine in budgetLines)
            {
                bl = new Models.BudgetLine();
                bl.BudgetCategoryId   = mbc.Id.ToString();
                bl.EntityBudgetLine   = budgetLine;
                bl.GeneralLedgerCodes = new SelectList(mbcList, "Id", "DataText");
                bl.BudgetLineId       = budgetLine.Id;
                blList.Add(bl);
            }
            return(blList);
        }
Exemplo n.º 28
0
        public static List <Models.Category> PrepareBudgetModel(IBudgetService budgetService, IExchangeRateService exchangeRateService,
                                                                ICurrencyService currencyService, CountryProgramme countryProg, ProjectDonor pd, Currency displayCurrency)
        {
            List <Model.BudgetCategory> bcList = budgetService.GetBudgetCategories(pd);
            List <Model.ProjectBudget>  budgetLines;
            List <Models.Category>      categories = new List <Models.Category>();

            Models.Category category;
            int             i = 0;

            foreach (Model.BudgetCategory bc in bcList)
            {
                budgetLines = budgetService.GetProjectBLByCategory(pd, bc);
                if (budgetLines.Count > 0)
                {
                    category = new Models.Category();
                    category.EntityBudgetCategory = bc;
                    category.Id = bc.Id.ToString();
                    if (i == 0)
                    {
                        category.ProjectDonorId = (Guid)bc.ProjectDonorId;
                        category.Currencies     = new SelectList(currencyService.GetCurrencies(countryProg.Id), "Id", "ShortName", displayCurrency.Id);
                        category.CurrencyId     = displayCurrency.Id;
                    }
                    AddCategoryLinesWithNumbers(exchangeRateService, category, budgetLines, displayCurrency, countryProg);
                    categories.Add(category);
                }
            }
            if (categories.Count > 0)
            {
                ComputeTotals(categories);
            }
            return(categories);
        }
Exemplo n.º 29
0
 public List <ProjectBudget> GetBudgetLinesByMBCategory(MasterBudgetCategory mbc, ProjectDonor pd)
 {
     try
     {
         using (var context = new SCMSEntities())
         {
             var pbList = context.ProjectBudgets.IncludeGeneralLedger().Where(b => b.GeneralLedger.MasterBudgetCategoryId == mbc.Id && b.BudgetCategory.ProjectDonorId == pd.Id).ToList();
             pbList = SCMS.Utils.BudgetLineSorter.SortBudgetLine(pbList);
             return(pbList);
         }
     }
     catch (Exception ex)
     {
         return(new List <ProjectBudget>());
     }
 }
Exemplo n.º 30
0
        public ActionResult Download(ProjectDonor pdModel)
        {
            ReportService rpSvc = new ReportService();

            ProjectService pSvc = new ProjectService();

            ProjectDonor pDonor = pSvc.GetProjectDonorById(pdModel.Id);
            Currency displayCurrency = currencyService.GetCurrency((Guid)pdModel.CurrencyId);
            if (displayCurrency == null)
                displayCurrency = pDonor.Currency;

            if (pDonor == null)
            {
                using (var stream = new MemoryStream())
                {
                    using (var xlPackage = new ExcelPackage())
                    {
                        var ws = xlPackage.Workbook.Worksheets.Add("Sheet1");
                        ws.SetValue(1, 1, "Unknown Donor.");
                        xlPackage.SaveAs(stream);
                    }

                    return File(stream.ToArray(), "application/excel", "unknown-donor" + " - " + DateTime.Now.Ticks.ToString() + ".xlsx");
                }
            }

            using (var stream = new MemoryStream())
            {
                using (var xlPackage = new ExcelPackage())
                {
                    var ws = xlPackage.Workbook.Worksheets.Add("Project Budget");
                    ws.SetValue(1, 1, "Project No.");
                    ws.SetValue(1, 2, pDonor.Project.ProjectNumber);

                    //format
                    using (ExcelRange r = ws.Cells["A1:B1"])
                    {
                        //r.Merge = true;
                        r.Style.Font.SetFromFont(new Font("Arial", 10, FontStyle.Regular));
                        r.Style.Font.Color.SetColor(Color.Red);
                        //r.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(23, 55, 93));
                    }

                    ws.SetValue(2, 1, "Currency");
                    ws.SetValue(2, 2, displayCurrency.ShortName);

                    //headings
                    ws.SetValue(4, 1, "BUDGETLINE");
                    ws.SetValue(4, 2, "DESCRIPTION");
                    ws.SetValue(4, 3, "TOTAL BUDGET");
                    ws.SetValue(4, 4, "COMMITTED");
                    ws.SetValue(4, 5, "ACTUAL POSTING");
                    ws.SetValue(4, 6, "REMAINING FUND");
                    ws.SetValue(4, 7, "% SPEND");
                    //
                    using (ExcelRange r = ws.Cells["A4:G4"])
                    {
                        r.Style.Font.SetFromFont(new Font("Arial", 10, FontStyle.Regular));
                        //r.Style.Font.UnderLine = true;
                        r.Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
                    }

                    //List<BudgetCategory> bCats = budSvc.GetBudgetCategories(pDonor);
                    //List<Models.Category> categories = new List<Models.Category>();
                    //foreach (BudgetCategory b in bCats)
                    //{
                    //    List<SCMS.Model.ProjectBudget> pBudgets = budSvc.GetProjectBLByCategory(pDonor, b);

                    //    if (pBudgets.Count > 0)
                    //    {
                    //        Models.Category category = new Models.Category();
                    //        category.EntityBudgetCategory = b;
                    //        category.Id = b.Id.ToString();
                    //        AddCategoryLinesWithNumbers(category, pBudgets, displayCurrency);
                    //        categories.Add(category);
                    //    }
                    //}

                    List<Models.Category> categories = Models.BudgetExtension.PrepareBudgetModel(budSvc, exchangeRateService, currencyService, countryProg, pDonor, displayCurrency);

                    int c = 6;
                    foreach (var cat in categories)
                    {
                        if (cat.BudgetLines == null)
                            continue;
                        foreach (Models.BudgetLine line in cat.BudgetLines)
                        {
                            ws.SetValue(c, 1, line.LineNumber);
                            ws.SetValue(c, 2, line.Description);
                            ws.SetValue(c, 3, line.TotalBudget);
                            ws.SetValue(c, 4, line.TotalCommitted);
                            ws.SetValue(c, 5, line.TotalPosted);
                            ws.SetValue(c, 6, line.RemainingBalance);
                            ws.SetValue(c, 7, 100 * (line.TotalBudget > 0 ? (line.TotalPosted / line.TotalBudget) : 0));
                            c++;
                        }

                        ws.SetValue(c, 1, cat.Number);
                        ws.SetValue(c, 2, cat.Name);
                        ws.SetValue(c, 3, cat.TotalBudget);
                        ws.SetValue(c, 4, cat.TotalCommitted);
                        ws.SetValue(c, 5, cat.TotalPosted);
                        ws.SetValue(c, 6, cat.RemainingBalance);
                        ws.SetValue(c, 7, 100 * (cat.TotalBudget > 0 ? (cat.TotalPosted / cat.TotalBudget) : 0));

                        using (ExcelRange r = ws.Cells["A" + c.ToString() + ":G" + c.ToString()])
                        {
                            r.Style.Font.Bold = true;
                        }
                        c++;
                    }

                    ws.Cells["C3:G" + c.ToString()].Style.Numberformat.Format = "#,##0.00";

                    ws.Cells["A1:G" + c.ToString()].AutoFitColumns();

                    xlPackage.SaveAs(stream);
                }

                return File(stream.ToArray(), "application/excel", pDonor.Project.ProjectNumber + " - " + DateTime.Now.Ticks.ToString() + ".xlsx");
            }
        }