} //end function
public StudentMatricSubject StudentMatricSubjectSelectByID(int intStudentSubjectID)
{
try
{
string sp_name = "StudentMatricSubjectSelectByID";
comStudentMatricSubject.Parameters.AddWithValue("StudentSubjectID", intStudentSubjectID);
ConnectAndExecute(sp_name); //no parameter will send to stored procedure
if (dsStudentMatricSubject.Tables[0].Rows.Count == 1)
{
DataRow drStudentMatricSubject = dsStudentMatricSubject.Tables[0].Rows[0];
StudentMatricSubject objStudentMatricSubject = new StudentMatricSubject();
objStudentMatricSubject.StudentSubjectID = Convert.ToInt64(drStudentMatricSubject["StudentSubjectID"]);
objStudentMatricSubject.StudentID = Convert.ToInt64(drStudentMatricSubject["StudentID"]);
objStudentMatricSubject.SubjectID = Convert.ToInt64(drStudentMatricSubject["SubjectID"]);
objStudentMatricSubject.Remarks = Convert.ToString(drStudentMatricSubject["Remarks"]);
objStudentMatricSubject.AddedByID = Convert.ToInt64(drStudentMatricSubject["AddedByID"]);
objStudentMatricSubject.AddedDateTime = Convert.ToDateTime(drStudentMatricSubject["AddedDateTime"]);
objStudentMatricSubject.LastUpdateID = Convert.ToInt64(drStudentMatricSubject["LastUpdateID"]);
objStudentMatricSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentMatricSubject["LastUpdateDateTime"]);
return(objStudentMatricSubject);
}
return(null);
}
catch (Exception ex)
{
SetError(ex.Message);
return(null);
} //end try
} //end function
///////////////////////////////////////////////////////////////////////////////////////////
//Private Methods///////////////////////////////////////////////////////////////////////////
//DB to Model//
private void GenerateModelList()
{
StudentMatricSubjectList.Clear();
foreach (DataRow drStudentMatricSubject in dsStudentMatricSubject.Tables[0].Rows)
{
StudentMatricSubject objStudentMatricSubject = new StudentMatricSubject();
objStudentMatricSubject.StudentSubjectID = Convert.ToInt64(drStudentMatricSubject["StudentSubjectID"]);
objStudentMatricSubject.StudentID = Convert.ToInt64(drStudentMatricSubject["StudentID"]);
objStudentMatricSubject.SubjectID = Convert.ToInt64(drStudentMatricSubject["SubjectID"]);
objStudentMatricSubject.Remarks = Convert.ToString(drStudentMatricSubject["Remarks"]);
objStudentMatricSubject.AddedByID = Convert.ToInt64(drStudentMatricSubject["AddedByID"]);
objStudentMatricSubject.AddedDateTime = Convert.ToDateTime(drStudentMatricSubject["AddedDateTime"]);
objStudentMatricSubject.LastUpdateID = Convert.ToInt64(drStudentMatricSubject["LastUpdateID"]);
objStudentMatricSubject.LastUpdateDateTime = Convert.ToDateTime(drStudentMatricSubject["LastUpdateDateTime"]);
StudentMatricSubjectList.Add(objStudentMatricSubject);
}
}
private void StudentMatricSubjectInsertUpdate(Int64 student_Id = 0)
{
StudentMatricSubject studentMatricSubject = new StudentMatricSubject();
ArrayList matricSubjectList = chkStudentMatricSelectedSubject.GetSelectedItems();
foreach (StudentSubject studentSubject in matricSubjectList)
{
studentMatricSubject = new StudentMatricSubject();
studentMatricSubject.StudentSubjectID = 0;
studentMatricSubject.StudentID = student_Id;
studentMatricSubject.SubjectID = studentSubject.SubjectID;
studentMatricSubject.Remarks = txtMatricStudentRemark.Text;
studentMatricSubject.AddedByID = Convert.ToInt64(this.Tag);
studentMatricSubject.AddedDateTime = System.DateTime.Now;
studentMatricSubject.LastUpdateID = Convert.ToInt64(this.Tag);
studentMatricSubject.LastUpdateDateTime = System.DateTime.Now;
Int64 id = StudentMatricSubjectController.InsertUpdateStudentMatricSubject(studentMatricSubject);
}
}
public static Int64 InsertUpdateStudentMatricSubject(StudentMatricSubject objIUStudentMatricSubject)
{
Int64 new_id = objIUStudentMatricSubject.InsertUpdateStudentMatricSubject();
return(new_id);
}
