public ActionResult CreateAdmin()
{
FinaceTool.Models.AMModel _AmDetails = new FinaceTool.Models.AMModel();
_AmDetails.CustomerList = BindDropdownAMDetails();
_AmDetails.duList = BindDropdownDUDetails();
_AmDetails.lobList = BindDropdownLobDetails();
_AmDetails.ProjectList = BindDropdownProjectDetails();
_AmDetails.serviceList = BindServiceLineDetails();
_AmDetails.ProductGroupList = BindDdlProductGroupDetails();
_AmDetails.DealStageList = BindDealStageDetails();
_AmDetails.SowStatusList = BindSowStatusDetails();
_AmDetails.AmUserList = BindAmUserDetails();
_AmDetails.OpportunityCategoryList = BindOpportunityCategoryDetails();
List <Quater> QuaterList = new List <Quater>();
var dbQuaterlist = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
foreach (var quater in dbQuaterlist)
{
quater.QuaterName = quater.QuaterName + "_FC" + " ($K)";
QuaterList.Add(quater);
}
_AmDetails.Quaterlist = QuaterList;
var AmDetailsModel = financetoolentities.Usp_GetAmMainDetails().OrderByDescending(item => item.S_No).ToList();
if (AmDetailsModel.Count == 0)
{
_AmDetails.S_No = 1;
}
else
{
_AmDetails.S_No = AmDetailsModel[0].S_No + 1;
}
return(View(_AmDetails));
}
public ActionResult DeleteAMGridById(FinaceTool.Models.AMModel amobj)
{
var result = financetoolentities.Opportunities.SingleOrDefault(b => b.OpportunityID.ToString() == amobj.OpportunityID);
result.IsActive = false;
financetoolentities.SaveChanges();
ViewBag.ddlAM = BindDropdownAMDetails();
return(View("DisplayAmDetails", Display()));
}
public ActionResult Edit(Usp_GetAdminMainDetails_Result _amSelctedObj)
{
FinaceTool.Models.AMModel _AmDetails = new FinaceTool.Models.AMModel();
bool result = QuaterGenerator.EditRestrictionByRole(Session["RoleId"].ToString());
if (result == false)
{
TempData["Message"] = "You do not have permissions to Edit in this Time Slab.";
return(View("DisplayAmDetails", Display()));
}
else
{
List <Usp_GetAdminMainDetails_V2_Result> myresult = financetoolentities.Usp_GetAdminMainDetails_V2()
.Where(i => i.OpportunityID == _amSelctedObj.OpportunityID &&
i.CustomerID == _amSelctedObj.CustomerID &&
i.AMID == _amSelctedObj.AMID &&
i.OpportunityLobId == _amSelctedObj.LOBID && i.DUID == _amSelctedObj.DUID && i.ServiceLineID == _amSelctedObj.ServiceLineID && i.IsUpdated == false)
.ToList();
_AmDetails.CustomerList = BindDropdownAMDetails();
_AmDetails.duList = BindDropdownDUDetails();
_AmDetails.lobList = BindDropdownLobDetails();
_AmDetails.ProjectList = BindDropdownProjectDetails();
_AmDetails.serviceList = BindServiceLineDetails();
_AmDetails.ProductGroupList = BindDdlProductGroupDetails();
_AmDetails.DealStageList = BindDealStageDetails();
_AmDetails.OpportunityCategoryList = BindOpportunityCategoryDetails();
_AmDetails.SowStatusList = BindSowStatusDetails();
_AmDetails.AmUserList = BindAmUserDetails();
//drop down binding ended
_AmDetails.OpportunityName = myresult[0].OpportunityName;
_AmDetails.S_No = myresult[0].S_No;
//_AmDetails.acv = myresult[0].acv;
_AmDetails.AMId = myresult[0].AMID.ToString();
_AmDetails.AMName = myresult[0].AMName;
_AmDetails.BillingStratDate = myresult[0].BillingStratDate;
_AmDetails.CustomerId = myresult[0].CustomerID.ToString();
_AmDetails.Customername = myresult[0].Customername;
_AmDetails.DBBLDU = myresult[0].DBBLDU;
_AmDetails.DBBLDuId = myresult[0].DBBLDUID.ToString();
_AmDetails.DuId = myresult[0].DUID.ToString();
_AmDetails.DUName = myresult[0].DUName;
_AmDetails.LOBName = myresult[0].OpportunityLobName;
_AmDetails.LobId = myresult[0].OpportunityLobId.ToString();
_AmDetails.OpportunityID = myresult[0].OpportunityID.ToString();
_AmDetails.OpportunityKeyID = Convert.ToInt16(myresult[0].OpportunityKeyID);
if (string.IsNullOrEmpty(myresult[0].ProjectID.ToString()))
{
_AmDetails.ProjectId = "0";
}
else
{
_AmDetails.ProjectIdForEdit = myresult[0].ProjectID.ToString();
}
_AmDetails.ServiceLine = myresult[0].ServiceLine;
_AmDetails.ProgramName = myresult[0].ProgramName;
_AmDetails.ServiceLineId = myresult[0].ServiceLineID.ToString();
_AmDetails.ProductGroup = myresult[0].ProductGroup;
_AmDetails.ProductGroupId = myresult[0].ProductGroupID.ToString();
_AmDetails.sowvalue = myresult[0].sowvalue;
_AmDetails.DealStageId = myresult[0].DealStage.ToString();
_AmDetails.acv = Convert.ToDecimal(MyCustomFormat(Convert.ToDouble(myresult[0].acv)));
_AmDetails.TCV = Convert.ToDecimal(MyCustomFormat(Convert.ToDouble(myresult[0].TCV)));
_AmDetails.BillingStratDate = myresult[0].BillingStratDate;
_AmDetails.Note_Comment = myresult[0].note;
_AmDetails.IsUpdated = Convert.ToBoolean(myresult[0].IsUpdated);
_AmDetails.OpportunityCategory = myresult[0].opportunitycategory;
List <Quater> QuaterList = new List <Quater>();
var dbQuaterlist = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
foreach (var quater in dbQuaterlist)
{
var value = myresult[0].GetType().GetProperty(quater.QuaterName);
var Quartervalue = value.GetValue(myresult[0], null).ToString();
var qvalue = MyCustomFormat(Convert.ToDouble(Quartervalue));
quater.QuaterName = quater.QuaterName + "_FC($K):" + qvalue;
QuaterList.Add(quater);
}
_AmDetails.Quaterlist = QuaterList;
_AmDetails.SowStatusValue = Convert.ToDecimal(MyCustomFormat(Convert.ToDouble(myresult[0].SowStatusValue)));
return(View(_AmDetails));
}
}
