public List <TransactionsDTO> GetTransactionslist(int AccountNo, string ConnectionString)
{
List <TransactionsDTO> lstTransactions = new List <TransactionsDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select * from(select received_amount,receipt_no,rd_receipt_date,narration,Mode_of_receipt,(case when tt.clearstatus='Y' then 'cleared' when (tt.clearstatus='R' or tt.clearstatus='C' or depositstatus='C') then 'Canceled' when tt.clearstatus is null then 'cleared' else 'Not Cleared' end ) as Chequestatus from rd_receipt fr left join tbltransreceiptreference tt on fr.receipt_no=tt.receiptid where rd_account_id=" + AccountNo + " order by rd_receipt_id desc)tbl where Chequestatus<>'Canceled' order by rd_receipt_date;"))
while (dr.Read())
{
TransactionsDTO objTransactions = new TransactionsDTO();
objTransactions.pReceiptamount = dr["received_amount"];
objTransactions.pReceiptno = dr["receipt_no"];
objTransactions.pNarration = dr["narration"];
objTransactions.pModeofReceipt = dr["Mode_of_receipt"];
objTransactions.pChequestatus = dr["Chequestatus"];
if (dr["rd_receipt_date"] != DBNull.Value)
{
objTransactions.pReceiptdate = Convert.ToDateTime(dr["rd_receipt_date"]).ToString("dd/MM/yyyy");
}
else
{
objTransactions.pReceiptdate = "";
}
//objTransactions.pChequestatus = dr["chequestatus"].ToString();
lstTransactions.Add(objTransactions);
}
}
catch (Exception ex)
{
throw;
}
return(lstTransactions);
}
private List <TransactionsDTO> GetTransactionslist(string loanid, string ConnectionString)
{
lstTransactions = new List <TransactionsDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, " select totalreceived,receiptno,receiptdate,narration,case when chrclearstatus in('N','P') then 'Not Cleared' when chrclearstatus='R' then 'Return' else 'Cleared' end as chequestatus from tbltransemireceipt where vchapplicationid='" + ManageQuote(loanid) + "' and chrclearstatus in('N','P','Y','') order by emiid desc;;"))
while (dr.Read())
{
TransactionsDTO objTransactions = new TransactionsDTO();
objTransactions.pReceiptamount = Convert.ToDecimal(dr["totalreceived"]);
objTransactions.pReceiptno = dr["receiptno"].ToString();
objTransactions.pNarration = dr["narration"].ToString();
if (dr["receiptdate"] != DBNull.Value)
{
objTransactions.pReceiptdate = Convert.ToDateTime(dr["receiptdate"]).ToString("dd/MM/yyyy");
}
else
{
objTransactions.pReceiptdate = "";
}
objTransactions.pChequestatus = dr["chequestatus"].ToString();
lstTransactions.Add(objTransactions);
}
}
catch (Exception)
{
throw;
}
return(lstTransactions);
}
public static TransactionsDTO ToDTO(this Transactions transaction)
{
TransactionsDTO transactionDto = new TransactionsDTO();
transactionDto.Sku = transaction.Sku;
transactionDto.Amount = transaction.Amount;
transactionDto.Currency = transaction.Currency;
return(transactionDto);
}
public static TransactionsDTO Transaction_To_TransactionDTO(Transactions entity)
{
TransactionsDTO mappedEntity = new TransactionsDTO
{
Amount = entity.Amount,
Currency = entity.Currency,
SKU = entity.SKU
};
return(mappedEntity);
}
public ApiCustomResponse(bool success, string message, TransactionsDTO data)
{
Success = success;
Message = message;
Data = data;
}
//// PUT: api/Transactions/5
//[ResponseType(typeof(void))]
//public async Task<IHttpActionResult> PutTransactions(int id, Transactions transactions)
//{
// if (!ModelState.IsValid)
// {
// return BadRequest(ModelState);
// }
// if (id != transactions.TransactionId)
// {
// return BadRequest();
// }
// db.Entry(transactions).State = EntityState.Modified;
// try
// {
// await db.SaveChangesAsync();
// }
// catch (DbUpdateConcurrencyException)
// {
// if (!TransactionsExists(id))
// {
// return NotFound();
// }
// else
// {
// throw;
// }
// }
// return StatusCode(HttpStatusCode.NoContent);
//}
// POST: api/Transactions
public IHttpActionResult GetFilterTransactions([FromUri] TransactionsDTO dtoModelTranscations)
{
//ModelState.Remove("MeatKinds.Id");
//if (!ModelState.IsValid)
//{
// var suppliesViewModelObject = new TransactionViewModel()
// {
// Fromdate = DateTime.Today.Date,
// Todate = DateTime.Today.Date,
// MeatKindList = _context.MeatKind.ToList(),
// TransactionTotal = transactionviewmodel.TransactionList.Sum(c => c.QuantityPurchased)
// };
// return View("TransactionHistory", suppliesViewModelObject);
//}
string converttostringFromDate = dtoModelTranscations.FromDate.ToString("M/dd/yyyy");
string converttostringToDate = dtoModelTranscations.ToDate.ToString("M/dd/yyyy");
bool checkIfFinished = true;
var transactionslist = db.Transactions.ToList();
List <Transactions> sorted = new List <Transactions>();
while (checkIfFinished == true)
{
foreach (var eachtransaction in transactionslist)
{
if (eachtransaction.TransactionDateTime.Date == dtoModelTranscations.FromDate.Date)
{
sorted.Add(eachtransaction);
}
}
if (dtoModelTranscations.FromDate.Date != dtoModelTranscations.ToDate.Date)
{
dtoModelTranscations.FromDate = dtoModelTranscations.FromDate.AddDays(1);
}
else
{
checkIfFinished = false;
}
}
if (dtoModelTranscations.MeatKindId == 0)
{
var _meattypeslist = db.MeatKinds.ToList();
var filteredjustdatetransactions = new TransactionsDTO()
{
TransactionsList = sorted,
MeatKindsList = _meattypeslist,
TransactionTotal = sorted.Sum(c => c.QuantityPurchased),
};
return(Ok(filteredjustdatetransactions));
}
List <Transactions> dab = new List <Transactions>();
if (dtoModelTranscations.MeatKinds.Id != 0)
{
var Transactionslist = db.Transactions.ToList();
var meattypeslist = db.MeatKinds.ToList();
var filteredmeattypealsotransactions = new TransactionsDTO();
filteredmeattypealsotransactions.TransactionsList = sorted.Where(c => c.MeatKindId == dtoModelTranscations.MeatKinds.Id).ToList();
filteredmeattypealsotransactions.MeatKindsList = meattypeslist;
filteredmeattypealsotransactions.TransactionTotal = sorted.Sum(c => c.QuantityPurchased);
return(Ok(filteredmeattypealsotransactions));
}
return(Ok());
}
