} //end function
public StudentGraduationSubject StudentGraduationSubjectSelectByID(int intStudentSubjectID)
{
try
{
string sp_name = "StudentGraduationSubjectSelectByID";
comStudentGraduationSubject.Parameters.AddWithValue("StudentSubjectID", intStudentSubjectID);
ConnectAndExecute(sp_name); //no parameter will send to stored procedure
if (dsStudentGraduationSubject.Tables[0].Rows.Count == 1)
{
DataRow drStudentGraduationSubject = dsStudentGraduationSubject.Tables[0].Rows[0];
StudentGraduationSubject objStudentGraduationSubject = new StudentGraduationSubject();
objStudentGraduationSubject.StudentSubjectID = Convert.ToInt64(drStudentGraduationSubject["StudentSubjectID"]);
objStudentGraduationSubject.StudentID = Convert.ToInt64(drStudentGraduationSubject["StudentID"]);
objStudentGraduationSubject.SubjectID = Convert.ToInt64(drStudentGraduationSubject["SubjectID"]);
objStudentGraduationSubject.Remarks = Convert.ToString(drStudentGraduationSubject["Remarks"]);
objStudentGraduationSubject.AddedByID = Convert.ToInt64(drStudentGraduationSubject["AddedByID"]);
objStudentGraduationSubject.AddedDateTime = Convert.ToDateTime(drStudentGraduationSubject["AddedDateTime"]);
objStudentGraduationSubject.LastUpdateID = Convert.ToInt64(drStudentGraduationSubject["LastUpdateID"]);
objStudentGraduationSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentGraduationSubject["LastUpdateDateTime"]);
return(objStudentGraduationSubject);
}
return(null);
}
catch (Exception ex)
{
SetError(ex.Message);
return(null);
} //end try
} //end function
///////////////////////////////////////////////////////////////////////////////////////////
//Private Methods///////////////////////////////////////////////////////////////////////////
//DB to Model//
private void GenerateModelList()
{
StudentGraduationSubjectList.Clear();
foreach (DataRow drStudentGraduationSubject in dsStudentGraduationSubject.Tables[0].Rows)
{
StudentGraduationSubject objStudentGraduationSubject = new StudentGraduationSubject();
objStudentGraduationSubject.StudentSubjectID = Convert.ToInt64(drStudentGraduationSubject["StudentSubjectID"]);
objStudentGraduationSubject.StudentID = Convert.ToInt64(drStudentGraduationSubject["StudentID"]);
objStudentGraduationSubject.SubjectID = Convert.ToInt64(drStudentGraduationSubject["SubjectID"]);
objStudentGraduationSubject.Remarks = Convert.ToString(drStudentGraduationSubject["Remarks"]);
objStudentGraduationSubject.AddedByID = Convert.ToInt64(drStudentGraduationSubject["AddedByID"]);
objStudentGraduationSubject.AddedDateTime = Convert.ToDateTime(drStudentGraduationSubject["AddedDateTime"]);
objStudentGraduationSubject.LastUpdateID = Convert.ToInt64(drStudentGraduationSubject["LastUpdateID"]);
objStudentGraduationSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentGraduationSubject["LastUpdateDateTime"]);
StudentGraduationSubjectList.Add(objStudentGraduationSubject);
}
}
private void StudentGraduationSubjectInsertUpdate(Int64 student_Id = 0)
{
StudentGraduationSubject studentGraduationSubject = new StudentGraduationSubject();
ArrayList studentGraduationSubjectList = chkGraduationSelectedSubject.GetSelectedItems();
foreach (StudentSubject studentSubject in studentGraduationSubjectList)
{
studentGraduationSubject = new StudentGraduationSubject();
studentGraduationSubject.StudentSubjectID = 0;
studentGraduationSubject.StudentID = student_Id;
studentGraduationSubject.SubjectID = studentSubject.SubjectID;
studentGraduationSubject.Remarks = txtGraduationStudentRemarks.Text;
studentGraduationSubject.AddedByID = Convert.ToInt64(this.Tag);
studentGraduationSubject.AddedDateTime = System.DateTime.Now;
studentGraduationSubject.LastUpdateID = Convert.ToInt64(this.Tag);
studentGraduationSubject.LastUpdateDateTime = System.DateTime.Now;
StudentGraduationSubjectController.InsertUpdateStudentGraduationSubject(studentGraduationSubject);
}
}
public static Int64 InsertUpdateStudentGraduationSubject(StudentGraduationSubject objIUStudentGraduationSubject)
{
Int64 new_id = objIUStudentGraduationSubject.InsertUpdateStudentGraduationSubject();
return(new_id);
}
