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