public void RetreiveAllEmployee()
{
StaticEmpoyeeCollection.staticEmployeeList.Clear();
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GetEmployees";
var cmd = new SqlCommand(sql, db);
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new EmployeeItem();
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._EMP_PASSWORD = (string)reader["EMP_PASSWORD"];
item._GENDER = (string)reader["GENDER"];
item._BIRTHDAY = (string)reader["BIRTHDAY"];
item._NATIONALITY = (string)reader["NATIONALITY"];
item._PASSPORT = (string)reader["PASSPORT"];
item._RELIGION = (string)reader["RELIGION"];
item._BIRTH_PLACE = (string)reader["BIRTH_PLACE"];
item._EMP_STATUS = (string)reader["EMP_STATUS"];
item._EMAIL_ADDRESS = (string)reader["EMAIL_ADDRESS"];
item._CONTACT = (string)reader["CONTACT"];
item._PRESENT_ADDRESS = (string)reader["PRESENT_ADDRESS"];
item._PERMANENT_ADDRESS = (string)reader["PERMANENT_ADDRESS"];
item._DATE_JOINED = (string)reader["DATE_JOINED"];
item._END_PROVITION = (string)reader["END_PROVITION"];
item._POS_ID = (int)reader["POS_ID"];
item._IOE_PERSON = (string)reader["IOE_PERSON"];
item._IOE_RELATION = (string)reader["IOE_RELATION"];
item._IOE_ADDRESS = (string)reader["IOE_ADDRESS"];
item._IOE_CONTACT = (string)reader["IOE_CONTACT"];
item._HOURLY_RATE = double.Parse(reader["HOURLY_RATE"].ToString());
item._MONTHLY_SALARY = double.Parse(reader["MONTHLY_SALARY"].ToString());
item._SSS_NO = (string)reader["SSS_NO"];
item._PHIL_HEALTH_NO = (string)reader["PHIL_HEALTH_NO"];
item._PAG_IBIG_NO = (string)reader["PAG_IBIG_NO"];
item._BIR_NO = (string)reader["BIR_NO"];
item._DEDUC_SSS = double.Parse(reader["DEDUC_SSS"].ToString());
item._DEDUC_PHIL_HEALTH = double.Parse(reader["DEDUC_PHIL_HEALTH"].ToString());
item._DEDUC_PAG_IBIG = double.Parse(reader["DEDUC_PAG_IBIG"].ToString());
item._DEDUC_BIR = double.Parse(reader["DEDUC_BIR"].ToString());
StaticEmpoyeeCollection.staticEmployeeList.Add(item);
}
db.Close();
}
}
public void SaveData(EmployeeItem myItem)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.spInsertEmployee";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EMP_NO", myItem._EMP_NO));
cmd.Parameters.Add(new SqlParameter("@FIRST_NAME", myItem._FIRST_NAME));
cmd.Parameters.Add(new SqlParameter("@MIDDLE_NAME", myItem._MIDDLE_NAME));
cmd.Parameters.Add(new SqlParameter("@LAST_NAME", myItem._LAST_NAME));
cmd.Parameters.Add(new SqlParameter("@EMP_PASSWORD", myItem._EMP_PASSWORD));
cmd.Parameters.Add(new SqlParameter("@GENDER", myItem._GENDER));
cmd.Parameters.Add(new SqlParameter("@BIRTHDAY", myItem._BIRTHDAY));
cmd.Parameters.Add(new SqlParameter("@NATIONALITY", myItem._NATIONALITY));
cmd.Parameters.Add(new SqlParameter("@PASSPORT", myItem._PASSPORT));
cmd.Parameters.Add(new SqlParameter("@RELIGION", myItem._RELIGION));
cmd.Parameters.Add(new SqlParameter("@BIRTH_PLACE", myItem._BIRTH_PLACE));
cmd.Parameters.Add(new SqlParameter("@EMP_STATUS", myItem._EMP_STATUS));
cmd.Parameters.Add(new SqlParameter("@EMAIL_ADDRESS", myItem._EMAIL_ADDRESS));
cmd.Parameters.Add(new SqlParameter("@CONTACT", myItem._CONTACT));
cmd.Parameters.Add(new SqlParameter("@PRESENT_ADDRESS", myItem._PRESENT_ADDRESS));
cmd.Parameters.Add(new SqlParameter("@PERMANENT_ADDRESS", myItem._PERMANENT_ADDRESS));
cmd.Parameters.Add(new SqlParameter("@DATE_JOINED", myItem._DATE_JOINED));
cmd.Parameters.Add(new SqlParameter("@END_PROVITION", myItem._END_PROVITION));
cmd.Parameters.Add(new SqlParameter("@POS_ID", myItem._POS_ID));
cmd.Parameters.Add(new SqlParameter("@IOE_PERSON", myItem._IOE_PERSON));
cmd.Parameters.Add(new SqlParameter("@IOE_RELATION", myItem._IOE_RELATION));
cmd.Parameters.Add(new SqlParameter("@IOE_ADDRESS", myItem._IOE_ADDRESS));
cmd.Parameters.Add(new SqlParameter("@IOE_CONTACT", myItem._IOE_CONTACT));
cmd.Parameters.Add(new SqlParameter("@HOURLY_RATE", myItem._HOURLY_RATE));
cmd.Parameters.Add(new SqlParameter("@MONTHLY_SALARY", myItem._MONTHLY_SALARY));
cmd.Parameters.Add(new SqlParameter("@SSS_NO", myItem._SSS_NO));
cmd.Parameters.Add(new SqlParameter("@PHIL_HEALTH_NO", myItem._PHIL_HEALTH_NO));
cmd.Parameters.Add(new SqlParameter("@PAG_IBIG_NO", myItem._PAG_IBIG_NO));
cmd.Parameters.Add(new SqlParameter("@BIR_NO", myItem._BIR_NO));
cmd.Parameters.Add(new SqlParameter("@DEDUC_SSS", myItem._DEDUC_SSS));
cmd.Parameters.Add(new SqlParameter("@DEDUC_PHIL_HEALTH", myItem._DEDUC_PHIL_HEALTH));
cmd.Parameters.Add(new SqlParameter("@DEDUC_PAG_IBIG", myItem._DEDUC_PAG_IBIG));
cmd.Parameters.Add(new SqlParameter("@DEDUC_BIR", myItem._DEDUC_BIR));
cmd.Parameters.Add(new SqlParameter("@VL_BALANCE", myItem._VL_BALANCE));
cmd.Parameters.Add(new SqlParameter("@SL_BALANCE", myItem._SL_BALANCE));
cmd.ExecuteNonQuery();
db.Close();
}
}
public EmployeeItem RetreiveSpecificEmployee(string employeeID)
{
var item = new EmployeeItem();
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GetSpecificEmployee";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Employee_ID", employeeID));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return(null);
}
if (reader.Read())
{
//item._employeeId = (string)reader["Empolyee_ID"];
//item._firstName = (string)reader["First_Name"];
//item._middleName = (string)reader["Middle_Name"];
//item._lastName = (string)reader["Last_Name"];
//item._nationality = (string)reader["Nationality"];
//item._eMail = (string)reader["Email"];
//item._contactNum = (string)reader["Contact_Number"];
//item._religion = (string)reader["Religion"];
//item._presentAddress = (string)reader["Present_Address"];
//item._permanentAddress = (string)reader["Permanent_Address"];
}
db.Close();
return(item);
}
}
public void UpdateData(EmployeeItem item)
{
using (var db = DBConnection.CreateConnection())
{
db.Open();
//var sql = "dbo.spUpdateEmployee";
//var cmd = new SqlCommand(sql, db);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@Employee_ID", item._employeeId));
//cmd.Parameters.Add(new SqlParameter("@First_Name", item._firstName));
//cmd.Parameters.Add(new SqlParameter("@Middle_Name", item._middleName));
//cmd.Parameters.Add(new SqlParameter("@Last_Name", item._lastName));
//cmd.Parameters.Add(new SqlParameter("@Nationality", item._nationality));
//cmd.Parameters.Add(new SqlParameter("@Religion", item._religion));
//cmd.Parameters.Add(new SqlParameter("@Email", item._eMail));
//cmd.Parameters.Add(new SqlParameter("@Contact_Number", item._contactNum));
//cmd.Parameters.Add(new SqlParameter("@Present_Address", item._presentAddress));
//cmd.Parameters.Add(new SqlParameter("@Permanent_Address", item._permanentAddress));
//cmd.ExecuteNonQuery();
db.Close();
}
}
public void RetreiveAllEmployee()
{
StaticEmpoyeeCollection.staticEmployeeList.Clear();
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GetEmployees";
var cmd = new SqlCommand(sql, db);
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new EmployeeItem();
item._employeeId = (string)reader["EMP_NO"];
item._firstName = (string)reader["FIRST_NAME"];
item._middleName = (string)reader["MIDDLE_NAME"];
item._lastName = (string)reader["LAST_NAME"];
item._nationality = (string)reader["NATIONALITY"];
item._eMail = (string)reader["EMAIL_ADDRESS"];
item._contactNum = (string)reader["CONTACT"];
item._religion = (string)reader["RELIGION"];
item._presentAddress = (string)reader["PRESENT_ADDRESS"];
item._permanentAddress = (string)reader["PERMANENT_ADDRESS"];
StaticEmpoyeeCollection.staticEmployeeList.Add(item);
}
db.Close();
}
}
public void RetreiveAllEmployee()
{
StaticEmpoyeeCollection.staticEmployeeList.Clear();
using (var db = DBConnection.CreateConnection())
{
db.Open();
var sql = "dbo.GetEmployees";
var cmd = new SqlCommand(sql, db);
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new EmployeeItem();
item._employeeId = (string)reader["Empolyee_ID"];
item._firstName = (string)reader["First_Name"];
item._middleName = (string)reader["Middle_Name"];
item._lastName = (string)reader["Last_Name"];
item._nationality = (string)reader["Nationality"];
item._eMail = (string)reader["Email"];
item._contactNum = (string)reader["Contact_Number"];
item._religion = (string)reader["Religion"];
item._presentAddress = (string)reader["Present_Address"];
item._permanentAddress = (string)reader["Permanent_Address"];
StaticEmpoyeeCollection.staticEmployeeList.Add(item);
}
db.Close();
}
}
