/// <summary>
/// Get delivery date for product from Visma OTRIVIT or VARASTO tables.
/// </summary>
/// <param name="articleCode">Visma article code</param>
/// <returns></returns>
public DateTime?GetDeliveryDate(string articleCode)
{
DateTime?date = null;
DataSet.OTRIVIDataTable otrivitDT = otrivitTA.GetDataByArticleCode(articleCode);
if (otrivitDT.Count > 0)
{
date = otrivitDT[0].TALKUPVM;
}
if (date == null)
{
DataSet.VARASTODataTable varastoDT = varastoTA.GetDataByArticleCode(articleCode);
if (varastoDT.Count > 0)
{
int days = -1;
string daysString = varastoDT[0].TOIMAIKA;
int.TryParse(daysString, out days);
if (days >= 0)
{
date = DateTime.Now.AddDays(days);
}
}
}
return(date);
}
/// <summary>
/// Get common part of multiple Article names with same FamilyCode.
/// </summary>
/// <param name="familyCode">Family code</param>
/// <returns></returns>
public string GetCommonArticleNameForFamilyCode(string familyCode)
{
string articleName = null;
DataSet.VARASTODataTable varastotDT = varastoTA.GetDataByFamilyCode(familyCode);
//string[] varastoNames = new string[] { };
List <string> varastoNames = new List <string>();
if (varastotDT.Count > 0)
{
foreach (DataSet.VARASTORow varasto in varastotDT)
{
string varastoName = varasto.NIMIKE;
varastoNames.Add(varastoName);
}
articleName = GetCommonString(varastoNames);
}
return(articleName);
}
