public async Task <Response <SecretCodeDTO> > GetCommunitySecretKeysAndStreetFloorBySecretCode(string SecretCode) { Response <SecretCodeDTO> responceSecretCodeDTO = new Response <SecretCodeDTO>(); SecretCodeDTO secretCodeDTO = new SecretCodeDTO(); CommunitySecretCodes communitySecretKeys = await db.CommunitySecretKeys.Where(x => x.secretCode == SecretCode).Include(x => x.community).FirstOrDefaultAsync();; if (communitySecretKeys == null) { responceSecretCodeDTO.status = "Failed: SecretKey did not found"; responceSecretCodeDTO.model = null; return(responceSecretCodeDTO); } int communityID = communitySecretKeys.communityID; secretCodeDTO.community = (from l in db.Communities where l.communityID == communityID select l).AsNoTracking().FirstOrDefault(); secretCodeDTO.communityStreetFloor = (from l in db.CommunityStreetFloors where l.communityID == communityID select l).OrderByDescending(x => x.id).AsNoTracking().ToList(); responceSecretCodeDTO.status = "Success"; responceSecretCodeDTO.model = secretCodeDTO; return(responceSecretCodeDTO); }
public async Task <IHttpActionResult> DeleteCommunitySecretKeys(int id) { CommunitySecretCodes communitySecretKeys = await db.CommunitySecretKeys.FindAsync(id); if (communitySecretKeys == null) { return(NotFound()); } db.CommunitySecretKeys.Remove(communitySecretKeys); await db.SaveChangesAsync(); return(Ok(communitySecretKeys)); }
public async Task <Response <CommunitySecretCodes> > GetCommunitySecretKeysBySecretCode(string SecretCode) { Response <CommunitySecretCodes> responceCommunitySecretKeys = new Response <CommunitySecretCodes>(); CommunitySecretCodes communitySecretKeys = await db.CommunitySecretKeys.Where(x => x.secretCode == SecretCode).Include(x => x.community).FirstOrDefaultAsync();; if (communitySecretKeys == null) { responceCommunitySecretKeys.status = "Failed: SecretKey did not found"; responceCommunitySecretKeys.model = null; return(responceCommunitySecretKeys); } responceCommunitySecretKeys.status = "Success"; responceCommunitySecretKeys.model = communitySecretKeys; return(responceCommunitySecretKeys); }
public async Task <Response <CommunitySecretCodes> > GetCommunitySecretCode(int id) { Response <CommunitySecretCodes> responceCommunitySecretKeys = new Response <CommunitySecretCodes>(); CommunitySecretCodes communitySecretKeys = await db.CommunitySecretKeys.FindAsync(id); if (communitySecretKeys == null) { responceCommunitySecretKeys.status = "Failed: SecretKey did not found"; responceCommunitySecretKeys.model = null; return(responceCommunitySecretKeys); } responceCommunitySecretKeys.status = "Success"; responceCommunitySecretKeys.model = communitySecretKeys; return(responceCommunitySecretKeys); }
public async Task <Response <CommunitySecretCodes> > PutCommunitySecretCodes(int id, CommunitySecretCodes communitySecretKeys) { Response <CommunitySecretCodes> responceCommunitySecretKeys = new Response <CommunitySecretCodes>(); if (!ModelState.IsValid) { responceCommunitySecretKeys.status = "Failure"; responceCommunitySecretKeys.model = null; return(responceCommunitySecretKeys); } if (id != communitySecretKeys.id) { responceCommunitySecretKeys.status = "Failed: ID did not Match"; responceCommunitySecretKeys.model = null; return(responceCommunitySecretKeys); } db.Entry(communitySecretKeys).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CommunitySecretKeysExists(id)) { responceCommunitySecretKeys.status = "Failed: ID did not Exist"; responceCommunitySecretKeys.model = null; return(responceCommunitySecretKeys); } else { responceCommunitySecretKeys.status = "Failed: DB Update Exception"; responceCommunitySecretKeys.model = null; return(responceCommunitySecretKeys); } } responceCommunitySecretKeys.status = "Success"; responceCommunitySecretKeys.model = communitySecretKeys; return(responceCommunitySecretKeys); }
public async Task <Response <CommunitySecretCodes> > PostCommunitySecretCodes(CommunitySecretCodes communitySecretCodes) { Response <CommunitySecretCodes> responceCommunitySecretKeys = new Response <CommunitySecretCodes>(); if (!ModelState.IsValid) { responceCommunitySecretKeys.status = "Failure"; responceCommunitySecretKeys.model = null; return(responceCommunitySecretKeys); } db.CommunitySecretKeys.Add(communitySecretCodes); await db.SaveChangesAsync(); responceCommunitySecretKeys.status = "Success"; responceCommunitySecretKeys.model = communitySecretCodes; return(responceCommunitySecretKeys); }