public void BulkUpsertUploadedTest()
{
//Creaer objeto
CiRegistroRepository crr=new CiRegistroRepository();
Model.RegistroModel rm = new Model.RegistroModel(){IdRegistro=20130515135610664,IdPuntoMedicion=1022,FechaCaptura= new DateTime(2013,5,15,2,0,0),HoraRegistro=1356,DiaRegistro=15,Valor=2.21,AccionActual="prueba",IsActive=true,IsModified=false,LastModifiedDate=20130515143505728,IdCondicion=1,ServerLastModifiedDate=0,FechaNumerica=201403091657};
//Crear parámetros de prueba
List<Model.CiRegistroPOCO> registros = new List<Model.CiRegistroPOCO>();
for (int i = 0; i < 5000; i++)
{
registros.Add(new Model.CiRegistroPOCO()
{
IdRegistro = rm.IdRegistro + i,
IdPuntoMedicion = rm.IdPuntoMedicion,
DiaRegistro = rm.DiaRegistro,
Valor = rm.Valor,
AccionActual = rm.AccionActual,
HoraRegistro = rm.HoraRegistro,
IsActive = rm.IsActive,
IsModified = rm.IsModified,
LastModifiedDate = rm.LastModifiedDate,
IdCondicion = rm.IdCondicion,
ServerLastModifiedDate = (long)( (rm.ServerLastModifiedDate == null) ? 0 : rm.ServerLastModifiedDate),
FechaNumerica = Int64.Parse(String.Format("{0:yyyyMMddHHmm}", rm.FechaCaptura.AddHours(i)))
});
}
//Llamar al método
crr.UpsertUploaded(registros);
}
public List<CiRegistroUploadConfirmationModel> Upload_CiRegistro(CiRegistroUploadModel param)
{
List<CiRegistroUploadConfirmationModel> response = null;
try
{
if (param != null && param.CiRegistro != null && param.CiRegistro.Count > 0)
{
CiRegistroRepository crr = new CiRegistroRepository();
response=crr.UpsertUploaded(param.CiRegistro);
}
}
catch (Exception ex)
{
throw;
}
return response;
}
public System.Collections.Generic.List<Server.DAL.POCOS.sp_ConsultaDemand_Result> Download_ConsultaDemmand(long fecha)
{
System.Collections.Generic.List<Server.DAL.POCOS.sp_ConsultaDemand_Result> items = new System.Collections.Generic.List<Server.DAL.POCOS.sp_ConsultaDemand_Result>();
try
{
CiRegistroRepository repository = new CiRegistroRepository();
items = repository.GetConsultaDemmand(fecha);
}
catch (Exception)
{
}
return items;
}
