public ScholarshipEstduentLoan getEScholarshipLoan(string stdId, string schCode, string AcadmicYear, string Semester)
    {
        ScholarshipEstduentLoan scholarshipData = new ScholarshipEstduentLoan();

        ConnectDB     db        = new ConnectDB();
        SqlDataSource oracleObj = db.ConnectionOracle();

        oracleObj.SelectCommand = "SELECT * FROM SCHOLARSHIP_ESTUDENT_LOAN WHERE STUDENT_ID = '" + stdId + "' AND SCHOLARSHIP_CODE = '" + schCode + "' AND ACADEMIC_YEAR = '" + AcadmicYear + "' AND SEMESTER = '" + Semester + "'";

        DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);

        foreach (DataRowView rowData in allData)
        {
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_STUDENT_ID          = rowData["STUDENT_ID"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_NATION_ID           = rowData["NATION_ID"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_CONTRACT_NUMBER     = rowData["CONTRACT_NUMBER"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_CONFIRMATION_NUMBER = rowData["CONFIRMATION_NUMBER"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_DATE_APPROVE        = rowData["DATE_APPROVE"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_STUDY          = rowData["LOAN_STUDY"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_ETC            = rowData["LOAN_ETC"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_LIVE           = rowData["LOAN_LIVE"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_TOTAL          = rowData["LOAN_TOTAL"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_SCHOLARSHIP_CODE    = rowData["SCHOLARSHIP_CODE"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_STUDY_YEAR          = rowData["STUDY_YEAR"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_ACADEMIC_YEAR       = rowData["ACADEMIC_YEAR"].ToString();
            scholarshipData.SCHOLARSHIP_ESTUDENT_LOAN_SEMESTER            = rowData["SEMESTER"].ToString();
        }

        return(scholarshipData);
    }
    public string updateEScholarshipLoan(ScholarshipEstduentLoan dataInsert, string schCode, string AcadmicYear, string Semester)
    {
        string response = "";

        UserLoginData loginData = new UserLoginData();

        loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
        LogData log_data = new LogData();

        log_data.ModuleCode = new LogData().Module_Scholarship;
        log_data.Username   = loginData.User_ID;
        log_data.Message    = "Update ScholarshipEstduentLoan with: " + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_STUDENT_ID + ", " + schCode + ", " + AcadmicYear + ", " + Semester;

        ConnectDB     db        = new ConnectDB();
        SqlDataSource oracleObj = db.ConnectionOracle();

        string sql = "Update SCHOLARSHIP_ESTUDENT_LOAN Set CONTRACT_NUMBER = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_CONTRACT_NUMBER +
                     "',CONFIRMATION_NUMBER = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_CONFIRMATION_NUMBER +
                     "',DATE_APPROVE = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_DATE_APPROVE +
                     "',LOAN_STUDY = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_STUDY +
                     "',LOAN_ETC = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_ETC +
                     "',LOAN_LIVE = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_LIVE +
                     "',LOAN_TOTAL = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_TOTAL +
                     "',SCHOLARSHIP_CODE = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_SCHOLARSHIP_CODE +
                     "',STUDY_YEAR = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_STUDY_YEAR +
                     "',ACADEMIC_YEAR = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_ACADEMIC_YEAR +
                     "',SEMESTER = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_SEMESTER +
                     "'Where STUDENT_ID = '" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_STUDENT_ID +
                     "' AND SCHOLARSHIP_CODE = '" + schCode +
                     "' AND ACADEMIC_YEAR = '" + AcadmicYear +
                     "' AND SEMESTER = '" + Semester + "'";

        oracleObj.UpdateCommand = sql;

        try
        {
            if (oracleObj.Update() == 1)
            {
                response            = "OK";
                log_data.StatusCode = log_data.LogStatus_SUCCESS;
            }
            else
            {
                log_data.StatusCode = log_data.LogStatus_FAILED;
            }
        }
        catch (Exception e)
        {
            response            = e.Message.ToString() + " ";
            log_data.StatusCode = log_data.LogStatus_ERROR;
            log_data.Message   += " [" + e.ToString() + "]";
        }

        new Log().WriteLog(log_data);
        return(response);
    }
    public string insertEScholarshipLoan(ScholarshipEstduentLoan dataInsert)
    {
        string response = "";

        UserLoginData loginData = new UserLoginData();

        loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
        LogData log_data = new LogData();

        log_data.ModuleCode = new LogData().Module_Scholarship;
        log_data.Username   = loginData.User_ID;
        log_data.Message    = "Insert ScholarshipEstduentLoan with: " + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_STUDENT_ID + ", " + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_SCHOLARSHIP_CODE;

        ConnectDB     db        = new ConnectDB();
        SqlDataSource oracleObj = db.ConnectionOracle();

        string sql = "";

        sql = "Insert Into SCHOLARSHIP_ESTUDENT_LOAN(STUDENT_ID, NATION_ID, CONTRACT_NUMBER, CONFIRMATION_NUMBER, DATE_APPROVE, LOAN_STUDY, LOAN_ETC, LOAN_LIVE, LOAN_TOTAL, SCHOLARSHIP_CODE, STUDY_YEAR, ACADEMIC_YEAR, SEMESTER) Values('" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_STUDENT_ID + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_NATION_ID + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_CONTRACT_NUMBER + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_CONFIRMATION_NUMBER + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_DATE_APPROVE + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_STUDY + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_ETC + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_LIVE + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_LOAN_TOTAL + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_SCHOLARSHIP_CODE + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_STUDY_YEAR + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_ACADEMIC_YEAR + "','" + dataInsert.SCHOLARSHIP_ESTUDENT_LOAN_SEMESTER + "')";

        oracleObj.InsertCommand = sql;

        try
        {
            if (oracleObj.Insert() == 1)
            {
                response            = "OK";
                log_data.StatusCode = log_data.LogStatus_SUCCESS;
            }
            else
            {
                log_data.StatusCode = log_data.LogStatus_FAILED;
            }
        }
        catch (Exception e)
        {
            response            = e.Message.ToString() + " ";
            log_data.StatusCode = log_data.LogStatus_ERROR;
            log_data.Message   += " [" + e.ToString() + "]";
        }

        new Log().WriteLog(log_data);
        return(response);
    }