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));
}
}
public IHttpActionResult Get()
{
try
{
using (BDRAEntities db = new BDRAEntities())
{
var lsPreRequest = db.STRPRC_GET_ALL_PRE_REQUEST();
var lsPreRequestResponse = new List <PreRequestViewModel>();
foreach (var preRequestBD in lsPreRequest)
{
PreRequestViewModel preRequest = new PreRequestViewModel();
preRequest.id = preRequestBD.code;
preRequest.preClient = new PreClientViewModel();
preRequest.preClient.name = preRequestBD.name;
preRequest.preClient.lastName = preRequestBD.lastName;
preRequest.preClient.cellPhone = preRequestBD.cellphone;
preRequest.preClient.email = preRequestBD.email;
preRequest.vehicleModel = new VehicleModelViewModel();
preRequest.vehicleModel.name = preRequestBD.vehicleModel;
preRequest.stateRequest = new StateViewModel();
preRequest.stateRequest.description = preRequestBD.state;
preRequest.firstCanal = new CanalViewModel();
preRequest.firstCanal.description = preRequestBD.firstCanal;
preRequest.secondCanal = new CanalViewModel();
preRequest.secondCanal.description = preRequestBD.secondCanal;
preRequest.registrationDate = preRequestBD.registrationDate;
lsPreRequestResponse.Add(preRequest);
}
return(Ok(lsPreRequestResponse));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult GetPreRequestByFilter(string pKindOfFilter, string pValue)
{
try
{
List <PreRequestViewModel> lsPreRequestResponse = new List <PreRequestViewModel>();
using (BDRAEntities db = new BDRAEntities())
{
var lsPreRequestBd = db.STRPRC_GET_PRE_REQUEST_BY_FILTER_VALUE(pKindOfFilter, pValue);
foreach (var preRequestDB in lsPreRequestBd)
{
PreRequestViewModel preRequest = new PreRequestViewModel();
preRequest.id = int.Parse(preRequestDB.code);
preRequest.preClient = new PreClientViewModel();
preRequest.preClient.name = preRequestDB.name;
preRequest.preClient.lastName = preRequestDB.lastName;
preRequest.preClient.cellPhone = preRequestDB.cellphone;
preRequest.preClient.email = preRequestDB.email;
preRequest.vehicleModel = new VehicleModelViewModel();
preRequest.vehicleModel.name = preRequestDB.vehicleModel;
preRequest.stateRequest = new StateViewModel();
preRequest.stateRequest.description = preRequestDB.state;
preRequest.firstCanal = new CanalViewModel();
preRequest.firstCanal.description = preRequestDB.firstCanal;
preRequest.secondCanal = new CanalViewModel();
preRequest.secondCanal.description = preRequestDB.secondCanal;
preRequest.registrationDate = preRequestDB.registrationDate;
lsPreRequestResponse.Add(preRequest);
}
}
return(Ok(lsPreRequestResponse));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
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));
}
}
