public IHttpActionResult savePermit([FromBody] contract_permits contract_permit) { try { //verify if the permit exist var query = from datos in fmp.contract_permits where datos.number_registered.Equals(contract_permit.number_registered) select datos; if (query.Count() > 0) { return(Ok("EXIST")); } else { fmp.contract_permits.Add(contract_permit); fmp.SaveChanges(); return(Ok(contract_permit.id)); } } catch (Exception ex) { return(InternalServerError(ex)); } }
public IHttpActionResult updatePermit(string number_registered, [FromBody] contract_permits contract_permit) { if (!string.IsNullOrEmpty(number_registered)) { var queryPermit = from datos in fmp.contract_permits where datos.number_registered.Equals(number_registered) select datos; if (queryPermit.Count() > 0) { queryPermit.FirstOrDefault().organization_name = contract_permit.organization_name; queryPermit.FirstOrDefault().telephone = contract_permit.telephone; queryPermit.FirstOrDefault().mailing_address = contract_permit.mailing_address; queryPermit.FirstOrDefault().authorized_organization_name = contract_permit.authorized_organization_name; queryPermit.FirstOrDefault().permit_start_date = contract_permit.permit_start_date; queryPermit.FirstOrDefault().permit_end_date = contract_permit.permit_end_date; fmp.SaveChanges(); return(Ok(1)); } } return(Ok()); }