//method delete data from z database private void DeletetoolStripButton_Click(object sender, EventArgs e) { if (DepartmentIdtextbox.Text == "") { MessageBox.Show("please insert departement id "); } else { DepartmentBiz depobiz = new DepartmentBiz(); int deleteId = Convert.ToInt32(DepartmentIdtextbox.Text); if (MessageBox.Show("Are you Sure you want to delete?", "Confirm deletion", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { var result = depobiz.Delete(deleteId); if (result.Status) { MessageBox.Show("Successfully Deleted"); clearbr(); } else { MessageBox.Show("Not Successfully Deleted." + result.Message); } } } }
//method edit data to the database private void EdittoolStripButton_Click(object sender, EventArgs e) { if (DepartmentIdtextbox.Text == "") { MessageBox.Show("Please Insert Department ID "); } else { var updatdepo = new Department() { ID = Convert.ToInt32(DepartmentIdtextbox.Text), DepartmentName = DepNametextbox.Text, Branch = DepBranchtextbox.Text, Remarks = DepRemarkstextbox.Text }; var updepobiz = new DepartmentBiz(); if (MessageBox.Show("are you sure you want to Edit this file ?", "Confirm Updating", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { var result = updepobiz.Update(updatdepo); if (result.Status) { MessageBox.Show("Successfuly Updated"); clearbr(); } else { MessageBox.Show("Update faild." + result.Message); } } } }
private void InitialControl() { ////Role cmbStaffTypeSearch.DataSource = StaffBiz.GetStaffTyeList(); cmbStaffTypeSearch.DataTextField = "TextField"; cmbStaffTypeSearch.DataValueField = "ValueField"; cmbStaffTypeSearch.DataBind(); cmbStaffTypeSearch.Items.Insert(0, new ListItem("", "")); ////Market Branch cmbBranchSearch.DataSource = BranchBiz.GetBranchList(); cmbBranchSearch.DataTextField = "TextField"; cmbBranchSearch.DataValueField = "ValueField"; cmbBranchSearch.DataBind(); cmbBranchSearch.Items.Insert(0, new ListItem("", "")); ////Department cmbDepartmentSearch.DataSource = DepartmentBiz.GetDepartmentList(); cmbDepartmentSearch.DataTextField = "TextField"; cmbDepartmentSearch.DataValueField = "ValueField"; cmbDepartmentSearch.DataBind(); cmbDepartmentSearch.Items.Insert(0, new ListItem("", "")); ////COC Team cmbCOCTeamSearch.DataSource = StaffBiz.GetTeamList(); cmbCOCTeamSearch.DataTextField = "TextField"; cmbCOCTeamSearch.DataValueField = "ValueField"; cmbCOCTeamSearch.DataBind(); cmbCOCTeamSearch.Items.Insert(0, new ListItem("", "")); //Position cmbPositionSearch.DataSource = PositionBiz.GetPositionList(COCConstant.Position.All); cmbPositionSearch.DataTextField = "TextField"; cmbPositionSearch.DataValueField = "ValueField"; cmbPositionSearch.DataBind(); cmbPositionSearch.Items.Insert(0, new ListItem("", "")); upSearch.Update(); }
//save data to the database in department table private void SavetoolStripButton_Click(object sender, EventArgs e) { var depodata = new Department() { DepartmentName = DepNametextbox.Text, Branch = DepBranchtextbox.Text, Remarks = DepRemarkstextbox.Text }; var dbDepobiz = new DepartmentBiz(); var result = dbDepobiz.Add(depodata); if (result.Status) { MessageBox.Show("Successfuly Saved"); clearbr(); } else { MessageBox.Show("Save Faild." + result.Message); } }
private void InitialControl() { //Role cmbStaffType.DataSource = StaffBiz.GetStaffTyeList(); cmbStaffType.DataTextField = "TextField"; cmbStaffType.DataValueField = "ValueField"; cmbStaffType.DataBind(); cmbStaffType.Items.Insert(0, new ListItem("", "")); //Market Branch cmbBranchCode.DataSource = BranchBiz.GetBranchList(); cmbBranchCode.DataTextField = "TextField"; cmbBranchCode.DataValueField = "ValueField"; cmbBranchCode.DataBind(); cmbBranchCode.Items.Insert(0, new ListItem("", "")); //Department cmbDepartment.DataSource = DepartmentBiz.GetDepartmentList(); cmbDepartment.DataTextField = "TextField"; cmbDepartment.DataValueField = "ValueField"; cmbDepartment.DataBind(); cmbDepartment.Items.Insert(0, new ListItem("", "")); ////COC Team cmbCocTeam.DataSource = StaffBiz.GetTeamList(); cmbCocTeam.DataTextField = "TextField"; cmbCocTeam.DataValueField = "ValueField"; cmbCocTeam.DataBind(); cmbCocTeam.Items.Insert(0, new ListItem("", "")); //Position cmbPosition.DataSource = PositionBiz.GetPositionList(COCConstant.Position.Active); cmbPosition.DataTextField = "TextField"; cmbPosition.DataValueField = "ValueField"; cmbPosition.DataBind(); cmbPosition.Items.Insert(0, new ListItem("", "")); }