public void InsertDepartmentTable(ref Employee employee) { DepartmentTable deptable = new DepartmentTable(); using (HRDatabaseEntities myEntities = new HRDatabaseEntities()) { deptable.Department_Name = DepartmentNameList.Text; myEntities.DepartmentTables.Add(deptable); myEntities.SaveChanges(); employee.department_id = deptable.Department_ID; } }
public void InsertJobTable(ref Employee employee) { JobTable jobtable = new JobTable(); using (HRDatabaseEntities myEntities = new HRDatabaseEntities()) { jobtable.Job_Title = titleList.Text; jobtable.Job_Salary = decimal.Parse(JobSalaryText.Text); myEntities.JobTables.Add(jobtable); myEntities.SaveChanges(); employee.job_id = jobtable.Job_ID; } }
public void InsertHRTable(int phoneNo, Employee employee) { HRTable hrtable = new HRTable(); using (HRDatabaseEntities myEntities = new HRDatabaseEntities()) { hrtable.Name = NameText.Text; hrtable.Phone = phoneNo.ToString(); hrtable.IC = ICText.Text; hrtable.Job_ID = employee.job_id; hrtable.Department_ID = employee.department_id; myEntities.HRTables.Add(hrtable); myEntities.SaveChanges(); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int s = int.Parse(GridView1.Rows[e.RowIndex].Cells[id_index].Text); using (var myEntities = new HRDatabaseEntities()) { var data = (from p in myEntities.HRTables where p.Id == s select p).Single(); myEntities.HRTables.Remove(data); myEntities.SaveChanges(); } LoadHRDatabase(); }
private void LoadHRDatabase() { using (HRDatabaseEntities myEntities = new HRDatabaseEntities()) { var reviews = from HRTable in myEntities.HRTables select HRTable; GridView1.DataSource = reviews.ToList(); GridView1.DataBind(); } SearchText.Text = string.Empty; //Hacky solution HideIDColumn(); }
private void FindInDatabase(string s) { using (HRDatabaseEntities myEntities = new HRDatabaseEntities()) { var reviews = from HRTable in myEntities.HRTables where HRTable.Name == s || HRTable.IC == s || HRTable.Phone == s select HRTable; GridView1.DataSource = reviews.ToList(); GridView1.DataBind(); } //Hacky solution HideIDColumn(); }