Example #1
0
        public List <DUHMainDetailsResult> NewDetails(FormCollection _formcollectionobj)
        {
            string SDUID = "ALL";
            string DUID  = "ALL";

            if (_formcollectionobj["DUHModel.SDUID"] == "0")
            {
                SDUID = "ALL";
            }
            else
            {
                SDUID = _formcollectionobj["DUHModel.SDUID"];
            }
            if (_formcollectionobj["DUHModel.DUID"] == "0")
            {
                DUID = "ALL";
            }
            else
            {
                DUID = _formcollectionobj["DUHModel.DUID"];
            }
            QuaterGenerator.UpdateActiveQuaters();
            List <Usp_GetDUHDetails_Comparision_V2_Result> DUHGriddetails = new List <Usp_GetDUHDetails_Comparision_V2_Result>();

            if (_formcollectionobj["DUHModel.ProjectID"] == "0")
            {
                DUHGriddetails = financetoolentities.Usp_GetDUHDetails_Comparision_V2(SDUID, DUID).Where(i => i.IsUpdated == false).ToList();
            }
            else
            {
                DUHGriddetails = financetoolentities.Usp_GetDUHDetails_Comparision_V2(SDUID, DUID).Where(i => i.IsUpdated == false && i.ProjectID == Convert.ToInt32(_formcollectionobj["DUHModel.ProjectID"])).ToList();
            }
            // var DUHGriddetails = financetoolentities.Usp_GetDUHDetails_Comparision_V2(SDUID, DUID).Where(i => i.IsUpdated == false).ToList();
            // var DUHGriddetails = financetoolentities.Usp_GetDUHMainDetails().ToList();
            int Iteration = 0;


            List <DUHMainDetailsResult> DUHMainDetailsResultList = new List <DUHMainDetailsResult>();

            foreach (var DUHdbvalues in DUHGriddetails)
            {
                DUHMainDetailsResult duhmaindetail = new DUHMainDetailsResult();
                duhmaindetail.AMID               = DUHdbvalues.AMID;
                duhmaindetail.AMName             = DUHdbvalues.AMName;
                duhmaindetail.CustomerID         = DUHdbvalues.CustomerID;
                duhmaindetail.Customername       = DUHdbvalues.Customername;
                duhmaindetail.DBBLDU             = DUHdbvalues.DBBLDU;
                duhmaindetail.DBBLDUID           = DUHdbvalues.DBBLDUID;
                duhmaindetail.DealStageID        = DUHdbvalues.DealStageID;
                duhmaindetail.DUID               = DUHdbvalues.DUID;
                duhmaindetail.DUName             = DUHdbvalues.DUName;
                duhmaindetail.LOBID              = DUHdbvalues.LOBID;
                duhmaindetail.LOBName            = DUHdbvalues.LOBName;
                duhmaindetail.Note               = DUHdbvalues.Note;
                duhmaindetail.OpportunityID      = DUHdbvalues.OpportunityID;
                duhmaindetail.OpportunityKeyID   = DUHdbvalues.OpportunityKeyID;
                duhmaindetail.OpportunityLobId   = DUHdbvalues.OpportunityLobId;
                duhmaindetail.OpportunityLobName = DUHdbvalues.OpportunityLobName;
                duhmaindetail.OpportunityName    = DUHdbvalues.OpportunityName;
                duhmaindetail.poavilable         = DUHdbvalues.poavilable;
                duhmaindetail.pobalance          = DUHdbvalues.pobalance;
                duhmaindetail.ProductGroup       = DUHdbvalues.ProductGroup;
                duhmaindetail.ProductGroupID     = DUHdbvalues.ProductGroupID;
                duhmaindetail.ProgramName        = DUHdbvalues.ProgramName;
                duhmaindetail.ProjectID          = DUHdbvalues.ProjectID;
                duhmaindetail.ProjectName        = DUHdbvalues.ProjectName;
                duhmaindetail.SDUID              = DUHdbvalues.SDUID;
                duhmaindetail.ServiceLine        = DUHdbvalues.ServiceLine;
                duhmaindetail.ServiceLineID      = DUHdbvalues.ServiceLineID;
                duhmaindetail.SowStatus          = DUHdbvalues.SOWStatus1;
                duhmaindetail.S_No               = DUHdbvalues.S_No;
                List <string> Objquater  = new List <string>();
                List <string> QuaterName = new List <string>();
                List <string> Operations = new List <string>();
                Operations.Add("_FC");
                var dbQuaterlist        = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
                var dbQuater_Actuallist = financetoolentities.quater_Actual.Where(i => i.IsActive == true).ToList();
                foreach (var quater in dbQuaterlist)
                {
                    foreach (var Obj in Operations)
                    {
                        var value        = DUHdbvalues.GetType().GetProperty(quater.QuaterName + Obj);
                        var Quartervalue = value.GetValue(DUHdbvalues, null).ToString();
                        var qvalue       = MyCustomFormat(Convert.ToDouble(Quartervalue));
                        Objquater.Add(qvalue);
                    }
                    QuaterName.Add(quater.QuaterName + "_FC($K)");
                    // QuaterName.Add(quater.QuaterName + "_ACT($K)");
                }
                Operations.Clear();
                Operations.Add("_ACT");
                foreach (var quater in dbQuater_Actuallist)
                {
                    foreach (var Obj in Operations)
                    {
                        var value        = DUHdbvalues.GetType().GetProperty(quater.QuaterName + Obj);
                        var Quartervalue = value.GetValue(DUHdbvalues, null).ToString();
                        var qvalue       = MyCustomFormat(Convert.ToDouble(Quartervalue));
                        Objquater.Add(qvalue);
                    }
                    //QuaterName.Add(quater.QuaterName + "_FC($K)");
                    QuaterName.Add(quater.QuaterName + "_ACT($K)");
                }

                if (Iteration == 0)
                {
                    duhmaindetail.QuaterName = QuaterName;
                }
                duhmaindetail.Quaterlist = Objquater;
                DUHMainDetailsResultList.Add(duhmaindetail);
                Iteration++;
            }
            return(DUHMainDetailsResultList);
        }
