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); } }