public ActionResult AllSales()
{
emed.Models.DB53Entities db = new emed.Models.DB53Entities();
//CrMVCApp.Models.Customer c;
//var c = (from b in db.AllSales select b).ToList();
var c = db.AllSales.ToList();
AllSales rpt = new AllSales();
rpt.Load();
rpt.SetDataSource(c);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "C:\\Users\\M.ALI\\Documents\\ProjectAreports\\AllSalesReport.pdf"));
}
public void FilterResult()
{
SelectedMonthCollection = new ObservableCollection <string>();
SelectedSales = AllSales.Where(x => SelectedStateCollection.Contains(x.State) && x.Country.Contains(SelectedCountry.CountryName) &&
x.Year.Equals(SelectedYear)).ToList();
if (SelectedMonth != null)
{
SelectedSales = SelectedSales.Where(x => x.Month.Equals(SelectedMonth)).ToList();
}
if (SelectedCities != null)
{
SelectedSales = SelectedSales.Where(sale => SelectedCities.Select(r => r.Name).Contains(sale.City)).ToList();
}
}
public void GetAllStatesForAnalysis()
{
SelectedStateCollection = new ObservableCollection <string>();
if (SelectedState != null)
{
SelectedStateCollection.Add(SelectedState.StateName);
return;
}
List <string> selectedStates = AllSales.Select(e => e.State).Distinct().ToList();
foreach (string state in selectedStates)
{
SelectedStateCollection.Add(state);
}
SelectedStateCollection.OrderBy(s => s.ToString());
}
private void списъкToolStripMenuItem_Click(object sender, EventArgs e)
{
AllSales form = new AllSales();
form.Show();
}
