Exemple #1
0
        private PreRequest_Observation SetDataToObservation(int pPreRequest_id, string pObservation, string pUsu_document)
        {
            PreRequest_Observation Observation = new PreRequest_Observation();

            Observation.preReq_id              = pPreRequest_id;
            Observation.prObs_observation      = pObservation;
            Observation.usu_document           = pUsu_document;
            Observation.prObs_registrationDate = DateTime.Now;
            return(Observation);
        }
Exemple #2
0
 private bool InsertObservationInDB(PreRequest_Observation pPbservation)
 {
     try
     {
         using (BDRAEntities db = new BDRAEntities())
         {
             db.PreRequest_Observation.Add(pPbservation);
             db.SaveChanges();
             return(true);
         }
     }
     catch (Exception ex)
     {
         return(false);
     }
 }
Exemple #3
0
        public IHttpActionResult UpdatePreRequest(PreRequestViewModel pPreRequest)
        {
            try
            {
                ResponseViewModel rta = new ResponseViewModel();

                using (BDRAEntities db = new BDRAEntities())
                {
                    //TODO: Update client
                    var preRequestBD = db.PreRequest.Where(p => p.preReq_id == pPreRequest.id).FirstOrDefault();
                    preRequestBD.firstCanal_id  = pPreRequest.firstCanal.id;
                    preRequestBD.secondCanal_id = pPreRequest.secondCanal.id;
                    preRequestBD.sta_id         = pPreRequest.stateRequest.id;

                    if (pPreRequest.vehicleModel.id != null && pPreRequest.vehicleModel.id != 0)
                    {
                        preRequestBD.vehMdl_id = pPreRequest.vehicleModel.id;
                    }
                    else
                    {
                        var vechicleModel  = VehicleModelController.SetDataToVehicleModel(pPreRequest.vehicleModel);
                        var vehicleModelDB = VehicleModelController.CreateVehicleModelInDB(vechicleModel);
                        preRequestBD.vehMdl_id = vehicleModelDB.id;
                    }

                    preRequestBD.preCli_id = pPreRequest.preClient.idPreClient;
                    db.SaveChanges();

                    if (pPreRequest.lsObservation[0].observation != "")
                    {
                        int idPreRequest = int.Parse(pPreRequest.id.ToString());
                        PreRequest_Observation observation = this.SetDataToObservation(idPreRequest, pPreRequest.lsObservation[0].observation, pPreRequest.user.id);
                        this.InsertObservationInDB(observation);
                    }

                    rta.response = true;
                    rta.message  = "Se ha actualizado la solicitud: " + pPreRequest.id;

                    return(Ok(rta));
                }
            }
            catch (Exception ex)
            {
                return(BadRequest(ex.Message));
            }
        }
Exemple #4
0
        public IHttpActionResult AddNewPreRequest(PreRequestViewModel pPreRequest)
        {
            try
            {
                this.objPreClientController = new PreClientController();
                ResponseViewModel rta = new ResponseViewModel();

                using (BDRAEntities db = new BDRAEntities())
                {
                    /*
                     *              Validamos si el PreCliente de la solicitud ya existe en la base de datos.
                     */

                    PreClient PreClientBD = new PreClient();

                    PreClientBD = objPreClientController.GetPreClientBD(pPreRequest.preClient);

                    if (PreClientBD == null)
                    {
                        PreClientBD = objPreClientController.SetDataToPreClient(pPreRequest.preClient, pPreRequest.user);
                        var preClientCreated = objPreClientController.CreatePreClientInBD(PreClientBD);
                        if (preClientCreated)
                        {
                            PreClientBD = objPreClientController.GetPreClientBD(pPreRequest.preClient);
                        }
                    }


                    PreRequest oPreRequest = new PreRequest();
                    oPreRequest.preReq_registrationDate = DateTime.Now;
                    oPreRequest.preCli_id    = PreClientBD.preCli_id;
                    oPreRequest.preReq_state = true;
                    oPreRequest.usu_document = pPreRequest.user.id;

                    if (pPreRequest.vehicleModel.id != null && pPreRequest.vehicleModel.id != 0)
                    {
                        oPreRequest.vehMdl_id = pPreRequest.vehicleModel.id;
                    }
                    else
                    {
                        var vechicleModel  = VehicleModelController.SetDataToVehicleModel(pPreRequest.vehicleModel);
                        var vehicleModelDB = VehicleModelController.CreateVehicleModelInDB(vechicleModel);
                        oPreRequest.vehMdl_id = vehicleModelDB.id;
                    }
                    if (pPreRequest.stateRequest != null)
                    {
                        oPreRequest.sta_id = pPreRequest.stateRequest.id;
                    }
                    if (pPreRequest.firstCanal != null)
                    {
                        oPreRequest.firstCanal_id = pPreRequest.firstCanal.id;
                    }
                    if (pPreRequest.secondCanal != null)
                    {
                        oPreRequest.secondCanal_id = pPreRequest.secondCanal.id;
                    }


                    db.PreRequest.Add(oPreRequest);
                    db.SaveChanges();

                    var lastRequest = GetTheLastPreRequestByPreClient(PreClientBD);

                    if (pPreRequest.lsObservation[0].observation != "")
                    {
                        PreRequest_Observation observation = this.SetDataToObservation(lastRequest.preReq_id, pPreRequest.lsObservation[0].observation, pPreRequest.user.id);
                        this.InsertObservationInDB(observation);
                    }


                    rta.response = true;
                    rta.message  = "Se ha creado la pre solicitud: " + lastRequest.preReq_id + " de cliente de persona natural";

                    return(Ok(rta));
                }
            }
            catch (Exception ex)
            {
                return(BadRequest(ex.Message));
            }
        }