public ServicesAndCatalog(service_catalog editServiceCatalog, ButtonEvent buttonEvent = ButtonEvent.Edit) { InitializeComponent(); _editServiceCatalog = editServiceCatalog; LoadServiceCatalogToControl(_editServiceCatalog); this.buttonEvent = buttonEvent; }
void DeleteServiceRelatedToServiceCatalog() { service_catalog scat = GetServiceCatalogFromDB(); var allService = dbHelper.services.Where(s => s.service_catalog_id == scat.service_catalog_id); dbHelper.services.RemoveRange(allService); dbHelper.SaveChanges(); }
private void EditServiceCatalog() { service_catalog serviceCatalog = GetServiceCatalogFromDB(); if (serviceCatalog != null) { ServicesAndCatalog sac = new ServicesAndCatalog(serviceCatalog, ButtonEvent.Edit); sac.headerText.Text = $"Edit Service Catalog : {serviceCatalog.name}"; sac.Show(); } }
private void AddNewService() { //Check selected Catalog where user wants to make an entry and add the service service_catalog selectedCatalog = GetServiceCatalogFromDB(); if (selectedCatalog != null) { Services services = new Services(selectedCatalog, ButtonEvent.Save); services.ShowDialog(); } }
private service_catalog GetServiceCatalogFromDB() { if (dataGridView1.CurrentRow.Index != -1) { serviceCatalog.service_catalog_id = Convert.ToInt32(dataGridView1.CurrentRow.Cells["service_catalog_id"].Value); using (emedEntities db = new emedEntities()) { serviceCatalog = db.service_catalog.FirstOrDefault(s => s.service_catalog_id == serviceCatalog.service_catalog_id); } } return(serviceCatalog); }
private void SaveServiceCatalog() { using (emedEntities db = new emedEntities()) { service_catalog serviceCatalog = new service_catalog(); serviceCatalog.name = txtName.Text.Trim(); serviceCatalog.description = txtDescription.Text.Trim(); serviceCatalog.created_at = DateTime.Now; serviceCatalog.creator_id = StartPage._loggedInUser.user_id; //serviceCatalog.creator_id = _authenticatedUser.user_id; serviceCatalog.active = (checkBoxActive.Checked) ? active + 1 : active; db.service_catalog.Add(serviceCatalog); db.SaveChanges(); MessageBox.Show("New Service Catalog Added Succesfully", "Message"); Close(); } }
private void comboBoxServices_SelectedIndexChanged(object sender, EventArgs e) { //service_catalog data = GetServiceCatalogName(comboBoxServices.Text); //List<service> serviceList; //if (data != null) //{ // using(emedEntities db = new emedEntities()) // { // serviceList = db.services.Where(s => s.service_catalog_id == data.service_catalog_id).ToList(); // dataGridViewServices.DataSource = serviceList; // } //} if (isLoaded) { service_catalog data = GetServiceCatalogName(comboBoxServices.Text); List <service> serviceList; if (data != null) { serviceList = dbHelper.services.Where(s => s.service_catalog_id == data.service_catalog_id).ToList(); dataGridViewServices.DataSource = serviceList; } } }
public List <service> GetServiceFromServiceCatalog() { service_catalog scat = GetServiceCatalogFromDB(); return(dbHelper.services.Where(s => s.service_catalog_id == scat.service_catalog_id).ToList()); }
private void LoadServiceCatalogToControl(service_catalog serviceCatalog) { txtName.Text = _editServiceCatalog.name; _editServiceCatalog.active = Convert.ToInt32(_editServiceCatalog.active == 1 ? checkBoxActive.CheckState = CheckState.Checked : checkBoxActive.CheckState = CheckState.Unchecked); txtDescription.Text = _editServiceCatalog.description; }
public Services(service_catalog serviceCatalog, ButtonEvent buttonEvent = ButtonEvent.Save) { InitializeComponent(); _service_catalog = serviceCatalog; this.buttonEvent = buttonEvent; }