protected void btnAdd_Click(object sender, EventArgs e) { if (isValid(0)) { DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter tableAdapter = new DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter(); tableAdapter.Insert(int.Parse(ddlDepartment.SelectedValue), loggedInUserCoId, tbName.Text, loggedInUserId,int.Parse(ddlCategory.SelectedValue),cbDefault.Checked); repeater.DataBind(); SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED); } //lbl }
private void BindGrids() { try { DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter ta = new DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter(); gv1.DataSource = ta.GetDepartmentToolByDeptId(int.Parse(ddlDepartment1.SelectedValue), int.Parse(ddlCompany1.SelectedValue)); gv1.DataBind(); gv2.DataSource = ta.GetDepartmentToolByDeptId(int.Parse(ddlDepartment2.SelectedValue), int.Parse(ddlCompany2.SelectedValue)); gv2.DataBind(); HideTransferButtons(); } catch { //this is needed as some time the ddls are not set. } }
protected void btnUpate_Click(object sender, EventArgs e) { int id = int.Parse(hfDeptPersonId.Value); if (isValid(id)) { DepartmentTool.DepartmentToolSelectCommandRow dataRow = getDepartmentPerson(id); if (dataRow != null) { DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter tableAdapter = new DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter(); tableAdapter.Update(int.Parse(ddlDepartment.SelectedValue), tbName.Text, dataRow.index_seq, loggedInUserId, dataRow.sequence,int.Parse(ddlCategory.SelectedValue),cbDefault.Checked); repeater.DataBind(); SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED); } btnAdd.Visible = true; btnUpate.Visible = false; tbName.Text = ""; } }
protected void btnSave_Click(object sender, EventArgs e) { string[] idList = Request["idOrdering"].Split(','); if (idList != null) { //-i because we have an extra comma at the end for (int i = 0; i < idList.Length - 1; i++) { DepartmentTool.DepartmentToolSelectCommandRow dataRow = getDepartmentPerson(int.Parse(idList[i])); if (dataRow != null) { DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter tableAdapter = new DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter(); tableAdapter.Update(dataRow.dept_id, dataRow.name_desc, i + 1, loggedInUserId, dataRow.sequence,dataRow.category_id,dataRow.flg_default); } } } SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED); repeater.DataBind(); }
protected void repeater_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.Equals("Edit")) { DepartmentTool.DepartmentToolSelectCommandRow dataRow = getDepartmentPerson(int.Parse(e.CommandArgument.ToString())); if (dataRow != null) { tbName.Text = dataRow.name_desc; ddlDepartment.SelectedValue = dataRow.dept_id.ToString(); ddlCategory.SelectedValue = dataRow.category_id.ToString(); cbDefault.Checked = dataRow.flg_default; btnAdd.Visible = false; btnUpate.Visible = true; hfDeptPersonId.Value = e.CommandArgument.ToString(); } } else if (e.CommandName.Equals("Delete")) { DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter tableAdapter = new DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter(); tableAdapter.Delete(int.Parse(e.CommandArgument.ToString()), loggedInUserId); repeater.DataBind(); SetInfoMessage(WebConstants.Messages.Information.RECORD_DELETED); } }
private bool isValid(int id) { DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter tableAdapter = new DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter(); IEnumerator iEnumerator = tableAdapter.GetDepartmentToolByName(int.Parse(ddlDepartment.SelectedValue), loggedInUserCoId, tbName.Text,id).GetEnumerator(); if (iEnumerator.MoveNext()) { SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS); return false; } return true; }
private DepartmentTool.DepartmentToolSelectCommandRow getDepartmentPerson(int departmentPersonId) { DepartmentTool.DepartmentToolSelectCommandRow dataRow = null; DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter tableAdapter = new DepartmentToolTableAdapters.DepartmentToolSelectCommandTableAdapter(); IEnumerator iEnumerator = tableAdapter.GetDepartmentToolById(departmentPersonId, loggedInUserCoId).GetEnumerator(); if (iEnumerator.MoveNext()) { dataRow = (DepartmentTool.DepartmentToolSelectCommandRow)iEnumerator.Current; } return dataRow; }