public ExperienciaVO Get(int idExperiencia)
{
ExperienciaVO experienciaVO = null;
DbCommand command = db.GetStoredProcCommand("dbo.DW_ExperienciaSelect");
db.AddInParameter(command, "@IdExperiencia", DbType.Int32, idExperiencia);
using (IDataReader reader = db.ExecuteReader(command))
{
if (reader.Read())
{
experienciaVO = new ExperienciaVO();
experienciaVO.IsPersisted = true;
if (!reader.IsDBNull(reader.GetOrdinal("IdExperiencia")))
experienciaVO.IdExperiencia = reader.GetInt32(reader.GetOrdinal("IdExperiencia"));
if (!reader.IsDBNull(reader.GetOrdinal("Funcao")))
experienciaVO.Funcao = reader.GetString(reader.GetOrdinal("Funcao")).Trim();
if (!reader.IsDBNull(reader.GetOrdinal("Descricao")))
experienciaVO.Descricao = reader.GetString(reader.GetOrdinal("Descricao")).Trim();
if (!reader.IsDBNull(reader.GetOrdinal("PeriodoDe")))
experienciaVO.PeriodoDe = reader.GetDateTime(reader.GetOrdinal("PeriodoDe"));
if (!reader.IsDBNull(reader.GetOrdinal("PeriodoAte")))
experienciaVO.PeriodoAte = reader.GetDateTime(reader.GetOrdinal("PeriodoAte"));
if (!reader.IsDBNull(reader.GetOrdinal("Empresa")))
experienciaVO.Empresa = reader.GetString(reader.GetOrdinal("Empresa")).Trim();
}
}
return experienciaVO;
}
public async Task <ActionResult> registraExperiencia(ExperienciaVO datos) //metodo asincrono
{
if (ModelState.IsValid)
{
if (datos.RegistroExperiencia() == false)
{
ViewBag.Message = "No se registro la experiencia";
return(View("registraExperiencia", datos));
}
else
{
ViewBag.Message = "Se registro la experiencia de manera correcta";
return(View("registraExperiencia"));
}
}
else
{
ViewBag.Message = "No se registro el usuario correctamente";
return(View("registraExperiencia"));
}
}
public ExperienciaVOCollection GetAll()
{
ExperienciaVOCollection listaExperienciaVO = new ExperienciaVOCollection();
ExperienciaVO experienciaVO = null;
DbCommand command = db.GetStoredProcCommand("dbo.DW_ExperienciaSelectAll");
using (IDataReader reader = db.ExecuteReader(command))
{
while (reader.Read())
{
experienciaVO = new ExperienciaVO();
experienciaVO.IsPersisted = true;
if (!reader.IsDBNull(reader.GetOrdinal("IdExperiencia")))
experienciaVO.IdExperiencia = reader.GetInt32(reader.GetOrdinal("IdExperiencia"));
if (!reader.IsDBNull(reader.GetOrdinal("Funcao")))
experienciaVO.Funcao = reader.GetString(reader.GetOrdinal("Funcao")).Trim();
if (!reader.IsDBNull(reader.GetOrdinal("Descricao")))
experienciaVO.Descricao = reader.GetString(reader.GetOrdinal("Descricao")).Trim();
if (!reader.IsDBNull(reader.GetOrdinal("PeriodoDe")))
experienciaVO.PeriodoDe = reader.GetDateTime(reader.GetOrdinal("PeriodoDe"));
if (!reader.IsDBNull(reader.GetOrdinal("PeriodoAte")))
experienciaVO.PeriodoAte = reader.GetDateTime(reader.GetOrdinal("PeriodoAte"));
if (!reader.IsDBNull(reader.GetOrdinal("Empresa")))
experienciaVO.Empresa = reader.GetString(reader.GetOrdinal("Empresa")).Trim();
listaExperienciaVO.Add(experienciaVO);
}
}
return listaExperienciaVO;
}
private void ValidateRequiredAttributes(ExperienciaVO experienciaVO, bool validateGuidOnPK)
{
if (experienciaVO.IdExperiencia == null)
RegisterCriticalMessageRequiredField("IdExperiencia");
if (string.IsNullOrEmpty(experienciaVO.Funcao))
RegisterCriticalMessageRequiredField("Funcao");
if (string.IsNullOrEmpty(experienciaVO.Descricao))
RegisterCriticalMessageRequiredField("Descricao");
if (experienciaVO.PeriodoDe == null)
RegisterCriticalMessageRequiredField("PeriodoDe");
if (experienciaVO.PeriodoAte == null)
RegisterCriticalMessageRequiredField("PeriodoAte");
if (string.IsNullOrEmpty(experienciaVO.Empresa))
RegisterCriticalMessageRequiredField("Empresa");
if (ex != null)
throw ex;
}
public void Update(ExperienciaVO experienciaVO)
{
ValidateRequiredAttributes(experienciaVO, true);
DbCommand command = db.GetStoredProcCommand("dbo.DW_ExperienciaUpdate");
db.AddInParameter(command, "@IdExperiencia", DbType.Int32, experienciaVO.IdExperiencia);
db.AddInParameter(command, "@Funcao", DbType.AnsiString, experienciaVO.Funcao);
db.AddInParameter(command, "@Descricao", DbType.AnsiString, experienciaVO.Descricao);
db.AddInParameter(command, "@PeriodoDe", DbType.DateTime, experienciaVO.PeriodoDe);
db.AddInParameter(command, "@PeriodoAte", DbType.DateTime, experienciaVO.PeriodoAte);
db.AddInParameter(command, "@Empresa", DbType.AnsiString, experienciaVO.Empresa);
db.ExecuteNonQuery(command);
}
public ExperienciaVOCollection GetAllPaged(long startRowIndex, int maximumRows)
{
ExperienciaVOCollection listaExperienciaVO = new ExperienciaVOCollection();
ExperienciaVO experienciaVO = null;
DbCommand command = db.GetStoredProcCommand("dbo.DW_ExperienciaSelectAllPaged");
db.AddInParameter(command, "@startRowIndex", DbType.Int64, startRowIndex);
db.AddInParameter(command, "@maximumRows", DbType.Int64, maximumRows);
using (IDataReader reader = db.ExecuteReader(command))
{
while (reader.Read())
{
if (listaExperienciaVO.Count == 0) listaExperienciaVO.TotalRows = int.Parse(reader.GetValue(reader.GetOrdinal("TotalRows")).ToString());
experienciaVO = new ExperienciaVO();
experienciaVO.IsPersisted = true;
if (!reader.IsDBNull(reader.GetOrdinal("IdExperiencia")))
experienciaVO.IdExperiencia = reader.GetInt32(reader.GetOrdinal("IdExperiencia"));
if (!reader.IsDBNull(reader.GetOrdinal("Funcao")))
experienciaVO.Funcao = reader.GetString(reader.GetOrdinal("Funcao")).Trim();
if (!reader.IsDBNull(reader.GetOrdinal("Descricao")))
experienciaVO.Descricao = reader.GetString(reader.GetOrdinal("Descricao")).Trim();
if (!reader.IsDBNull(reader.GetOrdinal("PeriodoDe")))
experienciaVO.PeriodoDe = reader.GetDateTime(reader.GetOrdinal("PeriodoDe"));
if (!reader.IsDBNull(reader.GetOrdinal("PeriodoAte")))
experienciaVO.PeriodoAte = reader.GetDateTime(reader.GetOrdinal("PeriodoAte"));
if (!reader.IsDBNull(reader.GetOrdinal("Empresa")))
experienciaVO.Empresa = reader.GetString(reader.GetOrdinal("Empresa")).Trim();
listaExperienciaVO.Add(experienciaVO);
}
}
listaExperienciaVO.PageSize = maximumRows;
return listaExperienciaVO;
}
