public static void staffDepartmentInsert(DepartmentStaff depStaff)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = Common.getConnection();
cmd.CommandText = "Staff_Department_Insert";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter sDepartmentName = new SqlParameter("@departmentName", depStaff.departmentName);
sDepartmentName.SqlDbType = System.Data.SqlDbType.NVarChar;
cmd.Parameters.Add(sDepartmentName);
cmd.ExecuteNonQuery();
}
}
public static void staffDepartmentDelete(DepartmentStaff depStaff)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = Common.getConnection();
cmd.CommandText = "Staff_Department_Delete";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter iDepartmentId = new SqlParameter("@departmentId", depStaff.departmentId);
iDepartmentId.SqlDbType = System.Data.SqlDbType.Int;
cmd.Parameters.Add(iDepartmentId);
cmd.ExecuteNonQuery();
}
}
public static List <DepartmentStaff> getDepartmentList()
{
List <DepartmentStaff> DepartmentList = new List <DepartmentStaff>();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = Common.getConnection();
cmd.CommandText = "Staff_Department_Select";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
DepartmentStaff dep = new DepartmentStaff();
dep.departmentName = dt.Rows[i]["departmentName"].ToString();
dep.departmentId = Int32.Parse(dt.Rows[i]["departmentId"].ToString());
DepartmentList.Add(dep);
}
}
return(DepartmentList);
}