public IActionResult EnrollStudent(EnrollmentsRequest request)
{
_service.EnrollStudent(request);
var response = new EnrollmentsResponse();
return(Ok(response));
}
public override Task <EnrollmentsListReply> GetEnrollments(EnrollmentsRequest request, ServerCallContext context)
{
var result = _mediator.Send(new EnrollmentsQuery()).Result;
EnrollmentsListReply enrollmentsListReply = new EnrollmentsListReply();
foreach (var item in result)
{
EnrollmentsReply enrollmentsReply = new EnrollmentsReply {
Studentcount = item.StudentCount.ToString(), Enrollmentsdate = item.EnrollmentsDate
};
enrollmentsListReply.Items.Add(enrollmentsReply);
}
return(Task.FromResult(enrollmentsListReply));
}
public void EnrollStudent(EnrollmentsRequest request)
{
var st = new Student();
st.FirstName = request.FirstName;
using (var con = new SqlConnection(""))
using (var com = new SqlCommand())
{
com.Connection = con;
con.Open();
var tran = con.BeginTransaction();
try
{
com.CommandText = "select IdStudies from studies where name=@name";
com.Parameters.AddWithValue("name", request.Studies);
var dr = com.ExecuteReader();
if (!dr.Read())
{
tran.Rollback();
}
int idstudies = (int)dr["IdStudies"];
com.CommandText = "INSERT INTO Student(IndexNumber, FirstName) VALUES(@Index, @Fname)";
com.Parameters.AddWithValue("index", request.IndexNumber);
com.ExecuteNonQuery();
tran.Commit();
}
catch (SqlException exc)
{
tran.Rollback();
}
}
}
