/// <summary> /// Swaps the receiving units. /// </summary> /// <param name="receivingUnitID">The receiving unit ID.</param> /// <param name="receivingUnitIDTarget">The receiving unit ID target.</param> public static void SwapReceivingUnits(int receivingUnitID, int receivingUnitIDTarget) { BLL.Institution ru = new Institution(); var query = HCMIS.Repository.Queries.Institution.UpdateSwapReceivingUnitsOrder(receivingUnitID, receivingUnitIDTarget); ru.LoadFromRawSql(query); ru.FlushData(); query = HCMIS.Repository.Queries.Institution.UpdateSwapReceivingUnitsIssueDoc(receivingUnitID, receivingUnitIDTarget); ru.LoadFromRawSql(query); }
/// <summary> /// Gets the top receiving units. /// </summary> /// <returns></returns> public static DataTable GetTopReceivingUnits() { var query = HCMIS.Repository.Queries.Institution.SelectGetTopReceivingUnits(); Institution institution = new Institution(); institution.LoadFromRawSql(query); return(institution.DataTable); }
/// <summary> /// Gets all receiving units. /// </summary> /// <returns></returns> public static Institution GetAllReceivingUnits() { Institution rec = new Institution(); var query = HCMIS.Repository.Queries.Institution.SelectLoadAll(); rec.LoadFromRawSql(query); return(rec); }
/// <summary> /// Gets receiving units for IssuDetail by Account report. /// </summary> /// public static DataTable GetDistinctInstitutionForIssueDetail() { var query = HCMIS.Repository.Queries.Institution.SelectGetDistinctInstitutionForIssueDetail(); Institution institution = new Institution(); institution.LoadFromRawSql(query); return(institution.DataTable); }
/// <summary> /// Gets the resupply per unit. /// </summary> /// <param name="recievingUnitID">The recieving unit ID.</param> /// <returns></returns> public static DataTable GetResupplyPerUnit(int recievingUnitID) { var query = HCMIS.Repository.Queries.Institution.SelectGetResupplyPerUnit(recievingUnitID); Institution institution = new Institution(); institution.LoadFromRawSql(query); return(institution.DataTable); }
/// <returns></returns> /// /// <summary> /// Gets the receiving units by type ID. /// </summary> /// <param name="TypeID">The type ID.</param> /// <returns></returns> public static Institution GetReceivingUnitsByTypeID(int TypeID) { Institution rec = new Institution(); var query = HCMIS.Repository.Queries.Institution.SelectGetReceivingUnitsByTypeID(TypeID); rec.LoadFromRawSql(query); return(rec); }
public static Institution LoadReceivingUnitByFilter(int woredaID) { var query = HCMIS.Repository.Queries.Institution.SelectLoadReceivingUnitByFilter(woredaID); var inst = new Institution(); inst.LoadFromRawSql(query); return(inst); }
/// <summary> /// Loads the receiving unit by filter. /// </summary> /// <param name="woredaID">The woreda ID.</param> /// <param name="zoneID">The zone ID.</param> /// <param name="ruType">Type of the ru.</param> /// <param name="ownershipType">Type of the ownership.</param> /// <param name="activeStatus">The active status.</param> /// <param name="inProcess">The in process.</param> /// <param name="hasBeenIssuedTo">if set to <c>true</c> [has been issued to].</param> /// <returns></returns> public static Institution LoadReceivingUnitByFilter(int woredaID, int zoneID, int ruType, int ownershipType, int activeStatus, Boolean inProcess, bool hasBeenIssuedTo) { var filterQuery = HCMIS.Repository.Queries.Institution.SelectLoadReceivingUnitByFilter(woredaID, zoneID, ruType, ownershipType, activeStatus, hasBeenIssuedTo, inProcess); var ru = new Institution(); ru.LoadFromRawSql(filterQuery); return(ru); }
/// <summary> /// Gets the other ID. /// </summary> /// <returns></returns> public static int getOtherID() { var filterQuery = HCMIS.Repository.Queries.Institution.SelectgetOtherID(); BLL.Institution ru = new Institution(); ru.LoadFromRawSql(filterQuery); return(ru.ID); }
/// <summary> /// Loads the receiving unit by filter. /// </summary> /// <param name="name">The name.</param> /// <returns></returns> public static Institution LoadReceivingUnitByFilter(string name) { var query = HCMIS.Repository.Queries.Institution.SelectLoadReceivingUnitByFilter(name); BLL.Institution ru = new Institution(); ru.LoadFromRawSql(query); return(ru); }
public static DataTable GetItemFacilityDistribution(int ModeID, DateTime StartDate, DateTime EndDate, int RegionID = -1, int ZoneID = -1, int WoredaID = -1) { string query = HCMIS.Repository.Queries.Institution.SelectGetItemFacilityDistribution(ModeID, StartDate.ToShortDateString(), EndDate.ToShortDateString(), RegionID, ZoneID, WoredaID); Institution inst = new Institution(); inst.LoadFromRawSql(query); return(inst.DefaultView.Table); }
/// <summary> /// Loads the hubs. /// </summary> /// <returns></returns> public static DataView LoadHubs() { // remember Hub is RUType 8 var filterQuery = HCMIS.Repository.Queries.Institution.SelectLoadHubs(InstitutionType.Constants.HUB); BLL.Institution ru = new Institution(); ru.LoadFromRawSql(filterQuery); return(ru.DefaultView); }
public static bool ValidateNewAddition(string facilityName, int woredaID) { BLL.Institution institution = new Institution(); var query = HCMIS.Repository.Queries.Institution.SelectValidateNewAddition(facilityName, woredaID); institution.LoadFromRawSql(query); if (institution.RowCount > 0) //If it already exists, then it's not valid. { return(false); } else { return(true); } }
/// <summary> /// Gets the receiving units by zone. /// </summary> /// <param name="zoneID">The zone ID.</param> /// <returns></returns> public static Institution GetReceivingUnitsByZone(int zoneID) { Institution rec = new Institution(); var query = HCMIS.Repository.Queries.Institution.SelectGetReceivingUnitsByZone(zoneID); rec.LoadFromRawSql(query); return rec; }
public static DataTable GetItemFacilityDistribution(int ModeID, DateTime StartDate, DateTime EndDate, int RegionID = -1, int ZoneID = -1, int WoredaID = -1) { string query = HCMIS.Repository.Queries.Institution.SelectGetItemFacilityDistribution(ModeID, StartDate.ToShortDateString(), EndDate.ToShortDateString(), RegionID, ZoneID, WoredaID); Institution inst = new Institution(); inst.LoadFromRawSql(query); return inst.DefaultView.Table; }
/// <summary> /// Gets the top receiving units. /// </summary> /// <returns></returns> public static DataTable GetTopReceivingUnits() { var query = HCMIS.Repository.Queries.Institution.SelectGetTopReceivingUnits(); Institution institution = new Institution(); institution.LoadFromRawSql(query); return institution.DataTable; }
public static bool ValidateNewAddition(string facilityName, int woredaID) { BLL.Institution institution = new Institution(); var query = HCMIS.Repository.Queries.Institution.SelectValidateNewAddition(facilityName, woredaID); institution.LoadFromRawSql(query); if(institution.RowCount>0) //If it already exists, then it's not valid. { return false; } else { return true; } }
public static Institution LoadReceivingUnitByFilter(int woredaID) { var query = HCMIS.Repository.Queries.Institution.SelectLoadReceivingUnitByFilter(woredaID); var inst = new Institution(); inst.LoadFromRawSql(query); return inst; }
/// <summary> /// Loads the receiving unit by filter. /// </summary> /// <param name="name">The name.</param> /// <returns></returns> public static Institution LoadReceivingUnitByFilter(string name) { var query = HCMIS.Repository.Queries.Institution.SelectLoadReceivingUnitByFilter(name); BLL.Institution ru = new Institution(); ru.LoadFromRawSql(query); return ru; }
/// <summary> /// Loads the receiving unit by filter. /// </summary> /// <param name="woredaID">The woreda ID.</param> /// <param name="zoneID">The zone ID.</param> /// <param name="ruType">Type of the ru.</param> /// <param name="ownershipType">Type of the ownership.</param> /// <param name="activeStatus">The active status.</param> /// <param name="inProcess">The in process.</param> /// <param name="storeID">The store ID.</param> /// <param name="hasBeenIssuedTo">if set to <c>true</c> [has been issued to].</param> /// <returns></returns> public static Institution LoadReceivingUnitByFilter(int woredaID, int zoneID, int ruType, int ownershipType, int activeStatus, Boolean inProcess,int storeID,bool hasBeenIssuedTo) { var query = HCMIS.Repository.Queries.Institution.SelectLoadReceivingUnitByFilterByName(woredaID, zoneID, ruType, ownershipType, activeStatus, hasBeenIssuedTo, inProcess, storeID); BLL.Institution ru = new Institution(); ru.LoadFromRawSql(query); return ru; }
/// <summary> /// Loads the hubs. /// </summary> /// <returns></returns> public static DataView LoadHubs() { // remember Hub is RUType 8 var filterQuery = HCMIS.Repository.Queries.Institution.SelectLoadHubs(InstitutionType.Constants.HUB); BLL.Institution ru = new Institution(); ru.LoadFromRawSql(filterQuery); return ru.DefaultView; }
/// <summary> /// Gets receiving units for IssuDetail by Account report. /// </summary> /// public static DataTable GetDistinctInstitutionForIssueDetail() { var query = HCMIS.Repository.Queries.Institution.SelectGetDistinctInstitutionForIssueDetail(); Institution institution = new Institution(); institution.LoadFromRawSql(query); return institution.DataTable; }
/// <summary> /// Gets the resupply per unit. /// </summary> /// <param name="recievingUnitID">The recieving unit ID.</param> /// <returns></returns> public static DataTable GetResupplyPerUnit(int recievingUnitID) { var query = HCMIS.Repository.Queries.Institution.SelectGetResupplyPerUnit(recievingUnitID); Institution institution = new Institution(); institution.LoadFromRawSql(query); return institution.DataTable; }
/// <summary> /// Gets all receiving units. /// </summary> /// <returns></returns> public static Institution GetAllReceivingUnits() { Institution rec = new Institution(); var query = HCMIS.Repository.Queries.Institution.SelectLoadAll(); rec.LoadFromRawSql(query); return rec; }
/// <summary> /// Gets the other ID. /// </summary> /// <returns></returns> public static int getOtherID() { var filterQuery = HCMIS.Repository.Queries.Institution.SelectgetOtherID(); BLL.Institution ru = new Institution(); ru.LoadFromRawSql(filterQuery); return ru.ID; }