public void AddEmployer(EmployerUnit oUnit) { SqlCommand oCommand = new SqlCommand(); oCommand.Connection = this.Connection; oCommand.CommandType = CommandType.StoredProcedure; oCommand.CommandText = "SP_TRANS_INSERT_EMPLOYER"; oCommand.Parameters.Add(new SqlParameter("@EmployerCode", oUnit.EmployerCode)); oCommand.Parameters.Add(new SqlParameter("@EmployerName", oUnit.EmployerName)); oCommand.Parameters.Add(new SqlParameter("@EmployerTINIDNo", oUnit.EmployerTINIDNo)); oCommand.Parameters.Add(new SqlParameter("@Address", oUnit.Address)); oCommand.Parameters.Add(new SqlParameter("@ContactNumber", oUnit.ContactNumber)); oCommand.Parameters.Add(new SqlParameter("@EmailAddress", oUnit.EmailAddress)); oCommand.Parameters.Add(new SqlParameter("@ContactPerson", oUnit.ContactPerson)); oCommand.ExecuteNonQuery(); }
public void AddEmployer() { EmployerManager oManager = new EmployerManager(); EmployerUnit oUnit = new EmployerUnit(); oManager.ConnectionString = this.ConnectionString; oManager.Open(); oUnit.EmployerCode = txtCode.Text; oUnit.EmployerName = txtEmployerName.Text; oUnit.EmployerTINIDNo = txtTINIDNo.Text; oUnit.Address = txtAddress.Text; oUnit.ContactNumber = txtContactNo.Text; oUnit.EmailAddress = txtEmailAddress.Text; oUnit.ContactNumber = txtContactNo.Text; oUnit.ContactPerson = txtContactPerson.Text; oManager.AddEmployer(oUnit); oManager.Close(); txtCode.Enabled = false; }