private void StudentMAstertInsertUpdate(Int64 student_Id = 0)
{
StudentMasterRecord studentMasterRecord = new StudentMasterRecord();
studentMasterRecord.MasterStudentID = 0;
studentMasterRecord.StudentID = student_id;
studentMasterRecord.UniversityInstitute = txtMasterBoardInstiute.Text;
studentMasterRecord.CollegeInstitute = txtMastersUniversityCollege.Text;
studentMasterRecord.EducationSystem = Convert.ToString(cmbMasterEducationSystem.Text);
studentMasterRecord.Major = Convert.ToInt64(cmbMasterMajor.SelectedValue);
studentMasterRecord.TotalMarks = Convert.ToInt32(txtMasterTotalMarks.Text);
studentMasterRecord.ObtainedMarks = Convert.ToInt32(txtMasterObtainedMarks.Text);
studentMasterRecord.CGPA = Convert.ToDouble(txtMasterObtainedCGPA.Text);
studentMasterRecord.YearPassed = Convert.ToInt32(txtMasterPassingYear.Text);
studentMasterRecord.AddByID = Convert.ToInt64(this.Tag);
studentMasterRecord.AddDateTime = System.DateTime.Now;
studentMasterRecord.LastUpdateID = Convert.ToInt64(this.Tag);
studentMasterRecord.LastUpdateDateTime = System.DateTime.Now;
StudentMasterRecordController.InsertUpdateStudentMasterRecord(studentMasterRecord);
}
} //end function
public StudentMasterRecord StudentMasterRecordSelectByID(int intMasterStudentID)
{
try
{
string sp_name = "StudentMasterRecordSelectByID";
comStudentMasterRecord.Parameters.AddWithValue("MasterStudentID", intMasterStudentID);
ConnectAndExecute(sp_name); //no parameter will send to stored procedure
if (dsStudentMasterRecord.Tables[0].Rows.Count == 1)
{
DataRow drStudentMasterRecord = dsStudentMasterRecord.Tables[0].Rows[0];
StudentMasterRecord objStudentMasterRecord = new StudentMasterRecord();
objStudentMasterRecord.MasterStudentID = Convert.ToInt64(drStudentMasterRecord["MasterStudentID"]);
objStudentMasterRecord.StudentID = Convert.ToInt64(drStudentMasterRecord["StudentID"]);
objStudentMasterRecord.UniversityInstitute = Convert.ToString(drStudentMasterRecord["UniversityInstitute"]);
objStudentMasterRecord.CollegeInstitute = Convert.ToString(drStudentMasterRecord["CollegeInstitute"]);
objStudentMasterRecord.EducationSystem = Convert.ToString(drStudentMasterRecord["EducationSystem"]);
objStudentMasterRecord.Major = Convert.ToInt64(drStudentMasterRecord["Major"]);
objStudentMasterRecord.TotalMarks = Convert.ToInt32(drStudentMasterRecord["TotalMarks"]);
objStudentMasterRecord.ObtainedMarks = Convert.ToInt32(drStudentMasterRecord["ObtainedMarks"]);
objStudentMasterRecord.CGPA = Convert.ToInt64(drStudentMasterRecord["CGPA"]);
objStudentMasterRecord.YearPassed = Convert.ToInt32(drStudentMasterRecord["YearPassed"]);
objStudentMasterRecord.AddByID = Convert.ToInt64(drStudentMasterRecord["AddByID"]);
objStudentMasterRecord.AddDateTime = Convert.ToDateTime(drStudentMasterRecord["AddDateTime"]);
objStudentMasterRecord.LastUpdateID = Convert.ToInt64(drStudentMasterRecord["LastUpdateID"]);
objStudentMasterRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentMasterRecord["LastUpdateDateTime"]);
return(objStudentMasterRecord);
}
return(null);
}
catch (Exception ex)
{
SetError(ex.Message);
return(null);
} //end try
} //end function
///////////////////////////////////////////////////////////////////////////////////////////
//Private Methods///////////////////////////////////////////////////////////////////////////
//DB to Model//
private void GenerateModelList()
{
StudentMasterRecordList.Clear();
foreach (DataRow drStudentMasterRecord in dsStudentMasterRecord.Tables[0].Rows)
{
StudentMasterRecord objStudentMasterRecord = new StudentMasterRecord();
objStudentMasterRecord.MasterStudentID = Convert.ToInt64(drStudentMasterRecord["MasterStudentID"]);
objStudentMasterRecord.StudentID = Convert.ToInt64(drStudentMasterRecord["StudentID"]);
objStudentMasterRecord.UniversityInstitute = Convert.ToString(drStudentMasterRecord["UniversityInstitute"]);
objStudentMasterRecord.CollegeInstitute = Convert.ToString(drStudentMasterRecord["CollegeInstitute"]);
objStudentMasterRecord.EducationSystem = Convert.ToString(drStudentMasterRecord["EducationSystem"]);
objStudentMasterRecord.Major = Convert.ToInt64(drStudentMasterRecord["Major"]);
objStudentMasterRecord.TotalMarks = Convert.ToInt32(drStudentMasterRecord["TotalMarks"]);
objStudentMasterRecord.ObtainedMarks = Convert.ToInt32(drStudentMasterRecord["ObtainedMarks"]);
objStudentMasterRecord.CGPA = Convert.ToInt64(drStudentMasterRecord["CGPA"]);
objStudentMasterRecord.YearPassed = Convert.ToInt32(drStudentMasterRecord["YearPassed"]);
objStudentMasterRecord.AddByID = Convert.ToInt64(drStudentMasterRecord["AddByID"]);
objStudentMasterRecord.AddDateTime = Convert.ToDateTime(drStudentMasterRecord["AddDateTime"]);
objStudentMasterRecord.LastUpdateID = Convert.ToInt64(drStudentMasterRecord["LastUpdateID"]);
objStudentMasterRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentMasterRecord["LastUpdateDateTime"]);
StudentMasterRecordList.Add(objStudentMasterRecord);
}
}
public static Int64 InsertUpdateStudentMasterRecord(StudentMasterRecord objIUStudentMasterRecord)
{
Int64 new_id = objIUStudentMasterRecord.InsertUpdateStudentMasterRecord();
return(new_id);
}
