static public ECompanyProposal GetByID(string id) { using (var context = new SMySQLContext()) { ECompanyProposal eCompanyProposal = context.CompanyProposals.SingleOrDefault(x => x.id == id); return(eCompanyProposal); } }
static public async Task <bool> Remove(string id) { using (var context = new SMySQLContext()) { ECompanyProposal eCompanyProposal = context.CompanyProposals.SingleOrDefault(x => x.id == id); if (eCompanyProposal == null) { return(false); } context.Remove(eCompanyProposal); await context.SaveChangesAsync(); return(true); } }
//=====================================================GETS ABOVE===================================================== #region Save static public async Task <string> Save(ECompanyProposal eProposal) { eProposal.modificationDateUTC = DateTime.UtcNow; using (var context = new SMySQLContext()) { if (string.IsNullOrEmpty(eProposal.id)) { eProposal.id = Guid.NewGuid().ToString(); eProposal.creationDateUTC = DateTime.UtcNow; var e = await context.CompanyProposals.AddAsync(eProposal); await context.SaveChangesAsync(); return(e.Entity.id); } else { var e = context.CompanyProposals.Update(eProposal); await context.SaveChangesAsync(); return(e.Entity.id); } } }
public async Task <IActionResult> Save([FromBody] ECompanyProposal eProposal) { var result = await SCompaniesProposals.Save(eProposal); return(Ok(result)); }