public IActionResult Get()
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
IQueryable <PurchaseReturnDetail> employees = objectSpace.GetObjectsQuery <PurchaseReturnDetail>();
return(Ok(employees));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public async Task <ActionResult> Logout()
{
await HttpContext.SignOutAsync();
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]Logout Done:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
return(Ok());
}
public vwBinWarehouseController(SecurityProvider securityProvider)
{
FT_PurchasingPortal.Module.GeneralValues.IsNetCore = true;
FT_PurchasingPortal.Module.GeneralValues.NetCoreUserName = securityProvider.GetUserName();
this.securityProvider = securityProvider;
objectSpace = securityProvider.ObjectSpaceProvider.CreateObjectSpace();
}
public ActionResult Get(string bokey)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get(" + bokey + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
vwWarehouses existing = objectSpace.FindObject <vwWarehouses>(CriteriaOperator.Parse("BoKey=?", bokey));
if (existing == null)
{
NotFound();
}
return(Ok(existing));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get(" + bokey + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public IActionResult GetOpenPO(string cardcodekey)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenPO(" + cardcodekey + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
List <PurchaseOrder> obj;
if (GenHelper.LiveWithPost)
{
obj = objectSpace.GetObjects <PurchaseOrder>(CriteriaOperator.Parse("[CardCode.BoKey]=? and [DocStatus.CurrDocStatus] in (?) and [PurchaseOrderDetail][[Quantity] > [CopyQty] and [VerNo] = [PostVerNo]]", cardcodekey, DocStatus.Accepted)).ToList();
}
else
{
obj = objectSpace.GetObjects <PurchaseOrder>(CriteriaOperator.Parse("[CardCode.BoKey]=? and [DocStatus.CurrDocStatus] in (?) and [PurchaseOrderDetail][[Quantity] > [CopyQty]]", cardcodekey, DocStatus.Accepted)).ToList();
}
return(Ok(obj));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenPO:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public IActionResult GenGRN([FromBody] JObject values)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
GenHelper.WriteLog("[Json]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[" + Environment.NewLine + values.ToString() + Environment.NewLine + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
//
//JsonParser.ParseJObjectXPO<PurchaseDelivery>(values, employee, objectSpace);
string temp = "";
JToken token;
PurchaseDelivery employee = objectSpace.CreateObject <PurchaseDelivery>();
token = values["CardCode"];
temp = token["BoKey"].ToString();
employee.CardCode = objectSpace.FindObject <vwBusinessPartners>(CriteriaOperator.Parse("BoKey=?", temp));
employee.NumAtCard = values["NumAtCard"].ToString();
//JsonPopulateObjectHelper.PopulateObjectWODetail(values.ToString(), employee.Session, employee);
string detalclassname = "PurchaseDeliveryDetail";
int intkeyvalue = -1;
JArray jarray = (JArray)values[detalclassname];
int cnt = 0;
foreach (JObject Jdtl in jarray.Children())
{
if (Jdtl.ContainsKey("Oid"))
{
if (int.TryParse(Jdtl["Oid"].ToString(), out intkeyvalue))
{
PurchaseDeliveryDetail dtl = objectSpace.GetObjectByKey <PurchaseDeliveryDetail>(intkeyvalue);
cnt++;
dtl.VisOrder = cnt;
dtl.VerNo = 1;
employee.PurchaseDeliveryDetail.Add(dtl);
}
else
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[Details Key value is invalid][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception("Details Key value is invalid");
}
}
else
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[Details Key Column Not found][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception("Details Key Column Not found");
}
}
if (employee.DocTypeSeries == null)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[Document series is not found][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception("Document series is not found");
}
employee.DocStatus.AddDocStatus(DocStatus.Accepted, "WebApi Generated");
employee.DocStatus.CurrDocStatus = DocStatus.Accepted;
employee.VerNo = 1;
employee.AssignDocNumber();
objectSpace.CommitChanges();
return(Ok(employee.DocNum));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
