/// <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; }