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 + "')"); }