public void GetProducts()
{
try
{
ProductDataBase productDatabase = new ProductDataBase();
var products = productDatabase.getCursos().Result;
if (products != null && products.Count > 0)
{
Cursos = new ObservableCollection <CursoxProfe>();
foreach (var prod in products)
{
if (prod.id == product.id)
{
Cursos.Add(new CursoxProfe
{
num = prod.num,
nombre = prod.nombre,
IsVisible = false,
id = prod.id
});
}
}
}
}
catch (Exception ex)
{
}
}
public void GetProducts()
{
try
{
ProductDataBase productDatabase = new ProductDataBase();
var products = productDatabase.getProfesor().Result;
if (products != null && products.Count > 0)
{
lstProducts = new ObservableCollection <Profesor>();
foreach (var prod in products)
{
lstProducts.Add(new Profesor
{
id = prod.id,
nombre = prod.nombre,
apellidos = prod.apellidos,
telefono = prod.telefono,
email = prod.email,
password = prod.password
});
}
}
}
catch (Exception ex)
{
}
}
public IActionResult GetProducts(int PageSize, int PageNumber)
{
var products = _productServices.GetProducts(PageSize, PageNumber);
if (products == null)
{
return(null);
}
ProductList model = new ProductList();
model.Page_Number = PageNumber;
model.Page_Size = PageSize;
foreach (var item in products)
{
ProductDataBase pd = new ProductDataBase();
pd.Id = item.Code;
pd.Creator = item.Creator;
pd.Image_Url = item.Image_Url;
pd.Status = item.Status.ToString();
if (model.Items == null)
{
model.Items = new List <ProductDataBase>();
}
model.Items.Add(pd);
}
return(Ok(model.ToJson()));
}
public async void Agregar()
{
try
{
var user = new User();
ProductDataBase productDatabase = new ProductDataBase();
if (product.nombre == "" || product.apellidos == "" || product.id == 0 || product.email == "" || product.password == "" || product.telefono == 0)
{
lblInfo = "Todos los datos del formulario deben llenarse correctamente";
ClearProduct();
}
else
{
bool find = productDatabase.findProfe(product);
if (find == true && btnSaveLabel.Equals("Agregar"))
{
lblInfo = "Profesor ya Existe";
ClearProduct();
}
else
{
int i = productDatabase.saveProduct(product).Result;
user.UserName = product.nombre;
user.Email = product.email;
user.Password = product.password;
product.idU = user.ID;
Profesor aux = product;
if (await App.Database.SaveNoteAsync(user) == 1)
{
if (i == 1)
{
if (btnSaveLabel.Equals("Agregar"))
{
ClearProduct();
await Navigation.PushAsync(new ListCursosPage(aux));
}
else
{
ClearProduct();
await Navigation.PushAsync(new ListProfesores());
}
}
else
{
lblInfo = "Ocurrio un problema y no se pudo guardar el Profesor";
}
}
}
}
}
catch (Exception ex)
{
}
}
public void Update(ProductDataBase product)
{
TotalCount++;
if (product.Status == ProductStatus.OK)
{
OKCount++;
}
else
{
NGCount++;
}
}
public void DeleteProduct(CursoxProfe product)
{
try
{
ProductDataBase productDatabase = new ProductDataBase();
var result = productDatabase.deleteCurso(product).Result;
if (result == 1)
{
GetProducts();
}
}
catch (Exception ex)
{
}
}
public void DeleteProduct(Profesor product)
{
try
{
ProductDataBase productDatabase = new ProductDataBase();
var result = productDatabase.deleteProduct(product).Result;
if (result == 1)
{
GetProducts();
}
}
catch (Exception ex)
{
throw new Exception(ex.StackTrace);
}
}
private async void Button_ClickedAsync(object sender, System.EventArgs e)
{
cx.id = aux.id;
cx.nombre = c.Name;
try
{
ProductDataBase productDatabase = new ProductDataBase();
int i = productDatabase.saveCurso(cx);
if (i == 1)
{
await DisplayAlert("Correcto", "Curso Asignado con Exito", "Continuar");
}
}
catch (Exception ex)
{
await DisplayAlert("Lo Sentimos", "Curso no Asignado o Ya Existe", "OK");
}
await Navigation.PushAsync(new ListCursosPage(aux));
}
private async void Button_ClickedAsync_1(object sender, System.EventArgs e)
{
u = App.Database.getUser(p.idU);
await App.Database.DeleteNoteAsync(u);
try
{
if (p.id != 0)
{
var result = await DisplayAlert("Confirm", "Seguro que quieres eliminar a: " + p.nombre + "? ", "Si", "No");
if (result)
{
lt.DeleteProduct(p);
ProductDataBase dataBase = new ProductDataBase();
var list = dataBase.getCursos().Result;
foreach (var prod in list)
{
if (prod.id == p.id)
{
CursoxProfe aux = new CursoxProfe();
aux.num = prod.num;
aux.nombre = prod.nombre;
aux.IsVisible = prod.IsVisible;
aux.id = prod.id;
_ = dataBase.deleteCurso(aux);
}
}
}
}
}
catch (Exception ex)
{
}
await Navigation.PushAsync(new ListProfesores());
}
