protected void companyBankAccountRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView row = (DataRowView)e.Item.DataItem; CheckBox cb = (CheckBox)e.Item.FindControl("ItemSelect"); WebFormUtils.LoadKeys(ECompanyBankAccount.db, row, cb); ECompanyBankAccount companyBankAccount = new ECompanyBankAccount(); ECompanyBankAccount.db.toObject(row.Row, companyBankAccount); cb.Text = string.Format("{0}-{1}-{2} ({3})", new string[] { companyBankAccount.CompanyBankAccountBankCode, companyBankAccount.CompanyBankAccountBranchCode, companyBankAccount.CompanyBankAccountAccountNo, companyBankAccount.CompanyBankAccountHolderName }); DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", CurID)); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", companyBankAccount.CompanyBankAccountID)); if (ECompanyBankAccountMap.db.count(dbConn, companyBankAccountMapFilter) > 0) { cb.Checked = true; } else { cb.Checked = false; } } }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); ArrayList list = new ArrayList(); foreach (RepeaterItem i in Repeater.Items) { CheckBox cb = (CheckBox)i.FindControl("ItemSelect"); if (cb.Checked) { ECompanyBankAccount o = new ECompanyBankAccount(); WebFormUtils.GetKeys(db, o, cb); list.Add(o); } } foreach (ECompanyBankAccount o in list) { if (db.select(dbConn, o)) { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, o); DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", o.CompanyBankAccountID)); ECompanyBankAccountMap.db.delete(dbConn, companyBankAccountMapFilter); WebUtils.EndFunction(dbConn); } } view = loadData(info, db, Repeater); }
protected void companyBankAccountRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView row = (DataRowView)e.Item.DataItem; CheckBox cb = (CheckBox)e.Item.FindControl("ItemSelect"); Label CompanyBankAccountIDLabel = (Label)e.Item.FindControl("CompanyBankAccountID"); WebFormUtils.LoadKeys(ECompanyBankAccount.db, row, cb); ECompanyBankAccount companyBankAccount = new ECompanyBankAccount(); ECompanyBankAccount.db.toObject(row.Row, companyBankAccount); CompanyBankAccountIDLabel.Text = string.Format("{0}-{1}-{2} ({3})", new string[] { companyBankAccount.CompanyBankAccountBankCode, companyBankAccount.CompanyBankAccountBranchCode, companyBankAccount.CompanyBankAccountAccountNo, companyBankAccount.CompanyBankAccountHolderName }); } }
protected bool loadObject() { ECompanyBankAccount obj = new ECompanyBankAccount(); bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest); if (!db.select(dbConn, obj)) { return(false); } Hashtable values = new Hashtable(); db.populate(obj, values); binding.toControl(values); return(true); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); ECompanyBankAccount c = new ECompanyBankAccount(); c.CompanyBankAccountID = CurID; if (db.select(dbConn, c)) { WebUtils.StartFunction(Session, FUNCTION_CODE); db.delete(dbConn, c); DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", c.CompanyBankAccountID)); ECompanyBankAccountMap.db.delete(dbConn, companyBankAccountMapFilter); WebUtils.EndFunction(dbConn); } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "CompanyBankAccount_List.aspx"); }
protected void Save_Click(object sender, EventArgs e) { ECompanyBankAccount c = new ECompanyBankAccount(); Hashtable values = new Hashtable(); binding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); if (c.CompanyBankAccountAccountNo.Length > 0) { if (!c.CompanyBankAccountBankCode.Equals("152") && !c.CompanyBankAccountBankCode.Equals("055")) { if (c.CompanyBankAccountAccountNo.Length > 9) { errors.addError("CompanyBankAccountAccountNo", "validate.maxlength", 9); } long dummyValue; if (!long.TryParse(c.CompanyBankAccountAccountNo, out dummyValue)) { errors.addError("CompanyBankAccountAccountNo", "validate.int"); } } } if (!errors.isEmpty()) { return; } WebUtils.StartFunction(Session, FUNCTION_CODE); if (CurID < 0) { // Utils.MarkCreate(Session, c); db.insert(dbConn, c); CurID = c.CompanyBankAccountID; // url = Utils.BuildURL(-1, CurID); } else { // Utils.Mark(Session, c); db.update(dbConn, c); } ArrayList selectedList = new ArrayList(); ArrayList unselectedList = new ArrayList(); foreach (RepeaterItem i in companyRepeater.Items) { CheckBox cb = (CheckBox)i.FindControl("ItemSelect"); ECompany o = new ECompany(); WebFormUtils.GetKeys(ECompany.db, o, cb); if (cb.Checked) { selectedList.Add(o); } else { unselectedList.Add(o); } } foreach (ECompany o in selectedList) { DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", o.CompanyID)); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", CurID)); ArrayList companyBankAccountMapList = ECompanyBankAccountMap.db.select(dbConn, companyBankAccountMapFilter); if (companyBankAccountMapList.Count == 0) { ECompanyBankAccountMap companyBankAccountMap = new ECompanyBankAccountMap(); companyBankAccountMap.CompanyID = o.CompanyID; companyBankAccountMap.CompanyBankAccountID = CurID; ECompanyBankAccountMap.db.insert(dbConn, companyBankAccountMap); } } foreach (ECompany o in unselectedList) { DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", o.CompanyID)); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", CurID)); ArrayList companyBankAccountMapList = ECompanyBankAccountMap.db.select(dbConn, companyBankAccountMapFilter); if (companyBankAccountMapList.Count != 0) { foreach (ECompanyBankAccountMap companyBankAccountMap in companyBankAccountMapList) { ECompanyBankAccountMap.db.delete(dbConn, companyBankAccountMap); } } } WebUtils.EndFunction(dbConn); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "CompanyBankAccount_View.aspx?CompanyBankAccountID=" + CurID); }
protected void Save_Click(object sender, EventArgs e) { ECompany c = new ECompany(); Hashtable values = new Hashtable(); binding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); if (!AppUtils.checkDuplicate(dbConn, db, c, errors, "CompanyCode")) { return; } if (WebUtils.TotalActiveCompany(dbConn, c.CompanyID) >= WebUtils.productLicense(Session).NumOfCompanies) { errors.addError(string.Format(PageErrorMessage.ERROR_MAX_LICENSE_LIMITCH_REACH, new string[] { WebUtils.productLicense(Session).NumOfCompanies + " " + HROne.Common.WebUtility.GetLocalizedString("Company") })); } if (!errors.isEmpty()) { return; } WebUtils.StartFunction(Session, FUNCTION_CODE); if (CurID < 0) { // Utils.MarkCreate(Session, c); db.insert(dbConn, c); EUserCompany.InsertCompanyForUser(dbConn, WebUtils.GetCurUser(Session).UserID, c.CompanyID); CurID = c.CompanyID; // url = Utils.BuildURL(-1, CurID); } else { // Utils.Mark(Session, c); db.update(dbConn, c); } ArrayList selectedList = new ArrayList(); ArrayList unselectedList = new ArrayList(); foreach (RepeaterItem i in companyBankAccountRepeater.Items) { CheckBox cb = (CheckBox)i.FindControl("ItemSelect"); ECompanyBankAccount o = new ECompanyBankAccount(); WebFormUtils.GetKeys(ECompanyBankAccount.db, o, cb); if (cb.Checked) { selectedList.Add(o); } else { unselectedList.Add(o); } } foreach (ECompanyBankAccount o in selectedList) { DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", CurID)); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", o.CompanyBankAccountID)); ArrayList companyBankAccountMapList = ECompanyBankAccountMap.db.select(dbConn, companyBankAccountMapFilter); if (companyBankAccountMapList.Count == 0) { ECompanyBankAccountMap companyBankAccountMap = new ECompanyBankAccountMap(); companyBankAccountMap.CompanyID = CurID; companyBankAccountMap.CompanyBankAccountID = o.CompanyBankAccountID; ECompanyBankAccountMap.db.insert(dbConn, companyBankAccountMap); } } foreach (ECompanyBankAccount o in unselectedList) { DBFilter companyBankAccountMapFilter = new DBFilter(); companyBankAccountMapFilter.add(new Match("CompanyID", CurID)); companyBankAccountMapFilter.add(new Match("CompanyBankAccountID", o.CompanyBankAccountID)); ArrayList companyBankAccountMapList = ECompanyBankAccountMap.db.select(dbConn, companyBankAccountMapFilter); if (companyBankAccountMapList.Count != 0) { foreach (ECompanyBankAccountMap companyBankAccountMap in companyBankAccountMapList) { ECompanyBankAccountMap.db.delete(dbConn, companyBankAccountMap); } } } WebUtils.EndFunction(dbConn); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Company_View.aspx?CompanyID=" + CurID); }