public ActionResult ViewOpportunities()
{
QuaterGenerator.UpdateActiveQuaters();
int UserId = Convert.ToInt16(Session["UserId"]);
int RoleId = Convert.ToInt16(Session["RoleId"]);
var AmDetailsModel = financetoolentities.Usp_GetAmMainDetails_V2()
.Where(i => i.Userid == UserId && i.RoleId == RoleId && i.IsUpdated == false).ToList();
List <AmMainDetailsResult> _AMMainResultList = new List <AmMainDetailsResult>();
int Iteration = 0;
foreach (var AmResult in AmDetailsModel)
{
AmMainDetailsResult obj = new AmMainDetailsResult();
obj.acv = AmResult.acv;
obj.AMID = Convert.ToInt16(AmResult.AMID);
obj.AMName = AmResult.AMName;
obj.BillingStratDate = AmResult.BillingStratDate;
obj.CustomerID = AmResult.CustomerID;
obj.Customername = AmResult.Customername;
obj.DBBLDU = AmResult.DBBLDU;
obj.DBBLDUID = Convert.ToInt16(AmResult.DBBLDUID);
obj.DealStagestatus = AmResult.DealStagestatus;
obj.DUID = AmResult.DUID;
obj.DUName = AmResult.DUName;
obj.IsActive = AmResult.IsActive;
obj.LOBID = Convert.ToInt16(AmResult.LOBID);
obj.LOBName = AmResult.LOBName;
obj.note = AmResult.note;
obj.OpportunityID = Convert.ToInt16(AmResult.OpportunityID);
obj.OpportunityKeyID = Convert.ToInt16(AmResult.OpportunityKeyID);
obj.OpportunityLobId = AmResult.OpportunityLobId;
obj.OpportunityLobName = AmResult.OpportunityLobName;
obj.OpportunityName = AmResult.OpportunityName;
obj.ProductGroup = AmResult.ProductGroup;
obj.ProductGroupID = AmResult.ProductGroupID;
obj.ProgramName = AmResult.ProgramName;
obj.ProjectID = Convert.ToInt16(AmResult.ProjectID);
obj.SDUID = AmResult.SDUID;
obj.ServiceLine = AmResult.ServiceLine;
obj.ServiceLineID = AmResult.ServiceLineID;
obj.SowStatusValue = AmResult.SowStatusValue;
obj.sowvalue = AmResult.SOWStatus;
obj.S_No = AmResult.S_No;
obj.TCV = AmResult.TCV;
List <string> Objquater = new List <string>();
List <string> QuaterName = new List <string>();
var dbQuaterlist = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
foreach (var quater in dbQuaterlist)
{
var value = AmResult.GetType().GetProperty(quater.QuaterName);
var Quartervalue = value.GetValue(AmResult, null).ToString();
var qvalue = MyCustomFormat(Convert.ToDouble(Quartervalue));
Objquater.Add(qvalue);
QuaterName.Add(quater.QuaterName + "_FC($K)");
}
if (Iteration == 0)
{
obj.QuaterName = QuaterName;
}
obj.Quaterlist = Objquater;
_AMMainResultList.Add(obj);
Iteration++;
}
return(View(_AMMainResultList));
}
