public void UpdateBaselineProjection(CustomBaselineProjection bp)
{
using (var ctx = new XrmServiceContext("Xrm"))
{
var bps = (from s in ctx.new_baselineprojectionsSet
where s.Id == bp.Id
select s).FirstOrDefault();
bps.new_name = bp.Name;
bps.new_Year = bp.Year;
bps.new_CA_Q1Actual = (int)bp.CA_Q1_A;
bps.new_Q1_ca = (decimal)bp.CA_Q1_P;
bps.new_CA_Q2Actual = (int)bp.CA_Q2_A;
bps.new_Q2_ca = (decimal)bp.CA_Q2_P;
bps.new_CA_Q3Actual = (int)bp.CA_Q3_A;
bps.new_Q3_ca = (decimal)bp.CA_Q3_P;
bps.new_CA_Q4Actual = (int)bp.CA_Q4_A;
bps.new_Q4_ca = (decimal)bp.CA_Q4_P;
bps.new_DB_Q1Actual = (int)bp.DB_Q1_A;
bps.new_Q1_db = (decimal)bp.DB_Q1_P;
bps.new_DB_Q2Actual = (int)bp.DB_Q2_A;
bps.new_Q2_db = (decimal)bp.DB_Q2_P;
bps.new_DB_Q3Actual = (int)bp.DB_Q3_A;
bps.new_Q3_db = (decimal)bp.DB_Q3_P;
bps.new_DB_Q4Actual = (int)bp.DB_Q4_A;
bps.new_Q4_db = (decimal)bp.DB_Q4_P;
ctx.UpdateObject(bps);
ctx.SaveChanges();
}
}
public static List<CustomBaselineProjection> ConvertToBaselineProjection(IEnumerable<new_baselineprojections> list)
{
List<CustomBaselineProjection> bps = new List<CustomBaselineProjection>();
foreach (new_baselineprojections item in list)
{
CustomBaselineProjection projection = new CustomBaselineProjection();
projection.Id = item.Id;
projection.Name = item.new_name;
projection.Year = item.new_Year.Value;
projection.CA_Q1_A = (double)item.new_CA_Q1Actual;
projection.CA_Q1_P = (double)item.new_Q1_ca;
projection.CA_Q2_A = (double)item.new_CA_Q2Actual;
projection.CA_Q2_P = (double)item.new_Q2_ca;
projection.CA_Q3_A = (double)item.new_CA_Q3Actual;
projection.CA_Q3_P = (double)item.new_Q3_ca;
projection.CA_Q4_A = (double)item.new_CA_Q4Actual;
projection.CA_Q4_P = (double)item.new_Q4_ca;
projection.Total_CA_Per_Year_A = (double)item.new_TotalCAperYearActual;
projection.Total_CA_Per_Year_P = (double)item.new_TotalCAperYear;
projection.DB_Q1_A = (double)item.new_DB_Q1Actual;
projection.DB_Q1_P = (double)item.new_Q1_db;
projection.DB_Q2_A = (double)item.new_DB_Q2Actual;
projection.DB_Q2_P = (double)item.new_Q2_db;
projection.DB_Q3_A = (double)item.new_DB_Q3Actual;
projection.DB_Q3_P = (double)item.new_Q3_db;
projection.DB_Q4_A = (double)item.new_DB_Q4Actual;
projection.DB_Q4_P = (double)item.new_Q4_db;
projection.Total_DB_Per_Year_A = (double)item.new_TotalDisbPerYearActual;
projection.Total_DB_Per_Year_P = (double)item.new_TotalDisbPerYear;
projection.ParentID = (item.new_opportunity_new_baselineprojections == null) ? Guid.Empty : item.new_opportunity_new_baselineprojections.Id;
projection.ParentIDString = string.Format("{0}{1}", "__bo4200", projection.ParentID.ToString());
bps.Add(projection);
}
return bps;
}
public void CreateBaselineProjection(CustomBaselineProjection bp)
{
}
