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);
}
