internal List <Attachments> GetProductAttachments(int orderID, string prodName)
{
string query = "PORDERS?$filter=ORD eq " + orderID + "&$expand=EXTFILES_SUBFORM($filter=SHR_PARTNAME eq '" + prodName + "')";
query = query.Replace("\"", "");
string res = Call_Get(query);
List <Attachments> lst = null;
OrdersWarpper ow = JsonConvert.DeserializeObject <OrdersWarpper>(res);
if (null == ow)
{
return(lst);
}
if (null == ow.Value[0].EXTFILES_SUBFORM)
{
return(lst);
}
lst = new List <Attachments>();
foreach (Attachments item in ow.Value[0].EXTFILES_SUBFORM)
{
lst.Add(item);
}
return(lst);
}
internal List <Order> GetSupplierOrders(string supplier)
{
OrdersWarpper ow = null;
string portalOrderStatus = GetOrderStatus();
if (string.IsNullOrEmpty(portalOrderStatus))
{
AppLogger.log.Error("GetSupplierOrders ==> No oreders status were found!!!");
return(new List <Order>());
}
try
{//STATDES eq 'מאושרת' or STATDES eq 'נשלחה-עדכון' or STATDES eq 'נשלחה' or STATDES eq 'אישור ספק' or STATDES eq 'פתיחה חוזרת' or STATDES eq 'מוקפאת'
string query = "PORDERS?$filter=SUPNAME eq '" + supplier + "' and CLOSEDBOOL ne 'Y' and(" + portalOrderStatus + ")&$select=EFI_ETYPEDES, EFI_ESTATDES,CURVERSION, TYPEDES, CLOSEDBOOL, ORDNAME,STATDES,CURDATE,ORD,CODEDES,SUPNAME,CDES,SHR_SUPTYPEDES,OWNERLOGIN&$expand=PORDERITEMS_SUBFORM($filter=CLOSEDBOOL ne 'Y';$expand=PORDERITEMSTEXT_SUBFORM)";
string res = Call_Get(query);
ow = JsonConvert.DeserializeObject <OrdersWarpper>(res);
if ((null != ow) && (null != ow.Value) && (ow.Value.Count > 0))
{
return(ow.Value);
}
}
catch (Exception ex)
{
AppLogger.log.Error("GetSupplierOrders ==> supplier = " + supplier, ex);
}
return(new List <Order>());
}
internal Order GetOrderProductDetails(int orderID, string prodName)
{
string query = "PORDERS?$filter=ORD eq " + orderID + "&$select=CURVERSION, TYPECODE, TYPEDES, ORDNAME,STATDES,CURDATE,ORD,CODEDES,SUPNAME,CDES,SHR_SUPTYPEDES,OWNERLOGIN&$expand=EXTFILES_SUBFORM($filter=SHR_PARTNAME eq '" + prodName + "'),PORDERITEMS_SUBFORM($filter=PARTNAME eq '" + prodName + "';$expand=PORDERITEMSTEXT_SUBFORM)";
string res = Call_Get(query);
OrdersWarpper ow = JsonConvert.DeserializeObject <OrdersWarpper>(res);
return(ow.Value[0]);
}
internal List <Revision> GetProdRevisionList(string oRDNAME, string supplierName, string pARTNAME, string rEVNAME)
{
//PART?$filter=PARTNAME eq '23559000'&$expand=REVISIONS_SUBFORM($filter=REVNUM eq 'C';$expand=MED_PARTQA_R_SUBFORM)
//MED_SAMPLE?$filter=PARTNAME eq '" + pARTNAME + "' and SHR_SER_ORDER eq '" + oRDNAME + "' and SUPNAME eq '" + supplierName + "')"
string query = "/PART?$filter=PARTNAME eq '" + pARTNAME + "'&$expand=REVISIONS_SUBFORM($filter=REVNUM eq '" + rEVNAME + "';$expand=MED_PARTQA_R_SUBFORM)";
string res = Call_Get(query);
OrdersWarpper ow = JsonConvert.DeserializeObject <OrdersWarpper>(res);
return(null);
}
internal Order GetProductDetailse(string SUPNAME, string ORDNAME, string PARTNAME)
{
//string query = "PORDERS?$filter=SUPNAME eq '" + SUPNAME + "' and ORDNAME eq '" + ORDNAME + "'&$expand=PORDERITEMS_SUBFORM($filter=PARTNAME eq '" + PARTNAME + "')";
string query = "PORDERS?$filter=SUPNAME eq '" + SUPNAME + "' and ORDNAME eq '" + ORDNAME + "'&$select=EFI_ETYPEDES, EFI_ESTATDES,TYPECODE, TYPEDES, ORDNAME,STATDES,CURDATE,ORD,CODEDES,SUPNAME,CDES,SHR_SUPTYPEDES,OWNERLOGIN&$expand=PORDERITEMS_SUBFORM($filter=PARTNAME eq '" + PARTNAME + "';$expand=PORDERITEMSTEXT_SUBFORM)";
string res = Call_Get(query);
OrdersWarpper ow = JsonConvert.DeserializeObject <OrdersWarpper>(res);
if ((null != ow) && (null != ow.Value) && (ow.Value.Count > 0))
{
return(ow.Value[0]);
}
return(null);
}
internal Order GetOrderProductDetailsByLine(int orderID, string prodName, int ordLine)
{
string query = "PORDERS?$filter=ORD eq " + orderID + "&$select=EFI_ETYPEDES, EFI_ESTATDES,CURVERSION, TYPECODE, TYPEDES, ORDNAME,STATDES,CURDATE,ORD,CODEDES,SUPNAME,CDES,SHR_SUPTYPEDES,OWNERLOGIN&$expand=EXTFILES_SUBFORM($filter=SHR_PARTNAME eq '" + prodName + "'),PORDERITEMS_SUBFORM($filter=PARTNAME eq '" + prodName + "' and LINE eq " + ordLine + ";$expand=PORDERITEMSTEXT_SUBFORM),PORDERSTEXT_SUBFORM";
string res = Call_Get(query);
if (null == res)
{
AppLogger.log.Info("GetOrderProductDetailsByLine ERROR ==> query = " + query);
return(null);
}
OrdersWarpper ow = JsonConvert.DeserializeObject <OrdersWarpper>(res);
return(ow.Value[0]);
}
internal Order GetOrderDetails(int orderID)
{
//"/PORDERS?$filter=ORD eq " + orderID + "&$expand=EXTFILES_SUBFORM,PORDERITEMS_SUBFORM($expand=PORDERITEMSTEXT_SUBFORM)";
string query = "PORDERS?$filter=ORD eq " + orderID + "&$select=EFI_ETYPEDES, EFI_ESTATDES, CURVERSION, TYPECODE, TYPEDES, ORDNAME,STATDES,CURDATE,ORD,CODEDES,SUPNAME,CDES,SHR_SUPTYPEDES,OWNERLOGIN&$expand=PORDERITEMS_SUBFORM($filter=CLOSEDBOOL ne 'Y';$expand=PORDERITEMSTEXT_SUBFORM),PORDERSTEXT_SUBFORM";
string res = Call_Get(query);
if (null == res)
{
AppLogger.log.Info("GetOrderDetails ERROR ==> query = " + query);
return(null);
}
OrdersWarpper ow = JsonConvert.DeserializeObject <OrdersWarpper>(res);
return(ow.Value[0]);
}