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);
}
