public void Rollback()
{
if (Trn != null)
{
Trn.Rollback();
ActiveTransaction = false;
}
}
public async Task <Trn> AddTrn(Trn trn)
{
var addResult = await appDbContext.Trn.AddAsync(trn);
await appDbContext.SaveChangesAsync();
return(addResult.Entity);
}
public void CommitTransaction()
{
if (Trn != null && ActiveTransaction == true)
{
Trn.Commit();
ActiveTransaction = false;
}
}
void IDisposable.Dispose()
{
if (ActiveTransaction == true)
{
Rollback();
}
Trn.Dispose();
Conn.Dispose();
}
public async Task <ActionResult <Trn> > AddTrn(Trn trn)
{
try
{
if (trn == null)
{
BadRequest();
}
var addResult = await trnRepository.AddTrn(trn);
return(CreatedAtAction(nameof(GetTrn), new { id = addResult.TrnID }, addResult));
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError, "Error for saving data."));
}
}
/// <summary>
/// Insert New Rate in DB which pick up from Azure Job Scheduled for every 30 minutes.
/// </summary>
/// <returns></returns>
public async Task <bool> Create(CurrencyViewModel currencyViewModel)
{
try
{
using (SqlConnection Cn = new SqlConnection(ConnectionString))
{
SqlParameter[] parameters =
{
new SqlParameter("@pstrCurrCode", SqlDbType.VarChar),
new SqlParameter("@pdecExchRate", SqlDbType.Decimal, 20),
};
parameters[0].Value = currencyViewModel.SourceCurrency;
parameters[1].Value = currencyViewModel.ConversionRate;
SqlTransaction Trn;
Cn.Open();
Trn = Cn.BeginTransaction();
try
{
await SqlHelper.ExecuteNonQueryAsync(Trn, CommandType.StoredProcedure, consExchRateCreate, parameters);
Trn.Commit();
}
catch (SqlException exSql)
{
Trn.Rollback();
//Need to use logger to log the error
}
finally
{
Trn.Dispose();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public async Task <Trn> UpdateTrn(Trn trn)
{
var updResult = await appDbContext.Trn.FirstOrDefaultAsync(a => a.TrnID == trn.TrnID);
if (updResult != null)
{
updResult.Vno = trn.Vno;
updResult.SvNo = trn.SvNo;
updResult.Vdt = trn.Vdt;
updResult.LedgerID = trn.LedgerID;
updResult.Slcd = trn.Slcd;
updResult.SubLedgerID = trn.SubLedgerID;
updResult.SubLcd = trn.SubLcd;
updResult.AcMasterID = trn.AcMasterID;
updResult.Acno = trn.Acno;
updResult.Narr1 = trn.Narr1;
updResult.Narr2 = trn.Narr2;
updResult.Narr3 = trn.Narr3;
updResult.Dc = trn.Dc;
updResult.PairNo = trn.PairNo;
updResult.Amount = trn.Amount;
updResult.Entrydate = trn.Entrydate;
updResult.BookMasterID = trn.BookMasterID;
updResult.BookNo = trn.BookNo;
updResult.Username = trn.Username;
updResult.CostCenterID = trn.CostCenterID;
updResult.Comp_Id = trn.Comp_Id;
updResult.ChequeNo = trn.ChequeNo;
updResult.ChqBr = trn.ChqBr;
updResult.RefModuleCode = trn.RefModuleCode;
updResult.ShareTrnNo = trn.ShareTrnNo;
updResult.BranchCode = trn.BranchCode;
await appDbContext.SaveChangesAsync();
return(updResult);
}
return(null);
}
protected void FetchRow(Trn trn_ml)
{
string[] selectedAcnoName;
string select_acno; string select_acname;
FromTableRowSelect = true;
UpdateSubVoucherDisplay = true;
selectedAcnoName = trn_ml.Acno.Split("#");
select_acno = selectedAcnoName[0].Trim();
select_acname = selectedAcnoName[1].Trim();
string selectedLedger = trn_ml.LedgerID.ToString() + "," + trn_ml.Slcd;
Ledger_Change(selectedLedger);
FetchSubLedger = trn_ml.SubLedgerID.ToString() + "," + trn_ml.SubLcd;
FetchAccountCode = trn_ml.AcMasterID.ToString().Trim() + "," + select_acno + "," + select_acname;
CostCenterID = trn_ml.CostCenterID.ToString();
Narration1 = trn_ml.Narr1;
SVNo = trn_ml.SvNo;
ChequeNo = trn_ml.ChequeNo;
PairNo = trn_ml.PairNo;
Amount = trn_ml.Amount;
DebitCredit = trn_ml.Dc;
}
public async Task <Trn> AddTrn(Trn newTrn)
{
return(await httpClient.PostJsonAsync <Trn>("api/trn", newTrn));
}
public string BuildEdi(List <Patient> patientList, InsuranceCompany insurance,
BillingProvider billingProvider)
{
var buildEdi = new StringBuilder();
//Begin ISA
var buildisa = new Isa();
buildEdi.Append(buildisa.BuildIsa());
//Begin GS
var buildGs = new Gs();
buildEdi.Append(buildGs.BuildGs());
//Begin ST
var buildSt = new St();
buildEdi.Append(buildSt.BuildSt());
//Begin BPR
var buildBpr = new Bpr();
buildEdi.Append(buildBpr.BuildBpr(insurance));
//Build TRN
var buildTrn = new Trn();
buildEdi.Append(buildTrn.BuildTrn(insurance));
//Ref Segment conditional, not included at this time
//REF Receiver Identification
//REF01 Receiver Reference Number
//REF02 Receiver Reference Identification
//Build DTM Loop Production Date
var buildDtm = new Dtm();
buildEdi.Append(buildDtm.BuildDtm(patientList));
//Build N1 Insurance Company Identification Segment 1000A
var buildNOne = new N1();
buildEdi.Append(buildNOne.BuildNOne(insurance));
//BuildN3 Insurance Company Identification Segment 1000A
var buildNThree = new N3();
buildEdi.Append(buildNThree.BuildNThree(insurance));
// Build N4 Insurance Company Identification 1000A
var buildNFour = new N4();
buildEdi.Append(buildNFour.BuildN4(insurance));
//Build Ref Insurance Company Identification 1000A
var buildRef = new Ref();
buildEdi.Append(buildRef.BuildRef());
//Build Per Insurance Company Identification 1000A
var buildPer = new Per();
buildEdi.Append(buildPer.BuildPerPhone());
//Build Per Insurance Company Website Information 1000A
buildEdi.Append(buildPer.BuildPerWebSite());
//Build N1 Provider Identifier Segment 1000B
buildEdi.Append(buildNOne.BuildNOne(billingProvider));
//Build N3 Provider Identifier Segment 1000B
buildEdi.Append(buildNThree.BuildNThree(billingProvider));
//Build N4 Provider Identifier Segment 1000B
buildEdi.Append(buildNFour.BuildN4(billingProvider));
//Build Ref Provider Identifier 1000B
buildEdi.Append(buildRef.BuildRefAdditionalPayee());
buildEdi.Append(buildRef.BuildRefAdditionalPayeeTwo());
//LX Segment 2000B
var buildLx = new Lx();
buildEdi.Append(buildLx.BuildLx());
//TS3 2000B NOT USED
//TS2 2000B NOT USED
//CLP Segment 2100
foreach (Patient patient in patientList)
{
var buildClp = new Clp();
buildEdi.Append(buildClp.BuildClp(patient));
var buildNmOne = new Nm1();
buildEdi.Append(buildNmOne.BuildNm1(patient));
//MIA Inpatient Adjudication Information
//MOA Outpatient Adjudication Information
//REF Other CLaim Related Identification
//Ref Rendering Provider Identifier 2100
buildEdi.Append(buildRef.BuildRef(patient.Provider));
//DTM Statement From or To Date 2100
buildEdi.Append(buildDtm.BuildDtm(patient));
//PER Claim Contact Information 2100
//SVC Level 2110
var buildSvc = new Svc();
buildEdi.Append(buildSvc.BuildSvc(patient.Charge));
buildEdi.Append(buildDtm.BuildDtm(patient.Charge));
var buildCas = new Cas();
if (patient.Charge.AdjustmentList != null)
{
buildEdi.Append(buildCas.BuildCas(patient.Charge.AdjustmentList));
buildEdi.Append(buildCas.BuildCas(patient.Charge));
}
else
{
buildEdi.Append(buildCas.BuildCas(patient.Charge));
}
buildEdi.Append(buildRef.BuildRefControlNumber());
var buildAmt = new Amt();
buildEdi.Append(buildAmt.BuildAmt(patient.Charge));
//QTY 2110
//LQ 2110
//LQ01 Service Line Remittance Remark Code 1
//LQ02 Service Line Remittance Remark Code 2
foreach (AddonCharge addon in patient.Charge.AddonChargeList)
{
buildEdi.Append(buildSvc.BuildSvc(addon));
buildEdi.Append(buildCas.BuildCas(addon.AdjustmentList));
buildEdi.Append(buildRef.BuildRefControlNumber());
buildEdi.Append(buildAmt.BuildAmt(addon));
}
}
var buildSe = new Se();
buildEdi.Append(buildSe.BuildSe());
var buildGe = new Ge();
buildEdi.Append(buildGe.BuildGe());
var buildIea = new Iea();
buildEdi.Append(buildIea.BuildIea());
return(buildEdi.ToString());
}
