protected void Page_Load(object sender, EventArgs e) { string departmentID = Request.QueryString["departmentID"] as string; if (departmentID == null) { Response.Redirect("Z_DepartmentDefault.aspx"); } try { departmentDepartmentID = Convert.ToInt32(departmentID.Trim()); departmentHandler = new DepartmentHandler(); Department department = departmentHandler.GetDetails(departmentDepartmentID); lblDepartmentID.Text = department.DepartmentID.ToString(); lblDividerFullName.Text = department.DividerFullName.ToString(); lblComputationTypeIDTitle.Text = department.ComputationTypeIDTitle.ToString(); lblMainOfficeTypeIDTitle.Text = department.MainOfficeTypeIDTitle.ToString(); lblAdjutancyTypeIDTitle.Text = department.AdjutancyTypeIDTitle.ToString(); lblComputationTypeID.Text = department.ComputationTypeID.ToString(); lblMainOfficeTypeID.Text = department.MainOfficeTypeID.ToString(); lblAdjutancyTypeID.Text = department.AdjutancyTypeID.ToString(); lblTotalEmployeeNumber.Text = department.TotalEmployeeNumber.ToString(); lblTotalContractualEmployeeNumber.Text = department.TotalContractualEmployeeNumber.ToString(); lblTotalPersonalScore.Text = department.TotalPersonalScore.ToString(); lblDividerNationalCode.Text = department.DividerNationalCode.ToString(); lblTitle.Text = department.Title.ToString(); } catch (Exception) { Response.Redirect("Z_DepartmentDefault.aspx"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { A_Handler = new DepartmentHandler(); A1 = new Department(); //A1.Dep_id = Convert.ToInt32(txtDep_id.Text); A1.Reg_id = Convert.ToInt32(ddlReg_id.SelectedValue); A1.Dep_name = txtDep_name.Text; A1.Dep_code = txtDep_code.Text; if (btnSubmit.Text == "Submit") { bool B = A_Handler.AddNewDepartment(A1); if (B == true) { Label1.Text = "Record Inserted"; MSG = "Record Inserted"; } else { Label1.Text = "Record Not Inserted"; MSG = "Record Not Inserted"; } } else if (btnSubmit.Text == "Update") { A1.Dep_id = Convert.ToInt32(txtDep_id.Text); bool B = A_Handler.UpdateDepartment(A1); if (B == true) { Label1.Text = "Record Updated"; MSG = "Record Not Updated"; } else { Label1.Text = "Record Not Updated"; MSG = "Record Not Updated"; } } else if (btnSubmit.Text == "Delete") { A1.Dep_id = Convert.ToInt32(txtDep_id.Text); bool B = A_Handler.DeleteDepartment(A1); if (B == true) { Label1.Text = "Record Deleted"; MSG = "Record Deleted"; } else { Label1.Text = "Record Not Deleted"; MSG = "Record Not Deleted"; } } //Response.Redirect("~/ADMIN/Department_list.aspx?msg="+MSG); }
public void show_data(int ID) { A_Handler = new DepartmentHandler(); A1 = new Department(); A1 = A_Handler.GetDepartmentDetails(ID); txtDep_id.Text = A1.Dep_id.ToString(); ddlReg_id.SelectedValue = A1.Reg_id.ToString(); txtDep_name.Text = A1.Dep_name.ToString(); txtDep_code.Text = A1.Dep_code.ToString(); btnSubmit.Text = "Update"; btnReset.Text = "Cancel"; if (Request.QueryString["action"] == "del") { Label1.Text = "Are U Sure, U want to Delete a Record ?"; txtDep_id.ReadOnly = false; ddlReg_id.Enabled = false; txtDep_name.ReadOnly = false; txtDep_code.ReadOnly = false; btnSubmit.Text = "Delete"; } }
protected void Page_Load(object sender, EventArgs e) { lblResult.Text = string.Empty; departmentHandler = new DepartmentHandler(); if (IsPostBack == false) { BindData(); } }
protected void btnYES_Click(object sender, EventArgs e) { Department department = new Department(); department.ComputationTypeID = Convert.ToInt32(ddlComputationTypeID.SelectedValue); department.MainOfficeTypeID = Convert.ToInt32(ddlMainOfficeTypeID.SelectedValue); department.AdjutancyTypeID = Convert.ToInt32(ddlAdjutancyTypeID.SelectedValue); department.TotalEmployeeNumber = Convert.ToInt32(txtTotalEmployeeNumber.Text); department.TotalContractualEmployeeNumber = Convert.ToInt32(txtTotalContractualEmployeeNumber.Text); department.DividerNationalCode = Convert.ToInt64(txtDividerNationalCode.Text); department.Title = txtTitle.Text; DepartmentHandler departmentHandler = new DepartmentHandler(); if (departmentHandler.Insert(department) > 0) { Response.Redirect("Z_DepartmentDefault.aspx"); } }
protected void btnShow_Click(object sender, EventArgs e) { fld = cboSearch.SelectedValue.ToString(); txt = txtSearch.Text; A_Handler = new DepartmentHandler(); sql = "select * from " + Tbl_Name + " where " + fld + " like '" + txt + "%' "; //Grid1.DataSource = A_Handler.GetDepartmentList(sql); //Grid1.DataBind(); SqlDataSource1.SelectCommand = sql; SqlDataSource1.DataBind(); if (Grid1.Rows.Count > 0) { lblRec.Text = "Total Records : " + Grid1.Rows.Count.ToString(); } else { lblRec.Text = "Record Not Found..."; } }
protected void Page_Load(object sender, EventArgs e) { //lblResult.Text = string.Empty; A_Handler = new DepartmentHandler(); //if (IsPostBack == false) //{ // Grid1.DataSource = A_Handler.GetDepartmentList(); // Grid1.DataBind(); if (Grid1.Rows.Count > 0) { lblRec.Text = "Total Records : " + Grid1.Rows.Count.ToString(); } else { lblRec.Text = "Record Not Found..."; } //} }
protected void Page_Load(object sender, EventArgs e) { DepartmentHandler departmentHandler = new DepartmentHandler(); List <Department> departmentList = departmentHandler.GetListAll(); DataTable departmentTable = new DataTable(); departmentTable.Columns.Add("DepartmentID"); if (departmentList != null) { foreach (Department department in departmentList) { departmentTable.Rows.Add(department.DepartmentID); } } if (!IsPostBack) { ddlDepartmentID.DataSource = departmentTable; ddlDepartmentID.DataTextField = "DepartmentID"; ddlDepartmentID.DataValueField = "DepartmentID"; ddlDepartmentID.DataBind(); } MonthTypeHandler monthTypeHandler = new MonthTypeHandler(); List <MonthType> monthTypeList = monthTypeHandler.GetListAll(); DataTable monthTypeTable = new DataTable(); monthTypeTable.Columns.Add("MonthTypeID"); if (monthTypeList != null) { foreach (MonthType monthType in monthTypeList) { monthTypeTable.Rows.Add(monthType.MonthTypeID); } } if (!IsPostBack) { ddlMonthTypeID.DataSource = monthTypeTable; ddlMonthTypeID.DataTextField = "MonthTypeID"; ddlMonthTypeID.DataValueField = "MonthTypeID"; ddlMonthTypeID.DataBind(); } YearTypeHandler yearTypeHandler = new YearTypeHandler(); List <YearType> yearTypeList = yearTypeHandler.GetListAll(); DataTable yearTypeTable = new DataTable(); yearTypeTable.Columns.Add("YearTypeID"); if (yearTypeList != null) { foreach (YearType yearType in yearTypeList) { yearTypeTable.Rows.Add(yearType.YearTypeID); } } if (!IsPostBack) { ddlYearTypeID.DataSource = yearTypeTable; ddlYearTypeID.DataTextField = "YearTypeID"; ddlYearTypeID.DataValueField = "YearTypeID"; ddlYearTypeID.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { ContractTypeHandler contractTypeHandler = new ContractTypeHandler(); List <ContractType> contractTypeList = contractTypeHandler.GetListAll(); DataTable contractTypeTable = new DataTable(); contractTypeTable.Columns.Add("ContractTypeID"); if (contractTypeList != null) { foreach (ContractType contractType in contractTypeList) { contractTypeTable.Rows.Add(contractType.ContractTypeID); } } if (!IsPostBack) { ddlContractTypeID.DataSource = contractTypeTable; ddlContractTypeID.DataTextField = "ContractTypeID"; ddlContractTypeID.DataValueField = "ContractTypeID"; ddlContractTypeID.DataBind(); } DepartmentHandler departmentHandler = new DepartmentHandler(); List <Department> departmentList = departmentHandler.GetListAll(); DataTable departmentTable = new DataTable(); departmentTable.Columns.Add("DepartmentID"); if (departmentList != null) { foreach (Department department in departmentList) { departmentTable.Rows.Add(department.DepartmentID); } } if (!IsPostBack) { ddlDepartmentID.DataSource = departmentTable; ddlDepartmentID.DataTextField = "DepartmentID"; ddlDepartmentID.DataValueField = "DepartmentID"; ddlDepartmentID.DataBind(); } RoleTypeHandler roleTypeHandler = new RoleTypeHandler(); List <RoleType> roleTypeList = roleTypeHandler.GetListAll(); DataTable roleTypeTable = new DataTable(); roleTypeTable.Columns.Add("RoleTypeID"); if (roleTypeList != null) { foreach (RoleType roleType in roleTypeList) { roleTypeTable.Rows.Add(roleType.RoleTypeID); } } if (!IsPostBack) { ddlRoleTypeID.DataSource = roleTypeTable; ddlRoleTypeID.DataTextField = "RoleTypeID"; ddlRoleTypeID.DataValueField = "RoleTypeID"; ddlRoleTypeID.DataBind(); } }