private static void Save_To_Fact_Audit_Table(Point_Measure_Fact tbl_point_measure_fact, double newvalue)
{
IFactsRestatementAudit_Service facts = new FactsRestatementAudit_Service();
FactsRestatementAudit tbl_facts_audit = FactsRestatementAudit_Convert.Convert_Point_Measure_Fact_To_FactsRestatmentAudit(tbl_point_measure_fact, newvalue);
facts.Save(tbl_facts_audit);
}
public static FactsRestatementAudit Convert_Point_Measure_Fact_To_FactsRestatmentAudit(Point_Measure_Fact point_measure_fact, double newvalue)
{
FactsRestatementAudit facts_restatment_audit = new FactsRestatementAudit();
facts_restatment_audit.Point_ID = point_measure_fact.Point_ID;
facts_restatment_audit.New_Value = newvalue;
facts_restatment_audit.Old_Value = point_measure_fact.Raw_Value;
facts_restatment_audit.Send_To_DW = true;
facts_restatment_audit.Timestamp_From = point_measure_fact.Timestamp_From;
facts_restatment_audit.Timestamp_To = point_measure_fact.Timestamp_To;
facts_restatment_audit.Updated_Datetime = System.DateTime.Now;
facts_restatment_audit.Updated_User_ID = 1;
return(facts_restatment_audit);
}
public void Save(FactsRestatementAudit tbl_fact_restatement_audit)
{
_dbcontext = new InnonAnalyticsWarehouseEntities();
_dbcontext.FactsRestatementAudits.Add(tbl_fact_restatement_audit);
_dbcontext.SaveChanges();
}
