private void loadPaymentHistory(AffiliateHistory[] affiliatesHistory) { DataTable dtPaymentHistory = new DataTable("PaymentHistory"); dtPaymentHistory.Columns.Add("ID"); dtPaymentHistory.Columns.Add("AffiliateID"); dtPaymentHistory.Columns.Add("Amount"); dtPaymentHistory.Columns.Add("DatePaid"); dtPaymentHistory.Columns.Add("Notes"); foreach (AffiliateHistory affiliateHistory in affiliatesHistory) { dtPaymentHistory.Rows.Add(new object[] { affiliateHistory.ID, affiliateHistory.AffiliateID, affiliateHistory.Amount.ToString("C"), affiliateHistory.DatePaid, affiliateHistory.Notes, }); } gvPaymentHistory.DataSource = dtPaymentHistory; gvPaymentHistory.DataBind(); gvPaymentHistory.Visible = dtPaymentHistory.Rows.Count > 0; }
private void loadPaymentHistory(AffiliateHistory[] affiliatesHistory) { DataTable dtPaymentHistory = new DataTable("PaymentHistory"); dtPaymentHistory.Columns.Add("ID"); dtPaymentHistory.Columns.Add("AffiliateUsername"); dtPaymentHistory.Columns.Add("Amount"); dtPaymentHistory.Columns.Add("DatePaid"); dtPaymentHistory.Columns.Add("Notes"); dtPaymentHistory.Columns.Add("PrivateNotes"); foreach (AffiliateHistory affiliateHistory in affiliatesHistory) { Affiliate affiliate = Affiliate.Fetch(affiliateHistory.AffiliateID); if (affiliate != null) { dtPaymentHistory.Rows.Add(new object[] { affiliateHistory.ID, affiliate.Username, affiliateHistory.Amount.ToString("C"), affiliateHistory.DatePaid, affiliateHistory.Notes, affiliateHistory.PrivateNotes }); } else { continue; } } gvPaymentHistory.DataSource = dtPaymentHistory; gvPaymentHistory.DataBind(); gvPaymentHistory.Visible = dtPaymentHistory.Rows.Count > 0; }
/// <summary> /// Fetches affiliates history by specified arguments. /// It returns an empty array if there are no affiliates history in DB by specified arguments. /// If these arguments are null it returns all affiliates history from DB. /// </summary> /// <param name="id">The id.</param> /// <param name="affiliateID">The affiliate ID.</param> /// <param name="amount">The amount.</param> /// <param name="datePayed">The date payed.</param> /// <param name="sortColumn">The sort column.</param> /// <returns></returns> private static AffiliateHistory[] Fetch(int? id, int? affiliateID, decimal? amount, DateTime? datePayed, eSortColumn sortColumn) { using (SqlConnection conn = Config.DB.Open()) { SqlDataReader reader = SqlHelper.ExecuteReader(conn, "FetchAffiliatesHistory", id, affiliateID, amount, datePayed, sortColumn); List<AffiliateHistory> lAffiliatesHistory = new List<AffiliateHistory>(); while (reader.Read()) { AffiliateHistory affiliate = new AffiliateHistory(); affiliate.id = (int)reader["ID"]; affiliate.affiliateID = (int)reader["AffiliateID"]; affiliate.amount = (decimal)reader["Amount"]; affiliate.datePaid = (DateTime)reader["DatePaid"]; affiliate.notes = reader["Notes"] == DBNull.Value ? null : (string) reader["Notes"]; affiliate.privateNotes = reader["PrivateNotes"] == DBNull.Value ? null : (string)reader["PrivateNotes"]; lAffiliatesHistory.Add(affiliate); } return lAffiliatesHistory.ToArray(); } }