public DropdownDepartmentListModel SelectDepaertmentFromDB()
{
var cs = "Server=localhost\\SQLEXPRESS;Database=HospitalDB;Trusted_Connection=True;";
using var con = new SqlConnection(cs); //Using Class SqlConnection for COnnent to database
con.Open();
string sql = "SELECT Id, DepartmentName FROM UserDepartment";
using var cmd = new SqlCommand(sql, con);
using SqlDataReader rdr = cmd.ExecuteReader();
DropdownDepartmentListModel output = new DropdownDepartmentListModel();
output.departmentList = new List <DropdownDepartmentModel>();
while (rdr.Read())
{
output.departmentList.Add(
new DropdownDepartmentModel()
{
id = rdr.GetInt32(0),
name = rdr.GetString(1)
}
);
}
;
return(output);
}
public DropdownDepartmentListModel GetDepartmentList()
{
DropdownDepartmentListModel result = _userService.DepartmentList();
return(result);
}
public DropdownDepartmentListModel DepartmentList()
{
DropdownDepartmentListModel result = _userRepository.SelectDepaertmentFromDB();
return(result);
}
