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; }