public async Task submitForm() { if (string.IsNullOrEmpty(docnumber)) { await _pageService.DisplayAlert("Fail", "Please fill in Doc Number", "OK"); return; } if (typeof(CartPage) == sourcepage.GetType()) { var vm = ((CartPage)sourcepage).BindingContext as CartPageViewModel; vm.docnumber = docnumber; await _pageService.PopModalAsync(); await vm.postGRN(); } else if (typeof(MainMenu) == sourcepage.GetType()) { PurchaseDelivery obj = new PurchaseDelivery() { DocNo = docnumber }; Application.Current.Properties[PropertyHelper.PurchaseOrderProp] = obj; await _pageService.PopModalAsync(); ((MainMenu)sourcepage).gotoPOItem(); } }
private void CopyFromPO_CustomizePopupWindowParams(object sender, CustomizePopupWindowParamsEventArgs e) { PurchaseDelivery masterobject = (PurchaseDelivery)View.CurrentObject; string ObjType = masterobject.DocType.BoCode; string BusinessPartner = masterobject.CardCode == null ? "" : masterobject.CardCode.CardCode; IObjectSpace newObjectSpace = Application.CreateObjectSpace(typeof(PurchaseOrderDetail)); string listViewId = Application.FindLookupListViewId(typeof(PurchaseOrderDetail)); CollectionSourceBase collectionSource = Application.CreateCollectionSource(newObjectSpace, typeof(PurchaseOrderDetail), listViewId); if (BusinessPartner == "") { collectionSource.Criteria["filter01"] = CriteriaOperator.Parse("1=0"); } else { if (GeneralValues.LiveWithPost) { collectionSource.Criteria["Filter01"] = CriteriaOperator.Parse("PostVerNo = VerNo and OpenQty > CopyQty and PurchaseOrder is not null and PurchaseOrder.PostVerNo = PurchaseOrder.VerNo and PurchaseOrder.DocStatus.CurrDocStatus in (?) and LineStatus in (?) and (PurchaseOrder.CardCode=?)", DocStatus.Accepted, LineStatusEnum.Open, BusinessPartner); } else { collectionSource.Criteria["Filter01"] = CriteriaOperator.Parse("OpenQty > CopyQty and PurchaseOrder is not null and PurchaseOrder.DocStatus.CurrDocStatus in (?) and LineStatus in (?) and (PurchaseOrder.CardCode=?)", DocStatus.Accepted, LineStatusEnum.Open, BusinessPartner); } } e.View = Application.CreateListView(listViewId, collectionSource, true); //e.View = Application.CreateListView(typeof(PurchaseRequestDetail), true); }
public async Task <IActionResult> Get(int id) { try { PurchaseDelivery obj = await _uow.GetObjectByKeyAsync <PurchaseDelivery>(id); if (obj == null) { return(NotFound()); } //return Ok(obj); List <PurchaseDelivery> objlist = new List <PurchaseDelivery>(); objlist.Add(obj); var result = objlist.Select(r => new { Header = r, PurchaseDeliveryDetail = r.PurchaseDeliveryDetail.ToArray() }).Single(); return(Ok(result)); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void deleteDetails(JObject value, PurchaseDelivery obj) { try { #region delete details string detalclassname = "PurchaseDeliveryDetail"; bool isnew = false; int intkeyvalue = -1; JArray jarray = (JArray)value[detalclassname]; foreach (JObject Jdtl in jarray.Children()) { isnew = false; if (Jdtl.ContainsKey("Oid")) { if (Jdtl["Oid"] == null) { isnew = true; } else { if (int.TryParse(Jdtl["Oid"].ToString(), out intkeyvalue)) { if (intkeyvalue == -1) { isnew = true; } } } } else { isnew = true; } if (!isnew) { if (Jdtl.ContainsKey("IsBeingDelete")) { if (Jdtl["IsBeingDelete"].ToString() == "1" || Jdtl["IsBeingDelete"].ToString().ToUpper() == "TRUE") { PurchaseDeliveryDetail dtl = obj.PurchaseDeliveryDetail.Where(pp => pp.Oid == intkeyvalue).FirstOrDefault(); if (dtl != null) { dtl.Delete(); } //obj.PurchaseDeliveryDetail.Remove(dtl); } } } } #endregion } catch (Exception ex) { throw new Exception(ex.Message); } }
private void CopyFromPO_Execute(object sender, PopupWindowShowActionExecuteEventArgs e) { PurchaseDelivery masterobject = (PurchaseDelivery)View.CurrentObject; IObjectSpace ios = View is DetailView ? ObjectSpace : Application.CreateObjectSpace(); if (copyCon.CopyFromDocument(masterobject, (ListView)e.PopupWindow.View, ios)) { masterobject.IsCopy = true; genCon.showMsg("Operation Done", "Item Copied.", InformationType.Success); return; } }
public void resetButton() { this.CopyFromPO.Active.SetItemValue("Enabled", false); this.CopyToGR.Active.SetItemValue("Enabled", false); PurchaseDelivery selectobject = (PurchaseDelivery)View.CurrentObject; SystemUsers user = ObjectSpace.GetObjectByKey <SystemUsers>(SecuritySystem.CurrentUserId); switch (selectobject.DocStatus.CurrDocStatus) { case DocStatus.Cancelled: case DocStatus.Closed: case DocStatus.Posted: case DocStatus.Accepted: case DocStatus.Submited: break; default: this.CopyFromPO.Active.SetItemValue("Enabled", true); break; } switch (selectobject.DocStatus.CurrDocStatus) { case DocStatus.Accepted: case DocStatus.Posted: if (user.Roles.Where(pp => pp.Name == DocTypeCodes.PurchaseReturn).Count() > 0) { if (GeneralValues.LiveWithPost) { if (selectobject.VerNo == selectobject.PostVerNo && selectobject.DocStatus.CurrDocStatus == DocStatus.Posted) { this.CopyToGR.Active.SetItemValue("Enabled", true); } } else { this.CopyToGR.Active.SetItemValue("Enabled", true); } } break; default: break; } }
public async Task <IActionResult> Put(int id, [FromBody] JObject values) { try { ////PurchaseDelivery customer = _uow.GetObjectByKey<PurchaseDelivery>(id); ////JToken token; ////if (value.TryGetValue("Department", out token)) ////{ //// customer.Department = _uow.GetObjectByKey<Departments>(token["Oid"].Value<int>()); ////} ////if (value.TryGetValue("FullName", out token)) ////{ //// customer.FullName = value["FullName"].Value<string>(); ////} //PurchaseDelivery customer = _uow.GetObjectByKey<PurchaseDelivery>(id); //JsonPopulateObjectHelper.PopulateObject(value.ToString(), _uow, customer); //_uow.CommitChanges(); PurchaseDelivery obj = null; obj = await _uow.GetObjectByKeyAsync <PurchaseDelivery>(id); if (obj == null) { return(NotFound()); } JsonPopulateObjectHelper.PopulateObject(values.ToString(), _uow, obj); addNewDetailsOnly(values, obj, false); deleteDetails(values, obj); await _uow.CommitChangesAsync(); return(Ok(obj)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> Post([FromBody] JObject values) { try { PurchaseDelivery obj = null; //PurchaseDelivery obj = JsonPopulateObjectHelper.PopulateObject<PurchaseDelivery>(values.ToString(), _uow); //PurchaseDelivery customer = new PurchaseDelivery(_uow); //customer.FullName = values["FullName"].Value<string>(); //_uow.CommitChanges(); obj = JsonPopulateObjectHelper.PopulateObject <PurchaseDelivery>(values.ToString(), _uow); addNewDetailsOnly(values, obj, true); await _uow.CommitChangesAsync(); //obj = JsonConvert.DeserializeObject<PurchaseDelivery>(values.ToString()); return(Ok(obj)); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void CopyToDO_Execute(object sender, SimpleActionExecuteEventArgs e) { PurchaseOrder sObject = (PurchaseOrder)View.CurrentObject; if (GeneralValues.LiveWithPost) { if (sObject.VerNo > sObject.PostVerNo) { genCon.showMsg("Operation fail", "Document has not yet sync. Please wait.", InformationType.Error); return; } foreach (PurchaseOrderDetail dtl in sObject.PurchaseOrderDetail) { if (dtl.VerNo > dtl.PostVerNo) { genCon.showMsg("Operation fail", "Document has not yet sync. Please wait.", InformationType.Error); return; } } } IObjectSpace ios = Application.CreateObjectSpace(); PurchaseDelivery tObject = ios.CreateObject <PurchaseDelivery>(); if (copyCon.CopyToDocument(sObject, tObject, ios, (DetailView)View)) { if (tObject.CardCode != null) { tObject.IsCopy = true; } genCon.showMsg("Operation Done", "New Purchase Delivery copied. Please save it.", InformationType.Success); genCon.openNewView(ios, tObject, ViewEditMode.Edit); return; } genCon.showMsg("Operation Done", "No Open Item for copied.", InformationType.Info); }
public async Task <IActionResult> Delete(int id) { try { //PurchaseDelivery customer = _uow.GetObjectByKey<PurchaseDelivery>(id); //_uow.Delete(customer); //_uow.CommitChanges(); PurchaseDelivery obj = await _uow.GetObjectByKeyAsync <PurchaseDelivery>(id); if (obj == null) { return(NotFound()); } _uow.Delete(obj); await _uow.CommitChangesAsync(); return(Ok(obj)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> GenGRN(string docno, [FromBody] JObject values) { try { PurchaseOrder sobj = _uow.Query <PurchaseOrder>().Where(pp => pp.DocNo == docno).FirstOrDefault(); if (sobj == null) { return(NotFound()); } PurchaseDelivery obj = JsonPopulateObjectHelper.PopulateObject <PurchaseDelivery>(values.ToString(), _uow); addNewDetailsOnly(values, obj, true); await _uow.CommitChangesAsync(); //obj = JsonConvert.DeserializeObject<PurchaseRequest>(values.ToString()); return(Ok(obj)); } catch (Exception ex) { throw new Exception(ex.Message); } }
//[HttpGet] //public List<DocTypeSeries> Get() //{ // List<DocTypeSeries> result = null; // XPQuery<DocTypeSeries> query = (XPQuery<DocTypeSeries>)_uow.Query<DocTypeSeries>(); // result = query.ToList<DocTypeSeries>(); // return result; //} private void addNewDetailsOnly(JObject value, PurchaseDelivery obj, bool IsNewHeader) { try { #region add details string detalclassname = "PurchaseDeliveryDetail"; bool isnew = false; int intkeyvalue = -1; JArray jarray = (JArray)value[detalclassname]; foreach (JObject Jdtl in jarray.Children()) { isnew = false; if (IsNewHeader) { isnew = true; } else { if (Jdtl.ContainsKey("Oid")) { if (Jdtl["Oid"] == null) { isnew = true; } else { if (int.TryParse(Jdtl["Oid"].ToString(), out intkeyvalue)) { if (intkeyvalue == -1) { isnew = true; } } } } else { isnew = true; } } if (isnew) { if (Jdtl.ContainsKey("IsBeingDelete")) { if (Jdtl["IsBeingDelete"].ToString() == "1" || Jdtl["IsBeingDelete"].ToString().ToUpper() == "TRUE") { isnew = false; } } if (isnew) { PurchaseDeliveryDetail dtl = JsonPopulateObjectHelper.PopulateObject <PurchaseDeliveryDetail>(Jdtl.ToString(), _uow); obj.PurchaseDeliveryDetail.Add(dtl); } } } #endregion } catch (Exception ex) { throw new Exception(ex.Message); } }
public void GetDetailClassVisOrder(ClassDocument tObject, ref int minvalue, ref int maxvisorder) { int comparevalue = 0; int comparevisorder = 0; if (tObject.GetType() == typeof(PurchaseRequest)) { PurchaseRequest masterobject = (PurchaseRequest)tObject; if (masterobject.PurchaseRequestDetail.Count > 0) { comparevalue = masterobject.PurchaseRequestDetail.Min(pp => pp.Oid); comparevisorder = masterobject.PurchaseRequestDetail.Max(pp => pp.VisOrder); } if (comparevalue <= minvalue) { minvalue = comparevalue - 1; } if (comparevisorder >= maxvisorder) { maxvisorder = comparevisorder + 1; } } else if (tObject.GetType() == typeof(PurchaseOrder)) { PurchaseOrder masterobject = (PurchaseOrder)tObject; if (masterobject.PurchaseOrderDetail.Count > 0) { comparevalue = masterobject.PurchaseOrderDetail.Min(pp => pp.Oid); comparevisorder = masterobject.PurchaseOrderDetail.Max(pp => pp.VisOrder); } if (comparevalue <= minvalue) { minvalue = comparevalue - 1; } if (comparevisorder >= maxvisorder) { maxvisorder = comparevisorder + 1; } } else if (tObject.GetType() == typeof(PurchaseDelivery)) { PurchaseDelivery masterobject = (PurchaseDelivery)tObject; if (masterobject.PurchaseDeliveryDetail.Count > 0) { comparevalue = masterobject.PurchaseDeliveryDetail.Min(pp => pp.Oid); comparevisorder = masterobject.PurchaseDeliveryDetail.Max(pp => pp.VisOrder); } if (comparevalue <= minvalue) { minvalue = comparevalue - 1; } if (comparevisorder >= maxvisorder) { maxvisorder = comparevisorder + 1; } } else if (tObject.GetType() == typeof(PurchaseReturn)) { PurchaseReturn masterobject = (PurchaseReturn)tObject; if (masterobject.PurchaseReturnDetail.Count > 0) { comparevalue = masterobject.PurchaseReturnDetail.Min(pp => pp.Oid); comparevisorder = masterobject.PurchaseReturnDetail.Max(pp => pp.VisOrder); } if (comparevalue <= minvalue) { minvalue = comparevalue - 1; } if (comparevisorder >= maxvisorder) { maxvisorder = comparevisorder + 1; } } else if (tObject.GetType() == typeof(PurchaseQuotation)) { PurchaseQuotation masterobject = (PurchaseQuotation)tObject; if (masterobject.PurchaseQuotationDetail.Count > 0) { comparevalue = masterobject.PurchaseQuotationDetail.Min(pp => pp.Oid); comparevisorder = masterobject.PurchaseQuotationDetail.Max(pp => pp.VisOrder); } if (comparevalue <= minvalue) { minvalue = comparevalue - 1; } if (comparevisorder >= maxvisorder) { maxvisorder = comparevisorder + 1; } } }
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); } }
public async Task <SaveResult> Save(PurchaseDelivery PurchaseOrder) { throw new NotImplementedException(); }
private void Controller_ObjectCreated(object sender, ObjectCreatedEventArgs e) { ListView lv = ((ListView)View); if (lv.CollectionSource is PropertyCollectionSource) { PropertyCollectionSource collectionSource = (PropertyCollectionSource)lv.CollectionSource; if (collectionSource.MasterObject != null) { int minvalue = 0; int maxvisorder = 0; if (collectionSource.MasterObjectType == typeof(StockTransferRequest) && e.CreatedObject.GetType() == typeof(StockTransferRequestDetail)) { StockTransferRequest masterobject = (StockTransferRequest)collectionSource.MasterObject; StockTransferRequestDetail currentobject = (StockTransferRequestDetail)e.CreatedObject; copyCon.GetStockDetailClassVisOrder(masterobject, ref minvalue, ref maxvisorder); currentobject.Oid = minvalue; currentobject.VisOrder = maxvisorder; if (sDtlS != null) { copyCon.copyClassStockTransferDocumentDetail(sDtlS, currentobject, e.ObjectSpace); } } else if (collectionSource.MasterObjectType == typeof(PurchaseOrder)) { PurchaseOrder masterobject = (PurchaseOrder)collectionSource.MasterObject; PurchaseOrderDetail currentobject = (PurchaseOrderDetail)e.CreatedObject; copyCon.GetDetailClassVisOrder(masterobject, ref minvalue, ref maxvisorder); currentobject.Oid = minvalue; currentobject.VisOrder = maxvisorder; currentobject.DocCur = currentobject.Session.GetObjectByKey <vwCurrency>(masterobject.DocCur.BoKey); if (sDtl != null) { copyCon.copyClassDocumentDetail(sDtl, currentobject, e.ObjectSpace); } } else if (collectionSource.MasterObjectType == typeof(PurchaseRequest)) { PurchaseRequest masterobject = (PurchaseRequest)collectionSource.MasterObject; PurchaseRequestDetail currentobject = (PurchaseRequestDetail)e.CreatedObject; copyCon.GetDetailClassVisOrder(masterobject, ref minvalue, ref maxvisorder); currentobject.Oid = minvalue; currentobject.VisOrder = maxvisorder; if (masterobject.DocCur != null) { currentobject.DocCur = currentobject.Session.GetObjectByKey <vwCurrency>(masterobject.DocCur.BoKey); } if (sDtl != null) { copyCon.copyClassDocumentDetail(sDtl, currentobject, e.ObjectSpace); } } else if (collectionSource.MasterObjectType == typeof(PurchaseDelivery)) { PurchaseDelivery masterobject = (PurchaseDelivery)collectionSource.MasterObject; PurchaseDeliveryDetail currentobject = (PurchaseDeliveryDetail)e.CreatedObject; copyCon.GetDetailClassVisOrder(masterobject, ref minvalue, ref maxvisorder); currentobject.Oid = minvalue; currentobject.VisOrder = maxvisorder; if (masterobject.DocCur != null) { currentobject.DocCur = currentobject.Session.GetObjectByKey <vwCurrency>(masterobject.DocCur.BoKey); } if (sDtl != null) { copyCon.copyClassDocumentDetail(sDtl, currentobject, e.ObjectSpace); } } else if (collectionSource.MasterObjectType == typeof(PurchaseReturn)) { PurchaseReturn masterobject = (PurchaseReturn)collectionSource.MasterObject; PurchaseReturnDetail currentobject = (PurchaseReturnDetail)e.CreatedObject; copyCon.GetDetailClassVisOrder(masterobject, ref minvalue, ref maxvisorder); currentobject.Oid = minvalue; currentobject.VisOrder = maxvisorder; if (masterobject.DocCur != null) { currentobject.DocCur = currentobject.Session.GetObjectByKey <vwCurrency>(masterobject.DocCur.BoKey); } if (sDtl != null) { copyCon.copyClassDocumentDetail(sDtl, currentobject, e.ObjectSpace); } } else if (collectionSource.MasterObjectType == typeof(PurchaseQuotation)) { PurchaseQuotation masterobject = (PurchaseQuotation)collectionSource.MasterObject; PurchaseQuotationDetail currentobject = (PurchaseQuotationDetail)e.CreatedObject; copyCon.GetDetailClassVisOrder(masterobject, ref minvalue, ref maxvisorder); currentobject.Oid = minvalue; currentobject.VisOrder = maxvisorder; if (masterobject.DocCur != null) { currentobject.DocCur = currentobject.Session.GetObjectByKey <vwCurrency>(masterobject.DocCur.BoKey); } if (sDtl != null) { copyCon.copyClassDocumentDetail(sDtl, currentobject, e.ObjectSpace); } } } } sDtl = null; sDtlS = null; }