private Boolean ValidateData() { Boolean result = false; result = CHelper.ValidateTextBox(lblItemCategoryName, txtItemCategoryName, false); if (!result) { return(result); } CTable ug = new CTable("ITEM_CATEGORY"); MItemCategory uv = new MItemCategory(ug); if (vw != null) { uv.ItemCategoryID = (vw as MItemCategory).ItemCategoryID; uv.CategoryName = (vw as MItemCategory).CategoryName; } if (OnixWebServiceAPI.IsItemCategoryExist(uv.GetDbObject())) { CHelper.ShowKeyExist(lblItemCategoryName, txtItemCategoryName); return(false); } return(result); }
private void cmdTaxReport_Click(object sender, RoutedEventArgs e) { bool result = CHelper.ValidateTextBox(lblEmployeeTax, txtTaxYear, false); if (!result) { return; } MEmployee emp = vw as MEmployee; CTable dat = emp.GetDbObject().CloneAll(); dat.SetFieldValue("TAX_YEAR", txtTaxYear.Text); dat.SetFieldValue("EMPLOYEE_ID", emp.EmployeeID); CTable obj = OnixWebServiceAPI.SubmitObjectAPI("GetEmployeeTaxYearSummary", dat); ArrayList arr = obj.GetChildArray("EMPLOYEE_YEARLY_SUMMARY"); emp.EmployeeTax.TaxYear = txtTaxYear.Text; if (arr.Count > 0) { CTable o = (CTable)arr[0]; emp.EmployeeTax.TaxAmount = o.GetFieldValue("DEDUCT_TAX"); emp.EmployeeTax.RevenueAmount = o.GetFieldValue("RECEIVE_AMOUNT"); emp.EmployeeTax.SocialInsuranceAmount = o.GetFieldValue("DEDUCT_SOCIAL_SECURITY"); } WinFormPrinting w = new WinFormPrinting("grpHRTax", emp); w.ShowDialog(); }
protected override ArrayList getRecordSet() { //Parameter.SetFieldValue("DOCUMENT_YYYY", "2018"); ArrayList arr = OnixWebServiceAPI.GetProfitByDocTypeMonth(Parameter); return(arr); }
public override Tuple <CTable, ObservableCollection <MBaseModel> > QueryData() { MVTaxDocument ad = (model as MVTaxDocument); CTable tb = ad.GetDbObject(); tb.SetFieldValue("DOCUMENT_TYPE_SET", "(4)"); items = OnixWebServiceAPI.GetListAPI("GetTaxDocList", "TAX_DOC_LIST", tb); lastObjectReturned = OnixWebServiceAPI.GetLastObjectReturned(); itemSources.Clear(); int idx = 0; foreach (CTable o in items) { MVTaxDocument v = new MVTaxDocument(o); v.RowIndex = idx; itemSources.Add(v); idx++; } Tuple <CTable, ObservableCollection <MBaseModel> > tuple = new Tuple <CTable, ObservableCollection <MBaseModel> >(lastObjectReturned, itemSources); return(tuple); }
//Get ScreenConfig by using the same API as GetReportConfig public void LoadScreenConfig() { CTable o = new CTable(""); o.SetFieldValue("REPORT_NAME", refID); o.SetFieldValue("USER_ID", OnixWebServiceAPI.UserID()); ArrayList arr = OnixWebServiceAPI.GetReportConfigList(o); if (arr.Count <= 0) { return; } CTable obj = (CTable)arr[0]; CTable info = OnixWebServiceAPI.GetReportConfigInfo(obj); scrConfig.SetDbObject(info); ArrayList cols = info.GetChildArray("SORTABLE_COLUMN_ITEMS"); if (cols == null) { return; } foreach (CTable t in cols) { MCriteriaColumn v = new MCriteriaColumn(t); scrConfig.SortingColumns.Add(v); } }
private MVTaxFormPRV3_53 fetchData() { if (currIdx >= arr.Count) { CTable t = new CTable(""); t.SetFieldValue("TAX_DOC_ID", actualView.TaxDocID); t.SetFieldValue("EXT_CHUNK_NO", chunk.ToString()); arr = OnixWebServiceAPI.GetListAPI("GetTaxDocRv3Rv53List", "TAX_DOC_REV_LIST", t); CTable lastObj = OnixWebServiceAPI.GetLastObjectReturned(); chunkCount = CUtil.StringToInt(lastObj.GetFieldValue("EXT_CHUNK_COUNT")); recordCount = CUtil.StringToInt(lastObj.GetFieldValue("EXT_RECORD_COUNT")); currIdx = 0; chunk++; } if (arr.Count > 0) { CTable o = (CTable)arr[currIdx]; currIdx++; currRecord++; MVTaxFormPRV3_53 m = new MVTaxFormPRV3_53(o); return(m); } return(null); }
private void mnuContextMenu_Click(object sender, RoutedEventArgs e) { MenuItem mnu = (sender as MenuItem); string name = mnu.Name; if (name.Equals("mnuEdit")) { showEditWindow(); } else if (name.Equals("mnuCopy")) { CUtil.EnableForm(false, ParentControl); CTable newobj = OnixWebServiceAPI.CopyEmployee(currentObj.GetDbObject()); if (newobj != null) { MVEmployee ivd = new MVEmployee(newobj); itemSources.Insert(0, ivd); } else { //Error here CHelper.ShowErorMessage(OnixWebServiceAPI.GetLastErrorDescription(), "ERROR_USER_ADD", null); } CUtil.EnableForm(true, ParentControl); } }
private void mnuContextMenu_Click(object sender, RoutedEventArgs e) { MenuItem mnu = (sender as MenuItem); string name = mnu.Name; if (name.Equals("mnuEdit")) { showEditWindow(); } else if (name.Equals("mnuCopy")) { CUtil.EnableForm(false, ParentControl); CTable newobj = OnixWebServiceAPI.SubmitObjectAPI("CopyCashDoc", currentObj.GetDbObject()); if (newobj != null) { MCashDoc ivd = new MCashDocXfer(newobj); ItemAddedEvent(ivd, e); } else { //Error here CHelper.ShowErorMessage(OnixWebServiceAPI.GetLastErrorDescription(), "ERROR_USER_ADD", null); } CUtil.EnableForm(true, ParentControl); } }
public override Tuple <CTable, ObservableCollection <MBaseModel> > QueryData() { MAccountDoc mp = model as MAccountDoc; mp.Category = eType; CTable tb = model.GetDbObject(); String tmpSet = "(1, 2)"; //Only pending and approved, no cancled status tb.SetFieldValue("DOCUMENT_STATUS_SET", tmpSet); items = OnixWebServiceAPI.GetBillSummaryAbleDocList(tb); lastObjectReturned = OnixWebServiceAPI.GetLastObjectReturned(); itemSources.Clear(); int idx = 0; foreach (CTable o in items) { MAccountDoc v = new MAccountDoc(o); v.RowIndex = idx; itemSources.Add(v); idx++; } Tuple <CTable, ObservableCollection <MBaseModel> > tuple = new Tuple <CTable, ObservableCollection <MBaseModel> >(lastObjectReturned, itemSources); return(tuple); }
public override Tuple <CTable, ObservableCollection <MBaseModel> > QueryData() { MAccountDocPayment mp = model as MAccountDocPayment; CTable tb = model.GetDbObject(); tb.SetFieldValue("CHUNK_FLAG", "Y"); tb.SetFieldValue("OWNER_FLAG", "Y"); tb.SetFieldValue("DOCUMENT_STATUS", "2"); tb.SetFieldValue("IS_NULL_REFUND_STATUS", "Y"); tb.SetFieldValue("REFUND_STATUS", ""); items = OnixWebServiceAPI.GetListAPI("GetPaymentTransactionList", "PAYMENT_TRANSACTION_LIST", tb); lastObjectReturned = OnixWebServiceAPI.GetLastObjectReturned(); itemSources.Clear(); int idx = 0; foreach (CTable o in items) { MAccountDocPayment v = new MAccountDocPayment(o); v.RowIndex = idx; itemSources.Add(v); idx++; } Tuple <CTable, ObservableCollection <MBaseModel> > tuple = new Tuple <CTable, ObservableCollection <MBaseModel> >(lastObjectReturned, itemSources); return(tuple); }
public override Tuple <CTable, ObservableCollection <MBaseModel> > QueryData() { (model as MCashDoc).DocumentType = ((int)docType).ToString(); items = OnixWebServiceAPI.GetListAPI("GetCashDocList", "CASH_DOC_LIST", model.GetDbObject()); lastObjectReturned = OnixWebServiceAPI.GetLastObjectReturned(); itemSources.Clear(); foreach (CTable o in items) { MCashDoc v = null; if (docType == CashDocumentType.CashDocImport) { v = new MCashDocIn(o); } else { v = new MCashDocOut(o); } itemSources.Add(v); } Tuple <CTable, ObservableCollection <MBaseModel> > tuple = new Tuple <CTable, ObservableCollection <MBaseModel> >(lastObjectReturned, itemSources); return(tuple); }
private Boolean SaveData(String approveFlag) { //if (!CHelper.VerifyAccessRight("GENERIC_PACKAGE_ADD")) //{ // return (false); //} //Edit mode, always if (vw.IsModified) { Boolean result = SaveToView(); if (result) { CUtil.EnableForm(false, this); CTable t = OnixWebServiceAPI.UpdateDocumentNumber(vw.GetDbObject()); CUtil.EnableForm(true, this); if (t != null) { return(true); } CHelper.ShowErorMessage(OnixWebServiceAPI.GetLastErrorDescription(), "ERROR_USER_EDIT", null); } return(false); } return(true); }
private void CmdAuto_Click(object sender, RoutedEventArgs e) { if (mv.EmployeeID.Equals("")) { return; } CUtil.EnableForm(false, this); CTable dat = new CTable(""); dat.SetFieldValue("FROM_DOCUMENT_DATE", CUtil.DateTimeToDateStringInternalMin(mvParent.FromSalaryDate)); dat.SetFieldValue("TO_DOCUMENT_DATE", CUtil.DateTimeToDateStringInternalMax(mvParent.ToSalaryDate)); dat.SetFieldValue("EMPLOYEE_ID", mv.EmployeeID); ArrayList arr = OnixWebServiceAPI.GetListAPI("GetEmployeePayrollAccumulate", "PAYROLL_EMPLOYEE_ACCUM_LIST", dat); mv.ReceiveOT = getAmount(arr, "EMPLOYEE_OT"); if (mvParent.EmployeeType.Equals("1")) { mv.ReceiveIncome = getAmount(arr, "EMPLOYEE_WORK"); } mv.ReceiveTransaportation = getAmount(arr, "EMPLOYEE_EXPENSE"); mv.DeductPenalty = getAmount(arr, "EMPLOYEE_DEDUCTION"); CUtil.EnableForm(true, this); }
private void populateSalary() { if (isInLoad) { return; } if (mv.EmployeeID.Equals("")) { return; } String empID = mv.EmployeeID; CTable dat = new CTable(""); dat.SetFieldValue("EMPLOYEE_ID", empID); CUtil.EnableForm(false, this); CTable empObj = OnixWebServiceAPI.SubmitObjectAPI("GetEmployeeInfo", dat); CUtil.EnableForm(true, this); MEmployee emp = new MEmployee(empObj); mv.ReceiveIncome = emp.Salary; }
private void cmdTest_Click(object sender, RoutedEventArgs e) { OnixConnectionXML dbos = new OnixConnectionXML(txtDesc.Password, url, "pemgail9uzpgzl88"); String sendString = "HELLOWORLD"; CTable t = new CTable(""); t.SetFieldValue("ECHO_MESSAGE", sendString); CUtil.EnableForm(false, this); CTable echo = OnixWebServiceAPI.TestServer(dbos, t); CUtil.EnableForm(true, this); if (echo == null) { CMessageBox.Show(OnixWebServiceAPI.GetLastErrorDescription(), "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } else { String returnStr = echo.GetFieldValue("RETURN_MESSAGE"); if (sendString.Equals(returnStr)) { CMessageBox.Show(CLanguage.getValue("connect_success"), "SUCCESS", MessageBoxButton.OK, MessageBoxImage.Information); } else { CMessageBox.Show(CLanguage.getValue("connect_fail"), "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); } } }
public override Tuple <CTable, ObservableCollection <MBaseModel> > QueryData() { MService svc = (MService)model; if (!category.Equals("0") && !category.Equals("")) { svc.Category = category; } svc.ServiceLevel = level; items = OnixWebServiceAPI.GetServiceList(model.GetDbObject()); lastObjectReturned = OnixWebServiceAPI.GetLastObjectReturned(); itemSources.Clear(); int idx = 0; foreach (CTable o in items) { MService v = new MService(o); v.RowIndex = idx; itemSources.Add(v); idx++; } Tuple <CTable, ObservableCollection <MBaseModel> > tuple = new Tuple <CTable, ObservableCollection <MBaseModel> >(lastObjectReturned, itemSources); return(tuple); }
protected override ArrayList getRecordSet() { //Parameter.SetFieldValue("DOCUMENT_YYYY", "2018"); ArrayList arr = OnixWebServiceAPI.GetListAPI("AcdGetProfitByDocTypeMonth", "DOCTYPE_SUMMARY_LIST", Parameter); return(arr); }
private Boolean ValidateData() { Boolean result = false; result = CHelper.ValidateTextBox(lblCycleCode, txtCycleCode, false); if (!result) { return(result); } result = CHelper.ValidateTextBox(lblCycleDesc, txtCycleDesc, true); if (!result) { return(result); } CTable ug = new CTable("CYCLE"); MCycle uv = new MCycle(ug); if (vw != null) { uv.CycleID = (vw as MCycle).CycleID; uv.CycleCode = (vw as MCycle).CycleCode; } if (OnixWebServiceAPI.IsCycleExist(uv.GetDbObject())) { CHelper.ShowKeyExist(lblCycleCode, txtCycleCode); return(false); } return(result); }
private void LoadData() { isInLoadData = true; this.Title = Caption; dtDocumentDate.Focus(); vw.CreateDefaultValue(); CUtil.EnableForm(false, this); if (Mode.Equals("E")) { CTable m = OnixWebServiceAPI.GetAccountDocInfo(actualView.GetDbObject()); if (m != null) { vw.SetDbObject(m); vw.NotifyAllPropertiesChanged(); } } else if (Mode.Equals("A")) { vw.DocumentDate = DateTime.Now; vw.DocumentType = ((int)dt).ToString(); vw.AllowCashNegative = CGlobalVariable.IsCashNegativeAllow(); vw.AllowARAPNegative = CGlobalVariable.IsArApNegativeAllow(); vw.AllowInventoryNegative = CGlobalVariable.IsInventoryNegativeAllow(); } vw.IsModified = false; isInLoadData = false; CUtil.EnableForm(true, this); }
private void LoadData() { txtCycleCode.Focus(); CTable t = new CTable("CYCLE"); vw = new MCycle(t); (vw as MCycle).CreateDefaultValue(); DataContext = vw; if (Mode.Equals("A")) { } else if (Mode.Equals("E")) { CTable m = OnixWebServiceAPI.GetCycleInfo(actualView.GetDbObject()); if (m != null) { vw.SetDbObject(m); (vw as MCycle).NotifyAllPropertiesChanged(); } } CUtil.LoadCycleType(cboCycleType, false, (vw as MCycle).CycleType); CUtil.LoadCycleDayWeekly(cboCycleWeekly, false, (vw as MCycle).DayOfWeek); CUtil.LoadCycleDayMonthly(cboCycleMonthly, false, (vw as MCycle).DayOfMonth); vw.IsModified = false; CUtil.EnableForm(true, this); }
private void cmdVerify_Click(object sender, RoutedEventArgs e) { Boolean r = SaveToView(); if (!r) { return; } CUtil.EnableForm(false, this); vw.DocumentType = ((int)dt).ToString(); CTable t = OnixWebServiceAPI.VerifyAccountDoc(vw.GetDbObject().Clone()); CUtil.EnableForm(true, this); if (t != null) { MInventoryDoc ivd = new MInventoryDoc(t); ivd.InitErrorItem(); if (ivd.ErrorItems.Count > 0) { WinErrorDetails w = new WinErrorDetails(ivd.ErrorItems, "InventoryDoc"); w.Title = CLanguage.getValue("approve_error"); w.ShowDialog(); } else { String msg = CLanguage.getValue("VERIFY_SUCCESS"); CMessageBox.Show(msg, "SUCCESS", MessageBoxButton.OK, MessageBoxImage.Information); } } }
public void InitTxCash() { CTable o = GetDbObject(); ArrayList arr = OnixWebServiceAPI.GetCashTransactionList(o); if (arr == null) { return; } int seq = 0; txCashMovement.Clear(); foreach (CTable t in arr) { MCashDoc v = new MCashDoc(t); if (seq == 0) { MCashDoc fw = new MCashDoc(t.Clone()); fw.IsBalanceForward = true; txCashMovement.Add(fw); } txCashMovement.Add(v); seq++; } }
protected void loadData() { CTable t = new CTable(""); vw = createObject(); DataContext = vw; CUtil.EnableForm(false, this); if (loadParam.Mode.Equals("E")) { CTable m = OnixWebServiceAPI.SubmitObjectAPI(getInfoAPIName, loadParam.ActualView.GetDbObject()); if (m != null) { vw.SetDbObject(m); vw.InitializeAfterLoaded(); vw.NotifyAllPropertiesChanged(); vw.InitializeAfterNotified(); } } vw.IsModified = false; isInLoad = false; CUtil.EnableForm(true, this); }
private void uSupplier_SelectedObjectChanged(object sender, EventArgs e) { if (!isInLoadData) { CTable cust = OnixWebServiceAPI.SubmitObjectAPI("GetEntityInfo", vw.EntityObj.GetDbObject()); MEntity en = new MEntity(cust); en.InitEntityAddress(); en.InitBankAccounts(); vw.ReloadEntityAddresses(en.AddressItems); vw.ReloadEntityBankAccount(en.BankAccounts); vw.CreditTermObj = en.CreditTermObj; vw.IsModified = true; if (en.AddressItems.Count > 0) { cboAddress.SelectedIndex = 0; } if (en.BankAccounts.Count > 0) { cboSupplierAccount.SelectedIndex = 0; } } }
private void cmdSaleOrderUnlink_Click(object sender, RoutedEventArgs e) { CTable m = new CTable(""); m.SetFieldValue("ACCOUNT_DOC_ID", vw.RefSaleOrderID); CUtil.EnableForm(false, this); CTable t = OnixWebServiceAPI.GetAccountDocInfo(m); CUtil.EnableForm(true, this); if (t == null) { return; } MAccountDoc vm = new MAccountDoc(t); Boolean ok = CHelper.AskConfirmMessage(vm.DocumentNo, "ERROR_SALE_ORDER_UNLINK"); if (!ok) { return; } OnixWebServiceAPI.UnlinkSaleOrderFromInvoice(vw.GetDbObject()); vw.RefSaleOrderID = ""; }
public static Boolean SaveReportConfig(UpdateFunction saveFunc, MReportConfig rptConfig) { rptConfig.PrepareForSaving(); CTable o = OnixWebServiceAPI.SaveReportConfig(rptConfig.GetDbObject()); return(true); }
public static void LoadUserGroupCombo(ComboBox cbo, Boolean allowEmpty, String id) { CTable obj = new CTable("USER_GROUP"); ArrayList arr = OnixWebServiceAPI.GetUserGroupList(obj); List <MUserGroup> items = new List <MUserGroup>(); int idx = 0; int selectedIndex = 0; if (allowEmpty) { MUserGroup v = new MUserGroup(null); v.RowIndex = idx; items.Add(v); idx++; } foreach (CTable o in arr) { MUserGroup v = new MUserGroup(o); v.RowIndex = idx; items.Add(v); if (v.GroupID.Equals(id)) { selectedIndex = idx; } idx++; } cbo.ItemsSource = items; cbo.SelectedIndex = selectedIndex; }
private void LoadData() { cboProduct.Focus(); CTable t = new CTable(""); vw = new MProject(t); vw.CreateDefaultValue(); DataContext = vw; CUtil.EnableForm(false, this); if (Mode.Equals("E")) { CTable m = OnixWebServiceAPI.SubmitObjectAPI("GetProjectInfo", actualView.GetDbObject()); if (m != null) { vw.SetDbObject(m); vw.NotifyAllPropertiesChanged(); } } vw.IsModified = false; CUtil.EnableForm(true, this); }
private void CmdAddProduct_Click(object sender, RoutedEventArgs e) { MVTaxDocument td = (MVTaxDocument)vw; if (td.TaxDocID.Equals("")) { CHelper.ShowErorMessage("", "ERROR_PLEASE_SAVE_FIRST", null); return; } Boolean result = validateData(); if (!result) { return; } TaxDocumentType tdt = (TaxDocumentType)CUtil.StringToInt(td.DocumentType); String tt = "53"; if (tdt == TaxDocumentType.TaxDocRev3) { tt = "3"; } CTable t = vw.GetDbObject(); t.SetFieldValue("RV_TAX_TYPE", tt); CUtil.EnableForm(false, this); CTable obj = OnixWebServiceAPI.SubmitObjectAPI("PopulateWhItems", t); CUtil.EnableForm(true, this); if (obj == null) { CHelper.ShowErorMessage("", "ERROR_NO_ITEM_FOUND", null); return; } if (obj != null) { td.ItemCount = obj.GetFieldValue("ITEM_COUNT"); td.WhAmount = obj.GetFieldValue("WH_AMOUNT"); td.ExpenseAmount = obj.GetFieldValue("EXPENSE_REVENUE_AMT"); td.PreviousRunMonth = obj.GetFieldValue("PREVIOUS_RUN_MONTH"); td.PreviousRunYear = obj.GetFieldValue("PREVIOUS_RUN_YEAR"); ArrayList arr = obj.GetChildArray("WH_ITEMS"); if (arr.Count <= 0) { //Just notify CHelper.ShowErorMessage("", "ERROR_NO_ITEM_FOUND", null); } td.PopulateWhItems(arr); td.IsModified = true; } }
private Boolean SaveData(String approveFlag) { if (!CHelper.VerifyAccessRight("GENERAL_VARIABLE_EDIT")) { return(false); } //Edit mode, always if (vw.IsModified) { Boolean result = SaveToView(); if (result) { CUtil.EnableForm(false, this); CTable t = OnixWebServiceAPI.UpdateGlobalVariable(vw.GetDbObject()); CUtil.EnableForm(true, this); if (t != null) { CGlobalVariable.InitGlobalVariables(); return(true); } CHelper.ShowErorMessage(OnixWebServiceAPI.GetLastErrorDescription(), "ERROR_USER_EDIT", null); } return(false); } return(true); }