// GET: Comparison
public ActionResult Index()
{
CompareDUHModel objCompareDUHModel = new CompareDUHModel();
DUHModel objDUHModel = new DUHModel();
objDUHModel.SDUList = BindSDUData();
objDUHModel.DUList = BindDUData(0);
objDUHModel.ProjectList = BindProjectData();
objCompareDUHModel.DUHModel = objDUHModel;
objCompareDUHModel.DUHMainDetailsResult = Get_SDU_DU_ALL_NewData();
objCompareDUHModel.OldDUHMainDetailsResult = Get_SDU_DU_ALL_OldData();
return(View(objCompareDUHModel));
}
public ActionResult Index(FormCollection _formcollectionobj)
{
CompareDUHModel objcompareDUHModel = new CompareDUHModel();
DUHModel objDUHModel = new DUHModel();
objcompareDUHModel.DUHMainDetailsResult = NewDetails(_formcollectionobj);
objcompareDUHModel.OldDUHMainDetailsResult = OldDetails(_formcollectionobj);
objDUHModel.SDUID = Convert.ToInt32(_formcollectionobj["DUHModel.SDUID"]);
objDUHModel.DUID = Convert.ToInt32(_formcollectionobj["DUHModel.DUID"]);
objDUHModel.CompareDate = Convert.ToDateTime(_formcollectionobj["DUHModel.CompareDate"]);
objDUHModel.SDUList = BindSDUData();
objDUHModel.DUList = BindDUData(Convert.ToInt32(_formcollectionobj["DUHModel.SDUID"]));
objDUHModel.ProjectList = BindProjectData();
objcompareDUHModel.DUHModel = objDUHModel;
return(View(objcompareDUHModel));
}
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);
}
