/// <summary>
 /// Gets the woreda by zone and number RU.
 /// </summary>
 /// <param name="zoneId">The zone id.</param>
 /// <returns></returns>
 public static DataTable GetWoredaByZoneAndNumberRU(int zoneId)
 {
     Woreda woredas = new Woreda();
     string query =
         HCMIS.Repository.Queries.Woreda.SelectGetWoredaByZoneAndNumberRU(zoneId);
     Institution institution = new Institution();
     woredas.LoadFromRawSql(query);
     return woredas.DataTable;
 }
Beispiel #2
0
        /// <summary>
        /// Gets the woreda by zone and number RU.
        /// </summary>
        /// <param name="zoneId">The zone id.</param>
        /// <returns></returns>
        public static DataTable GetWoredaByZoneAndNumberRU(int zoneId)
        {
            Woreda woredas = new Woreda();
            string query   =
                HCMIS.Repository.Queries.Woreda.SelectGetWoredaByZoneAndNumberRU(zoneId);
            Institution institution = new Institution();

            woredas.LoadFromRawSql(query);
            return(woredas.DataTable);
        }
 /// <summary>
 /// lists woreda's in a zone
 /// </summary>
 /// <param name="zoneId">The zone id.</param>
 /// <returns></returns>
 public static Woreda GetWoredaByZone(int zoneId)
 {
     Woreda woreda = new Woreda();
     woreda.FlushData();
     woreda.Where.WhereClauseReset();
     woreda.Where.ZoneID.Value = zoneId;
     woreda.Query.Load();
     woreda.Sort = "WoredaName ASC";
     return woreda;
 }
Beispiel #4
0
        /// <summary>
        /// lists woreda's in a zone
        /// </summary>
        /// <param name="zoneId">The zone id.</param>
        /// <returns></returns>
        public static Woreda GetWoredaByZone(int zoneId)
        {
            Woreda woreda = new Woreda();

            woreda.FlushData();
            woreda.Where.WhereClauseReset();
            woreda.Where.ZoneID.Value = zoneId;
            woreda.Query.Load();
            woreda.Sort = "WoredaName ASC";
            return(woreda);
        }
 /// <summary>
 /// Gets the woreda by zone and number RU.
 /// </summary>
 /// <param name="zoneId">The zone id.</param>
 /// <param name="storeID">The store ID.</param>
 /// <param name="issuedTo">if set to <c>true</c> [issued to].</param>
 /// <returns></returns>
 public static DataTable GetWoredaByZoneAndNumberRU(int zoneId,int storeID, bool issuedTo)
 {
     Woreda woredas = new Woreda();
     if (issuedTo)
     {
         string query =
             HCMIS.Repository.Queries.Woreda.SelectGetWoredaByZoneAndNumberRU(zoneId, storeID);
         Institution institution = new Institution();
         woredas.LoadFromRawSql(query);
     }
     return woredas.DataTable;
 }
