public async Task <TakeCare> SponcerAChild(TakeCare takeCare)
{
if (await _dbContext.Children.FindAsync(takeCare.ChildID) == null)
{
return(null);
}
_ = await _dbContext.TakeCares.AddAsync(takeCare);
_ = await _dbContext.SaveChangesAsync();
return(takeCare);
}
public async Task <bool> StopSponcoringAChild(int sponcerID, int childId)
{
if (!await _dbContext.TakeCares.AnyAsync())
{
return(false);
}
TakeCare care = await _dbContext.TakeCares
.Where <TakeCare>(c => c.ChildID == childId && c.SponserID == sponcerID)
.FirstAsync();
if (care != null)
{
_ = _dbContext.TakeCares.Remove(care);
_ = await _dbContext.SaveChangesAsync();
return(true);
}
return(false);
}
public List <TakeCare> listStaff()
{
SqlConnection con = DbConnect.GetConnection();
con.Open();
string sql = "select accountID,role,staffName From Account where role='CareStaff'";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader();
List <TakeCare> list = new List <TakeCare>();
TakeCare tk = null;
while (dr.Read())
{
tk = new TakeCare();
tk.accountID = dr["accountID"].ToString();
tk.role = dr["role"].ToString();
tk.staffname = dr["staffName"].ToString();
list.Add(tk);
}
dr.Close();
return(list);
}
