public bool UpdateMedicine(Medicine medicine) 
 {
     return du.AddRow(@"update Medicine set ID = " + medicine.ID + ")");
 }
 public bool DeleteMedicine(Medicine medicine)
 {
     return du.DeleteRow(@"update Medicine set DeleteFlag = 1 where ID ='" + medicine.ID + "')");
 }
 public bool AddMedicine(Medicine medicine)  
 {
     return du.AddRow(@"insert into Medicine(ID,MedicineName ,Code, GenericName,CompanyID)
     values(" + medicine.ID + ",'" + medicine.MedicineName + "', '" + medicine.Code + "', " + medicine.GenericName + ", '" + medicine.CompanyID + "')");
 }