Example #2
0
        public List <DUHMainDetailsResult> Get_SDU_DU_ALL_OldData()
        {
            QuaterGenerator.UpdateActiveQuaters();
            var DUHGriddetails = financetoolentities.Usp_GetDUHDetails_Comparision_OldDetails("ALL", "ALL", DateTime.Now).ToList();
            // var DUHGriddetails = financetoolentities.Usp_GetDUHMainDetails().ToList();
            int             Iteration          = 0;
            CompareDUHModel objcompareDUHModel = new CompareDUHModel();

            List <DUHMainDetailsResult> DUHMainDetailsResultList = new List <DUHMainDetailsResult>();

            foreach (var DUHdbvalues in DUHGriddetails)
            {
                DUHMainDetailsResult duhmaindetail = new DUHMainDetailsResult();
                duhmaindetail.AMID               = DUHdbvalues.AMID;
                duhmaindetail.AMName             = DUHdbvalues.AMName;
                duhmaindetail.CustomerID         = DUHdbvalues.CustomerID;
                duhmaindetail.Customername       = DUHdbvalues.Customername;
                duhmaindetail.DBBLDU             = DUHdbvalues.DBBLDU;
                duhmaindetail.DBBLDUID           = DUHdbvalues.DBBLDUID;
                duhmaindetail.DealStageID        = DUHdbvalues.DealStageID;
                duhmaindetail.DUID               = DUHdbvalues.DUID;
                duhmaindetail.DUName             = DUHdbvalues.DUName;
                duhmaindetail.LOBID              = DUHdbvalues.LOBID;
                duhmaindetail.LOBName            = DUHdbvalues.LOBName;
                duhmaindetail.Note               = DUHdbvalues.Note;
                duhmaindetail.OpportunityID      = DUHdbvalues.OpportunityID;
                duhmaindetail.OpportunityKeyID   = DUHdbvalues.OpportunityKeyID;
                duhmaindetail.OpportunityLobId   = DUHdbvalues.OpportunityLobId;
                duhmaindetail.OpportunityLobName = DUHdbvalues.OpportunityLobName;
                duhmaindetail.OpportunityName    = DUHdbvalues.OpportunityName;
                duhmaindetail.poavilable         = DUHdbvalues.poavilable;
                duhmaindetail.pobalance          = DUHdbvalues.pobalance;
                duhmaindetail.ProductGroup       = DUHdbvalues.ProductGroup;
                duhmaindetail.ProductGroupID     = DUHdbvalues.ProductGroupID;
                duhmaindetail.ProgramName        = DUHdbvalues.ProgramName;
                duhmaindetail.ProjectID          = DUHdbvalues.ProjectID;
                duhmaindetail.ProjectName        = DUHdbvalues.ProjectName;
                duhmaindetail.SDUID              = DUHdbvalues.SDUID;
                duhmaindetail.ServiceLine        = DUHdbvalues.ServiceLine;
                duhmaindetail.ServiceLineID      = DUHdbvalues.ServiceLineID;
                //duhmaindetail.SowStatus = DUHdbvalues.SOWStatus1;
                //duhmaindetail.S_No = DUHdbvalues.S_No;
                List <string> Objquater  = new List <string>();
                List <string> QuaterName = new List <string>();
                List <string> Operations = new List <string>();
                Operations.Add("_FC");
                var dbQuaterlist        = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
                var dbQuater_Actuallist = financetoolentities.quater_Actual.Where(i => i.IsActive == true).ToList();
                foreach (var quater in dbQuaterlist)
                {
                    foreach (var Obj in Operations)
                    {
                        var value        = DUHdbvalues.GetType().GetProperty(quater.QuaterName + Obj);
                        var Quartervalue = value.GetValue(DUHdbvalues, null).ToString();
                        var qvalue       = MyCustomFormat(Convert.ToDouble(Quartervalue));
                        Objquater.Add(qvalue);
                    }
                    QuaterName.Add(quater.QuaterName + "_FC($K)");
                    // QuaterName.Add(quater.QuaterName + "_ACT($K)");
                }
                Operations.Clear();
                Operations.Add("_ACT");
                foreach (var quater in dbQuater_Actuallist)
                {
                    foreach (var Obj in Operations)
                    {
                        var value        = DUHdbvalues.GetType().GetProperty(quater.QuaterName + Obj);
                        var Quartervalue = value.GetValue(DUHdbvalues, null).ToString();
                        var qvalue       = MyCustomFormat(Convert.ToDouble(Quartervalue));
                        Objquater.Add(qvalue);
                    }
                    //QuaterName.Add(quater.QuaterName + "_FC($K)");
                    QuaterName.Add(quater.QuaterName + "_ACT($K)");
                }

                if (Iteration == 0)
                {
                    duhmaindetail.QuaterName = QuaterName;
                }
                duhmaindetail.Quaterlist = Objquater;
                DUHMainDetailsResultList.Add(duhmaindetail);
                Iteration++;
            }
            return(DUHMainDetailsResultList);
        }
