protected void btnDelete_Click(object sender, EventArgs e)
{
using (var context = new PPPKContext())
{
int deleteId = int.Parse(ddlServiceItem.SelectedValue);
ServiceItem temp = context.ServiceItem.FirstOrDefault(x => x.Id == deleteId);
context.ServiceItem.Remove(temp);
context.SaveChanges();
context.Dispose();
}
InitVehicles();
}
private void InitVehicles()
{
using (var context = new PPPKContext())
{
_vehicles = context.Vehicle.ToList();
_services = context.Service.ToList();
_serviceItems = context.ServiceItem.ToList();
gvVehicles.DataSource = _vehicles;
gvVehicles.DataBind();
ddlVehicle.DataSource = _vehicles;
ddlVehicle.DataTextField = "Plate";
ddlVehicle.DataValueField = "Id";
ddlVehicle.DataBind();
ddlVehicle.SelectedIndex = 0;
ddlService.AppendDataBoundItems = false;
ddlService.DataSource = null;
ddlService.DataBind();
ddlService.DataSource = _services.Where(x => x.VehicleID == _vehicles.ElementAt(ddlVehicle.SelectedIndex).Id).ToList();
ddlService.DataValueField = "Id";
ddlService.DataTextField = "Date";
ddlService.DataBind();
ddlServiceItem.AppendDataBoundItems = false;
ddlServiceItem.DataSource = null;
ddlServiceItem.DataBind();
if (ddlService.Items.Count > 0)
{
ddlServiceItem.DataSource = _serviceItems.Where(x => x.ServiceID == _services.ElementAt(ddlService.SelectedIndex).Id).ToList();
ddlServiceItem.DataValueField = "Id";
ddlServiceItem.DataTextField = "ServiceName";
ddlServiceItem.DataBind();
gvServiceItems.DataSource = _serviceItems.Where(x => x.ServiceID == _services.ElementAt(ddlService.SelectedIndex).Id).ToList();
gvServiceItems.DataBind();
SetFields();
}
else
{
ddlServiceItem.AppendDataBoundItems = false;
ddlServiceItem.DataSource = null;
ddlServiceItem.DataBind();
gvServiceItems.DataSource = null;
gvServiceItems.DataBind();
ClearFields();
}
}
}
protected void btnAddNewService_Click(object sender, EventArgs e)
{
using (var context = new PPPKContext())
{
context.Service.Add(new Service
{
Date = DateTime.Now,
VehicleID = int.Parse(ddlVehicle.SelectedValue)
});
context.SaveChanges();
context.Dispose();
}
InitVehicles();
}
protected void btnAddService_Click(object sender, EventArgs e)
{
using (var context = new PPPKContext())
{
context.ServiceItem.Add(new ServiceItem
{
Price = Decimal.Parse(txtPrice.Text),
ServiceName = txtServiceName.Text,
ServiceID = int.Parse(ddlService.SelectedValue)
});
context.SaveChanges();
context.Dispose();
}
InitVehicles();
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (var context = new PPPKContext())
{
ServiceItem s = context.ServiceItem.Find(int.Parse(ddlServiceItem.SelectedValue));
s.Price = Decimal.Parse(txtPrice.Text);
s.ServiceName = txtServiceName.Text;
s.ServiceID = int.Parse(ddlService.SelectedValue);
context.SaveChanges();
context.Dispose();
}
InitVehicles();
}
