public IEnumerator AddWine(int index) { // Atualizar spreadsheet: WineInfo info = wineInfos.Find(i => i.id == index); info.quantity++; CloudConnectorCore.UpdateObjects(TABLE_NAME, ID_FIELD_NAME, info.id.ToString(), QUANTITY_FIELD_NAME, info.quantity.ToString()); // Atualiza server no webhost por php: wineQuantitiesFromWebhost[index]++; WWW www = new WWW(WEBHOST_URL + "addWine.php?id=" + index.ToString()); while (!www.isDone) { yield return(0); } // Atualizar server no heroku por node.js: @Heitor WWW wwnode = new WWW(HEROKU_URL + "addWine?id=" + index.ToString()); while (!wwnode.isDone) { yield return(0); } }
public WineInfo Insert(WineInfo wine) { var guid = Guid.NewGuid().ToString(); wine.RowKey = guid; WineTable.ExecuteAsync(TableOperation.Insert(wine)); return(wine); }
private static void ImportFromFile(CloudTable wineTable, string[] fileReader, string status, Dictionary <string, string[]> wineRepo) { foreach (string line in fileReader) { var columns = line.Split(','); var guid = Guid.NewGuid().ToString(); var vinmonopoletId = columns[10]; var wine = new WineInfo(status, guid) { Type = columns[0], Name = columns[1], Producer = columns[2], Country = columns[4], Vintage = columns[3], Area = columns[5], Price = columns[6], Occation = columns[7] == "Lagring" ? "" : columns[7], Storage = columns[7] == "Lagring" ? true : false, BoughtDate = columns[8], Fruit = columns[9] }; if (!string.IsNullOrEmpty(vinmonopoletId)) { var wineInfo = wineRepo[vinmonopoletId]; wine = new WineInfo(status, guid) { VinmonopoletId = vinmonopoletId, Name = wineInfo[2], Price = wineInfo[4], Type = wineInfo[6], Country = wineInfo[20], Area = wineInfo[21], Vintage = wineInfo[23], Fruit = wineInfo[24], Producer = wineInfo[30], VinmonopoletUrl = wineInfo[35], Occation = columns[7] == "Lagring" ? "" : columns[7], Storage = columns[7] == "Lagring" ? true : false, BoughtDate = columns[8], }; } wineTable.Execute(TableOperation.Insert(wine)); } }
/*---------------------------------------------------------------------------- * %%Function: ReaderGetBookScanInfoDelegate * %%Qualified: UpcSvc.UpcSvc.ReaderGetBookScanInfoDelegate * %%Contact: rlittle * * ----------------------------------------------------------------------------*/ public static void ReaderGetWineScanInfoDelegate(SqlReader sqlr, CorrelationID crid, ref USR_WineInfo usrw) { WineInfo wni = new WineInfo(); wni.Code = sqlr.Reader.GetString(0); wni.LastScan = sqlr.Reader.GetDateTime(1); wni.FirstScan = sqlr.Reader.GetDateTime(2); wni.Wine = sqlr.Reader.GetString(3); wni.Vintage = sqlr.Reader.GetString(4); wni.Notes = sqlr.Reader.IsDBNull(5) ? null : sqlr.Reader.GetString(5); wni.Bin = sqlr.Reader.GetString(6); wni.Location = sqlr.Reader.GetString(7); usrw = USR_WineInfo.FromTCSR(USR.SuccessCorrelate(crid)); usrw.TheValue = wni; }
/// <summary> /// Online /// </summary> /// <returns></returns> public List <WineInfo> GetWineInfo() { StringBuilder sql = new StringBuilder(); sql.AppendLine("SELECT "); sql.AppendLine(" P.WineID, P.WineCategoryID, P.Describle"); sql.AppendLine(" FROM WineProduct P WITH(NOLOCK)"); sql.AppendLine(" WHERE P.IsDelete = 0"); SqlAccess mySqlAccess = new SqlAccess(); DataSet ds = mySqlAccess.ExecuteAdapter(sql.ToString()); JsonSerializer myJson = new JsonSerializer(); List <WineInfo> wineInfos = new List <WineInfo>(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dw in ds.Tables[0].Rows) { WineInfo wineInfo = new WineInfo(); wineInfo.WineID = Convert.ToInt32(dw["WineID"]); wineInfo.WineCategoryID = Convert.ToInt32(dw["WineCategoryID"]); List <ProductDescribleModel> describles = new List <ProductDescribleModel>(); describles = myJson.Deserialize <List <ProductDescribleModel> >(dw["Describle"].ToString()); foreach (ProductDescribleModel describle in describles) { if (describle.Language == GlobalVariable.LanguageName.English) { wineInfo.WineName = describle.DescribleDetail.Name; break; } } wineInfos.Add(wineInfo); } } return(wineInfos); }