1 using System;
2 using System.Collections;
3 using System.Collections.Generic;
4 using System.ComponentModel;
5 using System.Data.OleDb;
6 using System.Drawing;
7 using System.Data;
8 using System.Text;
9 using System.Windows.Forms;
10
11
12 namespace Scheduler
13 {
14 public partial class frmManageSubject : Form
15 {
16
17 public frmManageSubject()
18 {
19 InitializeComponent();
20 }
21
22 private void frmManageSubject_Load(object sender, EventArgs e)
23 {
24 if (clsCon.con.State == ConnectionState.Open)
25 { clsCon.con.Close(); }
26 clsCon.con.Open();
27
28
29 LoadCurriculum();
30 LoadSubjects();
31 PopulatedTreeView();
32 LoadSubjectOffered();
33 cboCurriculum.SelectedIndex = cboCurriculum.FindStringExact("ALL");
34
35 }
36
37 public void LoadSubjects()
38 {
39 OleDbCommand com = new OleDbCommand("SELECT * FROM qrySubjects", clsCon.con);
40 OleDbDataReader dr = com.ExecuteReader();
41 lvSubjects.Items.Clear();
42 while (dr.Read())
43 {
44 ListViewItem list = new ListViewItem(dr["SubjectCode"].ToString());
45 list.SubItems.Add(dr["Subject"].ToString());
46 list.SubItems.Add(dr["DescriptiveTitle"].ToString());
47 list.SubItems.Add(dr["Units"].ToString());
48 list.SubItems.Add(dr["YearLevel"].ToString());
49 list.UseItemStyleForSubItems = false;
50 list.ImageIndex = 0;
51 lvSubjects.Items.AddRange(new ListViewItem[] { list });
52 }
53 dr.Close();
54 }
55
56 public void LoadSubjectsByYearLvl(string sYearLvl)
57 {
58 OleDbCommand com = new OleDbCommand("SELECT * FROM qrySubjects where YrLvlChar='" + sYearLvl +"'", clsCon.con);
59 OleDbDataReader dr = com.ExecuteReader();
60 lvSubjects.Items.Clear();
61 while (dr.Read())
62 {
63 ListViewItem list = new ListViewItem(dr["Subject"].ToString());
64 list.SubItems.Add(dr["SubjectCode"].ToString());
65 list.SubItems.Add(dr["DescriptiveTitle"].ToString());
66 list.SubItems.Add(dr["Units"].ToString());
67 list.SubItems.Add(dr["HrsWk"].ToString());
68 list.SubItems.Add(dr["YearLevel"].ToString());
69 list.ImageIndex = 0;
70 list.UseItemStyleForSubItems = false;
71 lvSubjects.Items.AddRange(new ListViewItem[] { list });
72 }
73 dr.Close();
74 }
75
76 void LoadCurriculum()
77 {
78 OleDbCommand com = new OleDbCommand("Select CurriculumTitle From tblCurriculum", clsCon.con);
79 OleDbDataReader dr = com.ExecuteReader();
80 cboCurriculum.Items.Clear();
81 while (dr.Read())
82 {
83 cboCurriculum.Items.Add(dr["CurriculumTitle"].ToString());
84 }
85 cboCurriculum.Items.Add("ALL");
86 dr.Close();
87 }
88
89 public void LoadSubjectsByCurriculum(string Curriculum)
90 {
91 OleDbCommand com = new OleDbCommand("SELECT * FROM qrySubjects where CurriculumTitle Like '%" + Curriculum + "%'", clsCon.con);
92 OleDbDataReader dr = com.ExecuteReader();
93 lvSubjects.Items.Clear();
94 while (dr.Read())
95 {
96 ListViewItem list = new ListViewItem(dr["Subject"].ToString());
97 list.SubItems.Add(dr["SubjectCode"].ToString());
98 list.SubItems.Add(dr["DescriptiveTitle"].ToString());
99 list.SubItems.Add(dr["Units"].ToString());
100 list.SubItems.Add(dr["HrsWk"].ToString());
101 list.SubItems.Add(dr["YearLevel"].ToString());
102 list.UseItemStyleForSubItems = false;
103 list.ImageIndex = 0;
104 lvSubjects.Items.AddRange(new ListViewItem[] { list });
105 }
106 dr.Close();
107 }
108
109 private void refreshToolStripMenuItem_Click(object sender, EventArgs e)
110 {
111 LoadSubjects();
112 }
113
114
115 void LoadSubjectOffered()
116 {
117 OleDbCommand com = new OleDbCommand("SELECT * FROM qrySubjectOfferring ", clsCon.con);
118 OleDbDataReader dr = com.ExecuteReader();
119 lvSchedule.Items.Clear();
120 while (dr.Read())
121 {
122 ListViewItem lv = new ListViewItem(dr["Subject"].ToString());
123 lv.SubItems.Add(dr["cRoom"].ToString());
124 lv.SubItems.Add(dr["Schedule"].ToString());
125 lv.SubItems.Add(dr["Faculty"].ToString());
126 lv.ImageIndex = 3;
127 lvSchedule.Items.AddRange(new ListViewItem[] { lv });
128 }
129 dr.Close();
130 }
131
132
133 void PopulatedTreeView()
134 {
135 tvSubject.BeginUpdate();
136 tvSubject.Nodes.Clear();
137
138 #region SchoolYear
139 OleDbCommand cmd = new OleDbCommand("Select * From tblSchoolYear", clsCon.con);
140 OleDbDataReader rs = cmd.ExecuteReader();
141 while (rs.Read())
142 {
143 //node.Text = rs["SchoolYear"].ToString();
144 tvSubject.Nodes.Add(rs["SchoolYear"].ToString(), rs["SchoolYear"].ToString(), 0);
145 }
146 rs.Close();
147 #endregion
148
149 #region Curriculum
150 OleDbCommand comm = new OleDbCommand("Select CurriculumTitle From tblCurriculum", clsCon.con);
151 OleDbDataReader vRS = comm.ExecuteReader();
152 while (vRS.Read())
153 {
154 ///node.Text = vRS["CurriculumTitle"].ToString();
155 tvSubject.Nodes[0].Nodes.Add(vRS["CurriculumTitle"].ToString(), vRS["CurriculumTitle"].ToString(),1);
156 }
157 vRS.Close();
158 #endregion
159
160 #region YearLvl
161 OleDbCommand com = new OleDbCommand("Select YrLvlChar From YearLevel", clsCon.con);
162 OleDbDataReader dr = com.ExecuteReader();
163 while (dr.Read())
164 {
165 //node.Text = dr["YrLvlChar"].ToString();
166 tvSubject.Nodes[0].Nodes[0].Nodes.Add(dr["YrLvlChar"].ToString(), dr["YrLvlChar"].ToString(),1);
167 }
168 dr.Close();
169 #endregion
170
171 tvSubject.EndUpdate();
172
173 }
174
175 private void addNewEntryToolStripMenuItem_Click(object sender, EventArgs e)
176 {
177 frmSubjectAE subject = new frmSubjectAE();
178 subject.mFormState = "ADD";
179 subject.ShowDialog();
180 }
181
182 private void cmdSubjectOffer_Click(object sender, EventArgs e)
183 {
184 frmScheduler pipo = new frmScheduler();
185 pipo.txtSubject.Text = lvSubjects.FocusedItem.Text;
186 pipo.sSubjectCode = lvSubjects.Items[lvSubjects.FocusedItem.Index].SubItems[1].Text;
187 pipo.sYearLevel = int.Parse(lvSubjects.Items[lvSubjects.FocusedItem.Index].SubItems[4].Text);
188 pipo.mFormState = "ADD";
189 pipo.ShowDialog();
190 }
191
192 private void cboCurriculum_SelectedIndexChanged(object sender, EventArgs e)
193 {
194 switch (cboCurriculum.Text)
195 {
196 case "ALL":
197 LoadSubjects();
198 break;
199 default:
200 LoadSubjectsByCurriculum(cboCurriculum.Text);
201 break;
202 }
203 }
204
205 private void cmdtoolCancel_Click(object sender, EventArgs e)
206 {
207
208 }
209
210 private void tvSubject_AfterSelect(object sender, TreeViewEventArgs e)
211 {
212
213 }
214
215 private void lvSubjects_ItemDrag(object sender, ItemDragEventArgs e)
216 {
217 lvSubjects.DoDragDrop(lvSubjects.FocusedItem.Text, DragDropEffects.Move);
218 }
219
220 private void lvSchedule_DragEnter(object sender, DragEventArgs e)
221 {
222 e.Effect = DragDropEffects.Move;
223 }
224
225 private void lvSchedule_DragDrop(object sender, DragEventArgs e)
226 {
227 frmScheduler pipo = new frmScheduler();
228 pipo.txtSubject.Text = lvSubjects.FocusedItem.Text;
229 pipo.sSubjectCode = lvSubjects.Items[lvSubjects.FocusedItem.Index].SubItems[1].Text;
230 pipo.sYearLevel=int.Parse(lvSubjects.Items[lvSubjects.FocusedItem.Index].SubItems[4].Text);
231 pipo.mFormState = "ADD";
232 pipo.ShowDialog();
233 }
234
235 private void timer2_Tick(object sender, EventArgs e)
236 {
237 LoadSubjectOffered();
238 }
239
240 private void modifyEntryToolStripMenuItem_Click(object sender, EventArgs e)
241 {
242 frmSubjectAE subj = new frmSubjectAE();
243 subj.mFormState = "EDIT";
244 subj.sSubjectCode = lvSubjects.FocusedItem.Text;
245 subj.ShowDialog();
246 }
247
248 private void cboCurriculum_Click(object sender, EventArgs e)
249 {
250
251 }
252
253 private void refreshToolStripMenuItem1_Click(object sender, EventArgs e)
254 {
255 LoadSubjectOffered();
256 }
257
258 }
259 }