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