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();
    }
Esempio n. 3
0
 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));
        }
Esempio n. 7
0
        public bool Put([FromBody] Drug drug)
        {
            DrugOperations drugOperations = new DrugOperations();

            return(drugOperations.DrugInsertIntoDatabase(drug));
        }
Esempio n. 8
0
        public string Get()
        {
            DrugOperations drugOperations = new DrugOperations();

            return(drugOperations.GetAllDrugs());
        }
Esempio n. 9
0
        public string Get([FromUri] int paramOne)
        {
            DrugOperations drugOperations = new DrugOperations();

            return(drugOperations.GetDrugfromDatabase(paramOne));
        }