public void Remove(UnknownObject unknown) { try { CheckTransaction(); new UnknownDataService(Transaction).Remove(unknown); if (IsOwner) { Transaction.Commit(); } } catch (Exception exception1) { if (IsOwner) { Transaction.Rollback(); } Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } finally { if (IsOwner) { Connection.Close(); } } }
public void Save(UnknownObject unknown) { SqlCommand cmd = null; try { ExecuteNonQuery(out cmd, false, "Unknown_Save", CreateParameter("@unkID", SqlDbType.UniqueIdentifier, unknown.UnkID, ParameterDirection.InputOutput), CreateParameter("@email", SqlDbType.NVarChar, unknown.Email) ); unknown.UnkID = (Guid)cmd.Parameters["@unkID"].Value; } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } finally { if (cmd != null) { cmd.Dispose(); } cmd = null; } }
public UnknownObject GetUnknownByEmail(string email) { UnknownObject unknown = new UnknownObject(); QueryBuilder builder; try { builder = new QueryBuilder(); builder.Append(this.BaseQuery(false, 0)); builder.AppendWhereString(UnknownObject.EMAIL, email, QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST); DataSet result = this.ExecuteDataSet(builder.Query, false); if (result.Tables[0].Rows.Count > 0) { unknown = UnknownConvertor.UnknownRowToObject(result.Tables[0].Rows[0]); } else { return(null); } } catch (System.Exception exception1) { throw new Exception(MethodBase.GetCurrentMethod().Name, exception1); } return(unknown); }
public bool Remove(UnknownObject unknown) { SqlCommand cmd = null; try { ExecuteNonQuery(out cmd, false, "Unknown_DELETE", CreateParameter("@unkID", SqlDbType.UniqueIdentifier, unknown.UnkID, ParameterDirection.Input) ); return(true); } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } finally { if (cmd != null) { cmd.Dispose(); } cmd = null; } }
private void CreateEmailAddress(TaskObject task, string emailAddress) { TIS.BL.Internal.Employee blEmp = new TIS.BL.Internal.Employee(); TIS.BL.Internal.Supplier blSup = new TIS.BL.Internal.Supplier(); TIS.BL.Internal.Unknown blUnk = new TIS.BL.Internal.Unknown(); TIS.DL.Internal.Employee.EmployeeObject employee; TIS.DL.Internal.Supplier.SupplierObject supplier; TIS.DL.Internal.Unknown.UnknownObject unknown; TIS.DL.Internal.TaskPeople.TaskPeopleObject taskPeople; try { if (PROF_IT.Common.Functions.Functions.IsEmailAddress(emailAddress)) { employee = blEmp.GetEmployeeByEmail(emailAddress); if (employee != null) { taskPeople = ProcessEmployee(employee); taskPeople.Task = task; task.AssigneesEmployee.Add(taskPeople); } supplier = blSup.GetSupplierByEmail(emailAddress); if (supplier != null) { taskPeople = ProcessSupplier(supplier); taskPeople.Task = task; task.AssigneesSupplier.Add(taskPeople); } if (supplier == null & employee == null) { unknown = blUnk.GetUnknownByEmail(emailAddress); if (unknown != null) { taskPeople = ProcessUnknown(unknown); taskPeople.Task = task; task.AssigneesUnknown.Add(taskPeople); } else { //Create Unknown record unknown = new UnknownObject(); unknown.Email = emailAddress; unknown.State = PROF_IT.Common.Enumerations.ObjectState.Created; blUnk.Save(unknown); taskPeople = ProcessUnknown(unknown); taskPeople.Task = task; task.AssigneesUnknown.Add(taskPeople); } } } } catch (System.Exception exception1) { System.Exception innerException = exception1; throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException); } }
private TaskPeopleObject ProcessUnknown(UnknownObject unknown) { try { TaskPeopleObject taskPeople = new TaskPeopleObject(); taskPeople.Assignee = true; taskPeople.Reporter = false; taskPeople.Unknown = unknown; taskPeople.State = PROF_IT.Common.Enumerations.ObjectState.Created; return(taskPeople); } catch (System.Exception exception1) { System.Exception innerException = exception1; throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException); } }
private void btnOk_Click(object sender, EventArgs e) { try { if (gdvUnknown.FocusedRowHandle != DevExpress.XtraGrid.GridControl.AutoFilterRowHandle) { Unknown = (UnknownObject)gdvUnknown.GetRow(gdvUnknown.FocusedRowHandle); this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); } else { DevExpress.XtraEditors.XtraMessageBox.Show("Please select first a unknown!", "Attention", MessageBoxButtons.OK); this.DialogResult = System.Windows.Forms.DialogResult.None; } } catch (System.Exception exception1) { System.Exception thisException = exception1; Management.ShowException(thisException); } }
void IEditableObject.EndEdit() { try { if (inTxn) { _loadedTask = this.Task; _loadedEmployee = this.Employee; _loadedSupplier = this.Supplier; _loadedCustomer = this.Customer; _loadedUnknown = this.Unknown; _loadedAssignee = this.Assignee; _loadedReporter = this.Reporter; inTxn = false; } } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } }
private void gdvUnknown_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { try { if (_saveRowToDatabase == true) { if (gdvUnknown.FocusedRowHandle != DevExpress.XtraGrid.GridControl.AutoFilterRowHandle) { UnknownObject unknown = (UnknownObject)gdvUnknown.GetRow(gdvUnknown.FocusedRowHandle); TIS.BL.Internal.Unknown blUnk = new TIS.BL.Internal.Unknown(); if (unknown != null) { blUnk.Save(unknown); } } } } catch (System.Exception exception1) { System.Exception thisException = exception1; Management.ShowException(thisException); } }
private static ActiveDirectoryObject GetActiveDirectoryObject(SearchResult searchResult) { ActiveDirectoryObject activeDirectoryObject; ActiveDirectoryObjectType activeDirectoryObjectType = GetActiveDirectoryObjectType(searchResult); switch (activeDirectoryObjectType) { case ActiveDirectoryObjectType.User: activeDirectoryObject = new User(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.Contact: activeDirectoryObject = new Contact(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.Computer: activeDirectoryObject = new Computer(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.Container: activeDirectoryObject = new Container(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.Group: activeDirectoryObject = new Group(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.InetOrgPerson: activeDirectoryObject = new InetOrgPerson(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.MSMQQueueAlias: activeDirectoryObject = new MSMQQueueAlias(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.MsImaging_PSPs: activeDirectoryObject = new MsImaging_PSPs(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.OrganizationalUnit: activeDirectoryObject = new OrganizationalUnit(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.Printer: activeDirectoryObject = new Printer(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.SharedFolder: activeDirectoryObject = new SharedFolder(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.DomainController: activeDirectoryObject = new DomainController(searchResult.GetDirectoryEntry()); break; case ActiveDirectoryObjectType.PasswordSettings: activeDirectoryObject = new PasswordSettings(searchResult.GetDirectoryEntry()); break; default: activeDirectoryObject = new UnknownObject(searchResult.GetDirectoryEntry()); break; } return(activeDirectoryObject); }