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