public async Task <IActionResult> SaveMemberReceipt([FromBody] MemberReceiptDTO ObjMemberReceiptDTO)
{
try
{
string OUTReceiptid = string.Empty;
if (objSDReceipt.SaveMemberReceipt(ObjMemberReceiptDTO, Con, out OUTReceiptid))
{
if (!string.IsNullOrEmpty(OUTReceiptid))
{
_GeneralReceiptReportDTO = new GeneralReceiptReportDTO();
_GeneralReceiptReportDTO = await _AccountingTransactionsDAL.GetgeneralreceiptReportData1(OUTReceiptid, Con);
_GeneralReceiptReportDTO.pCompanyInfoforReports = obj.GetcompanyNameandaddressDetails(Con);
return(Ok(_GeneralReceiptReportDTO));
}
else
{
return(Ok(false));
}
}
else
{
return(StatusCode(StatusCodes.Status304NotModified));
}
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw ex;
}
}
public async Task <IActionResult> GetgeneralreceiptReportData1(string ReceiptId)
{
try
{
if (!string.IsNullOrEmpty(ReceiptId))
{
_GeneralReceiptReportDTO = new GeneralReceiptReportDTO();
_GeneralReceiptReportDTO = await _AccountingTransactionsDAL.GetgeneralreceiptReportData1(ReceiptId, Con);
_GeneralReceiptReportDTO.pCompanyInfoforReports = obj.GetcompanyNameandaddressDetails(Con);
if (_GeneralReceiptReportDTO != null)
{
return(Ok(_GeneralReceiptReportDTO));
}
else
{
return(NotFound());
}
}
else
{
return(StatusCode(StatusCodes.Status406NotAcceptable));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw;
}
}
public async Task <List <GeneralReceiptReportDTO> > GetgeneralreceiptReportData(string ReceiptId, string Connectionstring)
{
await Task.Run(() =>
{
pGeneralReceiptReportDataList = new List <GeneralReceiptReportDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(Connectionstring, CommandType.Text, "select tr.receiptid,receiptdate,creditaccountid,ledgeramount,upper(gstnumber) GSTNO,contactname ,narration,accountname,trim(substring(cash_words(ledgeramount::money), 1, position('dollars' in cash_words(ledgeramount::money))-1)) as amountwords from tbltransgeneralreceipt tr join tbltransgeneralreceiptdetails trd on tr.receiptid=trd.receiptid left join tblmstaccounts tac on tac.accountid=trd.creditaccountid where upper(TR.receiptid)='" + ManageQuote(ReceiptId).Trim().ToUpper() + "';"))
{
while (dr.Read())
{
GeneralReceiptReportDTO _GeneralReceipt = new GeneralReceiptReportDTO
{
pReceiptdate = Convert.ToString(dr["receiptdate"]),
pReceiptId = Convert.ToString(dr["receiptid"]),
pCrdAccountId = Convert.ToInt64(dr["creditaccountid"]),
pLedgeramount = Convert.ToDecimal(dr["ledgeramount"]),
pGstno = Convert.ToString(dr["GSTNO"]),
pContactname = Convert.ToString(dr["contactname"]),
pNarration = Convert.ToString(dr["narration"]),
pAccountname = Convert.ToString(dr["accountname"]),
pAmountinWords = Convert.ToString(dr["amountwords"])
};
pGeneralReceiptReportDataList.Add(_GeneralReceipt);
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(pGeneralReceiptReportDataList);
}
public async Task <IActionResult> SaveEmiReceipt([FromBody] SaveEmireceiptsDTO SaveEmireceiptslist)
{
try
{
string OUTReceiptid = string.Empty;
if (ObjReceipts.SaveEmiReceipt(SaveEmireceiptslist, Con, out OUTReceiptid))
{
if (!string.IsNullOrEmpty(OUTReceiptid))
{
_GeneralReceiptReportDTO = new GeneralReceiptReportDTO();
_GeneralReceiptReportDTO = await _AccountingTransactionsDAL.GetgeneralreceiptReportData1(OUTReceiptid, Con);
_GeneralReceiptReportDTO.pCompanyInfoforReports = obj.GetcompanyNameandaddressDetails(Con);
return(Ok(_GeneralReceiptReportDTO));
}
else
{
return(Ok(false));
}
}
else
{
return(Ok(false));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public async Task <IActionResult> SaveGeneralReceipt([FromBody] GeneralreceiptDTO GeneralreceiptDTO)
{
try
{
string OldFolder = "Upload";
string NewFolder = "Original";
string webRootPath = _hostingEnvironment.ContentRootPath;
string OldPath = Path.Combine(webRootPath, OldFolder);
string newPath = Path.Combine(webRootPath, NewFolder);
if (!Directory.Exists(newPath))
{
Directory.CreateDirectory(newPath);
}
if (!string.IsNullOrEmpty(GeneralreceiptDTO.pFilepath))
{
string OldFullPath = Path.Combine(OldPath, GeneralreceiptDTO.pFilepath);
string NewFullPath = Path.Combine(newPath, GeneralreceiptDTO.pFilepath);
GeneralreceiptDTO.pFilepath = NewFullPath;
if (System.IO.File.Exists(OldFullPath))
{
System.IO.File.Move(OldFullPath, NewFullPath);
}
}
string GeneralReceiptId = string.Empty;
if (_AccountingTransactionsDAL.SaveGeneralReceipt(GeneralreceiptDTO, Con, out GeneralReceiptId))
{
if (!string.IsNullOrEmpty(GeneralReceiptId))
{
//GeneralReceiptReportDataList = new List<GeneralReceiptReportDTO>();
//GeneralReceiptReportDataList = await _AccountingTransactionsDAL.GetgeneralreceiptReportData(GeneralReceiptId, Con);
_GeneralReceiptReportDTO = new GeneralReceiptReportDTO();
_GeneralReceiptReportDTO = await _AccountingTransactionsDAL.GetgeneralreceiptReportData1(GeneralReceiptId, Con);
_GeneralReceiptReportDTO.pCompanyInfoforReports = obj.GetcompanyNameandaddressDetails(Con);
return(Ok(_GeneralReceiptReportDTO));
}
else
{
return(Ok(false));
}
}
else
{
return(Ok(false));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public async Task <IActionResult> SaveShareReceipt([FromBody] ShareReceiptDTO ObjShareReceiptDTO)
{
try
{
string OUTReceiptid = string.Empty;
if (objSDReceipt.SaveShareReceipt(ObjShareReceiptDTO, Con, out OUTReceiptid))
{
if (!string.IsNullOrEmpty(OUTReceiptid))
{
if (ObjShareReceiptDTO.pModeofreceipt != "ADJUSTMENT")
{
_GeneralReceiptReportDTO = new GeneralReceiptReportDTO();
_GeneralReceiptReportDTO = await _AccountingTransactionsDAL.GetgeneralreceiptReportData1(OUTReceiptid, Con);
return(Ok(_GeneralReceiptReportDTO));
}
else
{
_JournalVoucherReportDTO = new List <JournalVoucherReportDTO>();
_JournalVoucherReportDTO = await _AccountingTransactionsDAL.GetJournalVoucherReportData(Con, OUTReceiptid);
return(Ok(_JournalVoucherReportDTO));
}
}
else
{
return(Ok(false));
}
}
else
{
return(StatusCode(StatusCodes.Status304NotModified));
}
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw ex;
}
}
public async Task <GeneralReceiptReportDTO> GetgeneralreceiptReportData1(string ReceiptId, string Connectionstring)
{
await Task.Run(() =>
{
try
{
ReceiptId = ManageQuote(ReceiptId).Trim().ToUpper();
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(Connectionstring, CommandType.Text, "select distinct tr.receiptid,receiptdate,coalesce(upper(gstnumber),'') as gstno,coalesce(upper(contactname),'') as contactname ,coalesce(narration,'') as narration,modeofreceipt,coalesce(referencenumber,'')as referencenumber,trr.typeofpayment,coalesce(tu.employeename,'')as employeename,cleardate,chequedate,depositeddate from tbltransgeneralreceipt tr join tbltransgeneralreceiptdetails trd on tr.receiptid=trd.receiptid left join tbltransreceiptreference trr on trr.receiptid=tr.receiptid left join tblmstusers tu on tr.createdby=tu.userid where upper(TR.receiptid)='" + ReceiptId + "';"))
{
while (dr.Read())
{
pGeneralReceiptData = new GeneralReceiptReportDTO
{
pReceiptdate = Convert.ToDateTime(dr["receiptdate"]).ToString("dd-MMM-yyyy"),
pReceiptId = Convert.ToString(dr["receiptid"]),
pGstno = Convert.ToString(dr["gstno"]),
pContactname = Convert.ToString(dr["contactname"]),
pNarration = Convert.ToString(dr["narration"]),
pModeofreceipt = Convert.ToString(dr["modeofreceipt"]),
pReferenceorChequeNo = Convert.ToString(dr["referencenumber"]),
pTypeofpayment = Convert.ToString(dr["typeofpayment"]),
pPostedby = Convert.ToString(dr["employeename"]),
pGeneralReceiptSubDetailsList = GetGeneralreceiptParticulars(ReceiptId, Connectionstring),
pCleardate = Convert.ToString(dr["cleardate"]),
pChequedate = dr["chequedate"] != DBNull.Value ? Convert.ToDateTime(dr["chequedate"]).ToString("dd-MMM-yyyy") : Convert.ToString(dr["chequedate"]),
pDepositeddate = Convert.ToString(dr["depositeddate"])
};
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(pGeneralReceiptData);
}
