public List<ApprovalFlow> GetAll() { ApprovalFlowDAC _approvalFlowComponent = new ApprovalFlowDAC(); IDataReader reader = _approvalFlowComponent.GetAllApprovalFlow().CreateDataReader(); List<ApprovalFlow> _approvalFlowList = new List<ApprovalFlow>(); while(reader.Read()) { if(_approvalFlowList == null) _approvalFlowList = new List<ApprovalFlow>(); ApprovalFlow _approvalFlow = new ApprovalFlow(); if(reader["ApprovalFlowID"] != DBNull.Value) _approvalFlow.ApprovalFlowID = Convert.ToInt32(reader["ApprovalFlowID"]); if(reader["SectionID"] != DBNull.Value) _approvalFlow.SectionID = Convert.ToInt32(reader["SectionID"]); if(reader["Title"] != DBNull.Value) _approvalFlow.Title = Convert.ToString(reader["Title"]); if(reader["DateStart"] != DBNull.Value) _approvalFlow.DateStart = Convert.ToDateTime(reader["DateStart"]); if(reader["DateEnd"] != DBNull.Value) _approvalFlow.DateEnd = Convert.ToDateTime(reader["DateEnd"]); if(reader["ApprovedBy"] != DBNull.Value) _approvalFlow.ApprovedBy = Convert.ToInt32(reader["ApprovedBy"]); _approvalFlow.NewRecord = false; _approvalFlowList.Add(_approvalFlow); } reader.Close(); return _approvalFlowList; }
public ApprovalFlow GetByID(int _approvalFlowID) { ApprovalFlowDAC _approvalFlowComponent = new ApprovalFlowDAC(); IDataReader reader = _approvalFlowComponent.GetByIDApprovalFlow(_approvalFlowID); ApprovalFlow _approvalFlow = null; while(reader.Read()) { _approvalFlow = new ApprovalFlow(); if(reader["ApprovalFlowID"] != DBNull.Value) _approvalFlow.ApprovalFlowID = Convert.ToInt32(reader["ApprovalFlowID"]); if(reader["SectionID"] != DBNull.Value) _approvalFlow.SectionID = Convert.ToInt32(reader["SectionID"]); if(reader["Title"] != DBNull.Value) _approvalFlow.Title = Convert.ToString(reader["Title"]); if(reader["DateStart"] != DBNull.Value) _approvalFlow.DateStart = Convert.ToDateTime(reader["DateStart"]); if(reader["DateEnd"] != DBNull.Value) _approvalFlow.DateEnd = Convert.ToDateTime(reader["DateEnd"]); if(reader["ApprovedBy"] != DBNull.Value) _approvalFlow.ApprovedBy = Convert.ToInt32(reader["ApprovedBy"]); _approvalFlow.NewRecord = false; } reader.Close(); return _approvalFlow; }
public bool Insert(ApprovalFlow approvalflow) { int autonumber = 0; ApprovalFlowDAC approvalflowComponent = new ApprovalFlowDAC(); bool endedSuccessfuly = approvalflowComponent.InsertNewApprovalFlow( ref autonumber, approvalflow.SectionID, approvalflow.Title, approvalflow.DateStart, approvalflow.DateEnd, approvalflow.ApprovedBy); if(endedSuccessfuly) { approvalflow.ApprovalFlowID = autonumber; } return endedSuccessfuly; }
public bool Update(ApprovalFlow approvalflow ,int old_approvalFlowID) { ApprovalFlowDAC approvalflowComponent = new ApprovalFlowDAC(); return approvalflowComponent.UpdateApprovalFlow( approvalflow.SectionID, approvalflow.Title, approvalflow.DateStart, approvalflow.DateEnd, approvalflow.ApprovedBy, old_approvalFlowID); }