public DataSet CreateMarker(CreateMarkerRequest request)
{
var cmd = new OracleCommand
{
Connection = _conn,
CommandText = "CreateMarker"
};
var param1 = _infraDal.GetParameter("DocId", OracleDbType.Varchar2, request.Marker.DocId);
var param2 = _infraDal.GetParameter("OutMarkerId", OracleDbType.Varchar2, request.Marker.MarkerId);
var param3 = _infraDal.GetParameter("MarkerType", OracleDbType.Varchar2, request.Marker.MarkerType);
var param4 = _infraDal.GetParameter("ForColor", OracleDbType.Varchar2, request.Marker.ForColor);
var param5 = _infraDal.GetParameter("BackColor", OracleDbType.Varchar2, request.Marker.BackColor);
var param6 = _infraDal.GetParameter("UserId", OracleDbType.Varchar2, request.Marker.UserId);
var param7 = _infraDal.GetParameter("LocationX", OracleDbType.Double, request.Marker.LocationX);
var param8 = _infraDal.GetParameter("LocationY", OracleDbType.Double, request.Marker.LocationY);
var param9 = _infraDal.GetParameter("Width", OracleDbType.Double, request.Marker.Width);
var param10 = _infraDal.GetParameter("Height", OracleDbType.Double, request.Marker.Height);
cmd.Parameters.Add(param1);
cmd.Parameters.Add(param2);
cmd.Parameters.Add(param3);
cmd.Parameters.Add(param4);
cmd.Parameters.Add(param5);
cmd.Parameters.Add(param6);
cmd.Parameters.Add(param7);
cmd.Parameters.Add(param8);
cmd.Parameters.Add(param9);
cmd.Parameters.Add(param10);
return(_infraDal.ExecSpQuery(cmd));
}
public DataSet GetAllCourses(GetAllCoursesRequest request)
{
var cmd = new MySqlCommand
{
Connection = _conn,
CommandText = "getAllCourses"
};
return(_infraDal.ExecSpQuery(cmd));
}
public DataSet CreateUser(SignUpRequest request)
{
var cmd = new OracleCommand
{
Connection = _conn,
CommandText = "CreateUser"
};
var param1 = _infraDal.GetParameter("ID", OracleDbType.Varchar2, request.Id);
var param2 = _infraDal.GetParameter("NAME", OracleDbType.Varchar2, request.Name);
cmd.Parameters.Add(param1);
cmd.Parameters.Add(param2);
return(_infraDal.ExecSpQuery(cmd));
}
public DataSet CreateShare(CreateShareRequest request)
{
var cmd = new OracleCommand
{
Connection = _conn,
CommandText = "CreateShare"
};
var param1 = _infraDal.GetParameter("Doc", OracleDbType.Varchar2, request.DocId);
var param2 = _infraDal.GetParameter("User", OracleDbType.Varchar2, request.UserId);
cmd.Parameters.Add(param1);
cmd.Parameters.Add(param2);
return(_infraDal.ExecSpQuery(cmd));
}
public DataSet AddDocument(AddDocumentRequest request, string docId)
{
var cmd = new OracleCommand
{
Connection = _conn,
CommandText = "AddDocument "
};
var param1 = _infraDal.GetParameter("OwnerID", OracleDbType.Varchar2, request.Owner);
var param2 = _infraDal.GetParameter("ImageUrl", OracleDbType.Varchar2, request.ImageUrl);
var param3 = _infraDal.GetParameter("DocumentName", OracleDbType.Varchar2, request.DocumentName);
var param4 = _infraDal.GetParameter("DocId", OracleDbType.Varchar2, docId);
cmd.Parameters.Add(param1);
cmd.Parameters.Add(param2);
cmd.Parameters.Add(param3);
cmd.Parameters.Add(param4);
return(_infraDal.ExecSpQuery(cmd));
}