public int Insert(DBConnection objConnection, MATERIALDC objMATERIAL_VALUs)
{
int insertedCount = 0;
MATERIALDA objMATERIAL_VALUDA = new MATERIALDA();
insertedCount = objMATERIAL_VALUDA.Insert(objConnection, objMATERIAL_VALUs);
return(insertedCount);
}
public int Update(DBConnection objConnection, MATERIALDC objMATERIAL_VALUs)
{
int updatedCount = 0;
MATERIALDA objMATERIAL_VALUDA = new MATERIALDA();
updatedCount = objMATERIAL_VALUDA.Update(objConnection, objMATERIAL_VALUs);
return(updatedCount);
}
public List <MATERIALDC> LoadByDailyIDAndType(int DAILY_ID, int DAILY_TYPE, int SUB_CATEGORY)
{
DBConnection objConnection = new DBConnection();
MATERIALDA objMATERIAL_VALUDA = new MATERIALDA();
List <MATERIALDC> objMATERIAL_VALUDC = null;
try
{
objConnection.Open(false);
objMATERIAL_VALUDC = objMATERIAL_VALUDA.LoadByDailyIDAndType(objConnection, DAILY_ID, DAILY_TYPE, SUB_CATEGORY);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objMATERIAL_VALUDC);
}
public MATERIALDC LoadByPrimaryKey(int MATERIAL_VALUE_ID)
{
DBConnection objConnection = new DBConnection();
MATERIALDA objMATERIAL_VALUDA = new MATERIALDA();
MATERIALDC objMATERIAL_VALUDC = null;
try
{
objConnection.Open(false);
objMATERIAL_VALUDC = objMATERIAL_VALUDA.LoadByPrimaryKey(objConnection, MATERIAL_VALUE_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objMATERIAL_VALUDC);
}
public List <MATERIALDC> LoadAll()
{
DBConnection objConnection = new DBConnection();
MATERIALDA objMATERIAL_VALUDA = new MATERIALDA();
List <MATERIALDC> objMATERIAL_VALUDC = null;
try
{
objConnection.Open(false);
objMATERIAL_VALUDC = objMATERIAL_VALUDA.LoadAll(objConnection);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objMATERIAL_VALUDC);
}
public int Delete(List <MATERIALDC> objMATERIAL_VALUs)
{
int deletedCount = 0;
DBConnection objConnection = new DBConnection();
MATERIALDA objMATERIAL_VALUDA = new MATERIALDA();
try
{
objConnection.Open(true);
deletedCount = objMATERIAL_VALUDA.Delete(objConnection, objMATERIAL_VALUs);
objConnection.Commit();
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(deletedCount);
}
