Component Page /Video.cs (C#)
1: using System;
2: using System.Collections.Generic;
3: using Microsoft.ApplicationBlocks.Data;
4: using System.Data.SqlClient;
5: using System.Data;
6:
7: namespace QuizNetOnline.Logic
8: {
9: public class Video
10: {
11: public int VideoID { get; set; }
12: public Topic Topic { get; set; }
13: public string VideoDesc { get; set; }
14: public string VideoCode { get; set; }
15: public int VideoPosition { get; set; }
16:
17: public void Delete()
18: {
19: ISqlWrapper isqlWrapper = new SqlWrapper();
20: string connStr = isqlWrapper.GetConnectionString();
21: const string sproc = "DeleteVideo";
22:
23: var parameters = new SqlParameter[1];
24:
25: parameters[0] = new SqlParameter("@VideoID", VideoID);
26: try
27: {
28: isqlWrapper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, sproc, parameters);
29: }
30: catch (Exception ex)
31: {
32: ErrorLog errorLog = new ErrorLog();
33: errorLog.LogException("DeleteVideo", ex, isqlWrapper);
34: throw;
35: }
36: }
37:
38: public void Get(int videoID)
39: {
40: ISqlWrapper isqlWrapper = new SqlWrapper();
41: string connStr = isqlWrapper.GetConnectionString();
42: const string sproc = "GetVideo";
43:
44: var parameters = new SqlParameter[1];
45:
46: parameters[0] = new SqlParameter("@VideoID", videoID);
47: try
48: {
49: DataTable tbl = isqlWrapper.ExecuteDataset(connStr, CommandType.StoredProcedure, sproc, parameters).Tables[0];
50: foreach (DataRow row in tbl.Rows)
51: {
52: VideoID = Convert.ToInt32(row["VideoID"]);
53: Topic = new Topic(row["TopicCode"].ToString());
54: VideoDesc = row["VideoDesc"].ToString();
55: VideoCode = row["VideoCode"].ToString();
56: VideoPosition = Convert.ToInt32(row["VideoPosition"]);
57: }
58: }
59: catch (Exception ex)
60: {
61: ErrorLog errorLog = new ErrorLog();
62: errorLog.LogException("VideoGetVideoID", ex, isqlWrapper);
63: throw;
64: }
65: }
66:
67: public List<Video> Get(Topic topic)
68: {
69: ISqlWrapper isqlWrapper = new SqlWrapper();
70: string connStr = isqlWrapper.GetConnectionString();
71: const string sproc = "GetVideos";
72:
73: var parameters = new SqlParameter[1];
74:
75: parameters[0] = new SqlParameter("@TopicCode", topic.TopicCode);
76:
77: List<Video> videos = new List<Video>();
78: try
79: {
80: DataTable tbl = isqlWrapper.ExecuteDataset(connStr, CommandType.StoredProcedure, sproc, parameters).Tables[0];
81: foreach (DataRow row in tbl.Rows)
82: {
83: Video video = new Video();
84: video.VideoID = Convert.ToInt32(row["VideoID"]);
85: video.Topic = new Topic(row["TopicCode"].ToString());
86: video.VideoDesc = row["VideoDesc"].ToString();
87: video.VideoCode = row["VideoCode"].ToString();
88: video.VideoPosition = Convert.ToInt32(row["VideoPosition"]);
89: videos.Add(video);
90: }
91:
92: return videos;
93: }
94: catch (Exception ex)
95: {
96: ErrorLog errorLog = new ErrorLog();
97: errorLog.LogException("VideoGetTopic", ex, isqlWrapper);
98: throw;
99: }
100: }
101:
102: public void Add()
103: {
104: ISqlWrapper isqlWrapper = new SqlWrapper();
105: string connStr = isqlWrapper.GetConnectionString();
106: const string sproc = "InsertVideo";
107:
108: var parameters = new SqlParameter[5];
109:
110: parameters[0] = new SqlParameter("@TopicCode", Topic.TopicCode);
111: parameters[1] = new SqlParameter("@VideoDesc", VideoDesc);
112: parameters[2] = new SqlParameter("@VideoCode", VideoCode);
113: parameters[3] = new SqlParameter("@VideoPosition", VideoPosition);
114: parameters[4] = new SqlParameter("@VideoID", Convert.ToInt32(0)) { Direction = ParameterDirection.InputOutput };
115:
116:
117: try
118: {
119: isqlWrapper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, sproc, parameters);
120: VideoID = Convert.ToInt32(parameters[4].Value);
121: }
122: catch (Exception ex)
123: {
124: ErrorLog errorLog = new ErrorLog();
125: errorLog.LogException("VideoAdd", ex, isqlWrapper);
126: throw;
127: }
128: }
129:
130: public void Save()
131: {
132: ISqlWrapper isqlWrapper = new SqlWrapper();
133: string connStr = isqlWrapper.GetConnectionString();
134: const string sproc = "SaveVideo";
135:
136: var parameters = new SqlParameter[5];
137:
138: parameters[0] = new SqlParameter("@VideoID", VideoID);
139: parameters[1] = new SqlParameter("@TopicCode", Topic.TopicCode);
140: parameters[2] = new SqlParameter("@VideoDesc", VideoDesc);
141: parameters[3] = new SqlParameter("@VideoCode", VideoCode);
142: parameters[4] = new SqlParameter("@VideoPosition", VideoPosition);
143:
144:
145: try
146: {
147: isqlWrapper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, sproc, parameters);
148: }
149: catch (Exception ex)
150: {
151: There is a limit of 150 source code lines in the evaluation version
152: There is a limit of 150 source code lines in the evaluation version
153: There is a limit of 150 source code lines in the evaluation version
154: There is a limit of 150 source code lines in the evaluation version
155: There is a limit of 150 source code lines in the evaluation version
156: There is a limit of 150 source code lines in the evaluation version
157: There is a limit of 150 source code lines in the evaluation version
.NET Documentation Tool is © 2002 - 2009 Winnersh Triangle Web Solutions Limited.