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) { }