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()); } } }