public StaffAdmin Get(int Id)
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-3LQJUUD;Initial Catalog=SchoolDB;User ID=sa;Password=123");
string query = "Select * from dbo.StaffAdmin Where Id = @Id";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@Id", Id);
con.Open();
StaffAdmin staffAdmin = null;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
staffAdmin = new StaffAdmin()
{
Id = (int)dr[0],
StaffId = (int)dr[1],
DepartmentName = dr[2].ToString(),
StaffName = dr[3].ToString(),
UserName = dr[4].ToString(),
Password = (int)dr[5],
PhoneNumber = (int)dr[6],
Address = dr[5].ToString()
};
con.Close();
}
return(staffAdmin);
}
public bool Put(StaffAdmin admin)
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-3LQJUUD;Initial Catalog=SchoolDB;User ID=sa;Password=123");
string query = ("Update dbo.StaffAdmin Set StaffId=@StaffId,DepartmentName=@DepartmentName,StaffName=@StaffName,UserName=@UserName,Password=@Password,PhoneNumber=@PhoneNumber,Address=@Address Where Id = @Id");
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@Id", admin.Id);
cmd.Parameters.AddWithValue("@StaffId", admin.StaffId);
cmd.Parameters.AddWithValue("@DepartmentName", admin.DepartmentName);
cmd.Parameters.AddWithValue("@StaffName", admin.StaffName);
cmd.Parameters.AddWithValue("@UserName", admin.UserName);
cmd.Parameters.AddWithValue("@Password", admin.Password);
cmd.Parameters.AddWithValue("@PhoneNumber", admin.PhoneNumber);
cmd.Parameters.AddWithValue("@Address", admin.Address);
con.Open();
int noOfRowAffected = cmd.ExecuteNonQuery();
con.Close();
if (noOfRowAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
public List <StaffAdmin> GetAll()
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-3LQJUUD;Initial Catalog=SchoolDB;User ID=sa;Password=123");
string query = "Select * from dbo.StaffAdmin";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
List <StaffAdmin> staffAdmins = new List <StaffAdmin>();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
StaffAdmin staff = new StaffAdmin()
{
Id = (int)dr[0],
StaffId = (int)dr[1],
DepartmentName = dr[2].ToString(),
StaffName = dr[3].ToString(),
UserName = dr[4].ToString(),
Password = (int)dr[5],
PhoneNumber = (int)dr[6],
Address = dr[5].ToString(),
};
staffAdmins.Add(staff);
}
con.Close();
return(staffAdmins);
}
