public void AddChildArray(String arrName, CTable data)
{
ArrayList arr = dbobj.GetChildArray(arrName);
if (arr == null)
{
arr = new ArrayList();
dbobj.AddChildArray(arrName, arr);
}
arr.Add(data);
}
private void CalculateCompanyCommissionProfile()
{
CPriceProcessor.SetGetCompanyPackageAllCallback(OnixWebServiceAPI.GetCompanyPackageAll);
CUtil.EnableForm(false, this);
CTable t = new CTable("COMPANY_PACKAGE");
companyPackage = new MCompanyPackage(t);
companyPackage.CompanyID = "1";
CTable m = OnixWebServiceAPI.GetCompanyPackageInfo(companyPackage.GetDbObject());
if (m != null)
{
companyPackage.SetDbObject(m);
companyPackage.InitChildItems();
companyPackage.NotifyAllPropertiesChanged();
}
CPriceProcessor.LoadStandardPackages(companyPackage);
CUtil.EnableForm(true, this);
CBasketSet bks = CPriceProcessor.CreateInitialBasketSet(billSim.SelectedItems);
CUtil.EnableForm(false, this);
Boolean tmp = billSim.IsModified;
CBasketSet output = CPriceProcessor.PromotionProcessing(companyPackage, bks, billSim);
CPriceProcessor.CreateDisplayProcessingTreeView(billSim);
CPriceProcessor.CreateDisplayView(output, billSim, null);
billSim.NotifyAllPropertiesChanged();
ArrayList arrBill = ConvertResultItems(billSim.ResultItems);
ArrayList arrCommission = companyCommission.GetDbObject().GetChildArray("COMPANY_COMM_PROFILE_ITEM");
CTable oCal = new CTable("");
oCal.AddChildArray("BILL_LIST", arrBill);
oCal.AddChildArray("COMMISSION_LIST", arrCommission);
ArrayList CalComm = OnixWebServiceAPI.CalculateBillCommission(oCal);
billSim.InitCommissionItems(CalComm);
//CUtil.LoadMasterRefCombo(cboBranch, true, MasterRefEnum.MASTER_BRANCH, billSim.BranchId);
billSim.IsModified = tmp;
CUtil.EnableForm(true, this);
TabMain.SelectedIndex = 3;
}
public void InitItem(GenericStringTypeFilterCallback requireFunc)
{
items.Clear();
CTable o = GetDbObject();
ArrayList narr = o.GetChildArray("DOCUMENT_NUMBER_LIST");
if (narr == null)
{
narr = new ArrayList();
o.AddChildArray("DOCUMENT_NUMBER_LIST", narr);
}
foreach (CTable t in narr)
{
MDocumentNumber v = new MDocumentNumber(t);
if (!requireFunc(v.DocType))
{
continue;
}
items.Add(v);
v.ExtFlag = "I";
}
}
public void InitBranchPOSs()
{
details.Clear();
CTable o = GetDbObject();
if (o == null)
{
return;
}
ArrayList arr = o.GetChildArray("BRNCH_CONFIG_POS_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("BRNCH_CONFIG_POS_ITEM", arr);
}
foreach (CTable t in arr)
{
MBranchConfigPosCenter v = new MBranchConfigPosCenter(t);
details.Add(v);
v.ExtFlag = "I";
v.Seq = internalSeq;
internalSeq++;
}
}
public void InitPeriods()
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("PACKAGE_PERIOD_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("PACKAGE_PERIOD_ITEM", arr);
}
for (int d = 1; d <= 7; d++)
{
CTable dbo = getObjectByDay(arr, d.ToString());
if (dbo == null)
{
dbo = new CTable("PERIOD");
MPeriod p = new MPeriod(dbo);
p.ExtFlag = "A";
p.DayOfWeek = d.ToString();
p.CreateDefaultValue();
arr.Add(dbo);
periods.Add(p);
}
else
{
MPeriod p = new MPeriod(dbo);
p.ExtFlag = "I";
periods.Add(p);
}
}
}
public void InitPackageCustomers()
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("PACKAGE_CUSTOMER_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("PACKAGE_CUSTOMER_ITEM", arr);
}
int cnt = 0;
foreach (CTable t in arr)
{
MPackageCustomer v = new MPackageCustomer(t);
package_customerFilter.Add(v);
v.ExtFlag = "I";
v.Seq = customerItemSeq;
customerItemSeq++;
cnt++;
}
}
public void AddPromotionItem(CBasketItemDisplay itm, String arrName)
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray(arrName);
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray(arrName, arr);
}
itm.ExtFlag = "A";
itm.Seq = seq;
itm.DisplayCategory = getDisplayCategory(arrName);
ObservableCollection <CBasketItemDisplay> items = getNameMapArray(arrName);
CTable t = itm.CreateCTableObject();
t.SetFieldValue("INTERNAL_SEQ", seq.ToString());
arr.Add(t);
seq++;
items.Add(itm);
}
public void InitItem(GenericStringTypeFilterCallback requireFunc)
{
items.Clear();
CTable o = GetDbObject();
ArrayList narr = o.GetChildArray("GLOBAL_VARIABLE_ITEM");
if (narr == null)
{
narr = new ArrayList();
o.AddChildArray("GLOBAL_VARIABLE_ITEM", narr);
}
foreach (CTable t in narr)
{
MGlobalVariable v = new MGlobalVariable(t);
if (!requireFunc(v.VariableName))
{
continue;
}
items.Add(v);
v.ExtFlag = "I";
}
}
public void AddBranchPOS()
{
CTable t = new CTable("");
MBranchConfigPosCenter vp = new MBranchConfigPosCenter(t);
CTable o = GetDbObject();
if (o == null)
{
return;
}
ArrayList arr = o.GetChildArray("BRNCH_CONFIG_POS_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("BRNCH_CONFIG_POS_ITEM", arr);
}
arr.Add(vp.GetDbObject());
details.Add(vp);
vp.Seq = internalSeq;
internalSeq++;
vp.ExtFlag = "A";
}
public void InitPackageVoucherFilters()
{
package_voucherBuy.Clear();
package_voucherFree.Clear();
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("PACKAGE_VOUCHER_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("PACKAGE_VOUCHER_ITEM", arr);
}
int cntBuy = 0, cntFree = 0;
foreach (CTable t in arr)
{
MPackageVoucher v = new MPackageVoucher(t);
if (v.QuantityType.Equals("1"))
{
package_voucherBuy.Add(v);
cntBuy++;
}
else if (v.QuantityType.Equals("2"))
{
package_voucherFree.Add(v);
cntFree++;
}
v.ExtFlag = "I";
v.Seq = voucherItemSeq;
voucherItemSeq++;
}
}
public void InitPackageDiscountFilters()
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("PACKAGE_DISCOUNT_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("PACKAGE_DISCOUNT_ITEM", arr);
}
int cnt = 0;
foreach (CTable t in arr)
{
MPackageDiscount v = new MPackageDiscount(t);
package_discountFilter.Add(v);
v.ExtFlag = "I";
v.Seq = priceItemSeq;
priceItemSeq++;
cnt++;
}
}
public void InitPackageBonusFilters()
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("PACKAGE_BONUS_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("PACKAGE_BONUS_ITEM", arr);
}
int cntBuy = 0, cntFree = 0;
foreach (CTable t in arr)
{
MPackageBonus v = new MPackageBonus(t);
if (v.QuantityType.Equals("1"))
{
package_bonusFilterBuy.Add(v);
cntBuy++;
}
else if (v.QuantityType.Equals("2"))
{
package_bonusFilterFree.Add(v);
cntFree++;
}
v.ExtFlag = "I";
v.Seq = bonusItemSeq;
bonusItemSeq++;
}
}
public void AddChildItems(ObservableCollection <MCompanyCommissionProfile> items, MCompanyCommissionProfile vw, MCommissionProfile cv)
{
CTable t = new CTable("COMPANY_COMM_PROFILE");
t.CopyFrom(cv.GetDbObject());
MCompanyCommissionProfile v = new MCompanyCommissionProfile(t);
v.CompanyCommProfID = "";
v.CompanyID = "1";
v.SeqNo = (v.GetMaxSeqNo((items)) + 1).ToString();
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("COMPANY_COMM_PROFILE_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("COMPANY_COMM_PROFILE_ITEM", arr);
}
arr.Add(t);
items.Add(v);
v.ExtFlag = "A";
}
public void PopulateQuerySortSetting(CTable table)
{
String arrName = "@ORDER_BY_COLUMNS";
table.RemoveChildArray(arrName);
table.AddChildArray(arrName, getOrderByColumns());
}
private void saveData()
{
ArrayList arr1 = new ArrayList();
CTable o = orgDoc.GetDbObject();
ArrayList arr2 = doc.GetDbObject().GetChildArray("ACCOUNT_DOC_DISCOUNTS");
if (arr2 == null)
{
return;
}
foreach (CTable t in arr2)
{
arr1.Add(t);
}
o.RemoveChildArray("ACCOUNT_DOC_DISCOUNTS");
o.AddChildArray("ACCOUNT_DOC_DISCOUNTS", arr1);
orgDoc.DiscountItems.Clear();
foreach (MAccountDocDiscount pmt in doc.DiscountItems)
{
orgDoc.DiscountItems.Add(pmt);
}
orgDoc.FinalDiscount = doc.FinalDiscount;
}
//Send OBJECT node to this function
private CTable populateTableObject(XmlNode node)
{
CTable table = new CTable(node.Attributes["name"].Value);
foreach (XmlNode n1 in node.ChildNodes)
{
if (n1.Name.Equals("FIELD"))
{
table.SetFieldValue(n1.Attributes["name"].Value, n1.InnerText);
}
else if (n1.Name.Equals("ITEMS"))
{
String arrName = n1.Attributes["name"].Value;
ArrayList arr = new ArrayList();
table.AddChildArray(arrName, arr);
foreach (XmlNode n2 in n1.ChildNodes)
{
//Only OBJECTs are here
if (n2.Name.Equals("OBJECT"))
{
//Recursive
CTable child = populateTableObject(n2);
arr.Add(child);
}
}
}
}
return(table);
}
private void saveData()
{
orgDoc.ChangeType = doc.ChangeType;
createChangeTransaction();
ArrayList arr1 = new ArrayList();
CTable o = orgDoc.GetDbObject();
ArrayList arr2 = doc.GetDbObject().GetChildArray("ACCOUNT_DOC_PAYMENTS");
if (arr2 == null)
{
return;
}
foreach (CTable t in arr2)
{
arr1.Add(t);
}
o.RemoveChildArray("ACCOUNT_DOC_PAYMENTS");
o.AddChildArray("ACCOUNT_DOC_PAYMENTS", arr1);
orgDoc.PaymentItems.Clear();
foreach (MAccountDocPayment pmt in doc.PaymentItems)
{
orgDoc.PaymentItems.Add(pmt);
}
}
public void InitPackageBranches()
{
package_branches.Clear();
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("PACKAGE_BRANCH_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("PACKAGE_BRANCH_ITEM", arr);
}
Hashtable temp = new Hashtable();
foreach (CTable t in arr)
{
MPackageBranch v = new MPackageBranch(t);
package_branches.Add(v);
temp[v.BranchId] = "dummy";
v.ExtFlag = "I";
v.Seq = internalSeq;
internalSeq++;
}
if (!CMasterReference.IsMasterRefLoad(MasterRefEnum.MASTER_BRANCH))
{
CMasterReference.LoadAllMasterRefItems(OnixWebServiceAPI.GetMasterRefList);
}
foreach (MMasterRef mr in CMasterReference.Instance.Branches)
{
if (mr.MasterID.Equals(""))
{
continue;
}
if (temp.ContainsKey(mr.MasterID))
{
continue;
}
MPackageBranch v = new MPackageBranch(new CTable(""));
v.Code = mr.Code;
v.Name = mr.Description;
v.BranchId = mr.MasterID;
v.ExtFlag = "A";
package_branches.Add(v);
arr.Add(v.GetDbObject());
v.Seq = internalSeq;
internalSeq++;
}
}
public CExcelRenderer(String reportName)
{
cacheRows = new ArrayList();
cacheObj = new CTable(reportName);
cacheObj.AddChildArray("ROWS", cacheRows);
rptName = reportName;
}
public void PrepareForSaving()
{
CTable o = GetDbObject();
ArrayList arr = new ArrayList();
foreach (String key in fieldHash.Keys)
{
MGlobalVariable s = (MGlobalVariable)fieldHash[key];
arr.Add(s.GetDbObject());
}
o.RemoveChildArray("REPORT_CONFIG_LIST");
o.AddChildArray("REPORT_CONFIG_LIST", arr);
}
public void AddTxItem(MInventoryTransaction tx, InventoryDocumentType idt)
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("TX_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("TX_ITEM", arr);
}
arr.Add(tx.GetDbObject());
txitems.Add(tx);
}
public void AddExpenseItem(MVPayrollExpenseItem m)
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("OT_EXPENSE_LIST");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("OT_EXPENSE_LIST", arr);
}
m.ExtFlag = "A";
arr.Add(m.GetDbObject());
expenseItems.Add(m);
}
public void AddDeductionItem(MVPayrollDeductionItem m)
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("DEDUCTION_LIST");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("DEDUCTION_LIST", arr);
}
m.ExtFlag = "A";
arr.Add(m.GetDbObject());
deductionItems.Add(m);
}
public void AddXferItem(MCashDocXferDetail vp)
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("CASH_XFER_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("CASH_XFER_ITEM", arr);
}
vp.ExtFlag = "A";
arr.Add(vp.GetDbObject());
xferItems.Add(vp);
}
public void AddLeaveRecord(MLeaveRecord item)
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("EMPLOYEE_LEAVE_RECORDS");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("EMPLOYEE_LEAVE_RECORDS", arr);
}
item.ExtFlag = "A";
arr.Add(item.GetDbObject());
leaveItems.Add(item);
}
private ArrayList ConvertResultItems(ObservableCollection <CBasketItemDisplay> results)
{
ArrayList headItem = new ArrayList();
ArrayList resultItem = new ArrayList();
CTable m = new CTable("");
foreach (CBasketItemDisplay id in results)
{
CTable t = Convert2CTable(id);
resultItem.Add(t);
}
m.AddChildArray("BILL_ITEM", resultItem);
headItem.Add(m);
return(headItem);
}
public static CTable GetCTableObject(String id, String name)
{
CTable n = new CTable("");
ArrayList arr = new ArrayList();
foreach (MUserVariable m in variables)
{
m.UserID = id;
m.UserName = name;
arr.Add(m.GetDbObject());
}
n.AddChildArray("USER_VARIABLE_ITEM", arr);
return(n);
}
public void AddBranchItem(MPackageBranch vp)
{
CTable o = GetDbObject();
ArrayList arr = o.GetChildArray("PACKAGE_BRANCH_ITEM");
if (arr == null)
{
arr = new ArrayList();
o.AddChildArray("PACKAGE_BRANCH_ITEM", arr);
}
arr.Add(vp.GetDbObject());
package_branches.Add(vp);
vp.Seq = internalSeq;
internalSeq++;
}
public static CTable GetCTableObject()
{
CTable n = new CTable("");
ArrayList arr = new ArrayList();
foreach (MGlobalVariable m in globalvariables)
{
//m.UserID = id;
//m.UserName = name;
arr.Add(m.GetDbObject());
}
n.AddChildArray("GLOBAL_VARIABLE_ITEM", arr);
return(n);
}
public void AddRow(CRow row)
{
String name = row.GetName();
if (name.Contains("GLB_HEADER_LEVEL0"))
{
currentPage++;
}
if ((currentPage > 1) && name.Contains("HEADER"))
{
//Skip header if page greater than 1
return;
}
currentRow++;
ArrayList arr = (ArrayList)rowMergedParam[name];
if (arr == null)
{
return;
}
int cnt = row.GetColumnCount();
String rowText = String.Format("{0}", name);
CTable cacheRow = new CTable("ROW");
cacheRow.SetFieldValue("ROW_ID", currentRow.ToString());
cacheRow.SetFieldValue("ROW_TYPE", row.GetName());
cacheRow.AddChildArray("COLUMNS", new ArrayList());
cacheRows.Add(cacheRow);
for (int i = 0; i < cnt; i++)
{
CMergeCellParam mergedParam = (CMergeCellParam)arr[i];
CColumn col = row.GetColumn(i);
String text = col.GetText().Text;
populateCacheRow(cacheRow, mergedParam, row, col);
}
String dummy = rowText;
}
