private DoBase Update()
{
object ChangedValues = null;
bool HasChangedRecord = false;
ChangedValues = GetChangedValues(idoBase, ref HasChangedRecord);
if (HasChangedRecord == true)
{
SqlResult sqlResult = BlQuery.GetUpdateQuery(idoBase, ChangedValues);
int updatedRow = DataAccess.Execute(sqlResult);
if (updatedRow > 0)
{
idoBase.State = ObjState.Updated;
idoBase.OldValues = ConstructOldValues(idoBase);
idoBase.InfoMsg.Message = "Data Updated Successfully.";
}
}
else
{
idoBase.State = ObjState.NoChanges;
idoBase.InfoMsg.Message = "No Changes Made To Data.";
}
return(null);
}
private DoBase Insert()
{
SqlResult sqlResult = BlQuery.GetInsertQuery(idoBase);
object Id = DataAccess.ExecuteScalar(sqlResult);
idoBase.SetPrimaryValue(Id);
idoBase.State = ObjState.Inserted;
idoBase.OldValues = ConstructOldValues(idoBase);
idoBase.InfoMsg.Message = "New Data Saved Successfully.";
return(idoBase);
}
private void SaveAudit(string OldRecord, string NewRecord, string Action, string UserId)
{
Audit lAudit = new Audit();
lAudit.Action = Action;
lAudit.OldRecord = OldRecord;
lAudit.NewRecord = NewRecord;
lAudit.CreatedBy = UserId;
lAudit.ModifiedBy = UserId;
lAudit.CreatedDate = DateTime.Now;
lAudit.ModifiedDate = DateTime.Now;
SqlResult sqlResult = BlQuery.GetInsertQuery(lAudit);
object Id = DataAccess.ExecuteScalar(sqlResult);
}
public DoBase Open()
{
SqlResult sqlResult = BlQuery.GetOpenQuery(idoBase);
idoBase = DataAccess.QueryFirstOrDefault(sqlResult);
if (idoBase != null)
{
idoBase.State = ObjState.Selected;
idoBase.InfoMsg = new InfoMessage {
Message = "Data selected & Opened Successfully."
};
}
return(idoBase);
}
public DoBase Delete()
{
SqlResult sqlResult = BlQuery.GetDeleteQuery(idoBase);
int DeletedRow = DataAccess.Execute(sqlResult);
if (DeletedRow > 0)
{
idoBase.State = ObjState.Deleted;
idoBase.InfoMsg = new InfoMessage {
Message = "Data Deleted Successfully."
};
}
return(idoBase);
}