public void Salary(int id)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.TIME_OUT";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_ID", id));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
PayrollItem item = new PayrollItem();
item.SINGLE_SALARY = (double)reader["MONTHLY_SALARY"];
item.HOURLY_RATE = (double)reader["HOURLY_RATE"];
SingleSalary.salary = item;
}
db.Close();
}
}
public void GetId(string number)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GET_ID_FROM_EMPNO";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_NO", number));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
PayrollItem item = new PayrollItem();
item.EMP_ID = (int)reader["EMP_ID"];
item.DEPARTMENT = (string)reader["POS_NAME"];
PayrollDetails.paydetails = item;
}
}
}
public void UPayroll(string id)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GET_PAYROLL_DETAILS";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_ID", id));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
PayrollItem item = new PayrollItem();
item.EMP_ID = (int)reader["EMP_ID"];
item.EMP_NO = (string)reader["EMP_NO"];
item.FIRST_NAME = (string)reader["FIRST_NAME"];
item.MIDDLE_NAME = (string)reader["MIDDLE_NAME"];
item.LAST_NAME = (string)reader["LAST_NAME"];
item.DEPARTMENT = (string)reader["POS_DEPARTMENT"];
item.SSS = (string)reader["SSS_NO"];
item.PAG_IBIG = (string)reader["PAG_IBIG_NO"];
item.PHIL = (string)reader["PHIL_HEALTH_NO"];
item.BIR = (string)reader["BIR_NO"];
item.DEDUC_SSS = (double)reader["DEDUC_SSS"];
item.DEDUC_PAG_IBIG = (double)reader["DEDUC_PAG_IBIG"];
item.DEDUC_PHIL = (double)reader["DEDUC_PHIL_HEALTH"];
item.DEDUC_BIR = (double)reader["DEDUC_BIR"];
PayrollDetails.paydetails = item;
}
db.Close();
}
}