public bool CheckForPreviousGlobalPostOp(GlobalPostOp globalPostOp)
{
int count = 0;
try
{
using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
{
const string query = "select count(*) from GlobalPostOp"
+ " where ChargeID = @ChargeID";
count = db.Query<int>(query, new {
@ChargeID = globalPostOp.ChargeId,
}).Single();
if (count > 0)
{
return true;
}
else
{
return false;
}
}
}
catch (Exception er)
{
Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
return true;
}
}
public bool CheckForGlobalPostOpDataDuplicates(GlobalPostOp globalPostOp)
{
int count = 0;
try
{
using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
{
const string query = "SELECT count(*)"
+ " FROM [GlobalPostOp]"
+ " where PatientId = @PatientId"
+ " and DateOfService = @DateOfService"
+ " and ProcedureCode = @ProcedureCode"
+ " and ChargeId = @ChargeId";
count = db.Query<int>(query, new
{
@PatientId = globalPostOp.PatientId,
@DateOfService = globalPostOp.ServiceDate,
@ProcedureCode = globalPostOp.ProcedureCode,
@ChargeId = globalPostOp.ChargeId
}).Single();
if (count > 0)
{
return true;
}
else
{
return false;
}
}
}
catch (Exception er)
{
Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
return false;
}
}
public void InsertGlobalPostOp(GlobalPostOp globalPostOp)
{
OperationResult operationResult = new Models.OperationResult();
using (IDbConnection db = new SqlConnection(ConfigurationValues.FormsConsoleConnection))
{
try
{
const string query = "INSERT INTO [GlobalPostOp]"
+ " ("
+ " [PatientId]"
+ " ,[DateOfService]"
+ " ,[ProcedureCode]"
+ " ,[Charge]"
+ " ,[Description]"
+ " ,[RenderingProvider]"
+ " ,[ChargeID]"
+ ")"
+ " VALUES"
+ " ("
+ " @PatientId,@DateOfService,@ProcedureCode,@Charge,@Description,@RenderingProvider,@ChargeID"
+ ") ";
int rowsAffectd = db.Execute(query, new
{
@PatientId = globalPostOp.PatientId,
@DateOfService = globalPostOp.ServiceDate,
@ProcedureCode = globalPostOp.ProcedureCode,
@Charge = globalPostOp.Charge,
@Description = globalPostOp.ProcedureDescription,
@RenderingProvider = globalPostOp.RenderingProvider,
@ChargeID = globalPostOp.ChargeId
});
//operationResult.Success = true;
}
catch (Exception er)
{
Utility.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
}
}
