}     //end function

    public StudentAddmissionInfo StudentAddmissionInfoSelectByID(int intStudentAddmissionID)
    {
        try
        {
            string sp_name = "StudentAddmissionInfoSelectByID";
            comStudentAddmissionInfo.Parameters.AddWithValue("StudentAddmissionID", intStudentAddmissionID);
            ConnectAndExecute(sp_name);             //no parameter will send to stored procedure
            if (dsStudentAddmissionInfo.Tables[0].Rows.Count == 1)
            {
                DataRow drStudentAddmissionInfo = dsStudentAddmissionInfo.Tables[0].Rows[0];
                StudentAddmissionInfo objStudentAddmissionInfo = new StudentAddmissionInfo();
                objStudentAddmissionInfo.StudentAddmissionID = Convert.ToInt64(drStudentAddmissionInfo["StudentAddmissionID"]);
                objStudentAddmissionInfo.StudentID           = Convert.ToInt64(drStudentAddmissionInfo["StudentID"]);
                objStudentAddmissionInfo.StudentRollNo       = Convert.ToString(drStudentAddmissionInfo["StudentRollNo"]);
                objStudentAddmissionInfo.AdmissionProgram    = Convert.ToInt64(drStudentAddmissionInfo["AdmissionProgram"]);
                objStudentAddmissionInfo.AddmissionDegree    = Convert.ToInt64(drStudentAddmissionInfo["AddmissionDegree"]);
                objStudentAddmissionInfo.EducationSystem     = Convert.ToString(drStudentAddmissionInfo["EducationSystem"]);
                objStudentAddmissionInfo.StudentSessionID    = Convert.ToInt64(drStudentAddmissionInfo["StudentSessionID"]);
                objStudentAddmissionInfo.IsEnabled           = Convert.ToBoolean(drStudentAddmissionInfo["IsEnabled"]);
                objStudentAddmissionInfo.StudentSection      = Convert.ToInt64(drStudentAddmissionInfo["StudentSection"]);
                objStudentAddmissionInfo.AddByID             = Convert.ToInt64(drStudentAddmissionInfo["AddByID"]);
                objStudentAddmissionInfo.AddByDateTime       = Convert.ToDateTime(drStudentAddmissionInfo["AddByDateTime"]);
                objStudentAddmissionInfo.LastUpdateID        = Convert.ToInt64(drStudentAddmissionInfo["LastUpdateID"]);
                objStudentAddmissionInfo.LastUpdateDateTime  = Convert.ToDateTime(drStudentAddmissionInfo["LastUpdateDateTime"]);

                return(objStudentAddmissionInfo);
            }
            return(null);
        }
        catch (Exception ex)
        {
            SetError(ex.Message);
            return(null);
        } //end try
    }     //end function
Example #2
0
        private void StudentAdmissionInfoInsertUpdate(Int64 student_Id = 0)
        {
            StudentAddmissionInfo studentAddmissionInfo = new StudentAddmissionInfo();

            studentAddmissionInfo.StudentAddmissionID = 0;
            studentAddmissionInfo.StudentID           = student_Id;
            studentAddmissionInfo.StudentRollNo       = txtStudentRollNumber.Text;
            studentAddmissionInfo.AdmissionProgram    = Convert.ToInt64(cmbStudentAdmissionProgram.SelectedValue);
            studentAddmissionInfo.AddmissionDegree    = Convert.ToInt64(cmbStudentAdmissionDegree.SelectedValue);
            studentAddmissionInfo.EducationSystem     = cmbEducationSystem.Text;
            studentAddmissionInfo.StudentSessionID    = Convert.ToInt64(cmbStudentSession.SelectedValue);
            studentAddmissionInfo.IsEnabled           = true;
            studentAddmissionInfo.StudentSection      = Convert.ToInt64(cmbStudentSection.SelectedValue);
            studentAddmissionInfo.AddByID             = Convert.ToInt64(this.Tag);
            studentAddmissionInfo.AddByDateTime       = System.DateTime.Now;
            studentAddmissionInfo.LastUpdateID        = Convert.ToInt64(this.Tag);
            studentAddmissionInfo.LastUpdateDateTime  = System.DateTime.Now;
            StudentAddmissionInfoController.InsertUpdateStudentAddmissionInfo(studentAddmissionInfo);
        }
    ///////////////////////////////////////////////////////////////////////////////////////////

    //Private Methods///////////////////////////////////////////////////////////////////////////

    //DB to Model//
    private void GenerateModelList()
    {
        StudentAddmissionInfoList.Clear();
        foreach (DataRow drStudentAddmissionInfo in dsStudentAddmissionInfo.Tables[0].Rows)
        {
            StudentAddmissionInfo objStudentAddmissionInfo = new StudentAddmissionInfo();
            objStudentAddmissionInfo.StudentAddmissionID = Convert.ToInt64(drStudentAddmissionInfo["StudentAddmissionID"]);
            objStudentAddmissionInfo.StudentID           = Convert.ToInt64(drStudentAddmissionInfo["StudentID"]);
            objStudentAddmissionInfo.StudentRollNo       = Convert.ToString(drStudentAddmissionInfo["StudentRollNo"]);
            objStudentAddmissionInfo.AdmissionProgram    = Convert.ToInt64(drStudentAddmissionInfo["AdmissionProgram"]);
            objStudentAddmissionInfo.AddmissionDegree    = Convert.ToInt64(drStudentAddmissionInfo["AddmissionDegree"]);
            objStudentAddmissionInfo.EducationSystem     = Convert.ToString(drStudentAddmissionInfo["EducationSystem"]);
            objStudentAddmissionInfo.StudentSessionID    = Convert.ToInt64(drStudentAddmissionInfo["StudentSessionID"]);
            objStudentAddmissionInfo.IsEnabled           = Convert.ToBoolean(drStudentAddmissionInfo["IsEnabled"]);
            objStudentAddmissionInfo.StudentSection      = Convert.ToInt64(drStudentAddmissionInfo["StudentSection"]);
            objStudentAddmissionInfo.AddByID             = Convert.ToInt64(drStudentAddmissionInfo["AddByID"]);
            objStudentAddmissionInfo.AddByDateTime       = Convert.ToDateTime(drStudentAddmissionInfo["AddByDateTime"]);
            objStudentAddmissionInfo.LastUpdateID        = Convert.ToInt64(drStudentAddmissionInfo["LastUpdateID"]);
            objStudentAddmissionInfo.LastUpdateDateTime  = Convert.ToDateTime(drStudentAddmissionInfo["LastUpdateDateTime"]);

            StudentAddmissionInfoList.Add(objStudentAddmissionInfo);
        }
    }
    public static Int64 InsertUpdateStudentAddmissionInfo(StudentAddmissionInfo objIUStudentAddmissionInfo)
    {
        Int64 new_id = objIUStudentAddmissionInfo.InsertUpdateStudentAddmissionInfo();

        return(new_id);
    }