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