private void LoadDd()
{
DataTable dt = SharepointXlsHelper.ReadStandardFieldFromExcel();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
StandardFieldFromDD sf = new StandardFieldFromDD();
DataRow row = dt.Rows[i];
sf.FieldName = CommonUtilities.GetStringFormRow(row, "Field name");
sf.Required = CommonUtilities.GetStringFormRow(row, "Required");
sf.XmlNameResult = CommonUtilities.GetStringFormRow(row, "XML name - Results");
sf.DefNameResult = CommonUtilities.GetStringFormRow(row, "DEF Name - Results");
sf.FieldType = CommonUtilities.GetStringFormRow(row, "Result validation data type");
sf.DisplayName = CommonUtilities.GetStringFormRow(row, "Default Display name");
sf.AttributeExposure = CommonUtilities.GetStringFormRow(row, "Default Attribute Exposure");
sf.DisplayRule = CommonUtilities.GetStringFormRow(row, "Default Display Rule");
sf.Category = CommonUtilities.GetStringFormRow(row, "Default Category").Trim('\n'); //temporary fix for 198653, when DD goes to database, the issue will go.
sf.Comments = CommonUtilities.GetStringFormRow(row, "Description and Mapping Comments");
sf.Automap = CommonUtilities.GetStringFormRow(row, "Automap");
sf.LogicalOrder = CommonUtilities.GetStringFormRow(row, "Logical Sort");
sf.PromoteToBullets = CommonUtilities.GetStringFormRow(row, "Promote to bullets"); //Promote to bullets
StandardFieldCollection.Add(sf);
}
}
}
private void GenerateSearchFields()
{
try
{
var di =
new DirectoryInfo(Path.Combine(Properties.Settings.Default.TFSLocalFolder, ModuleIDTextBox.Text));
SharepointXlsHelper.RefreshDataDictionary();
var metaData = new Model.Metadata(Path.Combine(di.FullName, "metadata.xml"));
HashSet <string> mlsClassList = metaData.GetMlsMetadataClassList("Property");
if (mlsClassList.Count == 0)
{
mlsClassList = metaData.GetMlsMetadataClassList("PropertyResource");
}
foreach (var fi in di.GetFiles())
{
if (fi.Name.ToLower().EndsWith(".sql"))
{
if (fi.Name.ToLower().EndsWith("ag.sql"))
{
bool agentClassFound = false;
var classList = metaData.GetMlsMetadataClassList("ActiveAgent");
if (classList.Any())
{
GenerateDefFile(fi.FullName, metaData, TRPTxtSelectFileTextBox.Text, "ActiveAgent");
agentClassFound = true;
}
classList = metaData.GetMlsMetadataClassList("Agent");
if (classList.Any())
{
var agentFilePath = fi.FullName.ToLower().Replace("ag.sql", "Agentag.sql");
File.Copy(fi.FullName, agentFilePath);
GenerateDefFile(agentFilePath, metaData, TRPTxtSelectFileTextBox.Text, "Agent");
agentClassFound = true;
}
if (!agentClassFound)
{
classList = metaData.GetMlsMetadataClassList("User");
if (classList.Any())
{
GenerateDefFile(fi.FullName, metaData, TRPTxtSelectFileTextBox.Text, "User");
}
}
}
else if (fi.Name.ToLower().EndsWith("of.sql"))
{
var classList = metaData.GetMlsMetadataClassList("ActiveOffice");
if (classList.Any())
{
GenerateDefFile(fi.FullName, metaData, TRPTxtSelectFileTextBox.Text, "ActiveOffice");
}
classList = metaData.GetMlsMetadataClassList("Office");
if (classList.Any())
{
var filePath = fi.FullName.ToLower().Replace("of.sql", "Officeof.sql");
File.Copy(fi.FullName, filePath);
GenerateDefFile(filePath, metaData, TRPTxtSelectFileTextBox.Text, "Office");
}
}
else if (!fi.Name.ToLower().EndsWith("oh.sql"))
{
GenerateDefFile(fi.FullName, metaData, TRPTxtSelectFileTextBox.Text, "");
}
}
}
if (mlsClassList.Count > 0)
{
string filePath = "";
foreach (var item in mlsClassList)
{
foreach (var fi in di.GetFiles().Where(fi => fi.Name.ToLower().EndsWith(".def")))
{
filePath = fi.FullName;
break;
}
}
foreach (var item in mlsClassList)
{
string visibleName = metaData.GetMlsMetadataClassVisibleName(item);
string newFilePath = SetDefName(filePath, visibleName);
GenerateDefFile(newFilePath, metaData, TRPTxtSelectFileTextBox.Text, item);
}
File.Delete(filePath);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace + ex.Source);
_stopProgressDialog = true;
}
}
