public IActionResult SalvarRegistro(Registro r)
{
RegistroRepository repositorio = new RegistroRepository();
repositorio.Cadastra(r);
return(RedirectToAction("Index"));
}
public IActionResult Login(Registro r)
{
RegistroRepository rr = new RegistroRepository();
Registro registro = rr.QueryLogin(r);
if (registro != null)
{
ViewBag.Mensagem = "Você está logado";
HttpContext.Session.SetString("EMail", registro.EMail);
return(Redirect("Index"));
}
else
{
ViewBag.Mensagem = "Falha no Login";
return(View());
}
}
public RegistroController()
{
this.RegistroRepository = new RegistroRepository();
}
public RegistroService(RegistroRepository repository, TagRepository tagRepository)
{
this.repository = repository;
this.tagRepository = tagRepository;
}
public AppRolResultModel Serialize()
{
AppRolResultModel send = new AppRolResultModel();
string webMethodName = "Upload_AppRol";
try
{
//send.UploadAppRolResult = GetIsModified();
var client = new RestClient(SyncProperties.routeUpload);
//client.Authenticator = new HttpBasicAuthenticator(basicAuthUser, basicAuthPass);
var request = new RestRequest(Method.POST);
request.Resource = webMethodName;
request.RequestFormat = RestSharp.DataFormat.Json;
request.AddHeader("Content-type", "application/json");
//Body
MaxTableModel maximos = new MaxTableModel();
IRestResponse response = null;
RegistroRepository registroRepository = new RegistroRepository();
request.AddBody(new
{
param = send
});
response = client.Execute(request);
string res = response.Content;
}
catch (Exception)
{
}
return send;
}
public bool DownloadOnDemand(long lastDate, long IdPuntoMedicion)
{
bool x = false;
string webMethodName = "Download_CIRegistroOnDemand";
CiRegistroOnDemandResultModel list = new CiRegistroOnDemandResultModel();
RegistroRepository registroRepository = new RegistroRepository();
BodyContentOnDemand bodyContent = null;
try
{
bodyContent = GetBodyOnDemand(lastDate, IdPuntoMedicion);
//Desearilizar la respuestas
string jsonResponse = DownloadFactory.Instance.CallWebService(webMethodName, bodyContent);
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = Int32.MaxValue;
list = js.Deserialize<CiRegistroOnDemandResultModel>(jsonResponse);
if(list.Download_CIRegistroOnDemandResult!=null && list.Download_CIRegistroOnDemandResult.Count>0)
{
x = UpsertOnDemand(list.Download_CIRegistroOnDemandResult);
}
}
catch (Exception ex)
{
AppBitacoraRepository.Insert(new AppBitacoraModel() { Fecha = DateTime.Now, Metodo = ex.StackTrace, Mensaje = ex.Message });
}
return x;
}
/// <summary>
/// Logica de descarga e inserción de registros de servidor en base local
/// </summary>
/// <returns></returns>
public bool Download()
{
bool responseService = false;
string webMethodName = "Download_CIRegistroRecurrent";
CiRegistroRecurrentResultModel list = new CiRegistroRecurrentResultModel();
RegistroRepository registroRepository = new RegistroRepository();
long requestedFechaFin = 0;
long minFechaNumerica = 0;
try
{
//Obtener parámetros que se pasarán al servicio
RequestBodyContent bodyContent = this.GetBodyContent();
SQLLogger.Instance.log("BodyContent",bodyContent.ToString() );
requestedFechaFin = bodyContent.fechaFin;
minFechaNumerica = requestedFechaFin;
//Preparacion para bulk upsert
this.PrepareRecurrentBulkUpsert();
SQLLogger.Instance.log("PrepareBulk","Paso" );
while (requestedFechaFin <= minFechaNumerica)
{
//Desearilizar la respuestas
string jsonResponse = DownloadFactory.Instance.CallWebService(webMethodName, bodyContent);
SQLLogger.Instance.log("JsonResponse", jsonResponse);
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = Int32.MaxValue;
list = js.Deserialize<CiRegistroRecurrentResultModel>(jsonResponse);
SQLLogger.Instance.log("DeserealizaJson","Paso" );
//Obtener la fecha mas antigua de los datos recibidos
if (list.Download_CIRegistroRecurrentResult != null && list.Download_CIRegistroRecurrentResult.Count > 0)
{
//Insertar datos del servidor
this.BulkUpsertRecurrent(list.Download_CIRegistroRecurrentResult);
SQLLogger.Instance.log("BulkUpsert", "Paso");
minFechaNumerica = Int64.Parse(list.Download_CIRegistroRecurrentResult.Min(p => p.FechaNumerica).ToString().Substring(0, 8));
SQLLogger.Instance.log("FechaNuericaActual", "Paso");
//Restar un día a la fecha minima
if (minFechaNumerica.ToString().Length == 8)
{
DateTime dt = new DateTime(Int32.Parse(minFechaNumerica.ToString().Substring(0, 4)), Int32.Parse(minFechaNumerica.ToString().Substring(4, 2)), Int32.Parse(minFechaNumerica.ToString().Substring(6, 2)));
dt = dt.AddDays(-1);
SQLLogger.Instance.log("RestarDia", "Paso");
minFechaNumerica = Int64.Parse(String.Format("{0:yyyyMMdd}", dt));
bodyContent = this.GetBodyContent();
bodyContent.fechaActual = minFechaNumerica;
}
else
{
minFechaNumerica = 0;
}
}
else
{
minFechaNumerica = 0;
}
}
bool DataChanged = this.CommitBulkUpsertRecurrent();
SQLLogger.Instance.log("Commit", DataChanged.ToString());
if (DataChanged)
{
this.RaiseDidCiRegistroRecurrentDataChanged(DataChanged);
}
responseService = true;
}
catch (Exception ex)
{
//InsertLog(ex.Source.ToString(), ex.Message);
//Implementar bitácora
//throw ex;
SQLLogger.Instance.log("TryDownload", ex.Message);
}
return responseService;
}
public RegistroBusiness()
{
this.repositorio = new RegistroRepository();
}
