public static PersonalList Get()
{
PersonalList res = new PersonalList();
SqlCommand cmd = null;
SqlDataReader dr = null;
string query = "SELECT * FROM Personal";
try
{
cmd = Methods.CreateBasicCommand(query);
dr = Methods.ExecuteDataReaderCommand(cmd);
while (dr.Read())
{
int idPersona = dr.GetInt32(0);
Persona persona = PersonaDal.Get(idPersona);
res.Add(new Personal()
{
IdPersona = idPersona,
Ci = persona.Ci,
Nombre = persona.Nombre,
PrimerApellido = persona.PrimerApellido,
SegundoApellido = persona.SegundoApellido,
Sexo = persona.Sexo,
FechaNacimiento = persona.FechaNacimiento,
Correos = persona.Correos,
Usuario = persona.Usuario,
Direcciones = persona.Direcciones,
Telefonos = persona.Telefonos,
Borrado = persona.Borrado,
CodPersonal = dr.GetString(1),
FechaIngreso = dr.GetDateTime(2),
Cargo = CargoDal.Get(dr.GetInt32(3)),
Sueldo = dr.GetDecimal(4)
});
}
}
catch (SqlException ex)
{
//Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace);
throw ex;
}
catch (Exception ex)
{
//Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace);
throw ex;
}
finally
{
cmd.Connection.Close();
}
return(res);
}
} //!! PersonalList is actually referring to my PUBLIC list of books that will be selected so please use your public books list table in place of PersonalList
public void OnGet()
{
// Connect to Database
DBConnection dbstring = new DBConnection();
string DBConnection = dbstring.DbString();
SqlConnection conn = new SqlConnection(DBConnection);
conn.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = conn;
PublicBooks = new List <PersonalList>();
command.CommandText = @"SELECT * FROM PersonalList ORDER BY BookTitle ASC"; //Uses all books in PersonalList table to show them to the screen
if (!string.IsNullOrEmpty(SearchTerm))
{
command.CommandText += " WHERE (BookTitle LIKE '%' + @BKTitle) OR (BookTitle LIKE @BKTitle + '%') OR (BookTitle LIKE '%' + @BKTitle + '%') ORDER BY BookTitle ASC";
command.Parameters.AddWithValue("@BKTitle", (SearchTerm));
}
isLoan = new List <bool> {
false
};
SqlDataReader reader = command.ExecuteReader();
PublicBooks = new List <PersonalList>();
while (reader.Read())
{
PersonalList rec = new PersonalList();
rec.BookID = reader.GetInt32(1);
Console.WriteLine(rec.BookID);
rec.BookTitle = reader.GetString(2);
rec.Author = reader.GetString(3);
rec.Genre = reader.GetString(4);
rec.Price = reader.GetFloat(5);
PublicBooks.Add(rec);
}
reader.Close();
}
//return Page();
isLoan = new List <bool> {
};
for (int i = 0; i < PublicBooks.Count; i++)
{
isLoan.Add(false);
}
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
PersonalList = await _context.PersonalList.FirstOrDefaultAsync(m => m.Id == id);
if (PersonalList == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
PersonalList = await _context.PersonalList.FindAsync(id);
if (PersonalList != null)
{
_context.PersonalList.Remove(PersonalList);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
/// <summary>
/// Obtiene la lista de personal
/// </summary>
/// <returns>Categoria Lista</returns>
public static PersonalList Get()
{
PersonalList lista = null;
try
{
lista = PersonalListDal.Get();
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(lista);
}
public async Task AddRestaurantAndAttachToUser(int loginId, string restaurantName)
{
var user = await _lunchItContext.Logins.FirstOrDefaultAsync(d => d.Id == loginId);
var restaurant = new Restaurant()
{
Name = restaurantName
};
_lunchItContext.Restaurants.Add(restaurant);
var personalList = new PersonalList()
{
Login = user,
Restaurant = restaurant
};
_lunchItContext.PersonalLists.Add(personalList);
await _lunchItContext.SaveChangesAsync();
}
