public static List<CurrentShowCost> GetUserShowChargeList(int ShowID, int UserID) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.getUserShowCharges(ShowID, UserID); List<CurrentShowCost> showCostsList = new List<CurrentShowCost>(); foreach (DataRow row in ds.Tables[0].Rows) { showCostsList.Add(new CurrentShowCost(row)); } return showCostsList; }
public static RunningPlanDto GetUserTransactions(int Id, string refCode) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.GetUserTransactions(Id, refCode); DataRow row = ds.Tables[0].Rows[0]; var item = new RunningPlanDto { Amount = Convert.ToDecimal(row["Amount"]), RefCode = Convert.ToString(row["RefCode"]), EnteredBy = Convert.ToInt32(row["EnteredBy"]) }; return item; }
public static List<Transaction> getTransactionForUserRefCode(int ShowID, int UserID, int refcode) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.getTransactionsFor(ShowID, UserID, refcode); List<Transaction> translist = new List<Transaction>(); foreach (DataRow row in ds.Tables[0].Rows) { translist.Add(new Transaction(row)); } return translist; }
public static List<ShowTransaction> getTransactionForUser(int UserID) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.GetAllTransactionForUser(UserID); List<ShowTransaction> showTranslist = new List<ShowTransaction>(); foreach (DataRow row in ds.Tables[0].Rows) { showTranslist.Add(new ShowTransaction(row)); } return showTranslist; }
/* * public static List<Transaction> getTransactionForShowUser(int ShowID, int UserID) { String moduleSettings = ModuleConfig.GetSettings(); Data.Transaction t = new Fpp.WebModules.Data.Transaction(moduleSettings); DataSet ds = t.getTransactionsFor(ShowID, UserID, RefCode); List<Transaction> translist = new List<Transaction>(); foreach (DataRow row in ds.Tables[0].Rows) { translist.Add(new Transaction(row)); } return translist; } * * */ public static List<Transaction> GetTransactionForShowUser(int Id) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.getTransactionsFor(Id.ToString()); List<Transaction> translist = new List<Transaction>(); foreach (DataRow row in ds.Tables[0].Rows) { translist.Add(new Transaction(row)); } return translist; }
public Transaction(int TransactionID) : base() { Init(); _transaction = new Fpp.Data.Transaction(ModuleSettings); ID = TransactionID; DataTable dt = _transaction.GetTransaction(ID).Tables[0]; if (dt.Rows.Count > 0) { LoadFromRow(dt.Rows[0]); } }
public static TransactionSummary getTransactionSummary(int ShowID, int UserID) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.getTransactionSummary(ShowID, UserID); if (ds.Tables[0].Rows.Count > 0) { return new TransactionSummary(ds.Tables[0].Rows[0]); } else { return new TransactionSummary(); } }
public static List<OffLineTransactionSummary> getOfflineSummary(int ShowID) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.getOfflineSummary(ShowID); List<OffLineTransactionSummary> showTranslist = new List<OffLineTransactionSummary>(); foreach (DataRow row in ds.Tables[0].Rows) { showTranslist.Add(new OffLineTransactionSummary(row)); } return showTranslist; }
public static List<Transaction> getOnlineUserTransactions(int ShowID) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.getOnlineUserTransactions(ShowID); List<Transaction> showTranslist = new List<Transaction>(); foreach (DataRow row in ds.Tables[0].Rows) { showTranslist.Add(new Transaction(row)); } return showTranslist; }
public static void Delete(int Id) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); t.DeleteById(Id); }
public static List<Transaction> getOfflineList(int ShowID, DateTime fromDate, DateTime toDate) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.getOfflineList(ShowID, fromDate, toDate); List<Transaction> showTranslist = new List<Transaction>(); foreach (DataRow row in ds.Tables[0].Rows) { showTranslist.Add(new Transaction(row)); } return showTranslist; }
public static int Add(String refCode, TransactionTypes TransactionType, Decimal amount, String Comment, int ShowID, int UserID, DateTime TransactionDate, Decimal cheque) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); return t.Add(refCode, (int)TransactionType, amount, Comment, ShowID, UserID, TransactionDate, cheque); }
public Transaction(DataRow row) : base() { Init(); _transaction = new Fpp.Data.Transaction(ModuleSettings); LoadFromRow(row); }
public Transaction(int UserID, int ShowID) : base() { Init(); _transaction = new Fpp.Data.Transaction(ModuleSettings); DataTable dt = _transaction.GetAllTransactionForShowUser(ShowID, UserID).Tables[0]; if (dt.Rows.Count > 0) { LoadFromRow(dt.Rows[0]); } }
public static Transaction.ENTERED_BY hasShowAdminUpdateEntry(int ShowID, int UserID) { Transaction.ENTERED_BY eb = Transaction.ENTERED_BY.ONLINE_ENTRY; String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.hasShowAdminUpdateEntry(ShowID, UserID); if (ds.Tables[0].Rows.Count > 0) { int count = Convert.ToInt32(ds.Tables[0].Rows[0]["Count"]); if (count > 0) { eb = Transaction.ENTERED_BY.SHOW_ADMIN_ENTRY; } } return eb; }
public static List<RunningPlanDto> GetRunningPlansList(int Id) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); List<RunningPlanDto> list = new List<RunningPlanDto>(); DataSet ds = t.GetRunningPlansList(Id); foreach (DataRow row in ds.Tables[0].Rows) { list.Add(new RunningPlanDto { Amount = Convert.ToDecimal(row["Amount"]), Name = Convert.ToString(row["Name"]), RefCode = Convert.ToString(row["RefCode"]), UserId = Convert.ToInt32(row["UserId"]), EnteredBy = Convert.ToInt32(row["EnteredBy"]) }); } return list; }
public static void SetEnteredBy(int transID, ENTERED_BY EnteredBy) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); t.SetEnteredBy(transID, (int )EnteredBy); }
public static List<RefundsDto> GetShowRefunds(int ShowId) { List<RefundsDto> res = new List<RefundsDto>(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(ModuleConfig.GetSettings()); DataSet ds = t.GetShowRefunds(ShowId); foreach (DataRow row in ds.Tables[0].Rows) { res.Add(new RefundsDto { UserShowId = Convert.ToInt32(row["UserShowId"]), Amount = Convert.ToInt32(row["Amount"]), Comment = Convert.ToString(row["Comment"]), Name = Convert.ToString(row["Name"]), TransactionDate = Convert.ToDateTime(row["TransactionDate"]), TransactionType = Convert.ToInt32(row["TransactionType"]) }); } return res; }
public TransactionSummary(int ShowID, int UserID) : base() { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.getTransactionSummary(ShowID, UserID); if (ds.Tables[0].Rows.Count > 0) { LoadFromRow(ds.Tables[0].Rows[0]); } }
public static List<Transaction> getTransactionByTransactionNo(string txnNo) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.GetTransactionsForTxnNo(txnNo); List<Transaction> showTranslist = new List<Transaction>(); foreach (DataRow row in ds.Tables[0].Rows) { showTranslist.Add(new Transaction(row)); } return showTranslist; }
public static String GetUserShowCharges(int ShowID, int UserID) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings); DataSet ds = t.getUserShowCharges(ShowID, UserID); List<CurrentShowCost> showCostsList = new List<CurrentShowCost>(); foreach (DataRow row in ds.Tables[0].Rows) { showCostsList.Add(new CurrentShowCost(row)); } if (showCostsList.Count > 0) { return JsonConvert.SerializeObject(showCostsList); } else { return ""; } }
public Transaction() : base() { _transaction = new Fpp.Data.Transaction(ModuleSettings); Init(); }