protected void DeleteDepartmentPerson(Object sender, CommandEventArgs e) { DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter(); tableAdapter.Delete(int.Parse(e.CommandArgument.ToString()), loggedInUserId); GridView1.DataBind(); SetInfoMessage(WebConstants.Messages.Information.RECORD_DELETED); }
protected void UploadButton_Click(object sender, EventArgs e) { if (FileUploader.HasFile) { try { using (CsvReader csv = new CsvReader(new StreamReader(FileUploader.FileContent), true)) { int count = 0; while (csv.ReadNextRecord()) { DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter personTA = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter(); personTA.Insert((int)Session[WebConstants.Session.REG_DEPT_ID], (int)Session[WebConstants.Session.REG_CO_ID],csv[0], (int)Session[WebConstants.Session.REG_USER_ID], ParseBoolean(csv[1]), ParseBoolean(csv[2]), ParseBoolean(csv[3])); count++; } SetInfoMessage(count + " people added to the system."); } } catch(Exception ex) { SetErrorMessage("Error processing the file. Please check its contents. File should be CSV and in the format shown below"); } } else { SetErrorMessage("No file specified"); } }
protected void btnAdd_Click(object sender, EventArgs e) { if (isValid(0)) { DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter(); tableAdapter.Insert(int.Parse(ddlDepartment.SelectedValue), loggedInUserCoId, tbName.Text, loggedInUserId,chkboxSupervisor.Checked,chkboxFirstAider.Checked,chkboxWarden.Checked); GridView1.DataBind(); SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED); } //lbl }
private void BindGrids() { try { DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter ta = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter(); gv1.DataSource = ta.GetDepartmentPersonByDeptId(int.Parse(ddlDepartment1.SelectedValue), int.Parse(ddlCompany1.SelectedValue)); gv1.DataBind(); gv2.DataSource = ta.GetDepartmentPersonByDeptId(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)) { DepartmentPerson.un_ref_co_dept_peopleRow dataRow = getDepartmentPerson(id); if (dataRow != null) { DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter(); tableAdapter.Update(int.Parse(ddlDepartment.SelectedValue), tbName.Text, dataRow.index_seq, loggedInUserId, dataRow.sequence,chkboxSupervisor.Checked,chkboxFirstAider.Checked,chkboxWarden.Checked); GridView1.DataBind(); SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED); } btnAdd.Visible = true; btnUpate.Visible = false; tbName.Text = ""; chkboxSupervisor.Checked = false; chkboxWarden.Checked = false; chkboxFirstAider.Checked = false; } }
private bool isValid(int id) { DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter(); IEnumerator iEnumerator = tableAdapter.GetDepartmentPersonByName(int.Parse(ddlDepartment.SelectedValue),loggedInUserCoId,tbName.Text,id).GetEnumerator(); if (iEnumerator.MoveNext()) { SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS); return false; } return true; }
private DepartmentPerson.un_ref_co_dept_peopleRow getDepartmentPerson(int departmentPersonId) { DepartmentPerson.un_ref_co_dept_peopleRow dataRow = null; DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter tableAdapter = new DepartmentPersonTableAdapters.un_ref_co_dept_peopleTableAdapter(); IEnumerator iEnumerator = tableAdapter.GetDepartmentPersonByIdNCoId(departmentPersonId, loggedInUserCoId).GetEnumerator(); if (iEnumerator.MoveNext()) { dataRow = (DepartmentPerson.un_ref_co_dept_peopleRow)iEnumerator.Current; } return dataRow; }