public IHttpActionResult addRequest(RequestViewModel pRequest) { try { ResponseViewModel response = new ResponseViewModel(); using (BDRAEntities db = new BDRAEntities()) { Request oRequest = new Request(); oRequest.rqt_registrationDate = DateTime.Now; oRequest.rqt_firstVisitDate = pRequest.initialDate; oRequest.rqt_lastVisitDate = pRequest.lastDate; oRequest.prb_id = pRequest.probability.id; oRequest.cli_document = pRequest.client.id; oRequest.usu_document = pRequest.user.id; oRequest.rqt_primaryState = pRequest.parentState.id; oRequest.rqt_secondState = pRequest.childState.id; oRequest.rqt_state = true; if (pRequest.contact != null) { if (pRequest.contact.id != 0) { oRequest.cnt_id = pRequest.contact.id; } } oRequest.cnl_id = pRequest.canal.id; oRequest.rqt_observation = pRequest.observation; db.Request.Add(oRequest); db.SaveChanges(); var lastRequest = db.Request.Where(r => r.cli_document == pRequest.client.id) .OrderByDescending(r => r.rqt_registrationDate) .Select(r => new RequestViewModel { id = r.rqt_id }) .FirstOrDefault(); riskInformationByRequest riskInformation = new riskInformationByRequest(); riskInformation.rqt_id = lastRequest.id; riskInformation.ribr_ammountApproved = 0; riskInformation.ribr_state = true; db.riskInformationByRequest.Add(riskInformation); db.SaveChanges(); operationalInformationByRequest operationalInformation = new operationalInformationByRequest(); operationalInformation.rqt_id = lastRequest.id; operationalInformation.oibr_deliveredAmmount = 0; operationalInformation.oibr_deliveredVehicles = 0; operationalInformation.oibr_state = true; db.operationalInformationByRequest.Add(operationalInformation); db.SaveChanges(); response.response = true; response.message = "Se crea la solicitud N° " + lastRequest.id; return(Ok(response)); } } catch (Exception e) { return(BadRequest(e.Message)); throw; } }
public void CreateRequests(List <RequestViewModel> lsRequests, string separator, string headers, out List <string> lsDataErrorRqt) { lsDataErrorRqt = new List <string>(); int cont = 1; try { using (BDRAEntities db = new BDRAEntities()) { foreach (var rqt in lsRequests) { try { Console.WriteLine("Registro BD #: " + cont); Request oRqt = new Request(); oRqt.rqt_registrationDate = rqt.registrationDate.Value; oRqt.rqt_firstVisitDate = rqt.initialDate.Value; oRqt.rqt_lastVisitDate = rqt.lastDate.Value; oRqt.prb_id = rqt.probability.id; oRqt.rqt_primaryState = rqt.parentState.id; oRqt.rqt_secondState = rqt.childState.id; oRqt.cli_document = rqt.client.id; oRqt.usu_document = rqt.user.id; oRqt.cnt_id = rqt.contact.id; oRqt.rqt_state = true; db.Request.Add(oRqt); db.SaveChanges(); var lastRequest = db.Request.Where(r => r.cli_document == rqt.client.id) .OrderByDescending(r => r.rqt_registrationDate) .Select(r => new RequestViewModel { id = r.rqt_id }) .FirstOrDefault(); riskInformationByRequest riskInformation = new riskInformationByRequest(); riskInformation.rqt_id = lastRequest.id; riskInformation.ribr_ammountApproved = 0; riskInformation.ribr_state = true; db.riskInformationByRequest.Add(riskInformation); db.SaveChanges(); operationalInformationByRequest operationalInformation = new operationalInformationByRequest(); operationalInformation.rqt_id = lastRequest.id; operationalInformation.oibr_deliveredAmmount = 0; operationalInformation.oibr_deliveredVehicles = 0; operationalInformation.oibr_state = true; db.operationalInformationByRequest.Add(operationalInformation); db.SaveChanges(); cont++; } catch (Exception ex) { Console.WriteLine(ex.Message); cont++; continue; } } } } catch (Exception ex) { Console.WriteLine(ex.Message); } }