Пример #1
0
        public ActionResult GetProjectDetails()
        {
            List <ProjectDetails> Projectdetails = new List <ProjectDetails>();

            FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities();
            var datacontent = FinanceToolEntities2.AMTable().ToList();

            foreach (var item in datacontent)
            {
                ProjectDetails ProjectDetailitem = new ProjectDetails();
                ProjectDetailitem.SNo              = item.S_No;
                ProjectDetailitem.CustomerName     = item.CustomerName;
                ProjectDetailitem.AMName           = item.AMName;
                ProjectDetailitem.LOB              = item.LOBName;
                ProjectDetailitem.DUName           = item.DUName;
                ProjectDetailitem.DBBLDU           = item.DBBLDU;
                ProjectDetailitem.OpportunityID    = item.OpportunityID;
                ProjectDetailitem.OpportunityName  = item.OpportunityName;
                ProjectDetailitem.ProjectID        = item.ProjectID;
                ProjectDetailitem.ProgramName      = item.ProgramName;
                ProjectDetailitem.ServiceLine      = item.ServiceLine;
                ProjectDetailitem.ProductGroup     = item.ProductGroup;
                ProjectDetailitem.TCV              = item.TCV;
                ProjectDetailitem.ACV              = item.acv;
                ProjectDetailitem.SOWValue         = item.sowvalue;
                ProjectDetailitem.DealStage        = item.DealStage;
                ProjectDetailitem.BillingStartDate = item.BillingStratDate;
                ProjectDetailitem.Note             = item.Note;


                Projectdetails.Add(ProjectDetailitem);
            }
            return(View(Projectdetails));


            //return View(ProjectDetails);
        }