public IActionResult Get(int id) { using (var ctx = new StudentInfoManagmentDbContext()) { var studentDetail = ctx.StudentDetails.Where(t => t.StudentId == id).FirstOrDefault <StudentDetails>(); return(Ok(studentDetail)); } }
public IActionResult Delete(int id) { using (var ctx = new StudentInfoManagmentDbContext()) { var v = ctx.Database.ExecuteSqlCommand("spDeleteStudent @StudentId", new SqlParameter("@StudentId", id)); return(Ok(1)); } }
public IActionResult Put(StudentDetails sd) { using (var ctx = new StudentInfoManagmentDbContext()) { var v = ctx.Database.ExecuteSqlCommand("spUpdateFee @StudentId", new SqlParameter("@StudentId", sd.StudentId) ); return(Ok(v)); } }
public IActionResult Put(Students students) { using (var ctx = new StudentInfoManagmentDbContext()) { var v = ctx.Database.ExecuteSqlCommand("spUpdateStudent @StudentId, @StudentName,@Mobile", new SqlParameter("@StudentId", students.StudentId), new SqlParameter("@StudentName", students.StudentName), new SqlParameter("@Mobile", students.Mobile) ); return(Ok(v)); } }
public IActionResult Post(Students students) { using (var ctx = new StudentInfoManagmentDbContext()) { var v = ctx.Database.ExecuteSqlCommand("spAddStudent @StudentName,@Mobile,@Email,@CourseId,@Password", new SqlParameter("@StudentName", students.StudentName), new SqlParameter("@Mobile", students.Mobile), new SqlParameter("@Email", students.Email), new SqlParameter("@CourseId", students.CourseId), new SqlParameter("@Password", students.Password) ); return(Ok(v)); } }
public IActionResult Post(Students s) { using (var context = new StudentInfoManagmentDbContext()) { var isAvail = context.Students.Where(t => t.Email == s.Email && t.Password == s.Password).FirstOrDefault <Students>(); if (isAvail != null) { return(Ok(isAvail)); } else { return(Ok(0)); } } }
public IActionResult Post(StudentDetails sd) { using (var ctx = new StudentInfoManagmentDbContext()) { var studentDetail = new StudentDetails() { StudentId = sd.StudentId, CourseId = sd.CourseId, FeeStatus = sd.FeeStatus }; ctx.StudentDetails.Add(studentDetail); ctx.SaveChanges(); return(Ok(studentDetail)); } }
public IActionResult Get() { using (var ctx = new StudentInfoManagmentDbContext()) { var param = new SqlParameter { ParameterName = "@JsonOut", SqlDbType = SqlDbType.NVarChar, Size = -1, Direction = System.Data.ParameterDirection.Output }; var students = ctx.Database.ExecuteSqlCommand("spAllStudents @JsonOut=@JsonOut OUTPUT", param); return(Ok(param.Value.ToString())); } }