public static void InsertLotti(Lotti lotto)
{
using (var db = new BusinessLogic.Context.Context())
{
lotto.DataCarico = DateTime.Today;
db.lotti.Add(lotto);
db.SaveChanges();
}
}
public JsonResult setLotti(Lotti lotto)
{
if (lotto.Desc == null)
{
return(Json("ko", JsonRequestBehavior.AllowGet));
}
Insert.InsertLotti(lotto);
return(Json("ok", JsonRequestBehavior.AllowGet));
}
async void OnLottoSearchClicked(object sender, System.EventArgs e)
{
if (string.IsNullOrWhiteSpace(rig_.rig_art))
{
return;
}
//
// Verifichiamo che ci siano lotti per l'articolo
//
var cod_art = rig_.rig_art;
string sql = "SELECT COUNT(*) FROM lotti1 WHERE lot_stop IS NULL AND lot_start IS NOT NULL AND lot_codice = " + cod_art.SqlQuote(false);
var recTotal_ = await dbcon_.ExecuteScalarAsync <int>(sql);
if (recTotal_ == 0)
{
await DisplayAlert("Attenzione!", "Non ci sono lotti per l'articolo indicato", "OK");
return;
}
var page = new LottiSearch(rig_.rig_art);
page.LotList.ItemDoubleTapped += async(source, args) =>
{
Lotti lotti = (Lotti)args.ItemData;
change_ = true;
rig_.rig_gest_lotto = 1;
rig_.rig_lotto = lotti.lot_lotto;
rig_.rig_scadenza = lotti.lot_scadenza;
await Navigation.PopModalAsync();
SetField();
change_ = false;
};
await Navigation.PushModalAsync(page);
}
