public Attendnces()
{
employee = new Employee();
}
public void AddRecord(Employee employee)
{
byte[] img = null;
FileStream fs = new FileStream(employee.ImageLoc, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
img = br.ReadBytes((int)fs.Length);
connection.Open();
//set up command
SqlCommand command = new SqlCommand("eprocedureInsertEmployee", connection);
//set up commandType
command.CommandType = CommandType.StoredProcedure;
//set up parameters
command.Parameters.AddWithValue("@EmoloyeeID", employee.EmoloyeeID);
command.Parameters.AddWithValue("@FirstName", employee.FirstName);
command.Parameters.AddWithValue("@MiddleName", employee.MiddleName);
command.Parameters.AddWithValue("@LastName", employee.LastName);
command.Parameters.AddWithValue("@Age", employee.Age);
command.Parameters.AddWithValue("@Birthday", employee.Birthday);
command.Parameters.AddWithValue("@Sex", employee.Sex);
command.Parameters.AddWithValue("@City", employee.City);
command.Parameters.AddWithValue("@Province", employee.Province);
command.Parameters.AddWithValue("@Street", employee.Street);
command.Parameters.AddWithValue("@Country", employee.Country);
command.Parameters.AddWithValue("@Religion", employee.Religion);
command.Parameters.AddWithValue("@CivilStatus", employee.CivilStatus);
command.Parameters.AddWithValue("@NoOfChild", employee.NoOfChild);
command.Parameters.AddWithValue("@NoOfDependent", employee.NoOfDependent);
command.Parameters.AddWithValue("@Position", employee.Position);
command.Parameters.AddWithValue("@Salary", employee.Salary);
command.Parameters.AddWithValue("@EmployeePicture", img);
command.Parameters.AddWithValue("@TertiarySchool", employee.TertiarySchool);
command.Parameters.AddWithValue("@TertiaryYear", employee.TertiaryYear);
command.Parameters.AddWithValue("@SecondarySchool", employee.SecondarySchool);
command.Parameters.AddWithValue("@SecondaryYear", employee.SecondaryYear);
command.Parameters.AddWithValue("@ElementarySchool", employee.ElementarySchool);
command.Parameters.AddWithValue("@ElementaryYear", employee.ElementaryYear);
command.Parameters.AddWithValue("@DateHired", employee.DateHired);
command.ExecuteNonQuery();
connection.Close();
}
public Leaves()
{
employee = new Employee();
}