Example #3
0
        public ActionResult Index()
        {
            QuaterGenerator.UpdateActiveQuaters();
            var DUHGriddetails = financetoolentities.Usp_GetDUHMainDetailsByUserID_V2(Session["UserId"].ToString()).Where(i => i.IsUpdated == false).ToList();
            // var DUHGriddetails = financetoolentities.Usp_GetDUHMainDetails().ToList();
            int Iteration = 0;

            List <DUHMainDetailsResult> DUHMainDetailsResultList = new List <DUHMainDetailsResult>();

            foreach (var DUHdbvalues in DUHGriddetails)
            {
                DUHMainDetailsResult duhmaindetail = new DUHMainDetailsResult();
                duhmaindetail.AMID               = DUHdbvalues.AMID;
                duhmaindetail.AMName             = DUHdbvalues.AMName;
                duhmaindetail.CustomerID         = DUHdbvalues.CustomerID;
                duhmaindetail.Customername       = DUHdbvalues.Customername;
                duhmaindetail.DBBLDU             = DUHdbvalues.DBBLDU;
                duhmaindetail.DBBLDUID           = DUHdbvalues.DBBLDUID;
                duhmaindetail.DealStageID        = DUHdbvalues.DealStageID;
                duhmaindetail.DUID               = DUHdbvalues.DUID;
                duhmaindetail.DUName             = DUHdbvalues.DUName;
                duhmaindetail.LOBID              = DUHdbvalues.LOBID;
                duhmaindetail.LOBName            = DUHdbvalues.LOBName;
                duhmaindetail.Note               = DUHdbvalues.Note;
                duhmaindetail.OpportunityID      = DUHdbvalues.OpportunityID;
                duhmaindetail.OpportunityKeyID   = DUHdbvalues.OpportunityKeyID;
                duhmaindetail.OpportunityLobId   = DUHdbvalues.OpportunityLobId;
                duhmaindetail.OpportunityLobName = DUHdbvalues.OpportunityLobName;
                duhmaindetail.OpportunityName    = DUHdbvalues.OpportunityName;
                duhmaindetail.pobalance          = DUHdbvalues.pobalance;
                duhmaindetail.ProductGroup       = DUHdbvalues.ProductGroup;
                duhmaindetail.ProductGroupID     = DUHdbvalues.ProductGroupID;
                duhmaindetail.ProgramName        = DUHdbvalues.ProgramName;
                duhmaindetail.ProjectID          = DUHdbvalues.ProjectID;
                duhmaindetail.ProjectName        = DUHdbvalues.ProjectName;
                duhmaindetail.SDUID              = DUHdbvalues.SDUID;
                duhmaindetail.ServiceLine        = DUHdbvalues.ServiceLine;
                duhmaindetail.ServiceLineID      = DUHdbvalues.ServiceLineID;
                duhmaindetail.SowStatus          = DUHdbvalues.SOWStatus1;
                duhmaindetail.S_No               = DUHdbvalues.S_No;
                if (DUHdbvalues.poavilable == "1")
                {
                    duhmaindetail.poavilable = "Yes";
                }
                else if (DUHdbvalues.poavilable == "0")
                {
                    duhmaindetail.poavilable = "No";
                }

                List <string> Objquater  = new List <string>();
                List <string> QuaterName = new List <string>();
                List <string> Operations = new List <string>();
                Operations.Add("_FC");
                var dbQuaterlist        = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
                var dbQuater_Actuallist = financetoolentities.quater_Actual.Where(i => i.IsActive == true).ToList();
                foreach (var quater in dbQuaterlist)
                {
                    foreach (var Obj in Operations)
                    {
                        var value        = DUHdbvalues.GetType().GetProperty(quater.QuaterName + Obj);
                        var Quartervalue = value.GetValue(DUHdbvalues, null).ToString();
                        var qvalue       = MyCustomFormat(Convert.ToDouble(Quartervalue));
                        Objquater.Add(qvalue);
                    }
                    QuaterName.Add(quater.QuaterName + "_FC($K)");
                    // QuaterName.Add(quater.QuaterName + "_ACT($K)");
                }
                Operations.Clear();
                Operations.Add("_ACT");
                foreach (var quater in dbQuater_Actuallist)
                {
                    foreach (var Obj in Operations)
                    {
                        var value        = DUHdbvalues.GetType().GetProperty(quater.QuaterName + Obj);
                        var Quartervalue = value.GetValue(DUHdbvalues, null).ToString();
                        var qvalue       = MyCustomFormat(Convert.ToDouble(Quartervalue));
                        Objquater.Add(qvalue);
                    }
                    //QuaterName.Add(quater.QuaterName + "_FC($K)");
                    QuaterName.Add(quater.QuaterName + "_ACT($K)");
                }

                if (Iteration == 0)
                {
                    duhmaindetail.QuaterName = QuaterName;
                }
                duhmaindetail.Quaterlist = Objquater;
                DUHMainDetailsResultList.Add(duhmaindetail);
                Iteration++;
            }
            return(View(DUHMainDetailsResultList));
        }