public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.VisitTiming_VisionRefractionReading.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.VisitTiming_TreatmentPlan.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.ServiceCategory_Surcharge_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.Medication_Dose_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.CashBoxInOutTransactions.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.Service_StationPoint_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.UncorrectedDistanceVisualAcuity_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.VisitTiming_SurgeryReservation.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.UnitMeasurment_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.PatientDepositeBalances.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.RawMaterials_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.InPatientRoomClassification_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.FinanceInvoiceDetails.FirstOrDefault(item => item.FinanceInvoiceID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.OrganizationMachine_CashBox_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.VisitTiming_MainAdnexaSegmentSign.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.PEM_ElementPrintOrder_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.Doctor_DiagnosisCategory_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.InsuranceCarrier_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.InPatientRoomBed_InPatientAdmissionPricingType_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.Employee_cu.FirstOrDefault(item => item.Person_CU_ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.InventoryItem_Printing_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.AccountingJournalEntryTransactions.FirstOrDefault(item => item.ID.Equals(id)));
}
public IDBCommon GetSpecificEntity(MerkFinanceEntities context, int id)
{
return(context.GeneralChartOfAccountType_cu.FirstOrDefault(item => item.ID.Equals(id)));
}
public void objContext_SavingChanges(object sender, EventArgs e)
{
MerkFinanceEntities merkContext = this;
LogAuditing log = new LogAuditing();
using (TransactionScope scope = new TransactionScope())
{
StringBuilder currentvalues = new StringBuilder();
StringBuilder originalvalues = new StringBuilder();
IEnumerable <DbEntityEntry> addEntries = GetDbEntityEntries(merkContext, EntityState.Added);
IEnumerable <DbEntityEntry> unchangedEntries = GetDbEntityEntries(merkContext, EntityState.Unchanged);
IEnumerable <DbEntityEntry> updatedEntries = GetDbEntityEntries(merkContext, EntityState.Modified);
#region New Items
foreach (DbEntityEntry entry in addEntries)
{
log = new LogAuditing();
log.CommonTransactionType_P_ID = (int)DB_CommonTransactionType.SaveNew;
log.Date = DateTime.Now;
string[] entityNameArray = entry.Entity.ToString().Split('.');
log.EntityName = entityNameArray[1];
//TODO :: Should get the user from the context
int index = 0;
foreach (var propertyName in entry.CurrentValues.PropertyNames)
{
currentvalues.Append("(");
currentvalues.Append(entry.Member(propertyName).Name);
currentvalues.Append("=");
if (entry.Member(propertyName).CurrentValue != null)
{
Type type = entry.Member(propertyName).CurrentValue.GetType();
currentvalues.Append(entry.Member(propertyName).CurrentValue);
}
else
{
currentvalues.Append("null");
}
if (propertyName == "InsertedBy")
{
log.User_CU_ID = Convert.ToInt32(entry.Member(propertyName).CurrentValue);
}
currentvalues.Append(")");
index++;
if (index == entry.CurrentValues.PropertyNames.Count())
{
break;
}
currentvalues.Append(", ");
}
log.CurrentValues = currentvalues.ToString();
//MerkAuditingEntities.DBAuditingEntities.LogAuditings.Add(log);
//MerkAuditingEntities.DBAuditingEntities.SaveChanges();
}
#endregion
#region Updated Items
foreach (DbEntityEntry entry in updatedEntries)
{
log.CommonTransactionType_P_ID = (int)DB_CommonTransactionType.UpdateExisting;
log.Date = DateTime.Now;
string[] entityNameArray = entry.Entity.ToString().Split('.');
log.EntityName = entityNameArray[1];
//TODO :: Should get the user from the context
//log
int index = 0;
foreach (var propertyName in entry.OriginalValues.PropertyNames)
{
originalvalues.Append("(");
originalvalues.Append(entry.Member(propertyName).Name);
originalvalues.Append("=");
if (entry.Member(propertyName).CurrentValue != null)
{
originalvalues.Append(entry.Member(propertyName).CurrentValue);
}
else
{
originalvalues.Append("null");
}
originalvalues.Append(")");
index++;
if (index == entry.OriginalValues.PropertyNames.Count())
{
break;
}
originalvalues.Append(", ");
log.OriginalValues = originalvalues.ToString();
}
foreach (var propertyName in entry.CurrentValues.PropertyNames)
{
currentvalues.Append("(");
currentvalues.Append(entry.Member(propertyName).Name);
currentvalues.Append("=");
if (entry.Member(propertyName).CurrentValue != null)
{
currentvalues.Append(entry.Member(propertyName).CurrentValue);
}
else
{
currentvalues.Append("null");
}
currentvalues.Append(")");
index++;
if (index == entry.CurrentValues.PropertyNames.Count())
{
break;
}
currentvalues.Append(", ");
}
log.CurrentValues = currentvalues.ToString();
//MerkAuditingEntities.DBAuditingEntities.LogAuditings.Add(log);
//MerkAuditingEntities.DBAuditingEntities.SaveChanges();
}
#endregion
scope.Complete();
}
}