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(); } }