/// <summary>
    /// 
    /// </summary>
    public static void FillPharmacyDropdown(DropDownList ddPharmacy)
    {
        Pharmacy pharmacy = new Pharmacy();

        DataSet dsPharmacy = pharmacy.GetPharmacyList();
        ddPharmacy.DataSource = dsPharmacy;
        ddPharmacy.DataTextField = "PharmacyName";
        ddPharmacy.DataValueField = "PharmacyID";
        ddPharmacy.DataBind();
        ListItem itemPharmacy = new ListItem();
        itemPharmacy.Value = "0";
        itemPharmacy.Text = "-Select Pharmacy -";
        ddPharmacy.Items.Insert(0, itemPharmacy);
    }