private async void btnCreateType_Click(object sender, EventArgs e) { string name = txtCreateTypeName.Text.Trim(); if (name == "") { MessageBox.Show("Fill Out", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (_db.TypeOfDrug.Any(t => t.type.ToLower() == name.ToLower())) { MessageBox.Show($"{name} alrady exists", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } TypeOfDrug type = new TypeOfDrug() { type = name }; _db.TypeOfDrug.Add(type); await _db.SaveChangesAsync(); MessageBox.Show("Done"); txtCreateTypeName.Text = ""; _cmb.Items.Clear(); _cmb.Items.AddRange(_db.TypeOfDrug.Select(t => new CB_TypeOfDrug { id = t.id, type = t.type }).ToArray()); }
public bool insertTypeDrug(TypeOfDrug e) { try { typedal.insertTypeOfDrug(e); return(true); } catch { return(false); } }
private async void btnDeleteType_Click(object sender, EventArgs e) { int id = ((CB_TypeOfDrug)cmbDeleteType.SelectedItem).id; TypeOfDrug type = _db.TypeOfDrug.First(t => t.id == id); type.Deleted = false; //_db.TypeOfDrug.Remove(type); await _db.SaveChangesAsync(); MessageBox.Show("Deleted"); FillCmb(cmbDeleteType); FillCmb(_cmb); }
public bool updateTypeDrug(eTypeOfDrug e) { try { TypeOfDrug temp = new TypeOfDrug(); temp.Description = e.Description; temp.Type = e.Type; temp.TypeOfDrugID = e.TypeOfDrugID; typedal.updateTypeOfDrug(temp); return(true); } catch { return(false); } }
List <eDrug> IService1.getAllDrugs() { List <eDrug> ls = new List <eDrug>(); foreach (Drug dr in drugdal.getAllDrug()) { eDrug edr = new eDrug(); edr.DrugID = dr.DrugID; edr.Description = dr.Description; edr.Name = dr.Name; edr.Price = Convert.ToDouble(dr.Price); TypeOfDrug t = new TypeOfDrug(); t = typedal.getOneTypeOfDrug(dr.TypeID); eTypeOfDrug et = new eTypeOfDrug(); et.Type = t.Type; et.Description = t.Description; edr.Type = et; ls.Add(edr); } return(ls); }
public void updateTypeOfDrug(TypeOfDrug typeDrug) { //db.TypeOfDrugs.Attach(typeDrug); //db.Entry(typeDrug).State = System.Data.Entity.EntityState.Modified; //db.SaveChanges(); }
public void insertTypeOfDrug(TypeOfDrug TypeOfDrug) { db.TypeOfDrugs.InsertOnSubmit(TypeOfDrug); db.SubmitChanges(); }
public bool updateTypeDrug(TypeOfDrug e) { throw new NotImplementedException(); }