private void button1_Click(object sender, EventArgs e)
{
using (sqlConnection1)
{
sqlConnection1.Open();
String Dt1;
String Dt2;
Dt1 = Convert.ToString(dateTimePicker1.Value);
Dt1 = Dt1.Substring(3, 3) + Dt1.Substring(0, 3) + Dt1.Substring(6, 4);
Dt2 = Convert.ToString(dateTimePicker2.Value);
Dt2 = Dt2.Substring(3, 3) + Dt2.Substring(0, 3) + Dt2.Substring(6, 4);
textBox1.Text = "EXEC spSalesByPeriod " + "'" + Dt1 + "', '" + Dt2 + "'";
StringBuilder results = new StringBuilder();
sqlCommand1.Parameters["@Beginning_Date"].Value = dateTimePicker1.Value;
sqlCommand1.Parameters["@Ending_Date"].Value = dateTimePicker2.Value;
SqlDataReader reader = sqlCommand1.ExecuteReader();
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
results.Append(reader[i].ToString() + "\t");
}
results.Append(Environment.NewLine);
}
textBox2.Text = results.ToString();
}
sqlConnection1.Close();
}
private string BuildUrl(string baseurl, int?fundid, int?bundletypeid)
{
connector = "?";
var sb = new StringBuilder(baseurl);
if (fundid.HasValue)
{
Append(sb, "fundid=" + fundid);
}
if (bundletypeid.HasValue)
{
Append(sb, "bundletype=" + bundletypeid);
}
if (Dt1.HasValue)
{
Append(sb, "dt1=" + Dt1.ToSortableDate());
}
if (Dt2.HasValue)
{
Append(sb, "dt2=" + Dt2.ToSortableDate());
}
if (!IncUnclosedBundles)
{
Append(sb, "includeunclosedbundles=false");
}
if (TaxDedNonTax != "TaxDed")
{
Append(sb, "taxnontax=" + TaxDedNonTax);
}
if (CampusId > 0)
{
Append(sb, "campus=" + CampusId);
}
if (Online < 2)
{
Append(sb, "online=" + Online);
}
return(sb.ToString());
}
public IEnumerable <AgeRangeInfo> GetTotalsByFundAgeRange()
{
var model = new BundleModel();
var customFundIds = APIContributionSearchModel.GetCustomFundSetList(DbUtil.Db, FundSet);
var authorizedFundIds = DbUtil.Db.ContributionFunds.ScopedByRoleMembership(DbUtil.Db).Select(f => f.FundId).ToList();
string fundIds = string.Empty;
if (customFundIds?.Count > 0)
{
fundIds = authorizedFundIds.Where(f => customFundIds.Contains(f)).JoinInts(",");
}
else
{
fundIds = authorizedFundIds.JoinInts(",");
}
var ageRangeInfos = model.TotalsByFundAgeRange(0, Dt1.GetValueOrDefault(), Dt2.GetValueOrDefault(), string.Empty, CampusId, fundIds);
RangeTotal = model.RangeTotal;
return(ageRangeInfos);
}
public IEnumerable <AgeRangeInfo> GetTotalsByFundAgeRange()
{
var model = new BundleModel();
var fundids = APIContributionSearchModel.GetCustomFundSetList(DbUtil.Db, FundSet).JoinInts(",");
var ageRangeInfos = model.TotalsByFundAgeRange(0, Dt1.GetValueOrDefault(), Dt2.GetValueOrDefault(), string.Empty, CampusId, fundids);
RangeTotal = model.RangeTotal;
return(ageRangeInfos);
}
public IEnumerable <AgeRangeInfo> GetTotalsByFundAgeRange()
{
var model = new BundleModel();
var ageRangeInfos = model.TotalsByFundAgeRange(0, Dt1.GetValueOrDefault(), Dt2.GetValueOrDefault(), string.Empty, CampusId);
RangeTotal = model.RangeTotal;
return(ageRangeInfos);
}
public VisitLogVM()
{
Dt2 = DateTime.Now.AddDays(1);
Dt1 = Dt2.AddDays(-7);
Visits = dc.VisitLogs.Where(x => x.BeginDate > Dt1 && x.BeginDate < Dt2).ToList();
}
public IEnumerable <RangeInfo> GetTotalsByFundRange()
{
var model = new BundleModel();
var rangeInfos = model.TotalsByFundRange(FundId, Dt1.GetValueOrDefault(), Dt2.GetValueOrDefault(), string.IsNullOrWhiteSpace(Pledged) ? "false" : Pledged, CampusId);
RangeTotal = model.RangeTotal;
return(rangeInfos);
}
