protected override ICollection <Domain.Client> GetData()
{
ICollection <Domain.Client> clients = new Collection <Domain.Client>();
var dbClients = new BLL.Institution();
dbClients.LoadAll();
while (!dbClients.EOF)
{
clients.Add(new Domain.Client {
ClientID = dbClients.ID, ClientName = dbClients.Name, Woreda = dbClients.WoredaName, Zone = dbClients.ZoneName, Region = dbClients.RegionName, InstitutionType = dbClients.InstitutionTypeName
});
dbClients.MoveNext();
}
return(clients);
}
private void btnAddReceivingUnit_Click(object sender, EventArgs e)
{
int ActiveStatus;
int regionId = Convert.ToInt32(lkRegion.EditValue);
int woredaID = Convert.ToInt32(lkWoreda.EditValue);
int zoneID = Convert.ToInt32(lkZone.EditValue);
int ruType = Convert.ToInt32(lkType.EditValue);
int ownershipType = Convert.ToInt32(lkOwnership.EditValue);
if (lkActive.Text.ToString().Equals("Active"))
ActiveStatus = 1;
else if (lkActive.Text.ToString().Equals("InActive"))
ActiveStatus = 0;
else
ActiveStatus = -1;
// ReceivingUnitsForm con = new ReceivingUnitsForm(regionId, woredaID, zoneID, ruType, ownershipType, ActiveStatus);
// con.ShowDialog();
Institution recUnit = new Institution();
recUnit.LoadAll();
LoadReceivingUnits();
}
private void ReceiveingForm_Load(object sender, EventArgs e)
{
SetPermissions();
LoadDecimalFormatings();
//Bind ReceiptType
cboReceiveType.Properties.DataSource = ReceiptType.GetAllReceiptTypesForReceive();
cboReceiveType.EditValue = ReceiptType.CONSTANTS.STANDARD_RECEIPT;
//Bind the Receiving units Types Lookup
InstitutionType institutionsTypes = new InstitutionType();
institutionsTypes.LoadAll();
institutionsTypes.Sort = "Name ASC";
lkType.Properties.DataSource = institutionsTypes.DefaultView;
lkType.EditValue = InstitutionType.Constants.HEALTH_CENTER;
//---
//Bind the Ownership Type Lookup
LoadOwnershipType();
lkOwnership.EditValue = OwnershipType.Constants.Public;
LoadReceivingUnits();
//----------------------------
// reset the receiving date
dtRecDate.Value = DateTimeHelper.ServerDateTime;
// Load the logical stores and populate the combo boxes
//lkStoreType.Properties.DataSource = BLL.StoreType.GetStoreTypesForAUser(NewMainWindow.UserId).DefaultView;
lkAccounts.SetupActivityEditor().SetDefaultActivity();
// Load the possible suppliers and populate
// Load all occupied Pallet location list for the consolidate lookup editManuf2
repoLKConsolidate.DataSource = PalletLocation.GetAllOccupied();
// load the receiving unit's to the combo box
Institution rus = new Institution();
rus.LoadAll();
lkFacilitySelection.Properties.DataSource = rus.DefaultView;
lkStorageType.DataSource = StorageType.AllStorageTypes;
// bulkPalletLocationLookup.DataSource = PalletLocation.GetAllFree(StorageType.BulkStore);
nonBulkPalletLocationLookup.DataSource = PalletLocation.GetAllFreeNonBulk();
//OnSelectedFilterChanged(new object(), new DevExpress.XtraEditors.Controls.ChangingEventArgs(null,"Drug"));
// load all item Units
ItemUnit itemUnit = new ItemUnit();
itemUnit.LoadAll();
editUnits.DataSource = itemUnit.DefaultView;
lkCategories.Properties.DataSource = BLL.CommodityType.GetAllTypes();
lkCategories.ItemIndex = 0;
// Get the default who's receiving this
txtReceivedBy.Text = CurrentContext.LoggedInUserName;
// for RDF, Hide the packs column on receipt
if (BLL.Settings.IsRdfMode)
{
colPacks.Visible = false;
}
//lcDeliveryNoteCheck.Visibility = BLL.Settings.HandleDeliveryNotes ? DevExpress.XtraLayout.Utils.LayoutVisibility.Always : DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
colPricePerPack.Visible = !BLL.Settings.HandleGRV && srm != true;
lcRefNoInput.Visibility =
lcRefNo.Visibility =
BLL.Settings.HandleGRV
? DevExpress.XtraLayout.Utils.LayoutVisibility.Never
: DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
if (BLL.Settings.IsCenter)
{
colShipper.Visible = false;
colPercentReceived.Visible = true;
colPrintedDate.Visible = false;
PalletizeTab.PageVisible = false;
txtPassCode.Enabled = false;
lcPassCode .Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
tabReceiveTabs.TabPages[3].Text = "Step Three - Store Selection";
}
//Load the allowed Warehouses
DataView PossibleWarehouses = BLL.Warehouse.getActiveWarehouseWithCluster(CurrentContext.UserId);
lkWarehouse.Properties.DataSource = PossibleWarehouses;
if (PossibleWarehouses.Count > 0)
{
lkWarehouse.EditValue = ((DataView)lkWarehouse.Properties.DataSource)[0]["ID"];
}
//Load IsElectronicReceiveOnly Setting
LoadIsPOElectronicSetting();
}
public DataTable GetIssuesByReceivingUnit(int storeId, int routeId, int type, DateTime sdate, DateTime edate,int storeid)
{
//This function does not look efficient.
var rus = new Institution();
rus.LoadAll();
rus.GetAllUnderRoute(routeId);
string theFrom = "";
int i = 0;
while (!rus.EOF)
{
theFrom += HCMIS.Repository.Queries.Item.GetFromClauseFor_GetIssueByReceivingUnitsFilterByDateRange(rus.ID, i,sdate,edate, storeid);
i++;
rus.MoveNext();
}
string select = "";
rus.Rewind();
for (int j = 0; j < i; j++)
{
select = HCMIS.Repository.Queries.Item.GetSelectClauseFor_GetIssueByReceivingUnits(select, rus.Name, j);
rus.MoveNext();
}
var query = HCMIS.Repository.Queries.Item.SelectGetIssuesByReceivingUnit(type, select, theFrom);
Item ite =new Item();
ite.LoadFromRawSql(query);
return ite.DataTable;
}
private void DistributionReport_Load(object sender, EventArgs e)
{
dtFromFacilitySupply.Text = dtToTopFacilities.Text = dtFrom.Text = @"7/7/2010";
btnRefresh_Click(null, null);
Institution institution = new Institution();
institution.LoadAll();
gridFacilities.DataSource = institution.DefaultView;
gridTopFacilities.DataSource = BLL.Institution.GetTopReceivingUnits();
//TODO: add a combo box for selection and change this 1 whenever that combo is changed
gridItemList.DataSource = Item.GetActiveItemsByCommodityType(1, null);
lkStoreType.SetupModeEditor().SetDefaultMode();
}
private void LoadReceivingUnits()
{
Institution rUnit = new Institution();
rUnit.LoadAll();
lkForHub.Properties.DataSource = rUnit.DefaultView;
}
private void lkType_EditValueChanged(object sender, EventArgs e)
{
if (lkAccountType.EditValue == null || lkAccountType.EditValue.ToString() == "")
{
return;
}
layoutForFacility.Text = "For Hub";
layoutFromStore.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
Institution rUnits = new Institution();
rUnits.LoadAll();
lkForHub.Properties.DataSource = rUnits.DefaultView;
lkForHub.Properties.NullText = "Select Hub to Transfer to";
lkForHub.EditValue = null;
ResetOrder();
BindMainOrderGrid();
PopulateItemsList();
}
private void MultiFacilityRequisition_Load(object sender, EventArgs e)
{
BLL.Institution institution = new Institution();
institution.LoadAll();
institution.AddColumn("IsSelected", typeof (bool));
// bind the selected faciliteies to the selected grid
_selectedFacilities = institution.DefaultView.Table.Clone();
gridSelected.DataSource = _selectedFacilities;
// bind the source table
gridChoices.DataSource = institution.DefaultView;
}