public static bool UpdatedDataStoreDefinition(
DataStoreDefinition dataStoreDefinition,
Dictionary<string /*TemplateName*/, Guid /*TemplateID*/> templateIDLookup,
Dictionary<Guid /*TemplateID*/, Dictionary<string /*TermName*/, Guid /*TermID*/>> termIDLookup,
Dictionary<Guid /*TemplateID*/, Dictionary<Guid /*ComplexListID*/, Dictionary<string /*FieldName*/, Guid /*FieldID*/>>> fieldIDLookup)
{
return Data.DataStoreDefinitions.UpdateDataStoreDefinition(dataStoreDefinition.DataStoreDefinitionID, GetDataStoreDefinitionXML(dataStoreDefinition.DataStoreConfig, dataStoreDefinition.Name, dataStoreDefinition.Description, templateIDLookup, termIDLookup, fieldIDLookup), dataStoreDefinition.Description, dataStoreDefinition.Active);
}
public static bool UpdateDataStoreDefinitionOnRun(DataStoreDefinition dataStoreDefinition)
{
return Data.DataStoreDefinitions.UpdateDataStoreDefinitionOnRun(dataStoreDefinition.DataStoreDefinitionID, dataStoreDefinition.DefinitionFilePath, dataStoreDefinition.LastRunDate);
}
public static DataStoreDefinition GetDatatStoreDefinitionBySystemId(Guid SystemID)
{
ITATSystem system = ITATSystem.Get(SystemID);
DataStoreDefinition rtn = null;
DataTable dataStoreDef = Data.DataStoreDefinitions.GetDataStoreDefinitionBySystemID(SystemID);
if (dataStoreDef.Rows.Count > 0)
{
try
{
rtn = new DataStoreDefinition((Guid)dataStoreDef.Rows[0][StoreNames._C_DEFINITION_ID], system);
rtn.Name = dataStoreDef.Rows[0][StoreNames._C_DEFINITION_NAME].ToString();
rtn.Description = dataStoreDef.Rows[0][StoreNames._C_DESCRIPTION].ToString();
rtn.SystemID = (Guid)dataStoreDef.Rows[0][StoreNames._C_SYSTEM_ID];
rtn.LastRunDate = dataStoreDef.Rows[0][StoreNames._C_LASTRUNDATE].ToString().Length > 0 ? DateTime.Parse(dataStoreDef.Rows[0][Data.DataNames._C_LastRunDate].ToString()) : Convert.ToDateTime(null);
rtn.Definition = dataStoreDef.Rows[0][StoreNames._C_DEFINITION].ToString();
rtn.Active = Convert.ToBoolean(dataStoreDef.Rows[0][StoreNames._C_ACTIVE].ToString());
}
catch (Exception ex)
{
throw ex;
}
}
return rtn;
}
public static Guid AddDataStoreDefinition(DataStoreDefinition dataStoreDefinition,
Dictionary<string /*TemplateName*/, Guid /*TemplateID*/> templateIDLookup,
Dictionary<Guid /*TemplateID*/, Dictionary<string /*TermName*/, Guid /*TermID*/>> termIDLookup,
Dictionary<Guid /*TemplateID*/, Dictionary<Guid /*ComplexListID*/, Dictionary<string /*FieldName*/, Guid /*FieldID*/>>> fieldIDLookup)
{
try
{
return Data.DataStoreDefinitions.InsertDataStoreDefinition(dataStoreDefinition.Name, dataStoreDefinition.Description,
dataStoreDefinition.SystemID,
GetDataStoreDefinitionXML(dataStoreDefinition.DataStoreConfig, dataStoreDefinition.Name, dataStoreDefinition.Description, templateIDLookup, termIDLookup, fieldIDLookup), dataStoreDefinition.Active);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataStoreDefinition GetDataStoreDefinitionByID(
Guid dataStoreDefinitionID,
ITATSystem system,
Dictionary<Guid, Dictionary<Guid, string>> termNameLookup,
Dictionary<Guid /*TemplateID*/, Dictionary<Guid /*ComplexListID*/, Dictionary<Guid /*FieldID*/, string /*FieldName*/>>> fieldNameLookup,
bool testTermName)
{
DataStoreDefinition rtn = null;
DataTable dataStoreDef = Data.DataStoreDefinitions.GetDataStoreDefinitionsByDefinitionID(dataStoreDefinitionID);
if (dataStoreDef.Rows.Count > 0)
{
try
{
rtn = new DataStoreDefinition((Guid)dataStoreDef.Rows[0][StoreNames._C_DEFINITION_ID], system);
rtn.Name = dataStoreDef.Rows[0][StoreNames._C_DEFINITION_NAME].ToString();
if (dataStoreDef.Rows[0][StoreNames._C_DESCRIPTION] == DBNull.Value)
rtn.Description = string.Empty;
else
rtn.Description = dataStoreDef.Rows[0][StoreNames._C_DESCRIPTION].ToString();
rtn.SystemID = (Guid)dataStoreDef.Rows[0][StoreNames._C_SYSTEM_ID];
if (dataStoreDef.Rows[0][StoreNames._C_LASTRUNDATE] == DBNull.Value)
rtn.LastRunDate = null;
else
rtn.LastRunDate = DateTime.Parse(dataStoreDef.Rows[0][StoreNames._C_LASTRUNDATE].ToString());
rtn.Definition = dataStoreDef.Rows[0][StoreNames._C_DEFINITION].ToString();
rtn.Active = Convert.ToBoolean(dataStoreDef.Rows[0][StoreNames._C_ACTIVE].ToString());
rtn.DataStoreConfig = new DataStoreConfig(dataStoreDef.Rows[0][StoreNames._C_DEFINITION].ToString(), rtn.SystemID, termNameLookup, fieldNameLookup,testTermName);
if (dataStoreDef.Rows[0][StoreNames._C_DEFINITIONFILEPATH] == DBNull.Value)
rtn.DefinitionFilePath = string.Empty;
else
rtn.DefinitionFilePath = dataStoreDef.Rows[0][StoreNames._C_DEFINITIONFILEPATH].ToString();
}
catch (Exception ex)
{
throw ex;
}
}
return rtn;
}
protected void btnPromote_Click(object sender, EventArgs e)
{
UpdateTermSize();
Page.Validate(VALIDATION_GROUP);
string emailvalidationerror;
bool aliasvalidation = CheckSelectedTermsHasAlias();
bool emailvalidation = CheckErrorLogEmailList(out emailvalidationerror);
string dupAliasError;
bool duplicateAliasValidation = CheckAlias(out dupAliasError);
Guid dataStoreDefinitionID = new Guid(Request.QueryString[Common.Names._QS_DEFINITION_ID].ToString());
Dictionary<string /*TemplateName*/, Guid /*TemplateID*/> templateIDLookup = DataStoreConfig.GetActiveSearchOnlyTemplateListByName(_itatSystem.ID);
Dictionary<Guid /*TemplateID*/, Dictionary<string /*TermName*/, Guid /*TermID*/>> termIDLookup = null;
Dictionary<Guid /*TemplateID*/, Dictionary<Guid /*ComplexListID*/, Dictionary<string /*FieldName*/, Guid /*FieldID*/>>> fieldIDLookup = null;
SystemStore.GetTermAndFieldIDLookup(_itatSystem.ID, ref termIDLookup, ref fieldIDLookup);
bool pathValidation = CheckPath(txtPath.Text);
if (Page.IsValid && aliasvalidation && emailvalidation && duplicateAliasValidation && pathValidation)
{
DataStoreDefinition dataStoreDef = new DataStoreDefinition(_itatSystem);
dataStoreDef.SystemID = _itatSystem.ID;
dataStoreDef.DataStoreDefinitionID = dataStoreDefinitionID;
dataStoreDef.Active = radActiveYes.Checked ? true : false;
dataStoreDef.Description = txtDescription.Text;
dataStoreDef.DataStoreConfig.DefaultDateFormat = ddlDefaultDateFormat.SelectedValue.ToString();
dataStoreDef.DataStoreConfig.LoadType = radTypeDelta.Checked ? LoadType.Delta : LoadType.Full;
int deltadays;
int.TryParse(txtDeltaDays.Text, out deltadays);
dataStoreDef.DataStoreConfig.DeltaDays = deltadays;
dataStoreDef.DataStoreConfig.SearchCriteria = GetSearchCriteria("MySearchControl");
dataStoreDef.DataStoreConfig.PrimaryFacility = Extension.Concatenate<int>(dataStoreDef.DataStoreConfig.SearchCriteria.FacilityIds, PRIMARY_FACILITY_DELIMITER);
dataStoreDef.DataStoreConfig.Path = txtPath.Text;
foreach (ListItem li in chklstStatus.Items)
{
if (li.Selected)
{
dataStoreDef.DataStoreConfig.SearchCriteria.Statuses.Add(li.Text);
}
}
foreach (ListItem li in lstSelectedTemplates.Items)
{
dataStoreDef.DataStoreConfig.Templates.Add(new Guid(li.Value), li.Text);
}
foreach (DataStoreField dsf in SelectedTerms)
{
dataStoreDef.DataStoreConfig.Terms.Add(dsf);
}
dataStoreDef.DataStoreConfig.ErrorLogRecepientEmail = txtEmail.Text;
try
{
DataStoreDefinition.UpdatedDataStoreDefinition(dataStoreDef, templateIDLookup, termIDLookup, fieldIDLookup);
Response.Redirect(string.Format("~/Admin/DataStoreDefinitionList.aspx?System={0}", dataStoreDef.SystemID));
}
catch (Exception ex)
{
RegisterAlert(string.Format("UpdatedDataStoreDefinition call failed: {0}", ex.Message));
}
}
else
{
string errorMsg = "";
foreach (IValidator iv in Page.Validators)
{
if (!iv.IsValid)
{
errorMsg = errorMsg + iv.ErrorMessage + "\\n";
}
}
if (!emailvalidation)
{
errorMsg = errorMsg + emailvalidationerror + "\\n";
}
if (!pathValidation)
{
errorMsg = errorMsg + "Path you have specified is not a valid Path." + "\\n";
}
if (!duplicateAliasValidation)
{
errorMsg = errorMsg + dupAliasError;
}
if (errorMsg.Length > 0)
RegisterAlert(errorMsg);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.QueryString[Common.Names._QS_DEFINITION_ID].ToString() != string.Empty)
{
try
{
Dictionary<Guid, Dictionary<Guid, string>> termNameLookup = null;
Dictionary<Guid /*TemplateID*/, Dictionary<Guid /*ComplexListID*/, Dictionary<Guid /*FieldID*/, string /*FieldName*/>>> fieldNameLookup = null;
SystemStore.GetTermAndFieldNameLookup(_itatSystem.ID, ref termNameLookup, ref fieldNameLookup);
_dataStoreDefinition = Business.DataStoreDefinition.GetDataStoreDefinitionByID(new Guid(Request.QueryString[Common.Names._QS_DEFINITION_ID].ToString()), _itatSystem, termNameLookup, fieldNameLookup, false);
}
catch (Exception ex)
{
RegisterAlert(string.Format("Error: {0}",ex.Message));
}
}
if (_dataStoreDefinition == null)
{
RegisterAlert("Data Store Definition does not exists");
}
else
{
DisplayTerm1 = true;
DisplayTerm2 = true;
DisplayTerm3 = false;
DisplayTerm4 = true;
DisplayTerm5 = true;
DisplayTerm6 = false;
DisplayTerm7 = false;
searchControl = LoadControl("~\\Controls\\SearchControl.ascx", base._itatSystem, DisplayTerm1, DisplayTerm2, DisplayTerm3, DisplayTerm4, DisplayTerm5, DisplayTerm6,DisplayTerm7, _dataStoreDefinition.DataStoreConfig.SearchCriteria);
searchControl.ID = "MySearchControl";
apnlCriteria.Controls.Add(searchControl);
_itatsystem = Business.ITATSystem.Get(_dataStoreDefinition.SystemID);
LoadStatusList();
lblSystemName.Text = Business.ITATSystem.Get(_dataStoreDefinition.SystemID).Name;
lblDefinitionName.Text = _dataStoreDefinition.Name;
txtDescription.Text = _dataStoreDefinition.Description;
ddlDefaultDateFormat.DataSource = DataStoreDefinition.GetDateFormatList();
ddlDefaultDateFormat.DataBind();
ddlDefaultDateFormat.SelectedIndex = ddlDefaultDateFormat.Items.IndexOf(new ListItem(_dataStoreDefinition.DataStoreConfig.DefaultDateFormat));
LoadTemplateList(_dataStoreDefinition.SystemID);
string errSelectedTemplates = "";
foreach (KeyValuePair<Guid, string> template in _dataStoreDefinition.DataStoreConfig.Templates)
{
if (!lstTemplates.Items.Contains(new ListItem(template.Value, template.Key.ToString())))
errSelectedTemplates = errSelectedTemplates + string.Format("- {0} \\n", template.Value.ToString());
else
{
lstTemplates.Items.Remove(new ListItem(template.Value, template.Key.ToString()));
lstSelectedTemplates.Items.Add(new ListItem(template.Value, template.Key.ToString()));
}
}
if (errSelectedTemplates.Length > 0)
RegisterAlert("Following selected Template(s) are no longer Active \\n" + errSelectedTemplates);
SelectedTerms = _dataStoreDefinition.DataStoreConfig.Terms;
LoadTermList();
SortlistItems(lstTemplates);
MoveTerm(SelectedTerms);
if (_dataStoreDefinition.Active)
radActiveYes.Checked = true;
else
radActiveNo.Checked = true;
foreach (ListItem li in chklstStatus.Items)
{
if (_dataStoreDefinition.DataStoreConfig.SearchCriteria.Statuses.IndexOf(li.Text) > -1)
li.Selected = true;
else
li.Selected = false;
}
foreach (string status in _dataStoreDefinition.DataStoreConfig.SearchCriteria.Statuses)
{
chklstStatus.Items.FindByText(status).Selected = true;
}
radTypeDelta.Checked = _dataStoreDefinition.DataStoreConfig.LoadType == LoadType.Delta;
txtDeltaDays.Text = _dataStoreDefinition.DataStoreConfig.DeltaDays.ToString();
txtPath.Text = _dataStoreDefinition.DataStoreConfig.Path;
txtEmail.Text = _dataStoreDefinition.DataStoreConfig.ErrorLogRecepientEmail;
}
btnRemoveTerm.OnClientClick = string.Format("return confirm('All the selected Terms will be removed from the list.');");
btnRemoveTemplate.OnClientClick = string.Format("return confirm('All the selected Terms from the selected Templates also removed by removing Templates.');");
}
}
