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