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();
}
