public void GetMaterialMatrix()
{
var excelWrapper = new MySQLArticleClient(host);
var res = excelWrapper.GetAvailibilityMatrix();
Assert.IsNotNull(res);
}
static int Main(string[] args)
{
if (args.Length != 3)
{
Console.Error.WriteLine("Wrong number of Arguments");
Console.Error.WriteLine("Usage: RkpCli <sql_host> <depmatrix_csv_file> <article_num>");
return(1);
}
else
{
try
{
var sql = new MySQLArticleClient(args[0]);
var mat = MaterialMatrix.ReadFromFile(args[1]);
// todo get productkey
string[] productkey = sql.GetProductkey(args[2]);
if (productkey == null)
{
Console.Error.WriteLine("Article not found");
return(2);
}
Console.WriteLine((AvailabilityCheck.IsAvailable(productkey, mat) ? 1 : 0));
return(0);
}
catch (Exception exc)
{
Console.Error.WriteLine(exc);
return(3);
}
}
}
public void NotFoundSearch()
{
var excelWrapper = new MySQLArticleClient(host);
var res = excelWrapper.GetProductkey("D951-5051");
Assert.IsNull(res);
}
public void SetMaterialMatrix()
{
var excelWrapper = new MySQLArticleClient(host);
MaterialMatrix mat = MaterialMatrix.ReadFromFile(path_lagerVorlage);
excelWrapper.SetAvailibilityMatrix(mat);
}
public void ImportKennliste()
{
using (var client = new MySQLArticleClient(host))
{
client.ImportFromFile(kennliste_path);
}
}
public void SearchPump1()
{
var excelWrapper = new MySQLArticleClient(host);
var res = excelWrapper.GetProductkey("D954-2305");
string[] obj = res;
Assert.AreEqual(obj[0].Trim(), "D954-2305");
Assert.AreEqual(obj[1].Trim(), "HPR15A7RKP063KM28S2Z11");
}
public void SearchCaseInsensitive()
{
var excelWrapper = new MySQLArticleClient(host);
var res = excelWrapper.GetProductkey("d951-5001");
string[] obj = res;
Assert.AreEqual(obj[0].Trim(), "D951-5001");
Assert.AreEqual(obj[1].Trim(), "HPR18B1RKP019SM28F1Y00RKP019SM28F1Y00");
}
public void PartialSearch()
{
var excelWrapper = new MySQLArticleClient(host);
var res = excelWrapper.SearchProductkey("D951-504");
Assert.AreEqual(1, res.Count);
string[] obj = res[0];
Assert.AreEqual(obj[0].Trim(), "D951-5041");
Assert.AreEqual(obj[1].Trim(), "HPR18A7RKP019SM28D6ZA0RKP019SM28D6ZA0");
}
public void MaterialMatrixValues()
{
var excelWrapper = new MySQLArticleClient(host);
MaterialMatrix mat = MaterialMatrix.ReadFromFile(path_lagerVorlage);
excelWrapper.SetAvailibilityMatrix(mat);
var res = excelWrapper.GetAvailibilityMatrix();
Assert.IsNotNull(res);
Assert.AreEqual(mat, res);
}
public void GetPump()
{
using (var client = new MySQLArticleClient(host))
{
string article = "0514400337";
var key = client.GetProductkey(article);
Assert.IsNotNull(key);
Assert.AreEqual(article, key[0]);
Assert.AreEqual("HPR18A1RKP019SC21F1Z00", key[1]);
Assert.AreEqual("HP", key[7]);
}
}
public void AvailibilityValues()
{
var excelWrapper = new MySQLArticleClient(host);
string article = "D951-5001";
bool avai = true;
excelWrapper.SetAvailibility(article, avai);
var res = excelWrapper.GetAvailibility(article);
Assert.AreEqual(avai, res);
avai = false;
excelWrapper.SetAvailibility(article, avai);
res = excelWrapper.GetAvailibility(article);
Assert.AreEqual(avai, res);
}