Telephony based grading solution
This presentation is the property of its rightful owner.
Sponsored Links
1 / 42

Telephony Based Grading Solution PowerPoint PPT Presentation


  • 59 Views
  • Uploaded on
  • Presentation posted in: General

Telephony Based Grading Solution. by Svechinsky Ella and Simanovich Len. Project Description. Control Model. Solution enables: Retrieving their grades using a dial-phone. Server Answers Communicates Retrieves grades. We used: TAPI SDKs SQL DB C#. Telephony Operator.

Download Presentation

Telephony Based Grading Solution

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Telephony based grading solution

Telephony Based Grading Solution

by Svechinsky Ella and

Simanovich Len


Project description

ProjectDescription


Control model

Control Model


Telephony based grading solution

  • Solution enables:

    • Retrieving their grades using a dial-phone.

  • Server

    • Answers

    • Communicates

    • Retrieves grades


Telephony based grading solution

  • We used:

    • TAPI SDKs

    • SQL DB

    • C#


Telephony operator

Telephony Operator


Introduction to tapi 3 0

Introductionto TAPI 3.0


Telephony based grading solution

  • TAPI 3.0

    • Simple and generic methods for:

      • making connections

      • accessing media streams

    • Abstract call-control functionality.


Call control model for tapi 3 0

Call Control Model for TAPI 3.0


Telephony operator design

Telephony Operator Design


Telephony based grading solution

  • Telephony Operator application:

    • features for dial-up modem communication for Telephony Based Grading Solution project.


Definition of interfaces

Definition of Interfaces


Telephony based grading solution

  • Generalized solution:

    • Abstract interfaces.

    • Different kinds of communication.


Telephony based grading solution

  • Defined interfaces:

    • IEngine

    • ILine

    • ICall

    • IDisconnectCallBack


Telephony based grading solution

  • Enable communication

  • Support:

    • multiple lines.

    • incoming and outgoing requests.

    • receiving and sending data.


Communication control model

Communication Control Model


Disconnectcallback interface

DisconnectCallBack Interface

  • Assigned to the Call object.

  • Callback interface.

  • Signals the main server.


Implementation of interfaces

Implementation of Interfaces


Telephony based grading solution

  • Using TAPI 3.0:

    • ProjectEngine

    • ProjectLine

    • ProjectCall


Telephony based grading solution

  • Multiple modems.

  • One TAPI object = Engine object.

  • Dial-up modem = Line object.

  • Incoming call = Call object.

  • Methods:

    • multithreaded

    • callback


Projectengine implementation

ProjectEngine implementation

  • ProjectEngine:

    • TAPI object

    • ArrayList with Line objects.


Projectengine implementation cont

ProjectEngine implementation (cont.)

  • Multithreaded methods allow:

    • Registration for Lines.

    • Listening for TapiEvents.

    • Receiving events for all.

    • Identification of Line.

    • Passing event to the Line.


Project line implementation

Project Line implementation

  • ProjectLine:

    • TAPI object

    • Address of dial-up modem

    • Call object for a current call

    • Queue object with DigitEvents


Project line implementation cont

Project Line implementation (cont.)

  • Multithreaded methods allow:

    • Handling TapiEvents.

    • Getting a new call.


Project line implementation cont1

Project Line implementation (cont.)

  • NOTE:

    • Always answering the incoming call.

    • Delayed disconnection (Visual Studio .Net 2003)


Projectcall implementation

ProjectCall implementation

  • ProjectCall object:

    • ProjectLine object

    • CallInfo object.


Projectcall implementation cont

ProjectCall implementation (cont.)

  • Multithreaded callback methods allow:

    • Gathering one or more DigitEvents.

    • Playing audio messages.

    • Disconnecting.

  • NOTE:

    • IsConnected() method is enabled.


Data base side and main service

Data-Base Side and Main Service


Telephony operator project data base side and main service

Overview

Telephony Operator ProjectData-Base Side and Main Service


Telephony operator project data base side and main service1

Data Base

Telephony Operator Project Data-Base Side and Main Service

  • Implemented using Microsoft SQL server 2000.

  • The logic of managing the information is done in stored procedures.


Telephony operator project data base side and main service2

Data Base

Telephony Operator Project Data-Base Side and Main Service

  • The queries in the Main Service are done in real time, so it has to be fast. The database is designed to have fast queries, on GradesDBFeed’s expense.

  • The database is on one of the lab server. The connection to it is done with a connection string, using SqlConnection object.


Telephony operator project data base side and main service3

Data Base

Tables and Relationships

Telephony Operator Project Data-Base Side and Main Service


Telephony operator project data base side and main service4

Data Base

Special Stored Procedures

Telephony Operator Project Data-Base Side and Main Service

  • SP_last_grade_course_occurrence_update - used every time that a grade in changed/deleted.

  • SP_last_grade_all_students_course_update - used whenever a course occurrence is changed/deleted, and we have to update the records of all the students that were registered to this course occurrence.

  • SP_last_grade_course_update - used every time that a grade is changed/deleted, or the time of a course occurrence is changed/deleted.


Telephony operator project data base side and main service5

Data Base

Data integrity

Telephony Operator Project Data-Base Side and Main Service


Telephony operator project data base side and main service6

GradesDBFeed

Forms Application

Telephony Operator Project Data-Base Side and Main Service

MasterForm

StudentsForm

CoursesForm

CourseOccurrencesForm

GradesForm


Telephony operator project data base side and main service7

GradesDBFeed

Data Adapter

Telephony Operator Project Data-Base Side and Main Service


Telephony operator project data base side and main service8

DBIF Class Library

(Database Interface)

Telephony Operator Project Data-Base Side and Main Service

  • This class library has an explicit function for every query.

  • This code uses the AutoSProc tool.


Telephony operator project data base side and main service9

DBIF Class Library

AutoSProc

Telephony Operator Project Data-Base Side and Main Service

// creating a command object with the stored procedure name

SqlCommand cmd = new SqlCommand("SP_valid_student_password", cnn);

cmd.CommandType = CommandType.StoredProcedure;

//defining the parameters that the stored procedure gets

cmd.Parameters.Add("@student_id",SqlDbType.VarChar,50).Value=student_id;

cmd.Parameters.Add("@student_password",SqlDbType.VarChar,50).Value=student_password;

cmd.Parameters.Add("@valid", SqlDbType.Int);

cmd.Parameters["@valid"].Direction=ParameterDirection.Output;

//executing the sql command

public interface ISprocCalls: ISprocBase

{

int SP_valid_student_password(string student_id, string student_password, ref int valid);

...

}


Telephony operator project data base side and main service10

MainService

Telephony Operator Project Data-Base Side and Main Service

  • Most of the operations are allowed for a maximum number of tries.

  • This service is implemented only for one phone line.

  • Has a function for handling grammer of reading a number a loud. It combines a set of messages to one array."the number of points is 99.5" is translated to

    "the number of points is ",90","9","and, "a half".


Telephony operator project data base side and main service11

MainService

Telephony Operator Project Data-Base Side and Main Service


Telephony operator project data base side and main service12

What did we have here?

(key learnings)

Telephony Operator Project Data-Base Side and Main Service

  • System design and Layers of abstractions

  • C# and .Net

  • Databases: stored procedures and data integrity.


The end

THE END


  • Login