public FormPositions()
{
InitializeComponent();
admin = new Admin();
positions = new Positions();
counts = new Counts();
}
public FormPagIbig()
{
InitializeComponent();
pagIbig = new PagIbig();
counts = new Counts();
admin = new Admin();
}
public FormPhilHealth()
{
InitializeComponent();
philHealth = new PhilHealth();
counts = new Counts();
admin = new Admin();
}
public FormSSS()
{
InitializeComponent();
admin = new Admin();
sss = new SSS();
counts = new Counts();
}
public Department()
{
InitializeComponent();
admin = new Admin();
department = new Departments();
counts = new Counts();
}
public void GetCountDepartment(Counts counts)
{
SqlCommand command = new SqlCommand();
Object returnValue;
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "bprocedureCountDepartment";
command.Connection = connection;
connection.Open();
returnValue = command.ExecuteScalar();
connection.Close();
counts.Countss = returnValue.ToString();
}
public void GetCountDepartment(Counts counts)
{
SqlCommand command = new SqlCommand();
Object returnValue;
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "bprocedureCountDepartment";
command.Connection = connection;
connection.Open();
returnValue = command.ExecuteScalar();
connection.Close();
counts.Countss = returnValue.ToString();
}
public void GetLastIDPagIbig(Counts counts)
{
SqlCommand command = new SqlCommand();
Object returnValue;
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "fprocedureLastIDPagIbig";
command.Connection = connection;
connection.Open();
returnValue = command.ExecuteScalar();
connection.Close();
counts.LastID = returnValue.ToString();
}
public void GetLastIDPagIbig(Counts counts)
{
SqlCommand command = new SqlCommand();
Object returnValue;
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "fprocedureLastIDPagIbig";
command.Connection = connection;
connection.Open();
returnValue = command.ExecuteScalar();
connection.Close();
counts.LastID = returnValue.ToString();
}
