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);
}
}
