/// <summary>
/// Insert a new record into database
/// </summary>
public void Add(object pobjDetail)
{
try
{
PRO_WCCapacityDS dsWCCapacity = new PRO_WCCapacityDS();
dsWCCapacity.Add(pobjDetail);
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// Update into Database
/// </summary>
public void Update(object pObjectDetail)
{
try
{
PRO_WCCapacityDS dsWCCapacity = new PRO_WCCapacityDS();
dsWCCapacity.Update(pObjectDetail);
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// Return the DataSet (list of record) by inputing the FieldList and Condition
/// </summary>
public void UpdateDataSet(DataSet dstData)
{
try
{
PRO_WCCapacityDS dsWCCapacity = new PRO_WCCapacityDS();
dsWCCapacity.UpdateDataSet(dstData);
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// Delete record by condition
/// </summary>
public void Delete(int pintWCCapacityID)
{
try
{
PRO_WCCapacityDS dsWCCapacity = new PRO_WCCapacityDS();
dsWCCapacity.Delete(pintWCCapacityID);
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// Delete record by work center
/// </summary>
public void DeleteByWorkCenter(int pintCCNID, int pintWorkCenterId)
{
try
{
PRO_ShiftCapacityDS dsShiftCapacity = new PRO_ShiftCapacityDS();
PRO_WCCapacityDS dsWCCapacity = new PRO_WCCapacityDS();
dsShiftCapacity.DeleteByWorkCenter(pintCCNID, pintWorkCenterId);
dsWCCapacity.DeleteByWorkCenter(pintCCNID, pintWorkCenterId);
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
