public void PaymentInsert()
{
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.PaymentInsert", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.Parameters.Add("@EmployeeID", SqlDbType.Int);
Command.Parameters["@EmployeeID"].Value = EmployeeID.NullIfEmpty();
Command.Parameters.Add("@CommunityNumber", SqlDbType.VarChar);
Command.Parameters["@CommunityNumber"].Value = CommunityNumber.NullIfEmpty();
Command.Parameters.Add("@Amount", SqlDbType.VarChar);
Command.Parameters["@Amount"].Value = Amount.NullIfEmpty();
Command.Parameters.Add("@BonusPlanID", SqlDbType.Int);
Command.Parameters["@BonusPlanID"].Value = BonusPlanID.NullIfEmpty();
Command.Parameters.Add("@Note", SqlDbType.VarChar);
Command.Parameters["@Note"].Value = Note.NullIfEmpty();
Command.Parameters.Add("@CreateBy", SqlDbType.VarChar);
Command.Parameters["@CreateBy"].Value = Audit.CreateBy.NullIfEmpty();
Connection.Open();
Command.ExecuteNonQuery();
}
}
}
public void PaymentScheduleInsert()
{
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.PaymentScheduleInsert", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Add("@EmailAlertDt", SqlDbType.VarChar);
Command.Parameters["@EmailAlertDt"].Value = EmailAlertDt.NullIfEmpty();
Command.Parameters.Add("@ProcessDt", SqlDbType.VarChar);
Command.Parameters["@ProcessDt"].Value = ProcessDt.NullIfEmpty();
Command.Parameters.Add("@PayrollDt", SqlDbType.VarChar);
Command.Parameters["@PayrollDt"].Value = PayrollDt.NullIfEmpty();
Command.Parameters.Add("@CreateBy", SqlDbType.VarChar);
Command.Parameters["@CreateBy"].Value = Audit.CreateBy;
Command.Parameters.Add("@FinalNotificationDt", SqlDbType.VarChar);
Command.Parameters["@FinalNotificationDt"].Value = FinalNotificationDt.NullIfEmpty();
Command.Parameters.Add("@BonusPlanID", SqlDbType.VarChar);
Command.Parameters["@BonusPlanID"].Value = BonusPlanID.NullIfEmpty();
SqlDataAdapter DataAdapter = new SqlDataAdapter(Command);
Connection.Open();
Command.ExecuteNonQuery();
}
}
}
public void ApprovalManagementInsert()
{
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.ApprovalManagementInsert", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.Parameters.Add("@PaymentID", SqlDbType.Int);
Command.Parameters["@PaymentID"].Value = PaymentID.NullIfEmpty();
Command.Parameters.Add("@BonusPlanID", SqlDbType.Int);
Command.Parameters["@BonusPlanID"].Value = BonusPlanID.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("@CreateBy", SqlDbType.VarChar);
Command.Parameters["@CreateBy"].Value = Audit.CreateBy.NullIfEmpty();
Connection.Open();
Command.ExecuteNonQuery();
}
}
}
public void BonusPlanToUserCommunityInsert()
{
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.BonusPlanToUserCommunityInsert", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.Parameters.Add("@BonusPlanID", SqlDbType.Int);
Command.Parameters["@BonusPlanID"].Value = BonusPlanID.NullIfEmpty();
Command.Parameters.Add("@EmployeeID", SqlDbType.Int);
Command.Parameters["@EmployeeID"].Value = EmployeeID.NullIfEmpty();
Command.Parameters.Add("@CommunityNumber", SqlDbType.VarChar);
Command.Parameters["@CommunityNumber"].Value = CommunityNumber.NullIfEmpty();
Command.Parameters.Add("@Percentage", SqlDbType.VarChar);
Command.Parameters["@Percentage"].Value = Percentage.NullIfEmpty();
Command.Parameters.Add("@FlatRate", SqlDbType.VarChar);
Command.Parameters["@FlatRate"].Value = FlatRate.NullIfEmpty();
Command.Parameters.Add("@BeginDt", SqlDbType.VarChar);
Command.Parameters["@BeginDt"].Value = BeginDt.NullIfEmpty();
Command.Parameters.Add("@EndDt", SqlDbType.VarChar);
Command.Parameters["@EndDt"].Value = EndDt.NullIfEmpty();
Command.Parameters.Add("@RollforwardFlg", SqlDbType.Int);
Command.Parameters["@RollforwardFlg"].Value = RollforwardFlg.NullIfEmpty("0");
Command.Parameters.Add("@CreateBy", SqlDbType.VarChar);
Command.Parameters["@CreateBy"].Value = Audit.CreateBy.NullIfEmpty();
Connection.Open();
Command.ExecuteNonQuery();
}
}
}
public DataSet BonusPlanToApprovalWorkflowGet()
{
DataSet dsBonusPlan = new DataSet();
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.BonusPlanToApprovalWorkflowGet", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.Parameters.Add("@BonusPlanID", SqlDbType.Int);
Command.Parameters["@BonusPlanID"].Value = BonusPlanID.NullIfEmpty();
using (SqlDataAdapter DataAdapter = new SqlDataAdapter(Command))
{
DataAdapter.Fill(dsBonusPlan);
}
}
}
return(dsBonusPlan);
}
