public double AttendanceRuleInsert(
double IDS
, DateTime PunchInRule
, DateTime BreakOutRule
, DateTime BreakInRule
, DateTime PunchOutRule
, DateTime OvertimeInRule
, DateTime OvertimeOutRule
, string ShiftName
, int DayOfTheWeek
, decimal LatePerMinutePenalty
)
{
SqlConnection conn = null;
try
{
// create and open a connection object
Variables var = new Variables();
conn = new SqlConnection(var.ConString());
conn.Open();
// 1. create a command object identifying the stored procedure
SqlCommand cmd = new SqlCommand("AttendanceRuleInsert", conn);
// 2. set the command object so it knows to execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;
// 3. add parameter to command, which will be passed to the stored procedure
cmd.Parameters.Add(new SqlParameter("@IDS", IDS));
cmd.Parameters.Add(new SqlParameter("@PunchInRule", PunchInRule));
cmd.Parameters.Add(new SqlParameter("@BreakOutRule", BreakOutRule));
cmd.Parameters.Add(new SqlParameter("@BreakInRule", BreakInRule));
cmd.Parameters.Add(new SqlParameter("@PunchOutRule", PunchOutRule));
cmd.Parameters.Add(new SqlParameter("@OTInRule", OvertimeInRule));
cmd.Parameters.Add(new SqlParameter("@OTOutRule", OvertimeOutRule));
cmd.Parameters.Add(new SqlParameter("@ShiftName", ShiftName));
cmd.Parameters.Add(new SqlParameter("@DayOfTheWeek", DayOfTheWeek));
cmd.Parameters.Add(new SqlParameter("@LatePerMinutePenalty", LatePerMinutePenalty));
//Add the output parameter to the command object
SqlParameter outPutParameter = new SqlParameter();
outPutParameter.ParameterName = "@IDSOut";
outPutParameter.SqlDbType = System.Data.SqlDbType.BigInt;
outPutParameter.Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(outPutParameter);
// execute the command
//cmd.ExecuteReader();
cmd.ExecuteNonQuery();
return(Convert.ToDouble(outPutParameter.Value));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
return(0);
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
