public CompensationPackagesList getApproverComments()
{
CompensationPackagesBLL oCompensationPackagesBLL = new CompensationPackagesBLL();
CompensationPackagesBO oCompensationPackagesBO = new CompensationPackagesBO();
CompensationPackagesList oCompensationPackagesList = new CompensationPackagesList();
int projectID = 0;
int HHID = 0;
if (ViewState["PROJECT_ID"] != null)
{
projectID = Convert.ToInt32(ViewState["PROJECT_ID"]);
}
if (ViewState["HHID"] != null)
{
HHID = Convert.ToInt32(ViewState["HHID"]);
}
oCompensationPackagesBO.HHID = HHID;
oCompensationPackagesBO.ProjectID = projectID;
oCompensationPackagesList = oCompensationPackagesBLL.getApproverReviewComments(oCompensationPackagesBO);
return(oCompensationPackagesList);
}
/// <summary>
/// To get pre Comments
/// </summary>
/// <param name="cmppkgBo"></param>
/// <returns></returns>
public CompensationPackagesBO getpreComments(CompensationPackagesBO cmppkgBo)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GETPRINTCOUNT";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("DocumentCode_", cmppkgBo.DocumentCode);
cmd.Parameters.Add("HHID_", cmppkgBo.HHID);
cmd.Parameters.Add("UserID_", cmppkgBo.UserID);
cmd.Parameters.Add("ProjectID_", cmppkgBo.ProjectID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CompensationPackagesBO objCMPPACK = null;
CompensationPackagesList COMPACKList = new CompensationPackagesList();
while (dr.Read())
{
objCMPPACK = new CompensationPackagesBO();
if (!dr.IsDBNull(dr.GetOrdinal("TOTALPRINT")))
{
objCMPPACK.PKGdocCount = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("TOTALPRINT")));
}
}
dr.Close();
return(objCMPPACK);
}
/// <summary>
/// TO Bind Pkgs Data TO rptPKGDoccatName
/// </summary>
public void LoadComponestion()
{
CompensationPackagesBLL COMPACKBLLobj = new CompensationPackagesBLL();
CompensationPackagesList COMPACKList = new CompensationPackagesList();
try
{
int HHID = 0;
if (Session["HH_ID"] != null)
{
HHID = Convert.ToInt32(Session["HH_ID"].ToString());
}
else
{
Response.Redirect("~/UI/Compensation/PAPList.aspx");
}
COMPACKList = COMPACKBLLobj.GetComponestionbyId(HHID);
rptPKGDoccatName.DataSource = COMPACKList;
rptPKGDoccatName.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
COMPACKBLLobj = null;
}
}
/// <summary>
/// To get approval Comments
/// </summary>
/// <param name="objCOMPPACKBO"></param>
/// <returns></returns>
public CompensationPackagesBO getapprovalComments(CompensationPackagesBO objCOMPPACKBO)
{
proc = "USP_TRN_GET_PKGAPPCOMMENTS";
cnn = new OracleConnection(con);
CompensationPackagesBO objCOMPACK = null;
CompensationPackagesList COMPACKList = new CompensationPackagesList();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("DocumentCode_", objCOMPPACKBO.DocumentCode);
cmd.Parameters.Add("HHID_", objCOMPPACKBO.HHID);
cmd.Parameters.Add("ApprovalLevel_", objCOMPPACKBO.ApprovalLevel);
cmd.Parameters.Add("UserID_", objCOMPPACKBO.UserID);
cmd.Parameters.Add("ProjectID_", objCOMPPACKBO.ProjectID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objCOMPACK = new CompensationPackagesBO();
if (!dr.IsDBNull(dr.GetOrdinal("APPROVERCOMMENTS")))
{
objCOMPACK.ApprovalComents = dr.GetString(dr.GetOrdinal("APPROVERCOMMENTS"));
}
if (!dr.IsDBNull(dr.GetOrdinal("username")))
{
objCOMPACK.UserName = dr.GetString(dr.GetOrdinal("username"));
}
if (!dr.IsDBNull(dr.GetOrdinal("APPROVAL_LEVEL")))
{
objCOMPACK.ApprovalLevel = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("APPROVAL_LEVEL")));
}
if (!dr.IsDBNull(dr.GetOrdinal("REVIEWDATE")))
{
objCOMPACK.ApprovedDate = dr.GetDateTime(dr.GetOrdinal("REVIEWDATE")).ToString(UtilBO.DateFormatFull);
}
//COMPACKList.Add(objCOMPACK);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(objCOMPACK);
}
/// <summary>
/// To Get Componestion by HHId
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public CompensationPackagesList GetComponestionbyHHId(int householdID)
{
proc = "USP_MST_SELCOMPKGAPP";
cnn = new OracleConnection(con);
CompensationPackagesBO objCOMPACK = null;
CompensationPackagesList COMPACKList = new CompensationPackagesList();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("PackageCat_", PackageCat);
cmd.Parameters.Add("HHID_", householdID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objCOMPACK = new CompensationPackagesBO();
if (ColumnExists(dr, "PKGDOCITEMID") && !dr.IsDBNull(dr.GetOrdinal("PKGDOCITEMID")))
{
objCOMPACK.PKGdocItemID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PKGDOCITEMID")));
}
if (ColumnExists(dr, "PKGDOCCATEGORYID") && !dr.IsDBNull(dr.GetOrdinal("PKGDOCCATEGORYID")))
{
objCOMPACK.ITEMpkgdocitemID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PKGDOCCATEGORYID")));
}
if (ColumnExists(dr, "PKGDOCITEMNAME") && !dr.IsDBNull(dr.GetOrdinal("PKGDOCITEMNAME")))
{
objCOMPACK.PKGDOCitemName = dr.GetString(dr.GetOrdinal("PKGDOCITEMNAME"));
}
if (ColumnExists(dr, "DOCUMENTCODE") && !dr.IsDBNull(dr.GetOrdinal("DOCUMENTCODE")))
{
objCOMPACK.PKGDocumentCode = dr.GetString(dr.GetOrdinal("DOCUMENTCODE"));
}
COMPACKList.Add(objCOMPACK);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(COMPACKList);
}
/// <summary>
/// Set data to Child Repeater
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void rptPKGDoccatName_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
HiddenField hdnCategoryID = e.Item.FindControl("hdnCATpkgdoccatID") as HiddenField;
Repeater rpChild = e.Item.FindControl("rptDOCitem") as Repeater;//Child Repeater
CompensationPackagesBLL COMPACKBLLobj = new CompensationPackagesBLL();
CompensationPackagesList COMPACKList = new CompensationPackagesList();
COMPACKList = COMPACKBLLobj.getComponestion(Convert.ToInt32(Session["HH_ID"]), Convert.ToInt32(hdnCategoryID.Value), Convert.ToInt32(Session["USER_ID"]));
rpChild.DataSource = COMPACKList;
rpChild.DataBind();
}
public CompensationPackagesList getprintComments(int Hhid)
{
CompensationPackagesList COMPACKList = new CompensationPackagesList();
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_PRINTPKGCOMMENTS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", Hhid);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CompensationPackagesBO cmppkgBo;
while (dr.Read())
{
cmppkgBo = new CompensationPackagesBO();
if (!dr.IsDBNull(dr.GetOrdinal("PRINTBY")))
{
cmppkgBo.UserName = dr.GetString(dr.GetOrdinal("PRINTBY"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PRINTUPDATE")))
{
cmppkgBo.ApprovedDate = dr.GetValue(dr.GetOrdinal("PRINTUPDATE")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("PKGDOCITEMNAME")))
{
cmppkgBo.PKGDOCitemName = (dr.GetString(dr.GetOrdinal("PKGDOCITEMNAME")));
}
if (!dr.IsDBNull(dr.GetOrdinal("COMMENTS")))
{
cmppkgBo.ApprovalComents = dr.GetString(dr.GetOrdinal("COMMENTS"));
}
COMPACKList.Add(cmppkgBo);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(COMPACKList);
}
public CompensationPackagesList getApproverComments()
{
PAP_HouseholdBLL objOptionGroupCommentsBLL = new PAP_HouseholdBLL();
CompensationPackagesBO oCompensationPackagesBO = new CompensationPackagesBO();
CompensationPackagesList oCompensationPackagesList = new CompensationPackagesList();
int HHID = 0;
if (Session["HH_ID"] != null)
{
HHID = Convert.ToInt32(Session["HH_ID"]);
}
oCompensationPackagesBO.HHID = HHID;
oCompensationPackagesList = objOptionGroupCommentsBLL.getprintComments(HHID);
return(oCompensationPackagesList);
}
