public void Remove(MaterialCategoryObject materialCategory)
{
try
{
CheckTransaction();
foreach (MaterialTypeObject type in materialCategory.Types)
{
foreach (MaterialSubTypeObject subType in type.SubTypes)
{
new MaterialSubType(Transaction).Remove(subType);
}
new MaterialType(Transaction).Remove(type);
}
Revision blREv = new Revision(Transaction);
blREv.RemoveAll(materialCategory.Revisions);
new MaterialCategoryDataService(Transaction).Remove(materialCategory);
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 AddChilds(MaterialCategoryObject materialCategory)
{
try
{
Revision blRev = new Revision();
MaterialType bl = new MaterialType();
materialCategory.Types = bl.GetByCategory(materialCategory);
materialCategory.Revisions = blRev.GetByMaterialCategory(materialCategory);
foreach (MaterialTypeObject materialType in materialCategory.Types)
{
materialType.SubTypes = new MaterialSubType().GetSubTypesByType(materialType);
materialType.Revisions = blRev.GetByMaterialType(materialType);
materialType.ChildsAdded = true;
foreach (MaterialSubTypeObject materialSubType in materialType.SubTypes)
{
materialSubType.Revisions = blRev.GetByMaterialSubType(materialSubType);
materialSubType.ChildsAdded = true;
}
}
materialCategory.ChildsAdded = true;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public MaterialCateogry(PROF_IT.Common.Enumerations.TypeForm typeForm, MaterialCategoryObject materialCategory)
{
try
{
InitializeComponent();
MaterialCategoryMember = materialCategory;
_typeForm = typeForm;
if (_typeForm == PROF_IT.Common.Enumerations.TypeForm.NewForm)
{
throw new NotImplementedException();
}
else
{
Initialize();
InitializePropertyFormMaterialCategory();
SetPermissions();
}
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public int Add(MaterialCategoryObject value)
{
try
{
return(List.Add(value));
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public void Remove(MaterialCategoryObject value)
{
try
{
List.Remove(value);
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
// Called by MaterialCategoryObject when it changes
internal void MaterialCategoryObjectChanged(MaterialCategoryObject MaterialCategory)
{
try
{
int index = List.IndexOf(MaterialCategory);
OnListChanged(new ListChangedEventArgs(ListChangedType.ItemChanged, index));
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
protected override void OnRemoveComplete(int index, object value)
{
try
{
MaterialCategoryObject MaterialCategory = (MaterialCategoryObject)value;
MaterialCategory.Parent = this;
OnListChanged(new ListChangedEventArgs(ListChangedType.ItemDeleted, index));
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
// Methods.
object IBindingList.AddNew()
{
try
{
MaterialCategoryObject MaterialCategory = new MaterialCategoryObject();
List.Add(MaterialCategory);
return(MaterialCategory);
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public RevisionObjectCollection GetByMaterialCategory(MaterialCategoryObject materialCategory)
{
RevisionObjectCollection revisions;
try
{
revisions = new RevisionDataService().GetByMaterialCateogry(materialCategory);
}
catch (System.Exception exception1)
{
System.Exception innerException = exception1;
throw new System.Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return revisions;
}
public RevisionObjectCollection GetByMaterialCateogry(MaterialCategoryObject materialCategory)
{
RevisionObjectCollection revisions = new RevisionObjectCollection();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false, 0));
builder.AppendWhereString(RevisionObject.MATCAT_ID, materialCategory.MatcatID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST);
builder.Append("AND " + RevisionObject.MATCAT_ID + " is not null ");
revisions = RevisionConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return revisions;
}
public MaterialTypeObjectCollection GetTypesByCategorie(MaterialCategoryObject category)
{
MaterialTypeObjectCollection materialTypes = new MaterialTypeObjectCollection();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false, 0));
builder.AppendWhereString(MaterialTypeObject.MATCAT_ID, category.MatcatID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST);
builder.Append("AND " + MaterialTypeObject.MATCAT_ID + " is not null ");
builder.AppendOrderBy(MaterialTypeObject.TYPE, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
materialTypes = MaterialTypeConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return materialTypes;
}
protected override void OnSetComplete(int index, object oldValue, object newValue)
{
try
{
if (oldValue != newValue)
{
MaterialCategoryObject oldMaterialCategory = (MaterialCategoryObject)oldValue;
MaterialCategoryObject newMaterialCategory = (MaterialCategoryObject)newValue;
oldMaterialCategory.Parent = null;
newMaterialCategory.Parent = this;
OnListChanged(new ListChangedEventArgs(ListChangedType.ItemAdded, index));
}
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public static MaterialCategoryObject MaterialCategoryRowToObject(DataRow MaterialCategory, string alias)
{
MaterialCategoryObject obj = new MaterialCategoryObject();
try
{
if (MaterialCategory != null)
{
if (RowFunctions.GetValueFromRowToGuid(MaterialCategory, MaterialCategoryObject.ConvertColumnToAlias(MaterialCategoryObject.MATCAT_ID, alias), false, DataRowVersion.Current) != Guid.Empty)
{
obj.MatcatID = RowFunctions.GetValueFromRowToGuid(MaterialCategory, MaterialCategoryObject.ConvertColumnToAlias(MaterialCategoryObject.MATCAT_ID, alias), true, DataRowVersion.Current);
obj.Category = RowFunctions.GetValueFromRowToString(MaterialCategory, MaterialCategoryObject.ConvertColumnToAlias(MaterialCategoryObject.CATEGORY, alias), false, DataRowVersion.Current);
}
return obj;
}
obj = null;
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return obj;
}
public static MaterialCategoryObject MaterialCategoryRowToObject(DataRow MaterialCategory, string alias)
{
MaterialCategoryObject obj = new MaterialCategoryObject();
try
{
if (MaterialCategory != null)
{
if (RowFunctions.GetValueFromRowToGuid(MaterialCategory, MaterialCategoryObject.ConvertColumnToAlias(MaterialCategoryObject.MATCAT_ID, alias), false, DataRowVersion.Current) != Guid.Empty)
{
obj.MatcatID = RowFunctions.GetValueFromRowToGuid(MaterialCategory, MaterialCategoryObject.ConvertColumnToAlias(MaterialCategoryObject.MATCAT_ID, alias), true, DataRowVersion.Current);
obj.Category = RowFunctions.GetValueFromRowToString(MaterialCategory, MaterialCategoryObject.ConvertColumnToAlias(MaterialCategoryObject.CATEGORY, alias), false, DataRowVersion.Current);
}
return(obj);
}
obj = null;
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return(obj);
}
public bool Remove(MaterialCategoryObject materialCategory)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "MaterialCategory_DELETE",
CreateParameter("@matcatID", SqlDbType.UniqueIdentifier, materialCategory.MatcatID, 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 int Add(MaterialCategoryObject value)
{
try
{
return List.Add(value);
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
// Methods.
object IBindingList.AddNew()
{
try
{
MaterialCategoryObject MaterialCategory = new MaterialCategoryObject();
List.Add(MaterialCategory);
return MaterialCategory;
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public void Remove(MaterialCategoryObject value)
{
try
{
List.Remove(value);
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
// Called by MaterialCategoryObject when it changes
internal void MaterialCategoryObjectChanged(MaterialCategoryObject MaterialCategory)
{
try
{
int index = List.IndexOf(MaterialCategory);
OnListChanged(new ListChangedEventArgs(ListChangedType.ItemChanged, index));
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public void Save(MaterialCategoryObject materialCategory)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "MaterialCategory_SAVE",
CreateParameter("@matcatID", SqlDbType.UniqueIdentifier, materialCategory.MatcatID, ParameterDirection.InputOutput),
CreateParameter("@Category", SqlDbType.VarChar, materialCategory.Category)
);
materialCategory.MatcatID = (Guid)cmd.Parameters["@matcatID"].Value;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
cmd = null;
}
}
void IEditableObject.EndEdit()
{
try
{
if (_inTxn)
{
_loadedMaterialCategory = MaterialCategory;
_loadedType = Type;
//Child members
_loadedSubTypes = SubTypes;
_loadedRevisions = Revisions;
_inTxn = true;
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public void Save(MaterialCategoryObject materialCategory)
{
try
{
CheckTransaction();
new MaterialCategoryDataService(Transaction).Save(materialCategory);
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();
}
}
void IEditableObject.EndEdit()
{
try
{
if (_inTxn)
{
_loadedMaterialCategory = MaterialCategory;
_loadedMaterialType = MaterialType;
_loadedMaterialSubType = MaterialSubType;
_loadedEmployeeCreator = EmployeeCreator;
_loadedEmployeeResponsable = EmployeeResponsable;
_loadedVehicle = Vehicle;
_loadedSupplier = Supplier;
_loadedName = Name;
_loadedDescription = Description;
_loadedType = Type;
_loadedSerieNumber = SerieNumber;
_loadedInternalNumber = InternalNumber;
_loadedPurchasedOn = PurchasedOn;
_loadedPrice = Price;
_loadedNextMaintenance = NextMaintenance;
_loadedMaintenanceFrequency = MaintenanceFrequency;
_loadedActive = Active;
_loadedBroken = Broken;
//Child members
_loadedMemos = Memos;
_loadedMaintenances = Maintenances;
_inTxn = true;
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
