private void subAdd_Click(object sender, EventArgs e) { subjectModel subjectModel = new subjectModel(); subjectModel.OffYear = offyear.Text; subjectModel.OffSem = offSem.Text; subjectModel.SubName = subName.Text; subjectModel.subCode = subCode.Text; subjectModel.lechours = lecHrs.Text; subjectModel.labHours = labHrs.Text; subjectModel.tuteHours = tuteHrs.Text; subjectModel.evalHours = evalHrs.Text; subjectController subctrl = new subjectController(); subctrl.insertSubjectDetails(subjectModel); subTbl.DataSource = subctrl.getSubjectdatatoTable(); offyear.Text = ""; offSem.Text = ""; subName.Text = ""; subCode.Text = ""; lecHrs.Text = ""; labHrs.Text = ""; tuteHrs.Text = ""; evalHrs.Text = ""; }
private void subDel_Click(object sender, EventArgs e) { subjectModel subject = new subjectModel(); subject.subCode = subCode.Text; subjectController subController = new subjectController(); subController.DeleteSubject(subject); Year.Text = ""; offyear.Text = ""; offSem.Text = ""; subName.Text = ""; subCode.Text = ""; lecHrs.Text = ""; labHrs.Text = ""; tuteHrs.Text = ""; evalHrs.Text = ""; subCode.ReadOnly = false; subAdd.Enabled = true; subTbl.DataSource = subController.getSubjectdatatoTable(); }
private void subEdit_Click(object sender, EventArgs e) { subjectModel subjectModel = new subjectModel(); subjectModel.OffYear = offyear.Text; subjectModel.OffSem = offSem.Text; subjectModel.SubName = subName.Text; subjectModel.subCode = subCode.Text; subjectModel.lechours = lecHrs.Text; subjectModel.labHours = labHrs.Text; subjectModel.tuteHours = tuteHrs.Text; subjectModel.evalHours = evalHrs.Text; subjectController ctrl = new subjectController(); ctrl.UpdateSubject(subjectModel); subTbl.DataSource = ctrl.getSubjectdatatoTable(); offyear.Text = ""; offSem.Text = ""; subName.Text = ""; subCode.Text = ""; lecHrs.Text = ""; labHrs.Text = ""; tuteHrs.Text = ""; evalHrs.Text = ""; subCode.ReadOnly = false; }
private void subAdd_Click(object sender, EventArgs e) { if (Year.Text != "" && offyear.Text != "" && offSem.Text != "" && subName.Text != "" && subCode.Text != "" && lecHrs.Text != "" && labHrs.Text != "" && tuteHrs.Text != "" && evalHrs.Text != "") { subjectModel subjectModel = new subjectModel(); subjectModel.year = Year.Text; subjectModel.OffYear = offyear.Text; subjectModel.OffSem = offSem.Text; subjectModel.SubName = subName.Text; subjectModel.subCode = subCode.Text; subjectModel.lechours = lecHrs.Text; subjectModel.labHours = labHrs.Text; subjectModel.tuteHours = tuteHrs.Text; subjectModel.evalHours = evalHrs.Text; subjectController subctrl = new subjectController(); subctrl.insertSubjectDetails(subjectModel); subTbl.DataSource = subctrl.getSubjectdatatoTable(); Year.Text = ""; offyear.Text = ""; offSem.Text = ""; subName.Text = ""; subCode.Text = ""; lecHrs.Text = ""; labHrs.Text = ""; tuteHrs.Text = ""; evalHrs.Text = ""; } else { MessageBox.Show("Please Fill the all the required fields ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public SubjectList GetAllSubjects() { List <subject> _list = mr.SelectAllSubjects(); SubjectList s = new SubjectList(); List <subjectModel> sml = new List <subjectModel>(); foreach (subject sub in _list) { subjectModel sm = new subjectModel(); sm.id = sub.id; sm.name = sub.name; sm.description = sub.description; sml.Add(sm); } s._subList = sml; return(s); }
public string GenerateMarksheet() { string subjectStr = HttpContext.Current.Request.Params["request"]; subjectModel subject = JsonConvert.DeserializeObject <subjectModel>(subjectStr); //subjects.Add(subject); int totalMarks = 0; int minMarks = subjects[0].ObtainMarks; string minSubject = subjects[0].subjName; int maxMarks = subjects[0].ObtainMarks; string maxSubject = subjects[0].subjName; for (int i = 0; i < subjects.Count; i++) { totalMarks += subjects[i].ObtainMarks; if (minMarks > subjects[i].ObtainMarks) { minMarks = subjects[i].ObtainMarks; minSubject = subjects[i].subjName; } if (maxMarks < subjects[i].ObtainMarks) { maxMarks = subjects[i].ObtainMarks; maxSubject = subjects[i].subjName; } } int per = (totalMarks / (subjects.Count * 100)) * 100; MarksheetGenModel marksheetModel = new MarksheetGenModel(); marksheetModel.percentage = per; marksheetModel.minMarks = minMarks; marksheetModel.maxMarks = maxMarks; marksheetModel.minMarksSubject = minSubject; marksheetModel.maxMarksSubject = maxSubject; string str = JsonConvert.SerializeObject(marksheetModel); return(str); }
public void UpdateSubject(subjectModel subjectModel) { if (con.State.ToString() != "Open") { con.Open(); } string query = "UPDATE SubjectTable SET year='" + subjectModel.year + "', offYear ='" + subjectModel.OffYear + "',offSem ='" + subjectModel.OffSem + "', SubName='" + subjectModel.SubName + "', LecHrs = '" + subjectModel.lechours + "',TuteHrs= '" + subjectModel.tuteHours + "', LabHrs = '" + subjectModel.labHours + "', EvalHrs ='" + subjectModel.evalHours + "' WHERE SubCode='" + subjectModel.subCode + "'"; SqlCommand com = new SqlCommand(query, con); string ans = System.Windows.Forms.MessageBox.Show("Are sure to update subject details?", "Warning", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Warning).ToString(); if (ans == "Yes") { int ret = com.ExecuteNonQuery(); System.Windows.Forms.MessageBox.Show("subject details update successful"); } con.Close(); }
public void DeleteSubject(subjectModel subjectModel) { if (con.State.ToString() != "Open") { con.Open(); } string query = "DELETE FROM SubjectTable WHERE SubCode='" + subjectModel.subCode + "'"; SqlCommand com = new SqlCommand(query, con); string ans = System.Windows.Forms.MessageBox.Show("Are sure to remove subject?", "Warning", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Warning).ToString(); if (ans == "Yes") { int ret = com.ExecuteNonQuery(); System.Windows.Forms.MessageBox.Show("subject removed successful"); } con.Close(); }
public void insertSubjectDetails(subjectModel subject) { if (con.State.ToString() != "Open") { con.Open(); } string query = "INSERT INTO SubjectTable(offYear,offSem,SubName,SubCode,LecHrs,TuteHrs,LabHrs,EvalHrs,year) VALUES ('" + subject.OffYear + "','" + subject.OffSem + "','" + subject.SubName + "','" + subject.subCode + "','" + subject.lechours + "','" + subject.tuteHours + "','" + subject.labHours + "','" + subject.evalHours + "','" + subject.year + "')"; SqlCommand com = new SqlCommand(query, con); int ret = NewMethod(com); if (ret != 0) { System.Windows.Forms.MessageBox.Show("Successful"); } else { System.Windows.Forms.MessageBox.Show("Adding Error !!"); } con.Close(); }