protected void rptDepatments_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "edit_item") { if (iBiz.FinPro.Rights.edit_department) { int deptId = Convert.ToInt32(e.CommandArgument); iBiz.FinPro.Modules.Departments bDept = new iBiz.FinPro.Modules.Departments(); iBiz.FinPro.Modules.Departments.objfin_Departments objDept = new iBiz.FinPro.Modules.Departments.objfin_Departments(); objDept = bDept.Select(deptId); if (objDept != null) { hfDeptId.Value = objDept.deptId.ToString(); tbDeptCode.Text = objDept.deptCode; tbDeptDescription.Text = objDept.deptDescription; tbDeptTitle.Text = objDept.deptTitle; mpeNewAccount.Show(); } else { rnNotify.Show("Department doesn't exist."); } } } }
protected void Load_Departments() { iBiz.FinPro.Modules.Departments bDept = new iBiz.FinPro.Modules.Departments(); rptDepatments.DataSource = bDept.Select(); rptDepatments.DataBind(); }
protected void lbtnSubmit_Click(object sender, EventArgs e) { if (Page.IsValid) { iBiz.FinPro.Modules.Departments bDept = new iBiz.FinPro.Modules.Departments(); iBiz.FinPro.Modules.Departments.objfin_Departments objDept = new iBiz.FinPro.Modules.Departments.objfin_Departments(); objDept.deptCode = tbDeptCode.Text; objDept.deptDescription = tbDeptDescription.Text; objDept.deptTitle = tbDeptTitle.Text; if (!string.IsNullOrEmpty(hfDeptId.Value)) { objDept.deptId = Convert.ToInt32(hfDeptId.Value); bDept.Update(objDept); rnNotify.Show("Department has been updated."); } else { bDept.Add(objDept); rnNotify.Show("Department has been created."); } hfDeptId.Value = null; tbDeptTitle.Text = ""; tbDeptDescription.Text = ""; tbDeptCode.Text = ""; Load_Departments(); } }
protected DataTable List_Departments() { IDataReader idr = null; DataTable dt = new DataTable(); dt.Columns.Add("deptId"); dt.Columns.Add("deptCode"); iBiz.FinPro.Accounts bAcc = new iBiz.FinPro.Accounts(); iBiz.FinPro.Modules.Departments bDept = new iBiz.FinPro.Modules.Departments(); idr = bDept.Select(); dt.Rows.Add("0", "None"); while (idr.Read()) { dt.Rows.Add(idr["deptId"].ToString(), idr["deptCode"]); } return(dt); }
protected void Load_Departments() { IDataReader idr = null; DataTable dt = new DataTable(); dt.Columns.Add("deptId"); dt.Columns.Add("deptCode"); dt.Columns.Add("deptTitle"); iBiz.FinPro.Accounts bAcc = new iBiz.FinPro.Accounts(); iBiz.FinPro.Modules.Departments bDept = new iBiz.FinPro.Modules.Departments(); idr = bDept.Select(); dt.Rows.Add("0", "All", "All"); while (idr.Read()) { dt.Rows.Add(idr["deptId"].ToString(), idr["deptCode"], idr["deptTitle"]); } ddlDepartment.DataSource = dt; ddlDepartment.DataBind(); }