public ActionResult Index()
{
QuaterGenerator.UpdateActiveQuaters();
FinanceToolEntities financetoolentities = new FinanceToolEntities();
var PMOGriddetails = financetoolentities.Usp_GetPMOOpportunityDetails().ToList();
return(View(PMOGriddetails));
}
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);
}
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);
}
public ActionResult DisplayAmDetails()
{
QuaterGenerator.UpdateActiveQuaters();
var AmDetailsModel = financetoolentities.Usp_GetAdminMainDetails_V2().Where(i => i.IsUpdated == false).ToList();
List <AdminMainDetailsResult> _AdminMainResult = new List <AdminMainDetailsResult>();
int Iteration = 0;
foreach (var AmResult in AmDetailsModel)
{
AdminMainDetailsResult obj = new AdminMainDetailsResult();
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;
obj.IsUpdated = Convert.ToBoolean(AmResult.IsUpdated);
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;
_AdminMainResult.Add(obj);
Iteration++;
}
return(View(_AdminMainResult));
}
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));
}
}
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));
}
public ActionResult EditDUHData(FinaceTool.Usp_GetDUHMainDetails_Result _duhSelctedObj)
{
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("Index", Display()));
}
else
{
Usp_GetDUHMainDetailsByUserID_V2_Result[] myresult = financetoolentities.Usp_GetDUHMainDetailsByUserID_V2(Session["UserId"].ToString())
.Where(i => i.OpportunityID == _duhSelctedObj.OpportunityID && i.IsUpdated == false &&
i.CustomerID == _duhSelctedObj.CustomerID &&
i.AMID == _duhSelctedObj.AMID &&
i.OpportunityLobId == _duhSelctedObj.LOBID && i.DUID == _duhSelctedObj.DUID && i.ServiceLineID == _duhSelctedObj.ServiceLineID)
.ToArray();
FinaceTool.Models.DUHModel _DuhDetails = new FinaceTool.Models.DUHModel();
_DuhDetails.dealstageId = myresult[0].DealStageID.ToString();
_DuhDetails.Customername = _duhSelctedObj.Customername;
_DuhDetails.CustomerList = BindDropdowncustomerDetails();
_DuhDetails.duList = BindDropdownDUDetails();
_DuhDetails.lobList = BindDropdownLobDetails();
_DuhDetails.ProjectList = BindDropdownProjectDetails();
_DuhDetails.serviceList = BindServiceLineDetails();
_DuhDetails.ProductGroupList = BindDdlProductGroupDetails();
_DuhDetails.DealStageList = BindDealStageDetails();
_DuhDetails.SowStatusList = BindSowStatusDetails();
_DuhDetails.AmUserList = BindAmUserDetails();
_DuhDetails.poAvailablelist = BindPoAvailableDetails();
_DuhDetails.OpportunityList = BindDropdownOpportunityDetails();
//drop down binding ended
_DuhDetails.OpportunityName = myresult[0].OpportunityName;
_DuhDetails.S_No = myresult[0].S_No;
_DuhDetails.selectedcustomerText = myresult[0].Customername;
_DuhDetails.AMName = myresult[0].AMName;
_DuhDetails.AMID = myresult[0].AMID;
_DuhDetails.selectedcustomerId = myresult[0].CustomerID;
_DuhDetails.OpportunityID = myresult[0].OpportunityID;
_DuhDetails.DBBLDU = myresult[0].DBBLDU;
_DuhDetails.DBBLDUID = myresult[0].DBBLDUID;
_DuhDetails.DUID = myresult[0].DUID;
_DuhDetails.DUName = myresult[0].DUName;
_DuhDetails.LOBName = myresult[0].LOBName;
_DuhDetails.LOBID = Convert.ToInt16(myresult[0].OpportunityLobId);
_DuhDetails.OpportunityKeyID = myresult[0].OpportunityKeyID;
_DuhDetails.poavilable = myresult[0].poavilable;
_DuhDetails.pobalance = myresult[0].pobalance;
if (string.IsNullOrEmpty(myresult[0].ProjectID.ToString()))
{
_DuhDetails.ProjectID = 0;
_DuhDetails.ProjectName = "Please Select Project";
}
else
{
_DuhDetails.ProjectID = myresult[0].ProjectID;
_DuhDetails.ProjectName = myresult[0].ProjectName;
}
_DuhDetails.ServiceLine = myresult[0].ServiceLine;
_DuhDetails.ServiceLineID = myresult[0].ServiceLineID;;
_DuhDetails.ProgramName = myresult[0].ProgramName;
_DuhDetails.ProductGroup = myresult[0].ProductGroup;
_DuhDetails.ProductGroupID = myresult[0].ProductGroupID;
if (string.IsNullOrEmpty(myresult[0].SowStatus.ToString()))
{
_DuhDetails.SowStatus = 0;
}
else
{
_DuhDetails.SowStatus = myresult[0].SowStatus;
}
_DuhDetails.Note = myresult[0].Note;
//List<Quater> QuaterList = new List<Quater>();
var dbQuaterlist = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList();
var dbQuater_Actuallist = financetoolentities.quater_Actual.Where(i => i.IsActive == true).ToList();
List <string> Operations = new List <string>();
Operations.Add("_FC");
List <string> QuaterList = new List <string>();
foreach (var quater in dbQuaterlist)
{
foreach (var Obj in Operations)
{
var value = myresult[0].GetType().GetProperty(quater.QuaterName.Substring(0, 5) + Obj);
var Quartervalue = value.GetValue(myresult[0], null).ToString();
var qvalue = MyCustomFormat(Convert.ToDouble(Quartervalue));
string QuaterName = quater.QuaterName.Substring(0, 5) + Obj + "($K)" + ":" + qvalue;
QuaterList.Add(QuaterName);
}
}
Operations.Clear();
Operations.Add("_ACT");
foreach (var quater in dbQuater_Actuallist)
{
foreach (var Obj in Operations)
{
var value = myresult[0].GetType().GetProperty(quater.QuaterName.Substring(0, 5) + Obj);
var Quartervalue = value.GetValue(myresult[0], null).ToString();
var qvalue = MyCustomFormat(Convert.ToDouble(Quartervalue));
string QuaterName = quater.QuaterName.Substring(0, 5) + Obj + "($K)" + ":" + qvalue;
QuaterList.Add(QuaterName);
}
}
_DuhDetails.QuaterListData = QuaterList;
return(View(_DuhDetails));
}
}
