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