/// <summary>
/// This function will update the entries in the SQL table to the inserted vales
/// </summary>
/// <param name="std">Student object with updated values</param>
public void UpdateDL(Student std)
{
using (TestDBEntities context = new TestDBEntities())
{
context.Entry(std).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
/// <summary>
/// This function will update the entries in the SQL table to the inserted values
/// </summary>
/// <param name="emp">Object with updated values of the column in Employee object</param>
public void UpdateDL(Employee emp)
{
using (TestDBEntities context = new TestDBEntities())
{
context.Entry(emp).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
/// <summary>
/// This function will retrieve a list of the student objects in the SQL table
/// </summary>
/// <returns>List of student objects</returns>
public List <Student> GetDL()
{
List <Student> list;
using (TestDBEntities context = new TestDBEntities())
{
list = context.Students.ToList();
}
return(list);
}
/// <summary>
/// This function will get the list of employees from the SQL table
/// </summary>
/// <returns>List of student objects</returns>
public List <Employee> GetDL()
{
List <Employee> list;
using (TestDBEntities context = new TestDBEntities())
{
list = context.Employees.ToList();
}
return(list);
}
/// <summary>
/// This function will add rows in the SQL table
/// </summary>
/// <param name="std">Student object which contains data to be added</param>
/// <returns>primary key of the inserted row</returns>
public int AddDL(Student std)
{
int id;
using (TestDBEntities context = new TestDBEntities())
{
var dto = context.Students.Add(std);
context.SaveChanges();
id = dto.StudentID;
}
return(id);
}
/// <summary>
/// This function will add rows in the SQL table
/// </summary>
/// <param name="emp">Object with values of the row to be added</param>
/// <returns>Primary key of the inserted row</returns>
public int AddDL(Employee emp)
{
int id;
using (TestDBEntities context = new TestDBEntities())
{
var dto = context.Employees.Add(emp);
context.SaveChanges();
id = dto.EmployeeID;
}
return(id);
}