/// <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);
}
/// <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>
/// Bind Data to rptrSenderDetails
/// </summary>
private void BindRepeater()
{
ConversationLogBLL oConversationLogBLL = new ConversationLogBLL();
ConversationLogList objConversationLogList = new ConversationLogList();
if (ViewState["BatchNo"] != null)
{
objConversationLogList = oConversationLogBLL.GetBatchComments(Convert.ToInt32(ViewState["BatchNo"]), Convert.ToInt32(ViewState["HHID"]));
}
rptrSenderDetails.DataSource = objConversationLogList;
rptrSenderDetails.DataBind();
if (rptrSenderDetails.Items.Count == 0)
{
lblMessage.Text = "There is no Conversation";
lblMessage.Visible = true;
}
else
{
lblMessage.Visible = false;
}
}
/// <summary>
/// Bind Data to rptrSenderDetails
/// </summary>
private void BindRepeater()
{
ConversationLogBLL oConversationLogBLL = new ConversationLogBLL();
ConversationLogList objConversationLogList = new ConversationLogList();
if (ViewState["PROJECT_ID"] != null && ViewState["WorkFlowCode"] != null && ViewState["PageCode"] != null && ViewState["TrackHdrId"] != null && ViewState["BatchNo"] != null)
{
objConversationLogList = oConversationLogBLL.GetApproverDetails(Convert.ToInt32(ViewState["PROJECT_ID"]), ViewState["WorkFlowCode"].ToString(), ViewState["PageCode"].ToString(), ViewState["TrackHdrId"].ToString(), Convert.ToInt32(ViewState["BatchNo"].ToString()));
}
rptrSenderDetails.DataSource = objConversationLogList;
rptrSenderDetails.DataBind();
if (rptrSenderDetails.Items.Count == 0)
{
lblMessage.Text = "There is no Conversation";
lblMessage.Visible = true;
}
else
{
lblMessage.Visible = false;
}
}
