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); }
/// <summary> /// Gets the issues by receiving unit faster. /// </summary> /// <param name="storeID">The store ID.</param> /// <param name="routeID">The route ID.</param> /// <param name="type">The type.</param> /// <returns></returns> /// Shit: what a name? and it does crazy stuff too. public DataTable GetIssuesByReceivingUnitFaster(int storeID, int routeID, int type) { var ru = new Institution(); if (Settings.IsRdfMode) ru.GetFacilitiesThatEverReceivedItems(); else ru.GetAllUnderRoute(routeID); //Load all the items. var query = HCMIS.Repository.Queries.Item.SelectGetIssuesByReceivingUnitFaster(type); this.LoadFromRawSql(query); //Add the columns while (!ru.EOF) { this.AddColumn(string.Format("{0},{1}", ru.Name, ru.ID), typeof(int)); ru.MoveNext(); } while (!this.EOF) { Institution rus = new Institution(); if (Settings.IsRdfMode) rus.GetFacilitiesThatEverReceivedItems(); else rus.GetAllUnderRoute(routeID); while (!rus.EOF) { int itemID = int.Parse(this.GetColumn("ID").ToString()); var itm = new Item(); var issueQuery = HCMIS.Repository.Queries.Item.SelectGetIssuesByReceivingUnitFasterIssueQuery(itemID, rus.ID); itm.LoadFromRawSql(issueQuery); if (itm.RowCount > 0 && !itm.IsColumnNull("Quantity")) this.SetColumn(string.Format("{0},{1}", ru.Name, ru.ID), itm.GetColumn("Quantity")); rus.MoveNext(); } this.MoveNext(); } return this.DataTable; }
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; }