/// <summary> /// close the screen and return the selected extract as accepted record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AcceptExtract(System.Object sender, EventArgs e) { MExtractMasterRow ExtractMasterRow; FResultTable = new MExtractMasterTable(); //MExtractMasterRow SelectedRow = null; DataRow SelectedRow = null; if (AllowMultipleSelect) { // multiple rows may have been selected: find all the ones where first column is ticked foreach (DataRow Row in FDataTable.Rows) { if (Convert.ToBoolean(Row[FCheckedColumnName]) == true) { ExtractMasterRow = FResultTable.NewRowTyped(); ExtractMasterRow.ExtractId = (int)Row[MExtractMasterTable.GetExtractIdDBName()]; ExtractMasterRow.ExtractName = Row[MExtractMasterTable.GetExtractNameDBName()].ToString(); ExtractMasterRow.ExtractDesc = Row[MExtractMasterTable.GetExtractDescDBName()].ToString(); ExtractMasterRow.KeyCount = (int)Row[MExtractMasterTable.GetKeyCountDBName()]; ExtractMasterRow.CreatedBy = Row[MExtractMasterTable.GetCreatedByDBName()].ToString(); ExtractMasterRow.DateCreated = (DateTime)Row[MExtractMasterTable.GetDateCreatedDBName()]; FResultTable.Rows.Add(ExtractMasterRow); } } } else { // just one row can be selected DataRowView[] SelectedGridRow = clbDetails.SelectedDataRowsAsDataRowView; if (SelectedGridRow.Length >= 1) { SelectedRow = SelectedGridRow[0].Row; ExtractMasterRow = FResultTable.NewRowTyped(); ExtractMasterRow.ExtractId = (int)SelectedRow[MExtractMasterTable.GetExtractIdDBName()]; ExtractMasterRow.ExtractName = SelectedRow[MExtractMasterTable.GetExtractNameDBName()].ToString(); ExtractMasterRow.ExtractDesc = SelectedRow[MExtractMasterTable.GetExtractDescDBName()].ToString(); ExtractMasterRow.KeyCount = (int)SelectedRow[MExtractMasterTable.GetKeyCountDBName()]; ExtractMasterRow.CreatedBy = SelectedRow[MExtractMasterTable.GetCreatedByDBName()].ToString(); ExtractMasterRow.DateCreated = (DateTime)SelectedRow[MExtractMasterTable.GetDateCreatedDBName()]; FResultTable.Rows.Add(ExtractMasterRow); } } Close(); }
/// <summary> /// Open Dialog to find extracts to be added list /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AddExtractToList(System.Object sender, EventArgs e) { TFrmExtractFindDialog ExtractFindDialog = new TFrmExtractFindDialog(this.ParentForm); MExtractMasterTable ExtractMasterTable = new MExtractMasterTable(); MExtractMasterRow NewRow; // let the user select base extract ExtractFindDialog.AllowMultipleSelect = true; ExtractFindDialog.ShowDialog(true); // get data for selected base extract ExtractFindDialog.GetResult(ref ExtractMasterTable); ExtractFindDialog.Dispose(); // only continue if an extract was selected foreach (MExtractMasterRow Row in ExtractMasterTable.Rows) { if (!FExtractMasterTable.Rows.Contains(new object[] { Row.ExtractId })) { NewRow = FExtractMasterTable.NewRowTyped(); NewRow.ExtractId = Row.ExtractId; NewRow.ExtractName = Row.ExtractName; NewRow.ExtractDesc = Row.ExtractDesc; NewRow.KeyCount = Row.KeyCount; NewRow.CreatedBy = Row.CreatedBy; NewRow.DateCreated = Row.DateCreated; FExtractMasterTable.Rows.Add(NewRow); btnRemove.Enabled = true; } } }
/// <summary> /// Called by the instantiator of this Dialog to retrieve the result of the dialog /// /// </summary> /// <param name="AExtractMasterTable"></param> /// <returns>true if at least one row was selected /// </returns> public bool GetResult(ref MExtractMasterTable AExtractMasterTable) { MExtractMasterRow NewRow; AExtractMasterTable.Clear(); if (FResultTable == null) { return(false); } foreach (MExtractMasterRow Row in FResultTable.Rows) { NewRow = AExtractMasterTable.NewRowTyped(); NewRow.ExtractId = Row.ExtractId; NewRow.ExtractName = Row.ExtractName; NewRow.ExtractDesc = Row.ExtractDesc; NewRow.KeyCount = Row.KeyCount; NewRow.CreatedBy = Row.CreatedBy; NewRow.DateCreated = Row.DateCreated; AExtractMasterTable.Rows.Add(NewRow); } return(AExtractMasterTable.Count >= 0); }
public static Boolean GetExtractDescription(String AExtractName, out String AExtractDescription) { TDBTransaction ReadTransaction; Boolean NewTransaction; Boolean ReturnValue = false; AExtractDescription = "Can not retrieve description"; TLogging.LogAtLevel(9, "TPartnerServerLookups.GetExtractDescription called!"); MExtractMasterTable ExtractMasterDT = new MExtractMasterTable(); ReadTransaction = DBAccess.GDBAccessObj.GetNewOrExistingTransaction(IsolationLevel.ReadCommitted, TEnforceIsolationLevel.eilMinimum, out NewTransaction); // Load data MExtractMasterTable TemplateExtractDT = new MExtractMasterTable(); MExtractMasterRow TemplateRow = TemplateExtractDT.NewRowTyped(false); TemplateRow.ExtractName = AExtractName; try { ExtractMasterDT = MExtractMasterAccess.LoadUsingTemplate(TemplateRow, ReadTransaction); } finally { if (NewTransaction) { DBAccess.GDBAccessObj.CommitTransaction(); TLogging.LogAtLevel(7, "TPartnerServerLookups.GetExtractDescription: committed own transaction."); } } if (ExtractMasterDT.Rows.Count < 1) { ReturnValue = false; TLogging.LogAtLevel(7, "TPartnerServerLookups.TPartnerServerLookups.GetExtractDescription: m_extract_master DB Table is empty"); } else { MExtractMasterRow ExtractRow = ExtractMasterDT.Rows[0] as MExtractMasterRow; if (ExtractRow != null) { AExtractDescription = ExtractRow.ExtractDesc; ReturnValue = true; } } return(ReturnValue); }
/// <summary> /// Pre-select an extract to be displayed in the grid. /// </summary> /// <param name="ARow"></param> public void PreSelectExtract(MExtractMasterRow ARow) { if (FMode == TMode.ecisSubtractMode) { txtBaseExtract.Text = ARow.ExtractName; } else { MExtractMasterRow NewRow = FExtractMasterTable.NewRowTyped(); NewRow.ExtractId = ARow.ExtractId; NewRow.ExtractName = ARow.ExtractName; NewRow.ExtractDesc = ARow.ExtractDesc; NewRow.KeyCount = ARow.KeyCount; NewRow.CreatedBy = ARow.CreatedBy; NewRow.DateCreated = ARow.DateCreated; FExtractMasterTable.Rows.Add(NewRow); grdExtracts.SelectRowInGrid(1); btnRemove.Enabled = true; } }
/// <summary> /// Creates a new extract with the given extract name and extract description in the /// m_extract_master data table. The Extract Id and the Extract Name must both be /// unique in the Petra Database. /// </summary> /// <param name="AExtractName">Name of the Extract to be created.</param> /// <param name="AExtractDescription">Description of the Extract to be created.</param> /// <param name="ANewExtractId">Extract Id of the created Extract, or -1 if the /// creation of the Extract was not successful.</param> /// <param name="AExtractAlreadyExists">True if there is already an extract with /// the given name, otherwise false.</param> /// <returns>True if the new Extract was created, otherwise false.</returns> public static bool CreateNewExtract(String AExtractName, String AExtractDescription, out Int32 ANewExtractId, out Boolean AExtractAlreadyExists) { TDBTransaction Transaction = null; Boolean ReturnValue = false; bool SubmissionOK = false; MExtractMasterTable NewExtractMasterDT = null; MExtractMasterRow TemplateRow = null; Boolean ExtractAlreadyExists = false; Int32 NewExtractId = -1; TLogging.LogAtLevel(9, "CreateNewExtract called!"); DBAccess.GDBAccessObj.GetNewOrExistingAutoTransaction(IsolationLevel.Serializable, ref Transaction, ref SubmissionOK, delegate { // Check if there is already an extract with the extract name if (!CheckExtractExists(AExtractName)) { // The extract name is unique. So create the new extract... NewExtractMasterDT = new MExtractMasterTable(); TemplateRow = (MExtractMasterRow)NewExtractMasterDT.NewRowTyped(true); TemplateRow.ExtractName = AExtractName; TemplateRow.ExtractDesc = AExtractDescription; TemplateRow.ExtractId = -1; // initialize id negative so sequence can be used NewExtractMasterDT.Rows.Add(TemplateRow); MExtractMasterAccess.SubmitChanges(NewExtractMasterDT, Transaction); // Get the Extract Id TemplateRow = (MExtractMasterRow)NewExtractMasterDT.Rows[0]; NewExtractId = TemplateRow.ExtractId; SubmissionOK = true; ReturnValue = true; } else { ExtractAlreadyExists = true; ReturnValue = false; } if (ReturnValue) { SubmissionOK = true; } else { SubmissionOK = false; } }); // Get the Extract Id // if (NewExtractMasterDT != null) // { // TemplateRow = (MExtractMasterRow)NewExtractMasterDT.Rows[0]; // ANewExtractId = TemplateRow.ExtractId; // } ANewExtractId = NewExtractId; AExtractAlreadyExists = ExtractAlreadyExists; return ReturnValue; }
public static Boolean GetExtractDescription(String AExtractName, out String AExtractDescription) { TDBTransaction ReadTransaction; Boolean NewTransaction; Boolean ReturnValue = false; AExtractDescription = "Can not retrieve description"; TLogging.LogAtLevel(9, "TPartnerServerLookups.GetExtractDescription called!"); MExtractMasterTable ExtractMasterDT = new MExtractMasterTable(); ReadTransaction = DBAccess.GDBAccessObj.GetNewOrExistingTransaction(IsolationLevel.ReadCommitted, TEnforceIsolationLevel.eilMinimum, out NewTransaction); // Load data MExtractMasterTable TemplateExtractDT = new MExtractMasterTable(); MExtractMasterRow TemplateRow = TemplateExtractDT.NewRowTyped(false); TemplateRow.ExtractName = AExtractName; try { ExtractMasterDT = MExtractMasterAccess.LoadUsingTemplate(TemplateRow, ReadTransaction); } finally { if (NewTransaction) { DBAccess.GDBAccessObj.CommitTransaction(); TLogging.LogAtLevel(7, "TPartnerServerLookups.GetExtractDescription: committed own transaction."); } } if (ExtractMasterDT.Rows.Count < 1) { ReturnValue = false; TLogging.LogAtLevel(7, "TPartnerServerLookups.TPartnerServerLookups.GetExtractDescription: m_extract_master DB Table is empty"); } else { MExtractMasterRow ExtractRow = ExtractMasterDT.Rows[0] as MExtractMasterRow; if (ExtractRow != null) { AExtractDescription = ExtractRow.ExtractDesc; ReturnValue = true; } } return ReturnValue; }
/// <summary> /// Creates a new extract with the given extract name and extract description in the /// m_extract_master data table. The Extract Id and the Extract Name must both be /// unique in the Petra Database. /// </summary> /// <param name="AExtractName">Name of the Extract to be created.</param> /// <param name="AExtractDescription">Description of the Extract to be created.</param> /// <param name="ANewExtractId">Extract Id of the created Extract, or -1 if the /// creation of the Extract was not successful.</param> /// <param name="AExtractAlreadyExists">True if there is already an extract with /// the given name, otherwise false.</param> /// <returns>True if the new Extract was created, otherwise false.</returns> public static bool CreateNewExtract(String AExtractName, String AExtractDescription, out Int32 ANewExtractId, out Boolean AExtractAlreadyExists) { TDBTransaction Transaction = null; Boolean ReturnValue = false; bool SubmissionOK = false; MExtractMasterTable NewExtractMasterDT = null; MExtractMasterRow TemplateRow = null; Boolean ExtractAlreadyExists = false; Int32 NewExtractId = -1; TLogging.LogAtLevel(9, "CreateNewExtract called!"); DBAccess.GDBAccessObj.GetNewOrExistingAutoTransaction(IsolationLevel.Serializable, ref Transaction, ref SubmissionOK, delegate { // Check if there is already an extract with the extract name if (!CheckExtractExists(AExtractName)) { // The extract name is unique. So create the new extract... NewExtractMasterDT = new MExtractMasterTable(); TemplateRow = (MExtractMasterRow)NewExtractMasterDT.NewRowTyped(true); TemplateRow.ExtractName = AExtractName; TemplateRow.ExtractDesc = AExtractDescription; TemplateRow.ExtractId = -1; // initialize id negative so sequence can be used NewExtractMasterDT.Rows.Add(TemplateRow); MExtractMasterAccess.SubmitChanges(NewExtractMasterDT, Transaction); // Get the Extract Id TemplateRow = (MExtractMasterRow)NewExtractMasterDT.Rows[0]; NewExtractId = TemplateRow.ExtractId; SubmissionOK = true; ReturnValue = true; } else { ExtractAlreadyExists = true; ReturnValue = false; } if (ReturnValue) { SubmissionOK = true; } else { SubmissionOK = false; } }); // Get the Extract Id // if (NewExtractMasterDT != null) // { // TemplateRow = (MExtractMasterRow)NewExtractMasterDT.Rows[0]; // ANewExtractId = TemplateRow.ExtractId; // } ANewExtractId = NewExtractId; AExtractAlreadyExists = ExtractAlreadyExists; return(ReturnValue); }
/// <summary> /// Creates a new extract with the given extract name and extract description in the /// m_extract_master data table. The Extract Id and the Extract Name must both be /// unique in the Petra Database. /// </summary> /// <param name="AExtractName">Name of the Extract to be created.</param> /// <param name="AExtractDescription">Description of the Extract to be created.</param> /// <param name="ANewExtractId">Extract Id of the created Extract, or -1 if the /// creation of the Extract was not successful.</param> /// <param name="AExtractAlreadyExists">True if there is already an extract with /// the given name, otherwise false.</param> /// <returns>True if the new Extract was created, otherwise false.</returns> public static bool CreateNewExtract(String AExtractName, String AExtractDescription, out Int32 ANewExtractId, out Boolean AExtractAlreadyExists) { TDBTransaction WriteTransaction; Boolean NewTransaction; Boolean ReturnValue = false; ANewExtractId = -1; AExtractAlreadyExists = false; TLogging.LogAtLevel(9, "CreateNewExtract called!"); WriteTransaction = DBAccess.GDBAccessObj.GetNewOrExistingTransaction(IsolationLevel.Serializable, TEnforceIsolationLevel.eilMinimum, out NewTransaction); try { // Check if there is already an extract with the extract name if (!CheckExtractExists(AExtractName)) { // The extract name is unique. So create the new extract... MExtractMasterTable NewExtractMasterDT = new MExtractMasterTable(); MExtractMasterRow TemplateRow = (MExtractMasterRow)NewExtractMasterDT.NewRowTyped(true); TemplateRow.ExtractName = AExtractName; TemplateRow.ExtractDesc = AExtractDescription; TemplateRow.ExtractId = -1; // initialize id negative so sequence can be used NewExtractMasterDT.Rows.Add(TemplateRow); MExtractMasterAccess.SubmitChanges(NewExtractMasterDT, WriteTransaction); // Get the Extract Id TemplateRow = (MExtractMasterRow)NewExtractMasterDT.Rows[0]; ANewExtractId = TemplateRow.ExtractId; ReturnValue = true; } else { AExtractAlreadyExists = true; ReturnValue = false; } if (ReturnValue && NewTransaction) { DBAccess.GDBAccessObj.CommitTransaction(); } else if (NewTransaction) { DBAccess.GDBAccessObj.RollbackTransaction(); } } catch (Exception Exc) { TLogging.Log("An Exception occured during the creation of a new Extract:" + Environment.NewLine + Exc.ToString()); if (NewTransaction) { DBAccess.GDBAccessObj.RollbackTransaction(); } throw; } return(ReturnValue); }
public static Int32 GetExtractId(String AExtractName) { MExtractMasterTable TemplateTable; MExtractMasterRow TemplateRow; MExtractMasterTable ResultTable; MExtractMasterRow ResultRow; Int32 ReturnValue = -1; TDBTransaction Transaction = DBAccess.GDBAccessObj.BeginTransaction(IsolationLevel.Serializable); TemplateTable = new MExtractMasterTable(); TemplateRow = TemplateTable.NewRowTyped(false); TemplateRow.ExtractName = AExtractName; ResultTable = MExtractMasterAccess.LoadUsingTemplate(TemplateRow, null, Transaction); if (ResultTable.Count > 0) { ResultRow = (MExtractMasterRow)ResultTable.Rows[0]; ReturnValue = ResultRow.ExtractId; } DBAccess.GDBAccessObj.RollbackTransaction(); return ReturnValue; }
public static Boolean ExtractExists(String AExtractName) { MExtractMasterTable TemplateTable; MExtractMasterRow TemplateRow; Boolean ReturnValue = true; TDBTransaction Transaction = null; DBAccess.GDBAccessObj.BeginAutoReadTransaction(IsolationLevel.ReadCommitted, ref Transaction, delegate { TemplateTable = new MExtractMasterTable(); TemplateRow = TemplateTable.NewRowTyped(false); TemplateRow.ExtractName = AExtractName; if (MExtractMasterAccess.CountUsingTemplate(TemplateRow, null, Transaction) == 0) { ReturnValue = false; } }); return ReturnValue; }
/// <summary> /// Creates a new extract with the given extract name and extract description in the /// m_extract_master data table. The Extract Id and the Extract Name must both be /// unique in the Petra Database. /// </summary> /// <param name="AExtractName">Name of the Extract to be created.</param> /// <param name="AExtractDescription">Description of the Extract to be created.</param> /// <param name="ANewExtractId">Extract Id of the created Extract, or -1 if the /// creation of the Extract was not successful.</param> /// <param name="AExtractAlreadyExists">True if there is already an extract with /// the given name, otherwise false.</param> /// <returns>True if the new Extract was created, otherwise false.</returns> public static bool CreateNewExtract(String AExtractName, String AExtractDescription, out Int32 ANewExtractId, out Boolean AExtractAlreadyExists) { TDBTransaction WriteTransaction; Boolean NewTransaction; Boolean ReturnValue = false; ANewExtractId = -1; AExtractAlreadyExists = false; TLogging.LogAtLevel(9, "CreateNewExtract called!"); WriteTransaction = DBAccess.GDBAccessObj.GetNewOrExistingTransaction(IsolationLevel.Serializable, TEnforceIsolationLevel.eilMinimum, out NewTransaction); try { // Check if there is already an extract with the extract name if (!CheckExtractExists(AExtractName)) { // The extract name is unique. So create the new extract... MExtractMasterTable NewExtractMasterDT = new MExtractMasterTable(); MExtractMasterRow TemplateRow = (MExtractMasterRow)NewExtractMasterDT.NewRowTyped(true); TemplateRow.ExtractName = AExtractName; TemplateRow.ExtractDesc = AExtractDescription; TemplateRow.ExtractId = -1; // initialize id negative so sequence can be used NewExtractMasterDT.Rows.Add(TemplateRow); MExtractMasterAccess.SubmitChanges(NewExtractMasterDT, WriteTransaction); // Get the Extract Id TemplateRow = (MExtractMasterRow)NewExtractMasterDT.Rows[0]; ANewExtractId = TemplateRow.ExtractId; ReturnValue = true; } else { AExtractAlreadyExists = true; ReturnValue = false; } if (ReturnValue && NewTransaction) { DBAccess.GDBAccessObj.CommitTransaction(); } else if (NewTransaction) { DBAccess.GDBAccessObj.RollbackTransaction(); } } catch (Exception Exc) { TLogging.Log("An Exception occured during the creation of a new Extract:" + Environment.NewLine + Exc.ToString()); if (NewTransaction) { DBAccess.GDBAccessObj.RollbackTransaction(); } throw; } return ReturnValue; }
public static Boolean ExtractExists(String AExtractName) { MExtractMasterTable TemplateTable; MExtractMasterRow TemplateRow; Boolean ReturnValue = true; TDBTransaction Transaction = DBAccess.GDBAccessObj.BeginTransaction(IsolationLevel.Serializable); TemplateTable = new MExtractMasterTable(); TemplateRow = TemplateTable.NewRowTyped(false); TemplateRow.ExtractName = AExtractName; if (MExtractMasterAccess.CountUsingTemplate(TemplateRow, null, Transaction) == 0) { ReturnValue = false; } DBAccess.GDBAccessObj.CommitTransaction(); return ReturnValue; }
/// <summary> /// close the screen and return the selected extract as accepted record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AcceptExtract(System.Object sender, EventArgs e) { MExtractMasterRow ExtractMasterRow; FResultTable = new MExtractMasterTable(); //MExtractMasterRow SelectedRow = null; DataRow SelectedRow = null; if (AllowMultipleSelect) { // multiple rows may have been selected: find all the ones where first column is ticked foreach (DataRow Row in FDataTable.Rows) { if (Convert.ToBoolean(Row[FCheckedColumnName]) == true) { ExtractMasterRow = FResultTable.NewRowTyped(); ExtractMasterRow.ExtractId = (int)Row[MExtractMasterTable.GetExtractIdDBName()]; ExtractMasterRow.ExtractName = Row[MExtractMasterTable.GetExtractNameDBName()].ToString(); ExtractMasterRow.ExtractDesc = Row[MExtractMasterTable.GetExtractDescDBName()].ToString(); ExtractMasterRow.KeyCount = (int)Row[MExtractMasterTable.GetKeyCountDBName()]; ExtractMasterRow.CreatedBy = Row[MExtractMasterTable.GetCreatedByDBName()].ToString(); ExtractMasterRow.DateCreated = (DateTime)Row[MExtractMasterTable.GetDateCreatedDBName()]; FResultTable.Rows.Add(ExtractMasterRow); } } } else { // just one row can be selected DataRowView[] SelectedGridRow = clbDetails.SelectedDataRowsAsDataRowView; if (SelectedGridRow.Length >= 1) { SelectedRow = SelectedGridRow[0].Row; ExtractMasterRow = FResultTable.NewRowTyped(); ExtractMasterRow.ExtractId = (int)SelectedRow[MExtractMasterTable.GetExtractIdDBName()]; ExtractMasterRow.ExtractName = SelectedRow[MExtractMasterTable.GetExtractNameDBName()].ToString(); ExtractMasterRow.ExtractDesc = SelectedRow[MExtractMasterTable.GetExtractDescDBName()].ToString(); ExtractMasterRow.KeyCount = (int)SelectedRow[MExtractMasterTable.GetKeyCountDBName()]; ExtractMasterRow.CreatedBy = SelectedRow[MExtractMasterTable.GetCreatedByDBName()].ToString(); ExtractMasterRow.DateCreated = (DateTime)SelectedRow[MExtractMasterTable.GetDateCreatedDBName()]; FResultTable.Rows.Add(ExtractMasterRow); } } Close(); }
/// <summary> /// Called by the instantiator of this Dialog to retrieve the result of the dialog /// /// </summary> /// <param name="AExtractMasterTable"></param> /// <returns>true if at least one row was selected /// </returns> public bool GetResult(ref MExtractMasterTable AExtractMasterTable) { MExtractMasterRow NewRow; AExtractMasterTable.Clear(); if (FResultTable == null) { return false; } foreach (MExtractMasterRow Row in FResultTable.Rows) { NewRow = AExtractMasterTable.NewRowTyped(); NewRow.ExtractId = Row.ExtractId; NewRow.ExtractName = Row.ExtractName; NewRow.ExtractDesc = Row.ExtractDesc; NewRow.KeyCount = Row.KeyCount; NewRow.CreatedBy = Row.CreatedBy; NewRow.DateCreated = Row.DateCreated; AExtractMasterTable.Rows.Add(NewRow); } return AExtractMasterTable.Count >= 0; }