} //end function public StudentDegree StudentDegreeSelectByID(int intDegreeID) { try { string sp_name = "StudentDegreeSelectByID"; comStudentDegree.Parameters.AddWithValue("DegreeID", intDegreeID); ConnectAndExecute(sp_name); //no parameter will send to stored procedure if (dsStudentDegree.Tables[0].Rows.Count == 1) { DataRow drStudentDegree = dsStudentDegree.Tables[0].Rows[0]; StudentDegree objStudentDegree = new StudentDegree(); objStudentDegree.DegreeID = Convert.ToInt64(drStudentDegree["DegreeID"]); objStudentDegree.DegreeName = Convert.ToString(drStudentDegree["DegreeName"]); objStudentDegree.CreatedByID = Convert.ToInt64(drStudentDegree["CreatedByID"]); objStudentDegree.CreatedDateTime = Convert.ToDateTime(drStudentDegree["CreatedDateTime"]); objStudentDegree.IsEnabled = Convert.ToBoolean(drStudentDegree["IsEnabled"]); objStudentDegree.LastUpdateByID = Convert.ToInt64(drStudentDegree["LastUpdateByID"]); objStudentDegree.LastUpdateTime = Convert.ToDateTime(drStudentDegree["LastUpdateTime"]); objStudentDegree.Remarks = Convert.ToString(drStudentDegree["Remarks"]); return(objStudentDegree); } return(null); } catch (Exception ex) { SetError(ex.Message); return(null); } //end try } //end function
private void btnSave_Click(object sender, EventArgs e) { StudentDegree degree = new StudentDegree(); degree.DegreeID = Convert.ToInt32(txtDegreeName.Tag); degree.DegreeName = txtDegreeName.Text; degree.Remarks = txtDegreeRemarks.Text; degree.CreatedByID = Convert.ToInt32(this.Tag); degree.CreatedDateTime = System.DateTime.Now; degree.LastUpdateByID = Convert.ToInt32(this.Tag); degree.LastUpdateTime = System.DateTime.Now; degree.IsEnabled = chkIsEnabled.Checked; long degree_id = degree.InsertUpdateStudentDegree(); txtDegreeName.Tag = degree_id; if (degree_id > 0) { MessageBox.Show("Record Entered Successfully"); } else { MessageBox.Show("Error: Degree Not Added"); } }
/////////////////////////////////////////////////////////////////////////////////////////// //Private Methods/////////////////////////////////////////////////////////////////////////// //DB to Model// private void GenerateModelList() { StudentDegreeList.Clear(); foreach (DataRow drStudentDegree in dsStudentDegree.Tables[0].Rows) { StudentDegree objStudentDegree = new StudentDegree(); objStudentDegree.DegreeID = Convert.ToInt64(drStudentDegree["DegreeID"]); objStudentDegree.DegreeName = Convert.ToString(drStudentDegree["DegreeName"]); objStudentDegree.CreatedByID = Convert.ToInt64(drStudentDegree["CreatedByID"]); objStudentDegree.CreatedDateTime = Convert.ToDateTime(drStudentDegree["CreatedDateTime"]); objStudentDegree.IsEnabled = Convert.ToBoolean(drStudentDegree["IsEnabled"]); objStudentDegree.LastUpdateByID = Convert.ToInt64(drStudentDegree["LastUpdateByID"]); objStudentDegree.LastUpdateTime = Convert.ToDateTime(drStudentDegree["LastUpdateTime"]); objStudentDegree.Remarks = Convert.ToString(drStudentDegree["Remarks"]); StudentDegreeList.Add(objStudentDegree); } }
public static Int64 InsertUpdateStudentDegree(StudentDegree objIUStudentDegree) { Int64 new_id = objIUStudentDegree.InsertUpdateStudentDegree(); return(new_id); }
private void Daly_Tick(object sender, EventArgs e) { Daly.Stop(); List <StudentDegree> studentDegrees = new List <StudentDegree>(); studentDegrees = StudentDegreeController.StudentDegreeSelectAll(); lblTotalDegree.Text = studentDegrees.Count.ToString(); StudentDegree studentDegree = new StudentDegree(); studentDegrees = studentDegree.StudentDegreeSelectAll(); List <StudentProgram> studentPrograms = new List <StudentProgram>(); StudentProgram studentProgram = new StudentProgram(); studentPrograms = studentProgram.StudentProgramSelectAll(); lblProgramTotal.Text = studentPrograms.Count.ToString(); List <CollageAdmin> collageAdmins = CollageAdminController.CollageAdminSelectAll(); lblTotalAdmin.Text = collageAdmins.Count.ToString(); List <StudentPersonalInfo> studentPersonalInfos = StudentPersonalInfoController.StudentPersonalInfoSelectAll(); lblTotalStudent.Text = studentPersonalInfos.Count.ToString(); List <StudentSections> studentSections = StudentSectionsController.StudentSectionsSelectAll(); lblTotalSection.Text = studentSections.Count.ToString(); Bunifu.DataViz.Data data = new Bunifu.DataViz.Data(); Bunifu.DataViz.DataPoint dataPoint = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuCharts._type.column); Random r = new Random(); dataPoint.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); data.addData(dataPoint); CollumChart.Render(data); Bunifu.DataViz.Data data1 = new Bunifu.DataViz.Data(); Bunifu.DataViz.DataPoint dataPoint2 = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuCharts._type.pie); dataPoint2.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint2.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint2.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint2.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); data1.addData(dataPoint2); bunifuCharts1.Render(data1); Bunifu.DataViz.Data data2 = new Bunifu.DataViz.Data(); Bunifu.DataViz.DataPoint dataPoint3 = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuCharts._type.spline); dataPoint3.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint3.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint3.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); data2.addData(dataPoint3); bunifuCharts2.Render(data2); Bunifu.DataViz.Data data3 = new Bunifu.DataViz.Data(); Bunifu.DataViz.DataPoint dataPoint4 = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuCharts._type.area); dataPoint4.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint4.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint4.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString()); dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString()); data3.addData(dataPoint4); bunifuCharts3.Render(data3); }