Beispiel #6
0
        /// <summary>
        /// Gets the woreda by zone and number RU.
        /// </summary>
        /// <param name="zoneId">The zone id.</param>
        /// <param name="storeID">The store ID.</param>
        /// <param name="issuedTo">if set to <c>true</c> [issued to].</param>
        /// <returns></returns>
        public static DataTable GetWoredaByZoneAndNumberRU(int zoneId, int storeID, bool issuedTo)
        {
            Woreda woredas = new Woreda();

            if (issuedTo)
            {
                string query =
                    HCMIS.Repository.Queries.Woreda.SelectGetWoredaByZoneAndNumberRU(zoneId, storeID);
                Institution institution = new Institution();
                woredas.LoadFromRawSql(query);
            }
            return(woredas.DataTable);
        }
        private void lkForFacility_EditValueChanged(object sender, EventArgs e)
        {
            if (lkForFacility.EditValue == null)
                return;
            FacilityChanged(lkForFacility);

            Institution ru = new Institution();
            ru.LoadByPrimaryKey(Convert.ToInt32(lkForFacility.EditValue));

            if (!ru.IsColumnNull("Woreda"))
            {
                BLL.Woreda woreda = new BLL.Woreda();
                woreda.LoadByPrimaryKey(ru.Woreda);

                BLL.Zone zone = new BLL.Zone();
                zone.LoadByPrimaryKey(woreda.ZoneID);

                lkRegion.EditValue = zone.RegionId;
                lkZone.EditValue = zone.ID;
                lkWoreda.EditValue = ru.Woreda;

            }

            lkOwnership.EditValue = ru.Ownership;

            lkType.EditValue = ru.RUType;

            //Fill facility visit history
            DataRow facilityHis = BLL.Issue.GetVisitHistoryForFacility((int)lkForFacility.EditValue);
            NoOfVisitLabel.Text = facilityHis != null ? Convert.ToInt32(facilityHis["VisitCount"]).ToString(CultureInfo.InvariantCulture) : "0";
            LastVisitlabel.Text = facilityHis != null ? Convert.ToDateTime(facilityHis["LastVisit"]).TimeAgo() : "Never";

            //Reset Requisitoin Type
            if(!BLL.Settings.IsCenter && OrderID == null && Type == RequisitionType.History) lkRequisitionType_EditValueChanged(null, null);
        }
 private void Hospital_Load(object sender, EventArgs e)
 {
     SetPermission();
        BLL.Region reg = new BLL.Region();
     reg.LoadAll();
     //cboRegion.DataSource = reg.DefaultView;
     Zone zon = new Zone();
     zon.LoadAll();
     //cboZone.DataSource = zon.DefaultView;
     Woreda wor = new Woreda();
     wor.LoadAll();
     //cboWoreda.DataSource = wor.DefaultView;
     PopulateFields();
 }
        private void ReceivingUnitsDetails_Load(object sender, EventArgs e)
        {
            LoadReceivingUnits();

            if (ID != -1)
            {

                lcExistingInstitutions.Visibility = LayoutVisibility.Never;
                lcIsUsedInFacility.Visibility = LayoutVisibility.Always;

                int selected = ID;
                Institution recUnit = new Institution();
                recUnit.LoadByPrimaryKey(selected);
                txtReceivingUnit.Text = recUnit.IsColumnNull("Name") ? "" : recUnit.Name;;
                txtReceivingUnit.Enabled = false;
                txtDescription.Text = recUnit.IsColumnNull("Description") ? "" : recUnit.Description;
                txtPhone.Text = recUnit.IsColumnNull("Phone") ? "" : recUnit.Phone;

                if (!recUnit.IsColumnNull("Ownership"))
                    lkOwnership.EditValue = recUnit.Ownership;
                if (!recUnit.IsColumnNull("RUType"))
                    lkRUType.EditValue = recUnit.RUType;
                txtLicenseNo.Text = recUnit.IsColumnNull("LicenseNo") ? "" : recUnit.LicenseNo;
                txtVATNo.Text = recUnit.IsColumnNull("VATNo") ? "" : recUnit.VATNo;
                txtTinNo.Text = recUnit.IsColumnNull("TinNo") ? "" : recUnit.TinNo;

                chkIsInstitutionUsedAtFacility.Checked = recUnit.IsColumnNull("IsUsedAtFacility") ? false : recUnit.IsUsedAtFacility;
                dtRegistration.Value = recUnit.IsColumnNull("DateOfRegistration") ? DateTimeHelper.ServerDateTime : recUnit.DateOfRegistration;
                if (!recUnit.IsColumnNull("Woreda"))
                {
                    BLL.Woreda woreda = new Woreda();
                    woreda.LoadByPrimaryKey(recUnit.Woreda);

                    BLL.Zone zone = new Zone();
                    zone.LoadByPrimaryKey(woreda.ZoneID);

                    BLL.Region region = new BLL.Region();
                    region.LoadByPrimaryKey(zone.RegionId);

                    lkRegion.EditValue = region.ID;

                    lkZone.Properties.DataSource = BLL.Zone.GetZoneByRegion(region.ID).DefaultView;
                    lkZone.EditValue = zone.ID;

                    Woreda.GetWoredaByZone(zone.ID);
                    lkWoreda.Properties.DataSource = woreda.DefaultView;
                    lkWoreda.EditValue = recUnit.Woreda;
                }
                else if (!recUnit.IsColumnNull("Zone")) //We allow the Woreda to be empty so, let's check the zone now.
                {
                    BLL.Zone zone = new Zone();
                    zone.LoadByPrimaryKey(recUnit.Zone);

                    BLL.Region region = new BLL.Region();
                    region.LoadByPrimaryKey(zone.RegionId);

                    lkRegion.EditValue = region.ID;

                    lkZone.Properties.DataSource = BLL.Zone.GetZoneByRegion(region.ID).DefaultView;
                    lkZone.EditValue = zone.ID;
                }
                else
                {
                    lkRegion.EditValue = null;
                    lkZone.EditValue = null;
                    lkWoreda.EditValue = null;
                }

                Route r = new Route();
                r.LoadAll();
                lkRoute.Properties.DataSource = r.DefaultView;

                lkRoute.EditValue = (recUnit.IsColumnNull("Route")) ? 0 : recUnit.Route;
                receivingUnitId = recUnit.ID;

                bool isItDraft = !recUnit.IsColumnNull("IsDraft") && recUnit.IsDraft &&
                                 (BLL.Order.GetTotalForAnInstitution(recUnit.ID) == 0);

                lkRegion.Enabled = isItDraft;
                lkZone.Enabled = isItDraft;
                lkWoreda.Enabled = isItDraft;
                lkRUType.Enabled = isItDraft;
                lkOwnership.Enabled = isItDraft;
                txtReceivingUnit.Enabled = isItDraft;

            }
            else
            {
                lcExistingInstitutions.Visibility=LayoutVisibility.Always;
                lcIsUsedInFacility.Visibility = LayoutVisibility.Never;
            }
        }
        /// <summary>
        /// Loads the location tree
        /// </summary>
        private void PopulateLocationTree()
        {
            BLL.Region reg = new BLL.Region();
            Zone zon = new Zone();
            Woreda wrd = new Woreda();
            reg.LoadAll();
            locationTree.Nodes.Clear();
            foreach (DataRowView dv in reg.DefaultView)
            {
                TreeNode nodes = new TreeNode
                                     {
                                         Name = "Reg" + dv["ID"].ToString(),
                                         Text = dv["RegionName"].ToString(),
                                         ToolTipText = "Double Click to Edit."
                                     };
                zon.GetZoneByRegion(Convert.ToInt32(dv["ID"]));
                foreach (DataRowView subDv in zon.DefaultView)
                {
                    TreeNode zonNodes = new TreeNode
                                            {
                                                Name = "Zon" + subDv["ID"].ToString(),
                                                Text = subDv["ZoneName"].ToString(),
                                                ToolTipText = "Double Click to Edit."
                                            };
                    wrd.GetWoredaByZone(Convert.ToInt32(subDv["ID"]));
                    foreach (DataRowView worDv in wrd.DefaultView)
                    {
                        TreeNode wrdNodes = new TreeNode
                                                {
                                                    Name = "Wrd" + worDv["ID"].ToString(),
                                                    Text = worDv["WoredaName"].ToString(),
                                                    ToolTipText = "Double Click to Edit."
                                                };
                        zonNodes.Nodes.Add(wrdNodes);
                    }
                    nodes.Nodes.Add(zonNodes);
                }
                locationTree.Nodes.Add(nodes);
            }

            cboRegion.DataSource = reg.DefaultView;
        }
        /// <summary>
        /// Handles double click event of the location tree
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void locationTree_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            BLL.Region rgn = new BLL.Region();
            Zone zon = new Zone();
            Woreda wrd = new Woreda();
            string value = locationTree.SelectedNode.Name;
            string type = value.Substring(0, 3);
            int len = value.Length - 3;
            int locationId = Convert.ToInt32(value.Substring(3, len));
            if (type == "Reg")
            {
                rgn.LoadByPrimaryKey(locationId);
                cboRegion.SelectedValue = rgn.ID.ToString();
                txtCode.Text = rgn.RegionCode;
                cboWoreda.Enabled = false;
                cboZone.Enabled = false;
                cboRegion.Enabled = true;
                _locId = rgn.ID;
            }
            else if (type == "Zon")
            {
                zon.LoadByPrimaryKey(locationId);
                cboZone.SelectedValue = zon.ID.ToString();
                txtCode.Text = zon.ZoneCode;
                cboRegion.SelectedValue = zon.RegionId.ToString();
                cboWoreda.Enabled = false;
                cboRegion.Enabled = true;
                cboZone.Enabled = true;
                _locId = zon.ID;
            }
            else if (type == "Wrd")
            {
                wrd.LoadByPrimaryKey(locationId);
                cboWoreda.SelectedValue = wrd.ID.ToString();
                txtCode.Text = wrd.WoredaCode;
                cboZone.SelectedValue = wrd.ZoneID.ToString();
                zon.LoadByPrimaryKey(wrd.ZoneID);
                cboRegion.SelectedValue = zon.RegionId.ToString();
                cboWoreda.Enabled = true;
                cboRegion.Enabled = true;
                cboZone.Enabled = true;
                _locId = wrd.ID;

            }
            _locationType = type;
        }
 /// <summary>
 /// Populates the Woredas
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void cboZone_SelectedIndexChanged(object sender, EventArgs e)
 {
     Woreda wer = new Woreda();
     wer.GetWoredaByZone(Convert.ToInt32(cboZone.SelectedValue));
     cboWoreda.DataSource = wer.DefaultView;
 }
        /// <summary>
        /// Save location related information
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSaveLocation_Click(object sender, EventArgs e)
        {
            if (_locationType == "Reg")
            {
                BLL.Region reg = new BLL.Region();
                if (_locId != 0)
                    reg.LoadByPrimaryKey(_locId);
                else
                    reg.AddNew();
                reg.RegionName = cboRegion.Text;
                reg.RegionCode = txtCode.Text;
                reg.Save();

            }
            else if (_locationType == "Zon")
            {
                Zone zn = new Zone();
                if (_locId != 0)
                    zn.LoadByPrimaryKey(_locId);
                else
                    zn.AddNew();
                zn.ZoneName = cboZone.Text;
                zn.RegionId = Convert.ToInt32(cboRegion.SelectedValue);
                zn.ZoneCode = txtCode.Text;
                zn.Save();
            }
            else if (_locationType == "Wrd")
            {
                Woreda wrd = new Woreda();
                if (_locId != 0)
                    wrd.LoadByPrimaryKey(_locId);
                else
                    wrd.AddNew();
                wrd.WoredaName = cboWoreda.Text;
                wrd.ZoneID = Convert.ToInt32(cboZone.SelectedValue);
                wrd.WoredaCode = txtCode.Text;
                wrd.Save();
            }
            PopulateLocationTree();
        }