public void soarAction_Should_UploadFileToOrder_When_ButtonForUploadingOrdersExist()
{
IVA02 va02 = new VA02(sap, idaLog);
sap.enterTCode("VA02");
va02.enterOrder(208736896);
va02.soarAction("this is testing the csr notes function to upload a note into the order with enough text", "DeliveryBlocks", 208736896);
}
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 OrderStatus enterOrder(int order)
{
OrderStatus status;
sap.enterTCode("VA02");
sap.setText(VA02ID.ORDER_NUNBER_INPUT_TEXT_FIELD_ID, order.ToString());
sap.pressEnter();
sap.getRidOfPopUps();
if (sap.getInfoBarMsg().Contains("exists with same"))
{
sap.pressEnter();
}
status = checkIfOrderBlocked(order);
return(status);
}
public List <ZV04IProperty> getZV04IfloorCuts(List <MD04Property> MD04List, string salesOrg, IDAEnum.Task idaTask)
{
var ZV04I = new ZV04I(sap, salesOrg, idaTask);
//ZV04I.setParamsBeforeExecution();
sap.enterTCode("ZV04I");
ZV04I.sap.setText("wnd[0]/usr/ctxtS_LDDAT-LOW", DateTime.Now.Date.ToString("dd'.'MM'.'yyyy"));
ZV04I.sap.setText("wnd[0]/usr/ctxtS_LDDAT-HIGH", DateTime.Now.Date.ToString("dd'.'MM'.'yyyy"));
ZV04I.sap.setText("wnd[0]/usr/ctxtS_VKORG-LOW", salesOrg);
ZV04I.sap.setCheckboxStatus(ZV04ID.OPEN_ORDER_CHECKBOX_ID, true);
ZV04I.sap.setCheckboxStatus(ZV04ID.CREDIT_HOLD_CHECKBOX_ID, true);
ZV04I.sap.setCheckboxStatus(ZV04ID.WITH_DELIVERY_CHECKBOX_ID, false);
ZV04I.sap.setCheckboxStatus(ZV04ID.NOT_PGI_CHECKBOX_ID, false);
ZV04I.sap.setCheckboxStatus(ZV04ID.NOT_INVOICED_CHECKBOX_ID, false);
//ZV04I.sap.pressBtn("wnd[0]/usr/btn%_S_MATNR_%_APP_%-VALU_PUSH");
if (MD04List is null)
{
return(null);
}
else
{
string[] arrayList = new string[MD04List.Count];
for (int i = 0; i < MD04List.Count; i++)
{
arrayList[i] = MD04List[i].sku;
}
//string[] arrayLis1t = MD04List.ToArray();
ZV04I.sap.setMultipleSelection(arrayList, "wnd[0]/usr/btn%_S_MATNR_%_APP_%-VALU_PUSH");
string path = $"{Environment.GetFolderPath(Environment.SpecialFolder.Desktop)}\\{salesOrg} {DateTime.Now.Day}.{DateTime.Now.Month}.{DateTime.Now.Year} {DateTime.Now.Hour}hour {DateTime.Now.Minute}minute Orders with past PO date.xlsx";
ZV04I.extractReport();
var listZV04HNfloorCuts = parser.getObjectListFromClipboard <ZV04IProperty>();
//ZV04I.sap.pressBtn("wnd[0]/tbar[1]/btn[43]");
//ZV04I.sap.setText("wnd[1]/usr/ctxtDY_PATH", path);
//ZV04I.sap.setText("wnd[1]/usr/ctxtDY_FILENAME", "AlexFloorCuts.xlsm");
//ZV04I.sap.pressBtn("wnd[1]/tbar[0]/btn[11]");
//ZV04I.sap.exportExcel(@"C:\Users\g168180\Documents\SAP\SAP GUI\", "AlexFloorCuts.xlsx");
return(listZV04HNfloorCuts);
}
}
private void executeWE05(string direction, string status, string messageVariant)
{
string dateFrom = DateAndTime.DateAdd(DateInterval.Day, -90, DateAndTime.Now).ToSAPFormat();
string dateTo = DateAndTime.Now.ToSAPFormat();
sapLib.enterTCode("WE05");
sapLib.setText(lib.SAP_ALL_ID.WE05.MESSAGE_VARIAN_FLD, messageVariant);
if ((messageVariant ?? "") == "FR")
{
sapLib.setMultipleSelection(new[] { "BE" }, lib.SAP_ALL_ID.WE05.MESSAGE_VARIANT_MULTIPLE_SELECTION_BTN);
}
sapLib.setText(lib.SAP_ALL_ID.WE05.CREATED_ON_FROM_FLD, dateFrom);
sapLib.setText(lib.SAP_ALL_ID.WE05.CREATED_ON_TO_FLD, dateTo);
sapLib.setText(lib.SAP_ALL_ID.WE05.DIRECTION_FLD, direction);
sapLib.setText(lib.SAP_ALL_ID.WE05.CURRENT_STATUS_FLD, status);
//filter table by orders only
sapLib.setText("wnd[0]/usr/tabsTABSTRIP_IDOCTABBL/tabpSOS_TAB/ssub%_SUBSCREEN_IDOCTABBL:RSEIDOC2:1100/ctxtIDOCTP-LOW", "ORDERS04");
sapLib.pressF8();
}
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);
}
