/// <summary> /// To Get Sender Details /// </summary> /// <param name="projectID"></param> /// <param name="WorkFlowCode"></param> /// <param name="PageCode"></param> /// <param name="TrackHdrId"></param> /// <returns></returns> public ConversationLogList GetSenderDetails(int projectID, string WorkFlowCode, string PageCode, string TrackHdrId) { OracleConnection cnn = new OracleConnection(con); OracleCommand cmd; string proc = "USP_TRN_WORKFLO_SENDER_DETAILS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("WorkFlowCode_", WorkFlowCode); cmd.Parameters.Add("ProjectID_", projectID); cmd.Parameters.Add("PageCode_", PageCode); cmd.Parameters.Add("TrackHdrId_", TrackHdrId); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ConversationLogBO oConversationLogBO = null; ConversationLogList lstConversationLog = new ConversationLogList(); while (dr.Read()) { oConversationLogBO = new ConversationLogBO(); oConversationLogBO = MapData(dr); lstConversationLog.Add(oConversationLogBO); } dr.Close(); return(lstConversationLog); }
/// <summary> /// To Get Approver Details /// </summary> /// <param name="projectID"></param> /// <param name="WorkFlowCode"></param> /// <param name="PageCode"></param> /// <param name="TrackHdrId"></param> /// <returns></returns> public ConversationLogList GetBatchComments(int BatchNo, int HHID) { OracleConnection cnn = new OracleConnection(con); OracleCommand cmd; string proc = "USP_TRN_GET_BATCHCOMMENTS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("BatchNo_", BatchNo); cmd.Parameters.Add("HHID_", HHID); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ConversationLogBO oConversationLogBO = null; ConversationLogList lstConversationLog = new ConversationLogList(); while (dr.Read()) { oConversationLogBO = new ConversationLogBO(); if (!dr.IsDBNull(dr.GetOrdinal("papname"))) { oConversationLogBO.PAPName = dr.GetString(dr.GetOrdinal("papname")); } if (!dr.IsDBNull(dr.GetOrdinal("HHID"))) { oConversationLogBO.HHID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID"))); } if (!dr.IsDBNull(dr.GetOrdinal("ACTIONTAKENBY"))) { oConversationLogBO.RequesterName = dr.GetString(dr.GetOrdinal("ACTIONTAKENBY")); } if (!dr.IsDBNull(dr.GetOrdinal("ACTIONTAKENDATE"))) { oConversationLogBO.RequestDateTime = dr.GetDateTime(dr.GetOrdinal("ACTIONTAKENDATE")).ToString(UtilBO.DateFormatFull); } if (!dr.IsDBNull(dr.GetOrdinal("COMMENTS"))) { oConversationLogBO.eMailBody = dr.GetString(dr.GetOrdinal("COMMENTS")); } if (!dr.IsDBNull(dr.GetOrdinal("STATUS"))) { oConversationLogBO.Status = dr.GetString(dr.GetOrdinal("STATUS")); } lstConversationLog.Add(oConversationLogBO); } dr.Close(); return(lstConversationLog); }
private ConversationLogBO MapData(IDataReader reader) { ConversationLogBO oConversationLogBO = new ConversationLogBO(); if (ColumnExists(reader, "SenderId") && !reader.IsDBNull(reader.GetOrdinal("SenderId"))) { oConversationLogBO.RequesterId = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("SenderId"))); } if (ColumnExists(reader, "HHID") && !reader.IsDBNull(reader.GetOrdinal("HHID"))) { oConversationLogBO.HHID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("HHID"))); } if (ColumnExists(reader, "SenderName") && !reader.IsDBNull(reader.GetOrdinal("SenderName"))) { oConversationLogBO.RequesterName = reader.GetString(reader.GetOrdinal("SenderName")); } if (ColumnExists(reader, "SentDate") && !reader.IsDBNull(reader.GetOrdinal("SentDate"))) { oConversationLogBO.RequestDateTime = reader.GetDateTime(reader.GetOrdinal("SentDate")).ToString(UtilBO.DateFormatFull); } if (ColumnExists(reader, "TRACKERHEADERID") && !reader.IsDBNull(reader.GetOrdinal("TRACKERHEADERID"))) { oConversationLogBO.TrackerHeaderId = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("TRACKERHEADERID"))); } if (ColumnExists(reader, "TRACKERDETAILID") && !reader.IsDBNull(reader.GetOrdinal("TRACKERDETAILID"))) { oConversationLogBO.TrackerDetailId = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("TRACKERDETAILID"))); } if (ColumnExists(reader, "PROJECTID") && !reader.IsDBNull(reader.GetOrdinal("PROJECTID"))) { oConversationLogBO.ProjectId = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("PROJECTID"))); } if (ColumnExists(reader, "Comments") && !reader.IsDBNull(reader.GetOrdinal("Comments"))) { oConversationLogBO.ApproverComments = reader.GetString(reader.GetOrdinal("Comments")); } if (ColumnExists(reader, "MailSubject") && !reader.IsDBNull(reader.GetOrdinal("MailSubject"))) { oConversationLogBO.eMailSubject = reader.GetString(reader.GetOrdinal("MailSubject")); } if (ColumnExists(reader, "MailBody") && !reader.IsDBNull(reader.GetOrdinal("MailBody"))) { oConversationLogBO.eMailBody = reader.GetString(reader.GetOrdinal("MailBody")); } if (ColumnExists(reader, "PAGECODE") && !reader.IsDBNull(reader.GetOrdinal("PAGECODE"))) { oConversationLogBO.PageCode = reader.GetString(reader.GetOrdinal("PAGECODE")); } if (ColumnExists(reader, "WorkFlowCode") && !reader.IsDBNull(reader.GetOrdinal("WorkFlowCode"))) { oConversationLogBO.WorkFlowCode = reader.GetString(reader.GetOrdinal("WorkFlowCode")); } if (ColumnExists(reader, "DESCRIPTION") && !reader.IsDBNull(reader.GetOrdinal("DESCRIPTION"))) { oConversationLogBO.WorkFlowDescription = reader.GetString(reader.GetOrdinal("DESCRIPTION")); } if (ColumnExists(reader, "STATUS") && !reader.IsDBNull(reader.GetOrdinal("STATUS"))) { oConversationLogBO.Status = reader.GetString(reader.GetOrdinal("STATUS")); } if (ColumnExists(reader, "ApproverName") && !reader.IsDBNull(reader.GetOrdinal("ApproverName"))) { oConversationLogBO.ApproverName = reader.GetString(reader.GetOrdinal("ApproverName")); } if (ColumnExists(reader, "ApprovalDateTime") && !reader.IsDBNull(reader.GetOrdinal("ApprovalDateTime"))) { oConversationLogBO.ApprovalDateTime = reader.GetDateTime(reader.GetOrdinal("ApprovalDateTime")).ToString(UtilBO.DateFormatFull); } return(oConversationLogBO); }