public void AnalyzeDef(ref LLGapCompareResults result) { var iniReader = new IniFile(result.DefFilePath); //DEFNotAvailableTo=ORCA var defNotAvailable = iniReader.Read("DEFNotAvailableTo", "Common") ?? ""; if (defNotAvailable.Equals("ORCA", StringComparison.OrdinalIgnoreCase)) { result.IsNotAvailableForOrca = true; return; } else { result.IsNotAvailableForOrca = false; } var tcpIp = iniReader.Read("TcpIp", "Common"); if (tcpIp.Equals("10")) { result.IsOpenHouseOnlyModule = true; return; } var test = iniReader.GetSectionNames(); var test2 = iniReader.GetEntryNames("MLSRecordsEx"); result.TotalClasses++; }
public static void GetStatusInfo(LLGapCompareResults compareResult, string status, out string statusName, out string statusValue, out string lastModifyDateFieldName, out string lastModifyDateFiledValue) { statusValue = ""; var iniReader = new IniFile(compareResult.DefFilePath); lastModifyDateFieldName = iniReader.Read("ST_LastMod", "Standard_Search") ?? ""; var dateFormat = iniReader.Read("SDateFormat", "field_" + lastModifyDateFieldName) ?? ""; if (string.IsNullOrEmpty(dateFormat)) dateFormat = "MM/dd/yyyyTHH:mm:ss"; lastModifyDateFiledValue = DateTime.Now.AddYears(-10).ToString(dateFormat) + "-" + DateTime.Now.ToString(dateFormat); statusName = iniReader.Read("ST_Status", "Standard_Search") ?? ""; var statusFieldName = "field_" + statusName; var statusFormat = iniReader.Read("Format", statusFieldName) ?? ""; var sortingFormat = iniReader.Read("Format", "Sorting"); var formatFlag = GetFormatFlag(statusFormat, sortingFormat); var delimiter = GetFormatDelimiter(statusFormat); var initialValues = new List<string>(); for (var i = 1; i < 100; i++) { var val = iniReader.Read("Value" + i, statusFieldName); if (!string.IsNullOrEmpty(val)) initialValues.Add(val); else break; } if (initialValues.Count > 0) { var statusList = status.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (var item in statusList) { statusValue += GetStStatus(item, delimiter, initialValues, formatFlag) + ","; } if (statusValue.EndsWith(",")) statusValue = statusValue.Substring(0, statusValue.Length - 1); } else { statusValue = ""; } }
public void AnlyzeAccountAccessResult(ref LLGapCompareResults result) { if (!string.IsNullOrEmpty(result.TestResult)) return; if (!string.IsNullOrEmpty(result.StatusRdcAccountRequestFailed)) { result.TestResult = PsaConstants.ResultError; return; } if (!string.IsNullOrEmpty(result.StatusRdcAccountSuccess)) { if (string.IsNullOrEmpty(FindGap(result.StatusRdcAccountSuccess, result.TcsPending))) { result.TestResult = PsaConstants.AllPendingPresent; } else { result.TestResult = PsaConstants.PartialPending; } //else if (!string.IsNullOrEmpty(FindCommon(result.StatusRdcAccountSuccess, result.PendingGap))) // result.TestResult = PsaConstants.PartialPendingImprovement; //else if (string.IsNullOrEmpty(FindCommon(result.StatusRdcAccountSuccess, result.PendingGap)) && string.IsNullOrEmpty(FindGap(result.StatusRdcAccountSuccess,result.RdcPending))) // result.TestResult = PsaConstants.PartialPendingNoImprovement; //else if (!string.IsNullOrEmpty(FindGap(result.StatusRdcAccountSuccess, result.RdcPending))) // result.TestResult = PsaConstants.PartialPendingWorse; //else if (string.IsNullOrEmpty(FindCommon(result.StatusRdcAccountSuccess, result.TcsPending))) // result.TestResult = PsaConstants.NoPending; } else { result.TestResult = PsaConstants.NoPending; } }
public void WriteToLine(StreamWriter sw, LLGapCompareResults result) { var sb = new StringBuilder(); sb.Append(result.ModuleId).Append(","); sb.Append("\"").Append(result.ModuleName).Append("\","); sb.Append(result.RdcCode).Append(","); sb.Append(result.TraceName).Append(","); if (result.IsTpAccountLoginSuccess || string.IsNullOrEmpty(result.StatusRdcAccountReturnNoRecord)) sb.Append("\"").Append(result.StatusHasNoListing ?? "").Append("\","); else if (!string.IsNullOrEmpty(result.TpAccountCheckResult)) sb.Append(result.TpAccountCheckResult).Append(","); else sb.Append("Error - Authentication failed").Append(","); sb.Append("\"").Append(result.URLMappingOpp).Append("\","); sb.Append("\"").Append(result.STDFListingDetailsPageURLStatus).Append("\","); sb.Append("\"").Append(result.STDFListingDetailsPageURLCount).Append("\","); sb.Append("\"").Append(result.STDFListingOfficeURLStatus).Append("\","); sb.Append("\"").Append(result.STDFListingOfficeURLCount).Append("\","); sb.Append("\"").Append(result.STDFListingBrokerageURLStatus).Append("\","); sb.Append("\"").Append(result.STDFListingBrokerageURLCount).Append("\","); sb.Append("\"").Append(result.STDFListingFranchiseURLStatus).Append("\","); sb.Append("\"").Append(result.STDFListingFranchiseURLCount).Append("\","); sb.Append("\"").Append(result.ListingCount).Append("\","); sb.Append("\"").Append(result.AG_OfficeURLStatus).Append("\","); sb.Append("\"").Append(result.AG_OfficeURLCount).Append("\","); sb.Append("\"").Append(result.AG_BrokerageURLStatus).Append("\","); sb.Append("\"").Append(result.AG_BrokerageURLCount).Append("\","); sb.Append("\"").Append(result.AG_FranchiseURLStatus).Append("\","); sb.Append("\"").Append(result.AG_FranchiseURLCount).Append("\","); sb.Append("\"").Append(result.AgentCount).Append("\","); sb.Append("\"").Append(result.OF_WebsiteURLStatus).Append("\","); sb.Append("\"").Append(result.OF_WebsiteURLCount).Append("\","); sb.Append("\"").Append(result.OF_BrokerageURLStatus).Append("\","); sb.Append("\"").Append(result.OF_BrokerageURLCount).Append("\","); sb.Append("\"").Append(result.OF_FranchiseURLStatus).Append("\","); sb.Append("\"").Append(result.OF_FranchiseURLCount).Append("\","); sb.Append("\"").Append(result.OfficeCount).Append("\","); //sb.Append(result.PropertyClass).Append(","); //sb.Append("\"").Append(result.TcsPending).Append("\","); //sb.Append("\"").Append(result.RdcPending).Append("\","); //sb.Append("\"").Append(result.PendingGap).Append("\","); //sb.Append("\"").Append(result.TcsActive).Append("\","); //sb.Append("\"").Append(result.RdcActive).Append("\","); //sb.Append("\"").Append(result.ActiveDifNotInTcs).Append("\","); //sb.Append("\"").Append(result.ActiveDifNotInRdc).Append("\","); //sb.Append("\"").Append(result.TcsSold).Append("\","); //sb.Append("\"").Append(result.RdcSold).Append("\","); //sb.Append("\"").Append(result.SoldDifNotInTcs).Append("\","); //sb.Append("\"").Append(result.SoldDifNotInRdc).Append("\","); //sb.Append("\"").Append(result.TcsOffMarket).Append("\","); //sb.Append("\"").Append(result.RdcOffMarket).Append("\","); //sb.Append("\"").Append(result.OffMarketDifNotInTcs).Append("\","); //sb.Append("\"").Append(result.OffMarketDifNotInRdc).Append("\","); //sb.Append("\"").Append(result.TestResult).Append("\","); //sb.Append("\"").Append(result.StatusRdcAccountSuccess).Append("\","); //sb.Append("\"").Append(result.StatusRdcAccountRequestFailed).Append("\","); //sb.Append("\"").Append(result.StatusRdcAccountReturnNoRecord ?? "").Append("\","); //sb.Append(result.ProdutionListingCount).Append(","); //sb.Append(result.QaListingCount).Append(","); // sb.Append(result.IncreaseInActiveCounts ?? "").Append(","); //sb.Append(result.RdcCurrentPendingListingCount == 0 ? "" : result.RdcCurrentPendingListingCount.ToString(CultureInfo.InvariantCulture)).Append(","); //sb.Append("\"").Append(result.TotalClasses).Append("\","); //sb.Append("\"").Append(result.TotalLatLongMapped).Append("\","); //sb.Append("\"").Append(result.LatLongClassesMapped).Append("\","); //sb.Append("\"").Append(result.LatLongClassesNotMapped).Append("\","); //sb.Append("\"").Append(result.LatLongDataExists).Append("\","); //sb.Append("\"").Append(result.CandidateDEFs).Append("\","); //sb.Append("\"").Append(result.NonCandidateDEFs).Append("\","); //sb.Append("\"").Append(result.RawDataInClasses).Append("\","); sw.WriteLine(sb.ToString()); }
public void AnalyzeDef(ref LLGapCompareResults result) { var iniReader = new IniFile(result.DefFilePath); //DEFNotAvailableTo=ORCA var defNotAvailable = iniReader.Read("DEFNotAvailableTo", "Common") ?? ""; if (defNotAvailable.Equals("ORCA", StringComparison.OrdinalIgnoreCase)) { result.IsNotAvailableForOrca = true; return; } else { result.IsNotAvailableForOrca = false; } var tcpIp = iniReader.Read("TcpIp", "Common"); if (tcpIp.Equals("10")) { result.IsOpenHouseOnlyModule = true; return; } var test = iniReader.GetSectionNames(); var test2 = iniReader.GetEntryNames("MLSRecordsEx"); //result.LatLongClassesMapped = FindLatLongDEF(iniReader.GetSectionContent("MLSRecordsEX")); if (FindLatLongDEF(iniReader.GetSectionContent("MLSRecordsEX"))) { if (result.TotalLatLongMapped == 0) { result.LatLongClassesMapped = result.PropertyClass; } else { result.LatLongClassesMapped = result.LatLongClassesMapped + "," + result.PropertyClass; } result.TotalLatLongMapped++; } else { if (result.TotalLatLongMapped == result.TotalClasses) { result.LatLongClassesNotMapped = result.PropertyClass; } else { result.LatLongClassesNotMapped = result.LatLongClassesNotMapped + "," + result.PropertyClass; } } FindURLFieldsinDEF(iniReader.GetSectionContent("MLSRecordsEX"),ref result); result.TotalClasses++; result.IsOpenHouseOnlyModule = false; result.TcsActive = iniReader.Read("Active", "Sorting") ?? ""; result.TcsPending = iniReader.Read("Pending", "Sorting") ?? ""; result.RdcActive = iniReader.Read("Active", "SortingPublicListingStatus") ?? ""; result.RdcSold = iniReader.Read("Sold", "SortingPublicListingStatus") ?? ""; result.TcsSold = iniReader.Read("Sold", "Sorting") ?? ""; result.RdcOffMarket = iniReader.Read("OffMarketOrOther", "SortingPublicListingStatus") ?? ""; result.TcsOffMarket = iniReader.Read("Expired", "Sorting") ?? ""; if (!string.IsNullOrEmpty(result.RdcActive)) { result.TcsPendingGap = FindGap(result.TcsActive + "," + result.TcsPending, result.RdcActive); result.RdcPendingGap = FindGap(result.RdcActive, result.TcsActive + "," + result.TcsPending); result.RdcPending = FindCommon(result.TcsPending, result.RdcActive); result.PendingGap = FindGap(result.RdcPending, result.TcsPending); result.ActiveDifNotInRdc = FindGap(result.RdcActive, result.TcsActive); result.ActiveDifNotInTcs = FindGap(result.TcsActive + "," + result.TcsPending, result.RdcActive); result.CurrentRdcPendingStatus = FindCommon(result.TcsPending, result.RdcActive); } else { result.RdcActive = result.TcsActive; result.TcsPendingGap = ""; result.RdcPendingGap = ""; result.PendingGap = result.TcsPending; result.RdcPending = ""; result.ActiveDifNotInRdc = ""; } if (!string.IsNullOrEmpty(result.RdcSold)) { result.SoldDifNotInTcs = FindGap(result.TcsSold, result.RdcSold); result.SoldDifNotInRdc = FindGap(result.RdcSold, result.TcsSold); } else { result.SoldDifNotInRdc = ""; result.SoldDifNotInTcs = ""; } if (!string.IsNullOrEmpty(result.RdcOffMarket)) { result.OffMarketDifNotInTcs = FindGap(result.TcsOffMarket + "," + result.TcsPending, result.RdcOffMarket); result.OffMarketDifNotInRdc = FindGap(result.RdcOffMarket, result.TcsOffMarket); } else { result.OffMarketDifNotInRdc = ""; result.OffMarketDifNotInTcs = ""; } }
public void FindURLFieldsinDEF(string MLSRecordsEx, ref LLGapCompareResults result) { string[] stringSeparators = new string[] { "\r\n" }; var RecordMapping = MLSRecordsEx.Split(stringSeparators, StringSplitOptions.None); var LDPMapped = false; var OfficeURLMapped = false; var BrokerURLMapped = false; var FranchiseURLMapped = false; var ListingSys = new List<string> { "stdflistingdetailspageurl", "stdflistingofficeurl", "stdflistingbrokerageurl", "stdflistingfranchiseurl", "ag_officeurl", "ag_brokerageurl", "ag_franchiseurl", "of_websiteurl", "of_brokerageurl", "of_franchiseurl" }; foreach (string line in RecordMapping) { if(result.IsAgent) { if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=ag_officeurl")) { result.AG_OfficeURLStatus = "Mapped"; } if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=ag_brokerageurl")) { result.AG_BrokerageURLStatus = "Mapped"; } if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=ag_franchiseurl")) { result.AG_FranchiseURLStatus = "Mapped"; } } else if(result.IsOffice) { if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=of_websiteurl")) { result.OF_WebsiteURLStatus = "Mapped"; } if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=of_brokerageurl")) { result.OF_BrokerageURLStatus = "Mapped"; } if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=of_franchiseurl")) { result.OF_FranchiseURLStatus = "Mapped"; } } else { if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=stdflistingdetailspageurl")) { LDPMapped = true; } if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=stdflistingofficeurl")) { OfficeURLMapped = true; } if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=stdflistingbrokerageurl")) { BrokerURLMapped = true; } if ((!line.StartsWith(";")) && line.ToLower().Contains("fldname=stdflistingfranchiseurl")) { FranchiseURLMapped = true; } } } if (LDPMapped) { if (result.STDFListingDetailsPageURLStatus == "Partial-Mapped") { } else { result.STDFListingDetailsPageURLStatus = "Mapped"; } } else { if (result.STDFListingDetailsPageURLStatus == "Mapped") { result.STDFListingDetailsPageURLStatus = "Partial-Mapped"; } } if (OfficeURLMapped) { if (result.STDFListingOfficeURLStatus == "Partial-Mapped") { } else { result.STDFListingOfficeURLStatus = "Mapped"; } } else { if (result.STDFListingOfficeURLStatus == "Mapped") { result.STDFListingOfficeURLStatus = "Partial-Mapped"; } } if (BrokerURLMapped) { if (result.STDFListingBrokerageURLStatus == "Partial-Mapped") { } else { result.STDFListingBrokerageURLStatus = "Mapped"; } } else { if (result.STDFListingBrokerageURLStatus == "Mapped") { result.STDFListingBrokerageURLStatus = "Partial-Mapped"; } } if (FranchiseURLMapped) { if (result.STDFListingFranchiseURLStatus == "Partial-Mapped") { } else { result.STDFListingFranchiseURLStatus = "Mapped"; } } else { if (result.STDFListingFranchiseURLStatus == "Mapped") { result.STDFListingFranchiseURLStatus = "Partial-Mapped"; } } }