public bool SaveUser(Users dto)
{
using (var ctx = new SMSContext())
{
if (dto.UserID > 0)
{
//Update
var query = from p in ctx.Users
where p.UserID == dto.UserID
select p;
//Now query will be executed on DB and will return result
var result = query.FirstOrDefault();
if (result != null)
{
result.FirstName = dto.FirstName;
result.LastName = dto.LastName;
result.Gender = dto.Gender;
}
}
else
{
ctx.Users.Add(dto);
}
ctx.SaveChanges();
}
return(true);
}
public bool SaveStudent(StudentDTO dto)
{
using (var ctx = new SMSContext())
{
if (dto.StudentID > 0)
{
//Update
var query = from p in ctx.Students
where p.StudentID == dto.StudentID
select p;
//Now query will be executed on DB and will return result
var result = query.FirstOrDefault();
if (result != null)
{
result.StudentName = dto.StudentName;
result.FatherName = dto.FatherName;
}
}
else
{
ctx.Students.Add(dto);
}
ctx.SaveChanges();
}
return true;
}
public bool SaveTeacher(TeacherDTO dto)
{
using (var ctx = new SMSContext())
{
if (dto.TID > 0)
{
//Update
var query = from p in ctx.Teachers
where p.TID == dto.TID
select p;
//Now query will be executed on DB and will return result
var result = query.FirstOrDefault();
if (result != null)
{
result.Name = dto.Name;
result.Subject = dto.Subject;
}
}
else
{
ctx.Teachers.Add(dto);
}
ctx.SaveChanges();
}
return true;
}
public bool SaveTeacher(TeacherDTO dto)
{
using (var ctx = new SMSContext())
{
if (dto.TID > 0)
{
//Update
var query = from p in ctx.Teachers
where p.TID == dto.TID
select p;
//Now query will be executed on DB and will return result
var result = query.FirstOrDefault();
if (result != null)
{
result.Name = dto.Name;
result.Subject = dto.Subject;
}
}
else
{
ctx.Teachers.Add(dto);
}
ctx.SaveChanges();
}
return(true);
}
public bool SaveStudent(StudentDTO dto)
{
using (var ctx = new SMSContext())
{
if (dto.StudentID > 0)
{
//Update
var query = from p in ctx.Students
where p.StudentID == dto.StudentID
select p;
//Now query will be executed on DB and will return result
var result = query.FirstOrDefault();
if (result != null)
{
result.StudentName = dto.StudentName;
result.FatherName = dto.FatherName;
}
}
else
{
ctx.Students.Add(dto);
}
ctx.SaveChanges();
}
return(true);
}
public void RemoveById(int id)
{
using (var ctx = new SMSContext())
{
var result = ctx.Students.Where(p => p.StudentID == id).FirstOrDefault();
if (result != null)
{
ctx.Students.Remove(result);
ctx.SaveChanges();
}
}
}
public void RemoveById(int id)
{
using (var ctx = new SMSContext())
{
var result = ctx.Teachers.Where(p => p.TID == id).FirstOrDefault();
if (result != null)
{
ctx.Teachers.Remove(result);
ctx.SaveChanges();
}
}
}
public bool DeleteUserById(int userid)
{
using (var ctx = new SMSContext())
{
//LINQ to Entities approach
//This is just query object in memory
var query = from p in ctx.Users
where p.UserID == userid
select p;
//Now query will be executed on DB and will return result
var result = query.FirstOrDefault();
if (result != null)
{
ctx.Users.Remove(result);
ctx.SaveChanges();
}
return(true);
}
}
