• R/O
  • SSH
  • HTTPS

softbanking: Commit


Commit MetaInfo

Revision68 (tree)
Time2022-05-04 08:45:00
Authorhemaxvi_soft

Log Message

(empty log message)

Change Summary

Incremental Difference

--- Capas/Datos/TransactionDetailsDAL.cs (revision 67)
+++ Capas/Datos/TransactionDetailsDAL.cs (revision 68)
@@ -372,6 +372,60 @@
372372 return transactionDetailsList;
373373 }
374374
375+ public List<TransactionDetailsDAL> SearchDetail(LoginDAL loginDAL)
376+ {
377+ ErrorCode = 0;
378+ ErrorDescription = "Successful";
379+ SqlConnection con = new SqlConnection();
380+ SqlParameter parametros;
381+ SqlDataReader dr = null;
382+ List<TransactionDetailsDAL> transactionDetailsList = new List<TransactionDetailsDAL>();
383+ try
384+ {
385+ dbm.DataSource = loginDAL.DataSource; dbm.DataBase = loginDAL.DataBaseName; dbm.User = loginDAL.UserName; dbm.Password = loginDAL.UserPassword; con = dbm.getConexion(dbm);
386+ con.Open();
387+ SqlCommand cmd = new SqlCommand("TransactionDetailsSearch2", con);
388+
389+ if (TransactionID > 0)
390+ {
391+ parametros = cmd.Parameters.Add("@TransactionID", SqlDbType.Int);
392+ parametros.Value = TransactionID;
393+ }
394+ cmd.CommandType = CommandType.StoredProcedure;
395+ dr = cmd.ExecuteReader();
396+ if (dr.HasRows)
397+ {
398+ while (dr.Read())
399+ {
400+ transactionDetailsDAL = new TransactionDetailsDAL();
401+ transactionDetailsDAL.transactionDetailID = dr.GetInt64(dr.GetOrdinal("TransactionDetailID"));
402+ transactionDetailsDAL.transactionID = dr.GetInt64(dr.GetOrdinal("TransactionID"));
403+ transactionDetailsDAL.playTypeID = dr.GetInt32(dr.GetOrdinal("PlayTypeID"));
404+ transactionDetailsDAL.numbers = dr.GetString(dr.GetOrdinal("Numbers"));
405+ transactionDetailsDAL.transactionStatusID = dr.GetInt32(dr.GetOrdinal("TransactionStatusID"));
406+ transactionDetailsDAL.amount = dr.GetDecimal(dr.GetOrdinal("Amount"));
407+ transactionDetailsDAL.commission = dr.GetDecimal(dr.GetOrdinal("Commission"));
408+ transactionDetailsDAL.partnerCommission = dr.GetDecimal(dr.GetOrdinal("PartnerCommission"));
409+ transactionDetailsDAL.gainAmount = dr.GetInt32(dr.GetOrdinal("GainAmount"));
410+ transactionDetailsDAL.playTypeName = dr.GetString(dr.GetOrdinal("PlayTypeName"));
411+ transactionDetailsDAL.lotteryName = dr.GetString(dr.GetOrdinal("LotteryName"));
412+ transactionDetailsDAL.transactionStatusName = dr.GetString(dr.GetOrdinal("TransactionStatusName"));
413+ transactionDetailsDAL.branchName = dr.GetString(dr.GetOrdinal("BranchName"));
414+ transactionDetailsDAL.ticketDetailID = dr.GetString(dr.GetOrdinal("TicketDetailID"));
415+ transactionDetailsList.Add(transactionDetailsDAL);
416+ }
417+ }
418+ con.Close();
419+ }
420+ catch (Exception e)
421+ {
422+ errorDescription = "Error de SQL :" + e.Message;
423+ errorCode = 1;
424+ }
425+
426+ return transactionDetailsList;
427+ }
428+
375429 public List<TransactionDetailsDAL> SearchReport(LoginDAL loginDAL)
376430 {
377431 ErrorCode = 0;
--- TicketsDetalleWF.aspx.cs (revision 67)
+++ TicketsDetalleWF.aspx.cs (revision 68)
@@ -400,7 +400,7 @@
400400
401401 GvTicketsDetail.Controls.Clear();
402402
403- GvTicketsDetail.DataSource = transactionDetailsDAL.Search(loginDAL);
403+ GvTicketsDetail.DataSource = transactionDetailsDAL.SearchDetail(loginDAL);
404404 GvTicketsDetail.DataBind();
405405
406406 calcularTotal();
Show on old repository browser