private void Btninsert_Click(object sender, EventArgs e)
{
using (var dbCtx = new EmpDBContext())
{
//take user input for insert
var record = new Tbl_Employee
{
EmpId = int.Parse(textecode.Text),
Ename = textename.Text,
Salary = int.Parse(textsalary.Text),
Deptid = int.Parse(textdeptid.Text)
};
dbCtx.tbl_employee.Add(record);
dbCtx.SaveChanges();
MessageBox.Show("inserted successfully");
dgv.DataSource = dbCtx.tbl_employee.ToList();
}
}
public void AddEmplyee(string first_name, string last_name, string email, string phone_number, int department_id, string salary, int Job_id)
{
var db = new Employee_ManagementEntities();
Tbl_Employee emp = new Tbl_Employee();
emp.first_name = first_name;
emp.last_name = last_name;
emp.email = email;
emp.phone_number = phone_number;
emp.department_id = department_id;
emp.salary = salary;
emp.Job_id = Job_id;
db.Tbl_Employee.Add(emp);
db.SaveChanges();
db.Dispose();
}
