/// <summary>
 /// there is diffrent reqtypeID across hubs
 /// so lets use the names as an identify
 /// </summary>
 /// <param name="requisitionTypeName"></param>
 /// <returns></returns>
 private int GetRealValueForRequisitionTypeByName(string requisitionTypeName)
 {
     int realReqTypeID = -1;
     BLL.RequisitionType requisitionType = new BLL.RequisitionType();
     requisitionType.LoadAll();
     DataTable _requisitionTypes = requisitionType.DefaultView.Table;
     DataRow[] dataRows = _requisitionTypes.Select(string.Format(@"Name = '{0}'", requisitionTypeName));
        if(dataRows.Any())
        {
       realReqTypeID = Convert.ToInt32(dataRows[0]["RequisitionTypeID"]);
        }
        return realReqTypeID;
 }
 //fake one , local one not same accross hubs
 /// <summary>
 /// Get fake or Local enum RequisitionType By real reqTypeID
 /// </summary>
 /// <param name="reqTypeID"></param>
 /// <returns></returns>
 private RequisitionType GetfakeLocalenumRequisitionTypeByrealTypeID(int reqTypeID)
 {
     string fakeReqTypeName;
     RequisitionType localRequisitionType = 0;
     BLL.RequisitionType requisitionType = new BLL.RequisitionType();
     requisitionType.LoadAll();
     DataTable _requisitionTypes = requisitionType.DefaultView.Table;
     DataRow[] dataRows = _requisitionTypes.Select(string.Format(@"RequisitionTypeID ={0}", reqTypeID));
     if (dataRows.Any())
     {
         fakeReqTypeName = Convert.ToString(dataRows[0]["Name"]);
         localRequisitionType = (RequisitionType)Enum.GetValues(typeof(RequisitionType)).Cast<RequisitionType>()
             .Select(e => new { Value = (int)e, Description = e.ToString() })
             .ToList().Where(n => n.Description == fakeReqTypeName).Select(v => v.Value).FirstOrDefault();
     }
     return localRequisitionType;
 }