コード例 #1
0
        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));
            }
        }
コード例 #2
0
        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());
        }