public void DrugInsertIntoDatabaseTest() { var po = new DrugOperations(); var drug = new Drug() { DrugId = 2, DrugName = "Amoxylin", DrugType = "Antibiotic", AvailableNumber = 30, CommonIntake = "High Fever", }; //test CI Assert.AreEqual(true, po.DrugInsertIntoDatabase(drug)); }
public static void DeleteDependencies(long id) { var ctx = new DataClassesDataContext(); // drug group's depency is drug // select all drugs belong to this deug group var drugs = from d in ctx.Drugs where d.DrugGroupID == id select d; // delete all their dependencies foreach (var drug in drugs) { DrugOperations.DeleteDependencies(drug.ID); } // delete those drugs ctx.Drugs.DeleteAllOnSubmit(drugs); ctx.SubmitChanges(); }
protected void DrugDetailsFormView_ItemDeleting(object sender, FormViewDeleteEventArgs e) { // delete all this drug's dependencies DrugOperations.DeleteDependencies(long.Parse(e.Keys["ID"].ToString())); }
protected void AllDrugGridView_RowDeleting(object sender, GridViewDeleteEventArgs e) { // delete all this drug's dependencies DrugOperations.DeleteDependencies(long.Parse(e.Keys["ID"].ToString())); }
public void GetAllDrugsTest() { var po = new DrugOperations(); Assert.NotNull(po.GetAllDrugs()); }
public void GetDrugfromDatabaseTest() { var po = new DrugOperations(); Assert.NotNull(po.GetDrugfromDatabase(1)); }
public bool Put([FromBody] Drug drug) { DrugOperations drugOperations = new DrugOperations(); return(drugOperations.DrugInsertIntoDatabase(drug)); }
public string Get() { DrugOperations drugOperations = new DrugOperations(); return(drugOperations.GetAllDrugs()); }
public string Get([FromUri] int paramOne) { DrugOperations drugOperations = new DrugOperations(); return(drugOperations.GetDrugfromDatabase(paramOne)); }