示例#1
0
        public ActionResult UpdateOpportunity(FormCollection frmCollection)
        {
            var UiQuaterobj   = frmCollection.AllKeys.Where(i => i.Contains("_FC"));
            int OpportunityId = Convert.ToInt16(frmCollection["OpportunityID"].ToString());

            if (!string.IsNullOrEmpty(frmCollection["OpportunityID"].ToString()))
            {
                var opportunityresult = financetoolentities.Opportunities
                                        .SingleOrDefault(b => b.OpportunityID == OpportunityId && b.IsUpdated == false);

                var opportunitylatestresult = financetoolentities.Opportunity_Latest
                                              .SingleOrDefault(b => b.OpportunityID == OpportunityId && b.IsUpdated == false);



                if (opportunityresult != null)
                {
                    financetoolentities.Usp_UpdateOpportunity(opportunityresult.OpportunityID);
                }
                else
                {
                    financetoolentities.Usp_UpdateOpportunityLatest(opportunitylatestresult.OpportunityID);
                }

                AddOldAMDetails(frmCollection);
            }
            return(RedirectToAction("DisplayAmDetails"));
        }
示例#2
0
        public ActionResult UpdateDUHData(FormCollection formcollection)
        {
            var      UiFCQuaterobj   = formcollection.AllKeys.Where(i => i.Contains("_FC"));
            var      UiActQuaterobj  = formcollection.AllKeys.Where(i => i.Contains("_AC"));
            int      ProjectId       = Convert.ToInt32(formcollection["ProjectID"]);
            string   projectname     = string.IsNullOrEmpty(formcollection["hdnProjectName"]) ? formcollection["ProjectName"] : formcollection["hdnProjectName"];
            string   OpportunityName = string.IsNullOrEmpty(formcollection["hdnOpportunityName"]) ? formcollection["OpportunityName"] : formcollection["hdnOpportunityName"];
            int      OpportunityId   = Convert.ToInt16(formcollection["OpportunityID"]);
            int      DealStageID     = 0;
            decimal? TCV;
            decimal? ACV;
            DateTime?BillingStratDate;
            string   Note             = string.Empty;
            string   CreatedBy        = string.Empty;
            int      SalesForceCastID = 0;
            bool?    IsActive         = true;
            long?    SalesForceGuid;
            decimal? SowStatusValue;
            bool?    IsMapped;
            string   OpportunityCategory = string.Empty;

            if (!string.IsNullOrEmpty(formcollection["OpportunityID"].ToString()))
            {
                var opportunityresult = financetoolentities.Opportunities.Where(i => i.OpportunityID == OpportunityId && i.IsUpdated == false).SingleOrDefault();

                var opportunitylatestresult = financetoolentities.Opportunity_Latest
                                              .SingleOrDefault(b => b.OpportunityID == OpportunityId && b.IsUpdated == false);
                if (opportunityresult != null)
                {
                    financetoolentities.Usp_UpdateOpportunity(opportunityresult.OpportunityID);
                    TCV = opportunityresult.TCV;
                    ACV = opportunityresult.acv;
                    BillingStratDate    = opportunityresult.BillingStratDate;
                    Note                = opportunityresult.Note;
                    CreatedBy           = opportunityresult.Createdby;
                    SalesForceCastID    = opportunityresult.SalesForceCastID;
                    SalesForceGuid      = opportunityresult.SalesForceGuid;
                    SowStatusValue      = opportunityresult.SowStatusValue;
                    IsMapped            = opportunityresult.IsMapped;
                    OpportunityCategory = opportunityresult.OpportunityCategory;
                    if (projectname != "Please Select Project" && !string.IsNullOrEmpty(OpportunityId.ToString()))
                    {
                        // IsActive = false;
                        DealStageID = 4;
                        IsMapped    = true;
                    }
                    else
                    {
                        // IsActive = true;
                        DealStageID = Convert.ToInt16(formcollection["dealstageId"]);
                        IsMapped    = false;
                    }
                }
                else
                {
                    financetoolentities.Usp_UpdateOpportunityLatest(opportunitylatestresult.OpportunityID);
                    TCV = opportunitylatestresult.TCV;
                    ACV = opportunitylatestresult.acv;
                    BillingStratDate    = opportunitylatestresult.BillingStratDate;
                    Note                = opportunitylatestresult.Note;
                    CreatedBy           = opportunitylatestresult.Createdby;
                    SalesForceCastID    = opportunitylatestresult.SalesForceCastID;
                    SalesForceGuid      = opportunitylatestresult.SalesForceGuid;
                    SowStatusValue      = opportunitylatestresult.SowStatusValue;
                    IsMapped            = opportunitylatestresult.IsMapped;
                    OpportunityCategory = opportunitylatestresult.OpportunityCategory;
                    if (projectname != "Please Select Project" && !string.IsNullOrEmpty(OpportunityId.ToString()))
                    {
                        //IsActive = false;
                        DealStageID = 4;
                        IsMapped    = true;
                    }
                    else
                    {
                        // IsActive = true;
                        DealStageID = Convert.ToInt16(formcollection["dealstageId"]);
                        IsMapped    = false;
                    }
                }


                financetoolentities.Usp_InsertOpportunityLatest(Convert.ToInt16(formcollection["OpportunityID"]), OpportunityName,
                                                                DealStageID, Convert.ToInt16(formcollection["SowStatus"]), Convert.ToInt16(formcollection["AMID"]),
                                                                Convert.ToInt16(formcollection["selectedcustomerId"]), formcollection["ProgramName"], Convert.ToInt16(formcollection["ServiceLineID"]),
                                                                Convert.ToInt16(formcollection["ProductGroupID"]), Convert.ToInt16(formcollection["DBBLDUID"]), TCV,
                                                                ACV, Convert.ToInt16(formcollection["SowStatus"]), BillingStratDate,
                                                                Note, CreatedBy, System.DateTime.Now, Session["UserName"].ToString(), System.DateTime.Now, SalesForceCastID,
                                                                IsActive, SalesForceGuid, Convert.ToInt16(formcollection["DUID"]), Convert.ToInt16(formcollection["LOBID"]),
                                                                SowStatusValue, Convert.ToInt16(Session["UserId"]), Convert.ToInt16(Session["RoleId"]), IsMapped, false,
                                                                OpportunityCategory);

                financetoolentities.SaveChanges();
            }

            var myACTQuaterList = financetoolentities.quater_Actual.Where(i => i.IsActive == true).ToList();
            var myFCQuaterList  = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();

            foreach (var quarters in myACTQuaterList)
            {
                var actresult = financetoolentities.ProjectActualByDUHs
                                .Where(i => i.OpportunityID == OpportunityId && i.QuaterID == quarters.QuaterID).Where(i => i.IsNew == true).SingleOrDefault();


                if (actresult != null)
                {
                    if (quarters.QuaterID == actresult.QuaterID && !string.IsNullOrEmpty(formcollection[quarters.QuaterName + "_AC"]))
                    {
                        //making old records as o
                        actresult.IsNew = false;
                        financetoolentities.SaveChanges();
                        //Added new records
                        ProjectActualByDUH _projactobj = new ProjectActualByDUH();
                        _projactobj.Createdby        = Session["UserName"].ToString();
                        _projactobj.actualvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_AC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_AC"]);
                        _projactobj.OpportunityID    = OpportunityId;
                        _projactobj.Createddate      = System.DateTime.Now;
                        _projactobj.Modifiedby       = Session["UserName"].ToString();
                        _projactobj.ModifiedDate     = System.DateTime.Now;
                        _projactobj.QuaterID         = quarters.QuaterID;
                        _projactobj.IsNew            = true;
                        financetoolentities.ProjectActualByDUHs.Add(_projactobj);
                        financetoolentities.SaveChanges();
                    }
                }
                else
                {
                    ProjectActualByDUH _projactobj = new ProjectActualByDUH();
                    _projactobj.Createdby        = Session["UserName"].ToString();
                    _projactobj.actualvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_AC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_AC"]);
                    _projactobj.OpportunityID    = OpportunityId;
                    _projactobj.Createddate      = System.DateTime.Now;
                    _projactobj.Modifiedby       = Session["UserName"].ToString();
                    _projactobj.ModifiedDate     = System.DateTime.Now;
                    _projactobj.QuaterID         = quarters.QuaterID;
                    _projactobj.IsNew            = true;
                    financetoolentities.ProjectActualByDUHs.Add(_projactobj);
                    financetoolentities.SaveChanges();
                }
            }
            foreach (var quarters in myFCQuaterList)
            {
                var fcresult = financetoolentities.ProjectForecastByDUHs
                               .Where(i => i.OpportunityID == OpportunityId && i.QuaterID == quarters.QuaterID).Where(i => i.IsNew == true).SingleOrDefault();
                if (fcresult != null)
                {
                    if (quarters.QuaterID == fcresult.QuaterID && !string.IsNullOrEmpty(formcollection[quarters.QuaterName + "_FC"].ToString()))
                    {
                        //Old forecast values are becoming null
                        fcresult.IsNew = false;
                        financetoolentities.SaveChanges();
                        //Adding new records
                        ProjectForecastByDUH _projfcobj = new ProjectForecastByDUH();
                        _projfcobj.Createdby          = Session["UserName"].ToString();
                        _projfcobj.forecastvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_FC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_FC"]);
                        _projfcobj.OpportunityID      = OpportunityId;
                        _projfcobj.Createddate        = System.DateTime.Now;
                        _projfcobj.Modifiedby         = Session["UserName"].ToString();
                        _projfcobj.ModifiedDate       = System.DateTime.Now;
                        _projfcobj.QuaterID           = quarters.QuaterID;
                        _projfcobj.IsNew = true;
                        financetoolentities.ProjectForecastByDUHs.Add(_projfcobj);
                        financetoolentities.SaveChanges();
                    }
                }
                else
                {
                    ProjectForecastByDUH _projfcobj = new ProjectForecastByDUH();
                    _projfcobj.Createdby          = Session["UserName"].ToString();
                    _projfcobj.forecastvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_FC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_FC"]);
                    _projfcobj.OpportunityID      = OpportunityId;
                    _projfcobj.Createddate        = System.DateTime.Now;
                    _projfcobj.Modifiedby         = Session["UserName"].ToString();
                    _projfcobj.ModifiedDate       = System.DateTime.Now;
                    _projfcobj.QuaterID           = quarters.QuaterID;
                    _projfcobj.IsNew = true;
                    financetoolentities.ProjectForecastByDUHs.Add(_projfcobj);
                    financetoolentities.SaveChanges();
                }
            }
            return(RedirectToAction("Index"));
        }