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(); }