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