/// <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 Save reprint Comments
/// </summary>
/// <param name="cmppkgBo"></param>
/// <returns></returns>
public int SavereprintComments(CompensationPackagesBO cmppkgBo)
{
int returnResult;
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_INS_PKGPRINTDOC", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("HHID_", cmppkgBo.HHID);
dcmd.Parameters.Add("DOCUMENTCODE", cmppkgBo.DocumentCode);
dcmd.Parameters.Add("REVIEWEDBY_", cmppkgBo.UserID);
dcmd.Parameters.Add("APPROVERCOMMENTS_", cmppkgBo.ApprovalComents);
dcmd.Parameters.Add("PROJECTID", cmppkgBo.ProjectID);
dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
returnResult = dcmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
return(returnResult);
}
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 Update Approval Status
/// </summary>
/// <param name="objCompensationPackagesBO"></param>
/// <returns></returns>
public int UpdateApprovalStatus(CompensationPackagesBO objCompensationPackagesBO)
{
int returnResult;
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_GRIEAPPROVAL", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("HHID_", objCompensationPackagesBO.HHID);
dcmd.Parameters.Add("DocumentCode_", objCompensationPackagesBO.DocumentCode);
returnResult = dcmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
return(returnResult);
}
/// <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);
}
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);
}
/// <summary>
/// To get pre Comments
/// </summary>
/// <param name="cmppkgBo"></param>
/// <returns></returns>
public CompensationPackagesBO getpreComments(CompensationPackagesBO cmppkgBo)
{
objCOMPACKDAL = new CompensationPackagesDAL();
return(objCOMPACKDAL.getpreComments(cmppkgBo));
}
/// <summary>
/// To get approval Comments
/// </summary>
/// <param name="objCOMPPACKBO"></param>
/// <returns></returns>
public CompensationPackagesBO getapprovalComments(CompensationPackagesBO objCOMPPACKBO)
{
objCOMPACKDAL = new CompensationPackagesDAL();
return(objCOMPACKDAL.getapprovalComments(objCOMPPACKBO));
}
/// <summary>
/// To get approval Comments
/// </summary>
/// <param name="objCOMPPACKBO"></param>
/// <returns></returns>
public CompensationPackagesList getApproverReviewComments(CompensationPackagesBO pCompensationPackagesBO)
{
objCOMPACKDAL = new CompensationPackagesDAL();
return(objCOMPACKDAL.getApproverReviewComments(pCompensationPackagesBO));
}
/// <summary>
/// To Save Approval Comments
/// </summary>
/// <param name="objCOMPPACKBO"></param>
/// <returns></returns>
public int SaveApprovalComments(CompensationPackagesBO objCOMPPACKBO)
{
objCOMPACKDAL = new CompensationPackagesDAL();
return(objCOMPACKDAL.SaveApprovalComments(objCOMPPACKBO));
}
/// <summary>
/// To Update Approval Status
/// </summary>
/// <param name="objCompensationPackagesBO"></param>
/// <returns></returns>
public int UpdateApprovalStatus(CompensationPackagesBO objCompensationPackagesBO)
{
objCOMPACKDAL = new CompensationPackagesDAL();
return(objCOMPACKDAL.UpdateApprovalStatus(objCompensationPackagesBO));
}
/// <summary>
/// To Save reprint Comments
/// </summary>
/// <param name="cmppkgBo"></param>
/// <returns></returns>
public int SavereprintComments(CompensationPackagesBO cmppkgBo)
{
objCOMPACKDAL = new CompensationPackagesDAL();
return(objCOMPACKDAL.SavereprintComments(cmppkgBo));
}