public ITable getTable()
{
ITable table;
// sometimes table is not found when sap is slow
try {
table = sap.getITableObject();
} catch (Exception) {
System.Threading.Thread.Sleep(1000);
table = sap.getITableObject();
}
return(table);
}
public CO09Property getStockDetails(int sku, string salesOrg)
{
int plant = new SalesOrgDetails().getPlant(salesOrg);
sap.enterTCode("CO09");
bool isOpenTable = isOpenStockAndDates(sku, plant.ToString());
if (!isOpenTable)
{
return(new CO09Property()
{
salesOrg = salesOrg,
plant = plant,
sku = sku,
ATP = 0,
recoveryQty = 0,
recoveryDate = "SKU does not exists for this plant"
});
}
var table = sap.getITableObject();
double atp = double.Parse(table.getCellValue(0, 4));
string recDate = "";
double recQty = 0;
int i = 0;
// had to do this due to a table bug
System.Threading.Thread.Sleep(1000);
(sap.findById("wnd[0]") as dynamic).resizeWorkingPane(100, 25, 0);
System.Threading.Thread.Sleep(1000);
try {
while (!string.IsNullOrEmpty(table.getCellValue(i, 1)))
{
if (new[] { "POitem", "PurRqs", "ShpgNt" }.Contains(table.getCellValue(i, 1)))
{
recDate = table.getCellValue(i, 0);
recQty = double.Parse(table.getCellValue(i, 3));
break;
}
i += 1;
}
} catch (TableWasNotScrolledException) {
}
return(new CO09Property()
{
salesOrg = salesOrg,
plant = plant,
sku = sku,
ATP = atp,
recoveryQty = recQty,
recoveryDate = string.IsNullOrEmpty(recDate) ? "No Date Available" : recDate
});
}
public bool runQuantityChange(QtyConversionOrderProperty order)
{
sap.enterTCode("VA02");
sap.setText(lib.SAP_ALL_ID.VA02.ORDER_FLD, order.orderNumber.ToString());
sap.pressEnter();
va02.checkIfOrderBlocked(order.orderNumber);
sap.pressEnter();
sap.getRidOfPopUps();
if (sap.getInfoBarMsg().Contains("exists with same PO"))
{
sap.pressEnter();
}
sap.getRidOfPopUps();
var table = sap.getITableObject();
if (changeQuantityInTable(table, order))
{
string csrNote = $"Order number {order.orderNumber} had qty's changed in the following - {va02.getChangedListForCSR(order)}";
va02.soarAction(csrNote, "Quantity Conversion", order.orderNumber);
va02.save();
if (sap.getInfoBarMsg().Contains($"{order.orderNumber} has been saved"))
{
order.isSaved = true;
var itemArr = order.documentLineChangeList.Select(x => x.item).ToArray();
log.update("QuantityConversionLog",
new[] { "isSaved" },
new[] { "1" },
new[] { "orderNumber" },
new[] { order.orderNumber.ToString() },
$"item IN ({string.Join(",", itemArr)})");
return(true);
}
}
return(false);
}
public bool getStockDetails(string sku, string salesOrg)
{
int plant = new SalesOrgDetails().getPlant(salesOrg);
sap.enterTCode("MD04");
bool isOpenTable = isOpenStockAndDates(sku, plant.ToString());
//if (!isOpenTable)
//{
// return new MD04Property()
// {
// salesOrg = salesOrg,
// plant = plant,
// sku = sku,
// ATP = 0,
// recoveryQty = 0,
// recoveryDate = "SKU does not exists for this plant"
// };
//}
var table = sap.getITableObject();
string qty = table.getCellValue(0, 8);
double atp = 0;
if (!String.IsNullOrEmpty(qty))
{
atp = double.Parse(qty);
}
string recDate = "";
string recQty = "";
int i = 1;
// had to do this due to a table bug
System.Threading.Thread.Sleep(1000);
(sap.findById("wnd[0]") as dynamic).resizeWorkingPane(100, 25, 0);
System.Threading.Thread.Sleep(1000);
try {
while (!string.IsNullOrEmpty(table.getCellValue(i, 1)) && DateTime.Parse(table.getCellValue(i, 1)) <= DateAndTime.Now)
{
//if (new[] { "Delvry", "CusOrd", "ShpgNt" }.Contains(table.getCellValue(i, 2)))
if (new[] { "Delvry" }.Contains(table.getCellValue(i, 2)) && (DateTime.Parse(table.getCellValue(i, 1)) == DateAndTime.Today))
{
recQty = table.getCellValue(i, 8);
recQty = recQty.Replace("-", "");
atp = atp - double.Parse(recQty);
}
if ((new[] { "CusOrd" }.Contains(table.getCellValue(i, 2))) && (DateTime.Parse(table.getCellValue(i, 1)) <= DateAndTime.Now))
{
recQty = table.getCellValue(i, 8);
recQty = recQty.Replace("-", "");
atp = atp - double.Parse(recQty);
}
//{
//{
// recDate = table.getCellValue(i, 1);
// recQty = double.Parse(table.getCellValue(i, 8));
// return new MD04Property()
//}
// recQty = table.getCellValue(i, 8);
//recQty = recQty.Replace("-", "");
//atp = atp - double.Parse(recQty);
//}
i += 1;
}
//if (i > 1) {
// recQty = table.getCellValue(i-1, 9);
// if (recQty.Contains("-")) {
// recQty = recQty.Replace("-", "");
// atp = -double.Parse(recQty);
// }
// else {
// atp = double.Parse(table.getCellValue(i-1, 9));
// }
//}
//else {
// atp = double.Parse(table.getCellValue(i, 9));
//}
if (atp <= 0)
{
return(false);
}
else
{
return(true);
}
}
catch (TableWasNotScrolledException)
{
}
// return new MD04Property()
// {
// salesOrg = salesOrg,
// plant = plant,
// sku = sku,
// ATP = atp,
// recoveryQty = recQty,
// recoveryDate = string.IsNullOrEmpty(recDate) ? "No Date Available" : recDate
// };
return(true);
}
