protected void ButtonInsert_Click(object sender, EventArgs e) { using (SalesSystem.DataClassesSalesDataContext context = new DataClassesSalesDataContext()) { int roleID = context.sp_Insert_Role(TextBoxRoleDescription.Text, Convert.ToDecimal(TextBoxRoleRate.Text)); Response.Redirect("~/Default.aspx"); } }
protected void LoadEmployeesGrid() { using (SalesSystem.DataClassesSalesDataContext context = new DataClassesSalesDataContext()) { var employeeRole = (from empRol in context.vw_Custom_SelectEmployeeRoles select empRol).ToList(); GridViewEmployees.DataSource = employeeRole; GridViewEmployees.DataBind(); } }
protected void ButtonSearch_Click(object sender, EventArgs e) { using (SalesSystem.DataClassesSalesDataContext context = new DataClassesSalesDataContext()) { var result = (from searchRes in context.vw_Custom_SelectEmployeeRoles where (searchRes.RoleRate.ToString().Contains(TextBoxSearch.Text)) || (searchRes.EmployeeName.Contains(TextBoxSearch.Text)) || (searchRes.EmployeeSurname.Contains(TextBoxSearch.Text)) || (searchRes.RoleDescription.Contains(TextBoxSearch.Text)) select new { searchRes.EmployeeID, searchRes.EmployeeName, searchRes.EmployeeSurname, searchRes.RoleDescription, searchRes.RoleRate }); GridViewEmployees.DataSource = result; GridViewEmployees.DataBind(); } }
protected void LoadRoleDropDown() { using (SalesSystem.DataClassesSalesDataContext context = new DataClassesSalesDataContext()) { var role = (from rl in context.Roles select rl).ToList(); DropDownListRole.DataValueField = "RoleID"; DropDownListRole.DataTextField = "RoleDescription"; DropDownListRole.DataSource = role; DropDownListRole.DataBind(); } }
protected void ButtonInsert_Click(object sender, EventArgs e) { using (SalesSystem.DataClassesSalesDataContext context = new DataClassesSalesDataContext()) { if (string.IsNullOrEmpty(hdfPrimaryKey.Value)) { int EmployeeID = context.sp_Insert_Employee(Convert.ToInt32(DropDownListRole.SelectedValue), TextBoxEmployeeName.Text, TextBoxEmployeeSurname.Text); } else { context.sp_Update_Employee(Convert.ToInt32(hdfPrimaryKey.Value), Convert.ToInt32(DropDownListRole.SelectedValue), TextBoxEmployeeName.Text, TextBoxEmployeeSurname.Text, Convert.ToInt32(hdfCounter.Value)); } Response.Redirect("~/Default.aspx"); } }
protected void LoadEmployee(int employeeID) { using (SalesSystem.DataClassesSalesDataContext context = new DataClassesSalesDataContext()) { var result = (from emp in context.vw_Data_Employees where emp.EmployeeID == employeeID select emp).FirstOrDefault(); hdfPrimaryKey.Value = result.EmployeeID.ToString(); hdfCounter.Value = result.Counter.ToString(); DropDownListRole.SelectedValue = result.RoleID.ToString(); TextBoxEmployeeName.Text = result.EmployeeName; TextBoxEmployeeSurname.Text = result.EmployeeSurname; } }