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 IActionResult GenPURItem([FromBody] JArray values) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenPURItem:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); GenHelper.WriteLog("[Json]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenPURItem:[" + Environment.NewLine + values.ToString() + Environment.NewLine + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); PurchaseReturnDetail dtl; string temp = ""; JToken token; foreach (JObject Jdtl in values.Children()) { dtl = objectSpace.CreateObject <PurchaseReturnDetail>(); temp = Jdtl["Baseline"].ToString(); dtl.Baseline = int.Parse(temp); if (Jdtl.ContainsKey("BaseDocNo")) { temp = Jdtl["BaseDocNo"].ToString(); dtl.BaseDocNo = temp; } temp = DocTypeCodes.PurchaseDelivery; dtl.BaseType = objectSpace.FindObject <DocType>(CriteriaOperator.Parse("BoCode=?", temp)); temp = Jdtl["Quantity"].ToString(); dtl.Quantity = double.Parse(temp); if (Jdtl.ContainsKey("BatchNumber")) { if (Jdtl["BatchNumber"] != null) { temp = Jdtl["BatchNumber"].ToString(); } if (!string.IsNullOrEmpty(temp)) { dtl.BatchNumber = temp; } } token = Jdtl["BinCode"]; temp = token["BoKey"].ToString(); dtl.BinCode = objectSpace.FindObject <vwWarehouseBins>(CriteriaOperator.Parse("BoKey=?", temp)); token = Jdtl["LineVendor"]; temp = token["BoKey"].ToString(); dtl.LineVendor = objectSpace.FindObject <vwBusinessPartners>(CriteriaOperator.Parse("BoKey=?", temp)); } objectSpace.CommitChanges(); return(Ok()); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenPURItem:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
public ActionResult GetWhsList(string companycode) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetWhsList(" + companycode + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); List <vwWarehouseBins> existing = objectSpace.GetObjects <vwWarehouseBins>(CriteriaOperator.Parse("CompanyCode=? and BinAbsEntry=0", companycode)).ToList(); return(Ok(existing)); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetWhsList(" + companycode + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
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 ActionResult Add([FromBody] JObject values) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Post:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); PurchaseReturnDetail employee = objectSpace.CreateObject <PurchaseReturnDetail>(); JsonParser.ParseJObjectXPO <PurchaseReturnDetail>(values, employee, objectSpace); objectSpace.CommitChanges(); return(Ok(employee)); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Post:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
public ActionResult Get(string bokey) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get(" + bokey + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); vwWarehouseBins existing = objectSpace.FindObject <vwWarehouseBins>(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 ActionResult Get(int id) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get(" + id.ToString() + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); PurchaseReturnDetail existing = objectSpace.GetObjectByKey <PurchaseReturnDetail>(id); if (existing == null) { NotFound(); } return(Ok(existing)); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get(" + id.ToString() + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
public ActionResult SupplierList(string companycode) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-SupplierList(" + companycode + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); List <vwBusinessPartners> existing = objectSpace.GetObjects <vwBusinessPartners>(CriteriaOperator.Parse("CompanyCode=? and CardType=?", companycode, "S")).ToList(); if (existing == null) { NotFound(); } return(Ok(existing)); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-SupplierList(" + companycode + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
public IActionResult GetPURItem(string username) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetPURItem(" + username + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); List <PurchaseReturnDetail> obj = objectSpace.GetObjects <PurchaseReturnDetail>(CriteriaOperator.Parse("[CreateUser.UserName]=? and isnull([PurchaseReturn])", username)).ToList(); if (obj == null) { return(NotFound()); } return(Ok(obj)); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetPURItem:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
public IActionResult GetGRNItemCount(string username) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetGRNItemCount(" + username + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); int cnt = 0; List <PurchaseDeliveryDetail> obj = objectSpace.GetObjects <PurchaseDeliveryDetail>(CriteriaOperator.Parse("[CreateUser.UserName]=? and isnull([PurchaseDelivery])", username)).ToList(); if (obj != null) { cnt = obj.Count; } return(Ok(cnt)); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetGRNItemCount:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
public ActionResult Update(int id, [FromBody] JObject values) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Put(" + id.ToString() + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); PurchaseReturnDetail employee = objectSpace.GetObjectByKey <PurchaseReturnDetail>(id); if (employee != null) { JsonParser.ParseJObjectXPO <PurchaseReturnDetail>(values, employee, objectSpace); objectSpace.CommitChanges(); return(Ok(employee)); } return(NotFound()); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Put(" + id.ToString() + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
public ActionResult Delete(int id) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Delete(" + id.ToString() + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); PurchaseDeliveryDetail existing = objectSpace.GetObjectByKey <PurchaseDeliveryDetail>(id); if (existing != null) { objectSpace.Delete(existing); objectSpace.CommitChanges(); return(NoContent()); } return(NotFound()); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Delete(" + id.ToString() + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
public ActionResult Login([FromBody] UserLogin data) { try { ActionResult result; string userName = data.UserName; string password = data.Password; if (securityProvider.InitConnection(userName, password)) { result = Ok(); GenHelper.WriteLog("[Log]", "[" + userName + "]Login Done:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); } else { result = Unauthorized(); } return(result); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IActionResult GetOpenPOItem(string cardcodekey) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenPOItem(" + cardcodekey + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); List <PurchaseOrderDetail> obj; if (GenHelper.LiveWithPost) { obj = objectSpace.GetObjects <PurchaseOrderDetail>(CriteriaOperator.Parse("!isnull([PurchaseOrder]) and [PurchaseOrder.CardCode.BoKey]=? and [PurchaseOrder.DocStatus.CurrDocStatus] in (?) and [Quantity] > [CopyQty] and [VerNo] = [PostVerNo]", cardcodekey, DocStatus.Accepted)).OrderBy(pp => pp.PurchaseOrder.DocNo).ToList(); } else { obj = objectSpace.GetObjects <PurchaseOrderDetail>(CriteriaOperator.Parse("!isnull([PurchaseOrder]) and [PurchaseOrder.CardCode.BoKey]=? and [PurchaseOrder.DocStatus.CurrDocStatus] in (?) and [Quantity] > [CopyQty]", cardcodekey, DocStatus.Accepted)).OrderBy(pp => pp.PurchaseOrder.DocNo).ToList(); } return(Ok(obj)); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenPOItem:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
public IActionResult GetOpenGRNItemByDoc(string docno) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenGRNItemByDoc(" + docno + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); List <PurchaseDeliveryDetail> obj; if (GenHelper.LiveWithPost) { obj = objectSpace.GetObjects <PurchaseDeliveryDetail>(CriteriaOperator.Parse("!isnull([PurchaseDelivery]) and [PurchaseDelivery.DocNo]=? and [PurchaseDelivery.DocStatus.CurrDocStatus]=? and [PurchaseDelivery.DocStatus.IsSAPPosted]=1 and [Quantity] > [CopyQty] and [VerNo] = [PostVerNo]", docno, DocStatus.Posted)).OrderBy(pp => pp.PurchaseDelivery.DocNo).ToList(); } else { obj = objectSpace.GetObjects <PurchaseDeliveryDetail>(CriteriaOperator.Parse("!isnull([PurchaseDelivery]) and [PurchaseDelivery.DocNo]=? and [PurchaseDelivery.DocStatus.CurrDocStatus] in (?,?) and [Quantity] > [CopyQty]", docno, DocStatus.Accepted, DocStatus.Posted)).OrderBy(pp => pp.PurchaseDelivery.DocNo).ToList(); } return(Ok(obj)); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenGRNItemByDoc:[" + 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); } }