internal async Task <bool> UpdateModelInInventory(PC_MsInwentory towar)
{
// $@"cdn.PC_WykonajSelect N'Select * from cdn.PC_MsPolozenie where PlaceTwrNumer={msi.Twr_Gidnumer} and PlaceTrnNumer= {msi.MsI_TrnNumer}'";
bool done = false;
try
{
var data = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var sqlInsert = $@"cdn.PC_WykonajSelect N'Update [CDN].[PC_MsInwentory] set MsI_TwrIloscSkan= {towar.MsI_TwrIloscSkan}
where MsI_TrnNumer={towar.MsI_TrnNumer} and MsI_TwrNumer={towar.MsI_TwrNumer}
'";
await App.TodoManager.PobierzDaneZWeb <PC_MsInwentory>(sqlInsert);
}
catch (Exception)
{
throw;
}
finally
{
done = true;
}
//var Webquery = $@"cdn.PC_WykonajSelect N'Select * from cdn.PC_MsPolozenie where PlaceTwrNumer={msi.Twr_Gidnumer} '";
//var dane = await App.TodoManager.PobierzDaneZWeb<Place>(Webquery);
//return IsAddRow;
return(done);
}
internal async Task <bool> UpdateModelInPlace(PC_MsInwentory towar, string place)
{
// $@"cdn.PC_WykonajSelect N'Select * from cdn.PC_MsPolozenie where PlaceTwrNumer={msi.Twr_Gidnumer} and PlaceTrnNumer= {msi.MsI_TrnNumer}'";
bool done = false;
string sqlInsert = "";
try
{
var data = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (towar.MsI_TrnNumer == 1)
{
sqlInsert = $@"cdn.PC_WykonajSelect N'Update cdn.PC_MsPolozenie set PlaceQuantity+= {towar.MsI_TwrIloscSkan}, PlaceTime=''{data}''
where PlaceTrnNumer={towar.MsI_TrnNumer} and PlaceTwrNumer={towar.MsI_TwrNumer} and PlaceName= ''{place} ''
'";
}
else
{
sqlInsert = $@"cdn.PC_WykonajSelect N'Update cdn.PC_MsPolozenie set PlaceQuantity= {towar.MsI_TwrIloscSkan}, PlaceTime=''{data}''
where PlaceTrnNumer={towar.MsI_TrnNumer} and PlaceTwrNumer={towar.MsI_TwrNumer} and PlaceName= ''{place} ''
'";
}
await App.TodoManager.PobierzDaneZWeb <Place>(sqlInsert);
}
catch (Exception)
{
throw;
}
finally
{
done = true;
}
//var Webquery = $@"cdn.PC_WykonajSelect N'Select * from cdn.PC_MsPolozenie where PlaceTwrNumer={msi.Twr_Gidnumer} '";
//var dane = await App.TodoManager.PobierzDaneZWeb<Place>(Webquery);
//return IsAddRow;
return(done);
}
// select(placeName+' - '+ cdn.NazwaObiektu(1604, placetrnnumer,0,2) +' - ' + placeQuantity +'szt')as sss
//from cdn.pc_mspolozenie
//where placetwrnumer=65839
internal async Task <bool> AddTowarToPlace(PC_MsInwentory msi, string placeName)
{
try
{
bool IsAddRow = true;
var IsAddedRow = await IsPlaceExists(msi.MsI_TwrNumer, msi.MsI_TrnNumer, placeName);
// $@"cdn.PC_WykonajSelect N'Select * from cdn.PC_MsPolozenie where PlaceTwrNumer={msi.Twr_Gidnumer} and PlaceTrnNumer= {msi.MsI_TrnNumer}'";
if (IsAddedRow.Count != 0)
{
if (msi.MsI_TrnNumer == 1)
{
await UpdateModelInPlace(msi, placeName);
IsAddRow = true;
}
else
{
IsAddRow = false;
}
}
else
{
var data = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var sqlInsert = $@"cdn.PC_WykonajSelect N'insert into cdn.PC_MsPolozenie values (''{placeName}'','''',{msi.MsI_TwrNumer},{msi.MsI_TrnNumer},{msi.MsI_MagNumer},{msi.MsI_TwrIloscSkan},''{data}'') '";
await App.TodoManager.PobierzDaneZWeb <Place>(sqlInsert);
}
//var Webquery = $@"cdn.PC_WykonajSelect N'Select * from cdn.PC_MsPolozenie where PlaceTwrNumer={msi.Twr_Gidnumer} '";
//var dane = await App.TodoManager.PobierzDaneZWeb<Place>(Webquery);
return(IsAddRow);
}
catch (Exception)
{
throw;
}
}
private async Task <bool> AddTowarToPlace(PC_MsInwentory pC_MsInwentory, string placeName)
{
return(await viewModel.AddTowarToPlace(pC_MsInwentory, placeName));
}
public async void pobierztwrkod(string _ean)
{
var app = Application.Current as App;
if (!string.IsNullOrEmpty(_ean) || _ean != "2010000")
{
try
{
var Webquery = $@"cdn.PC_WykonajSelect N'Select Twr_Kod, Twr_Nazwa, Twr_Katalog Twr_Symbol, cast(twc_wartosc as decimal(5,2))Cena ,cast(sum(TwZ_Ilosc) as int)Ilosc, case when len(twr_kod) > 5 and len(twr_url)> 5
then replace(twr_url, substring(twr_url, 1, len(twr_url) - len(twr_kod) - 4), substring(twr_url, 1, len(twr_url) - len(twr_kod) - 4) + ''Miniatury/'')
else twr_kod end as Url ,Twr_Ean Ean , Twr_Gidnumer
from cdn.TwrKarty
join cdn.TwrCeny on Twr_GIDNumer = TwC_TwrNumer and TwC_TwrLp = 2
left join cdn.TwrZasoby on Twr_GIDNumer = TwZ_TwrNumer where twr_ean=''{_ean}'' or twr_kod=''{_ean}''
group by twr_kod, twr_nazwa, Twr_Katalog,twc_wartosc, twr_url,twr_ean,Twr_Gidnumer'" ;
var dane = await App.TodoManager.PobierzDaneZWeb <DaneMMElem>(Webquery);
var karta = dane.FirstOrDefault();
towar = new PC_MsInwentory()
{
Cena = karta.Cena,
Ean = karta.Ean,
MsI_TwrNumer = karta.Twr_Gidnumer,
};
if (dane.Count > 0)
{
twrkod = dane[0].Twr_Kod;
twr_url = dane[0].Url;
twr_nazwa = dane[0].Twr_Nazwa;
twr_ean = dane[0].Ean;
twr_cena = dane[0].Cena;
}
else
{
await DisplayAlert("Uwaga", "Kod nie istnieje!", "OK");
}
entry_kodean.Text = twrkod;
lbl_ean.Text = twr_ean;
lbl_symbol.Text = twr_symbol;
lbl_nazwa.Text = twr_nazwa;
lbl_cena.Text = twr_cena;
lbl_stan.Text = "Stan : " + stan_szt;
if (!string.IsNullOrEmpty(twr_url))
{
img_foto.Source = twr_url.Replace("Miniatury/", ""); //twr_url;
}
}
catch (Exception)
{
await DisplayAlert("Uwaga", "Nie znaleziono towaru", "OK");
}
}
//return twrkod;
}
