public void ApprovalManagementUpdate()
{
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.ApprovalManagementUpdate", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.Parameters.Add("@PaymentToApprovalID", SqlDbType.Int);
Command.Parameters["@PaymentToApprovalID"].Value = PaymentToApprovalID.NullIfEmpty();
Command.Parameters.Add("@UsernameAlternate", SqlDbType.VarChar);
Command.Parameters["@UsernameAlternate"].Value = UsernameAlternate.NullIfEmpty();
Command.Parameters.Add("@JobCategoryID", SqlDbType.Int);
Command.Parameters["@JobCategoryID"].Value = JobCategoryID.NullIfEmpty();
Command.Parameters.Add("@JobCategoryIDAlternate", SqlDbType.Int);
Command.Parameters["@JobCategoryIDAlternate"].Value = JobCategoryIDAlternate.NullIfEmpty();
Command.Parameters.Add("@Sort", SqlDbType.Int);
Command.Parameters["@Sort"].Value = Sort.NullIfEmpty();
Command.Parameters.Add("@ApproveFlg", SqlDbType.Int);
Command.Parameters["@ApproveFlg"].Value = ApproveFlg.NullIfEmpty();
Command.Parameters.Add("@DenyFlg", SqlDbType.Int);
Command.Parameters["@DenyFlg"].Value = DenyFlg.NullIfEmpty();
Command.Parameters.Add("@ExceptionFlg", SqlDbType.Int);
Command.Parameters["@ExceptionFlg"].Value = ExceptionFlg.NullIfEmpty();
Command.Parameters.Add("@ExceptionNote", SqlDbType.VarChar);
Command.Parameters["@ExceptionNote"].Value = ExceptionNote.NullIfEmpty();
Command.Parameters.Add("@AdministrationNote", SqlDbType.VarChar);
Command.Parameters["@AdministrationNote"].Value = AdministrationNote.NullIfEmpty();
Command.Parameters.Add("@OverrideFlg", SqlDbType.Int);
Command.Parameters["@OverrideFlg"].Value = OverrideFlg.NullIfEmpty();
Command.Parameters.Add("@ModifyBy", SqlDbType.VarChar);
Command.Parameters["@ModifyBy"].Value = Audit.ModifyBy.NullIfEmpty();
Command.Parameters.Add("@ActiveFlg", SqlDbType.Int);
Command.Parameters["@ActiveFlg"].Value = Audit.ActiveFlg.NullIfEmpty();
Connection.Open();
Command.ExecuteNonQuery();
}
}
}
public DataSet ApprovalManagementDetailGet()
{
DataSet dsApproval = new DataSet();
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.ApprovalManagementDetailGet", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.Parameters.Add("@PaymentToApprovalID", SqlDbType.Int);
Command.Parameters["@PaymentToApprovalID"].Value = PaymentToApprovalID.NullIfEmpty();
using (SqlDataAdapter DataAdapter = new SqlDataAdapter(Command))
{
DataAdapter.Fill(dsApproval);
if (dsApproval.HasRows())
{
PaymentToApprovalID = dsApproval.Tables[0].Rows[0]["PaymentToApprovalID"].ToString();
BonusPlanID = dsApproval.Tables[0].Rows[0]["BonusPlanID"].ToString();
JobCategoryID = dsApproval.Tables[0].Rows[0]["JobCategoryID"].ToString();
JobCategoryIDAlternate = dsApproval.Tables[0].Rows[0]["JobCategoryIDAlternate"].ToString();
UsernameAlternate = dsApproval.Tables[0].Rows[0]["UsernameAlternate"].ToString();
//CriteriaValue = dsApproval.Tables[0].Rows[0]["CriteriaValue"].ToString();
Sort = dsApproval.Tables[0].Rows[0]["Sort"].ToString();
ApproveFlg = dsApproval.Tables[0].Rows[0]["ApproveFlg"].ToString();
DenyFlg = dsApproval.Tables[0].Rows[0]["DenyFlg"].ToString();
ExceptionFlg = dsApproval.Tables[0].Rows[0]["ExceptionFlg"].ToString();
OverrideFlg = dsApproval.Tables[0].Rows[0]["OverrideFlg"].ToString();
ExceptionNote = dsApproval.Tables[0].Rows[0]["ExceptionNote"].ToString();
AdministrationNote = dsApproval.Tables[0].Rows[0]["AdministrationNote"].ToString();
Audit.CreateBy = dsApproval.Tables[0].Rows[0]["CreateBy"].ToString();
Audit.CreateDt = dsApproval.Tables[0].Rows[0]["CreateDt"].ToString();
Audit.ModifyBy = dsApproval.Tables[0].Rows[0]["ModifyBy"].ToString();
Audit.ModifyDt = dsApproval.Tables[0].Rows[0]["ModifyDt"].ToString();
Audit.ActiveFlg = dsApproval.Tables[0].Rows[0]["ActiveFlg"].ToString();
}
}
}
}
return(dsApproval);
}