public List<ApprovalFlowDetail> GetAllByApprovalFlowID(int ApprovalFlowID)
{
ApprovalFlowDetailDAC _approvalFlowDetailComponent = new ApprovalFlowDetailDAC();
IDataReader reader = _approvalFlowDetailComponent.GetAllApprovalFlowDetail("ApprovalFlowID = " + ApprovalFlowID).CreateDataReader();
List<ApprovalFlowDetail> _approvalFlowDetailList = new List<ApprovalFlowDetail>();
while (reader.Read())
{
if (_approvalFlowDetailList == null)
_approvalFlowDetailList = new List<ApprovalFlowDetail>();
ApprovalFlowDetail _approvalFlowDetail = new ApprovalFlowDetail();
if (reader["ApprovalFlowDetailID"] != DBNull.Value)
_approvalFlowDetail.ApprovalFlowDetailID = Convert.ToInt32(reader["ApprovalFlowDetailID"]);
if (reader["ApprovalFlowID"] != DBNull.Value)
_approvalFlowDetail.ApprovalFlowID = Convert.ToInt32(reader["ApprovalFlowID"]);
if (reader["OrderNumber"] != DBNull.Value)
_approvalFlowDetail.OrderNumber = Convert.ToInt32(reader["OrderNumber"]);
if (reader["ArticleStatusID"] != DBNull.Value)
_approvalFlowDetail.ArticleStatusID = Convert.ToInt32(reader["ArticleStatusID"]);
if (reader["UserID"] != DBNull.Value)
_approvalFlowDetail.UserID = Convert.ToInt32(reader["UserID"]);
if (reader["StatusDurationInHours"] != DBNull.Value)
_approvalFlowDetail.StatusDurationInHours = Convert.ToInt32(reader["StatusDurationInHours"]);
_approvalFlowDetail.NewRecord = false;
_approvalFlowDetailList.Add(_approvalFlowDetail);
} reader.Close();
return _approvalFlowDetailList;
}
public ApprovalFlowDetail GetByID(int _approvalFlowDetailID)
{
ApprovalFlowDetailDAC _approvalFlowDetailComponent = new ApprovalFlowDetailDAC();
IDataReader reader = _approvalFlowDetailComponent.GetByIDApprovalFlowDetail(_approvalFlowDetailID);
ApprovalFlowDetail _approvalFlowDetail = null;
while(reader.Read())
{
_approvalFlowDetail = new ApprovalFlowDetail();
if(reader["ApprovalFlowDetailID"] != DBNull.Value)
_approvalFlowDetail.ApprovalFlowDetailID = Convert.ToInt32(reader["ApprovalFlowDetailID"]);
if(reader["ApprovalFlowID"] != DBNull.Value)
_approvalFlowDetail.ApprovalFlowID = Convert.ToInt32(reader["ApprovalFlowID"]);
if(reader["OrderNumber"] != DBNull.Value)
_approvalFlowDetail.OrderNumber = Convert.ToInt32(reader["OrderNumber"]);
if(reader["ArticleStatusID"] != DBNull.Value)
_approvalFlowDetail.ArticleStatusID = Convert.ToInt32(reader["ArticleStatusID"]);
if(reader["UserID"] != DBNull.Value)
_approvalFlowDetail.UserID = Convert.ToInt32(reader["UserID"]);
if(reader["StatusDurationInHours"] != DBNull.Value)
_approvalFlowDetail.StatusDurationInHours = Convert.ToInt32(reader["StatusDurationInHours"]);
_approvalFlowDetail.NewRecord = false; } reader.Close();
return _approvalFlowDetail;
}
public void Delete(int Original_ApprovalFlowDetailID)
{
ApprovalFlowDetailDAC approvalflowdetailComponent = new ApprovalFlowDetailDAC();
approvalflowdetailComponent.DeleteApprovalFlowDetail(Original_ApprovalFlowDetailID);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
ApprovalFlowDetailDAC approvalflowdetailcomponent = new ApprovalFlowDetailDAC();
return approvalflowdetailcomponent.UpdateDataset(dataset);
}
public bool Update( int ApprovalFlowDetailID, int ApprovalFlowID, int OrderNumber, int ArticleStatusID, int UserID, int StatusDurationInHours, int Original_ApprovalFlowDetailID)
{
ApprovalFlowDetailDAC approvalflowdetailComponent = new ApprovalFlowDetailDAC();
return approvalflowdetailComponent.UpdateApprovalFlowDetail( ApprovalFlowDetailID, ApprovalFlowID, OrderNumber, ArticleStatusID, UserID, StatusDurationInHours, Original_ApprovalFlowDetailID);
}
public bool Update(ApprovalFlowDetail approvalflowdetail ,int old_approvalFlowDetailID)
{
ApprovalFlowDetailDAC approvalflowdetailComponent = new ApprovalFlowDetailDAC();
return approvalflowdetailComponent.UpdateApprovalFlowDetail( approvalflowdetail.ApprovalFlowDetailID, approvalflowdetail.ApprovalFlowID, approvalflowdetail.OrderNumber, approvalflowdetail.ArticleStatusID, approvalflowdetail.UserID, approvalflowdetail.StatusDurationInHours, old_approvalFlowDetailID);
}
public bool Insert( int ApprovalFlowDetailID, int ApprovalFlowID, int OrderNumber, int ArticleStatusID, int UserID, int StatusDurationInHours)
{
ApprovalFlowDetailDAC approvalflowdetailComponent = new ApprovalFlowDetailDAC();
return approvalflowdetailComponent.InsertNewApprovalFlowDetail( ApprovalFlowDetailID, ApprovalFlowID, OrderNumber, ArticleStatusID, UserID, StatusDurationInHours);
}
public bool Insert(ApprovalFlowDetail approvalflowdetail)
{
ApprovalFlowDetailDAC approvalflowdetailComponent = new ApprovalFlowDetailDAC();
return approvalflowdetailComponent.InsertNewApprovalFlowDetail( approvalflowdetail.ApprovalFlowDetailID, approvalflowdetail.ApprovalFlowID, approvalflowdetail.OrderNumber, approvalflowdetail.ArticleStatusID, approvalflowdetail.UserID, approvalflowdetail.StatusDurationInHours);
}