/// <summary>
/// Add a new entry to the RegisterPayout table
/// </summary>
public static RegisterPayout Add(int registerDrawerId, int employeeId,
double amount, string reason, DateTime payoutTime)
{
RegisterPayout result = null;
DateTime purchaseTime = DateTime.Now;
SqlConnection cn = GetConnection();
string cmd = "AddRegisterPayout";
using (SqlCommand sqlCmd = new SqlCommand(cmd, cn))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
BuildSqlParameter(sqlCmd, "@RegisterPayoutRegisterDrawerId", SqlDbType.Int, registerDrawerId);
BuildSqlParameter(sqlCmd, "@RegisterPayoutEmployeeId", SqlDbType.Int, employeeId);
BuildSqlParameter(sqlCmd, "@RegisterPayoutAmount", SqlDbType.Float, amount);
BuildSqlParameter(sqlCmd, "@RegisterPayoutReason", SqlDbType.Text, reason);
BuildSqlParameter(sqlCmd, "@RegisterPayoutTime", SqlDbType.DateTime, payoutTime);
BuildSqlParameter(sqlCmd, "@RegisterPayoutId", SqlDbType.Int, ParameterDirection.ReturnValue);
if (sqlCmd.ExecuteNonQuery() > 0)
{
result = new RegisterPayout(Convert.ToInt32(sqlCmd.Parameters["@RegisterPayoutId"].Value),
registerDrawerId, employeeId, amount, reason, payoutTime);
}
}
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Update an entry in the RegisterPayout table
/// </summary>
public static bool Update(RegisterPayout registerPayout)
{
bool result = false;
SqlConnection cn = GetConnection();
result = Update(cn, registerPayout);
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Get an entry from the RegisterPayout table
/// </summary>
public static RegisterPayout Get(int id)
{
RegisterPayout result = null;
SqlConnection cn = GetConnection();
result = Get(cn, id);
FinishedWithConnection(cn);
return(result);
}
private static RegisterPayout Get(SqlConnection cn, int id)
{
RegisterPayout result = null;
using (SqlCommand cmd = new SqlCommand("SELECT * FROM RegisterPayout WHERE RegisterPayoutId=" + id, cn))
{
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = BuildRegisterPayout(rdr);
}
}
}
return(result);
}
/// <summary>
/// Delete an entry from the RegisterPayout table
/// </summary>
public static bool Delete(int id)
{
Int32 rowsAffected = 0;
SqlConnection cn = GetConnection();
RegisterPayout registerPayout = Get(cn, id);
if (registerPayout != null)
{
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "DELETE FROM RegisterPayout WHERE RegisterPayoutId=" + id;
rowsAffected = sqlCmd.ExecuteNonQuery();
}
}
FinishedWithConnection(cn);
return(rowsAffected != 0);
}
private static bool Update(SqlConnection cn, RegisterPayout registerPayout)
{
Int32 rowsAffected = 0;
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "UPDATE RegisterPayout SET RegisterPayoutRegisterDrawerId=@RegisterPayoutRegisterDrawerId,RegisterPayoutEmployeeId=@RegisterPayoutEmployeeId,RegisterPayoutAmount=@RegisterPayoutAmount,RegisterPayoutReason=@RegisterPayoutReason,RegisterPayoutTime=@RegisterPayoutTime WHERE RegisterPayoutId=@RegisterPayoutId";
BuildSqlParameter(sqlCmd, "@RegisterPayoutId", SqlDbType.Int, registerPayout.Id);
BuildSqlParameter(sqlCmd, "@RegisterPayoutRegisterDrawerId", SqlDbType.Int, registerPayout.RegisterDrawerId);
BuildSqlParameter(sqlCmd, "@RegisterPayoutEmployeeId", SqlDbType.Int, registerPayout.EmployeeId);
BuildSqlParameter(sqlCmd, "@RegisterPayoutAmount", SqlDbType.Float, registerPayout.Amount);
BuildSqlParameter(sqlCmd, "@RegisterPayoutReason", SqlDbType.Float, registerPayout.Reason);
BuildSqlParameter(sqlCmd, "@RegisterPayoutTime", SqlDbType.DateTime, registerPayout.When);
rowsAffected = sqlCmd.ExecuteNonQuery();
}
return(rowsAffected != 0);
}
