protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PartyTableAdapter daParty = new PartyTableAdapter();
SalesTableAdapter daCust = new SalesTableAdapter();
BestCustomerTableAdapter daBest = new BestCustomerTableAdapter();
try
{
daParty.Fill(dsSales.Party);
daCust.Fill(dsSales.Sales);
daBest.Fill(dsSales.BestCustomer);
}
catch { }
foreach (DataRow r in dsSales.Sales)
{
MakeTable(r);
}
CalcNetTotal();
lblParty.Text = String.Format("{0:C}", dsSales.Party.Select().First().ItemArray[0]);
DataRow best = dsSales.BestCustomer.Select().First();
lblBestCust.Text = best.Field <string>("custName") + ", " + "spent a total of " + best.Field <decimal>("total").ToString("c");
}
}
public async Task <int> GetPartiesCountAsync(int electionId)
{
await Task.CompletedTask;
using (var tableAdapter = new PartyTableAdapter())
{
return(tableAdapter.CountPartiesQuery(electionId) ?? 0);
}
}
public async Task DeletePartyAsync(PartyModel model)
{
await Task.CompletedTask;
using (var tableAdapter = new PartyTableAdapter())
{
tableAdapter.Delete(
model.Id
);
}
}
public async Task <IEnumerable <PartyModel> > GetPartiesAsync(int electionId)
{
await Task.CompletedTask;
using (var tableAdapter = new PartyTableAdapter())
{
var parties = tableAdapter.GetData(electionId)
.AsQueryable();
return(_mapper.ProjectTo <PartyModel>(parties));
}
}
public async Task InsertPartyAsync(PartyModel model)
{
await Task.CompletedTask;
using (var tableAdapter = new PartyTableAdapter())
{
tableAdapter.Insert(
model.Title,
model.ShortName,
model.Argb,
model.ElectionId
);
}
}
public async Task <PartyModel> GetPartyAsync(int partyId)
{
await Task.CompletedTask;
using (var tableAdapter = new PartyTableAdapter())
{
var row = tableAdapter.GetParties(partyId).SingleOrDefault();
if (row == null)
{
return(null);
}
var model = new PartyModel();
_mapper.Map(row, model);
return(model);
}
}
