public void Save(MaterialRevisionObject materialRevision)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "MaterialRevision_SAVE",
CreateParameter("@matrevID", SqlDbType.UniqueIdentifier, materialRevision.MatRevID, ParameterDirection.InputOutput),
CreateParameter("@maintID", SqlDbType.UniqueIdentifier, materialRevision.Maintenance == null ? Guid.Empty : materialRevision.Maintenance.MaintID),
CreateParameter("@Revision", SqlDbType.VarChar, materialRevision.Revision),
CreateParameter("@Answer", SqlDbType.VarChar, materialRevision.Answer),
CreateParameter("@Category", SqlDbType.VarChar, materialRevision.Category)
);
materialRevision.MatRevID = (Guid)cmd.Parameters["@matrevID"].Value;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
cmd = null;
}
}
public bool Remove(MaterialRevisionObject materialRevision)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "MaterialRevision_DELETE",
CreateParameter("@matrevID", SqlDbType.UniqueIdentifier, materialRevision.MatRevID, 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;
}
}
public void Remove(MaterialRevisionObject materialRevision)
{
try
{
CheckTransaction();
new MaterialRevisionDataService(Transaction).Remove(materialRevision);
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 CreateNewMaterialRevisions()
{
try
{
MaterialRevisionObjectCollection materialRevisions = new MaterialRevisionObjectCollection();
RevisionObjectCollection revisions;
if (Material.MaterialCategory != null)
{
revisions = new BL.Internal.Revision().GetByMaterialCategory(Material.MaterialCategory);
foreach (RevisionObject revision in revisions)
{
MaterialRevisionObject materialRevision = new MaterialRevisionObject();
materialRevision.Revision = revision.Revision;
materialRevision.Maintenance = MaintenanceMember;
materialRevision.Category = revision.MaterialCategory.Category;
materialRevision.State = PROF_IT.Common.Enumerations.ObjectState.Created;
materialRevisions.Add(materialRevision);
}
}
if (Material.MaterialType != null)
{
revisions = new BL.Internal.Revision().GetByMaterialType(Material.MaterialType);
foreach (RevisionObject revision in revisions)
{
MaterialRevisionObject materialRevision = new MaterialRevisionObject();
materialRevision.Revision = revision.Revision;
materialRevision.Maintenance = MaintenanceMember;
materialRevision.Category = revision.MaterialType.Type;
materialRevision.State = PROF_IT.Common.Enumerations.ObjectState.Created;
materialRevisions.Add(materialRevision);
}
}
if (Material.MaterialSubType != null)
{
revisions = new BL.Internal.Revision().GetByMaterialSubType(Material.MaterialSubType);
foreach (RevisionObject revision in revisions)
{
MaterialRevisionObject materialRevision = new MaterialRevisionObject();
materialRevision.Revision = revision.Revision;
materialRevision.Maintenance = MaintenanceMember;
materialRevision.Category = revision.MaterialSubType.SubType;
materialRevision.State = PROF_IT.Common.Enumerations.ObjectState.Created;
materialRevisions.Add(materialRevision);
}
}
MaterialRevisions = materialRevisions;
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}