Category: MVC

This is Proof of Concept for Querying data using AJAX and filling the drop down list from a oracle database using DB procedures. Model : public class listmodel     {         public string txtdesc{ get; set; }         public string txtval { get; set; } } Controller public JsonResult get_crn_term(string term)         {             var crnlist = functions.getCRN(term) as List<listmodel>;             return Json(crnlist, JsonRequestBehavior.AllowGet);         } Function to Call the Oracle procedure which has the data:   public static List<listmodel> getCRN(string term_code)         {             var p = new OracleDynamicParameters();             p.Add(“p_term”, term_code);             p.Add(“p_crn”, dbType: OracleDbType.RefCursor, direction: ParameterDirection.Output);             var crnlist = new List<listmodel>();             using (SqlMapper.GridReader gr = DB.GetMultiGrid(“procedure.p_get_term_crn”, p))             {                 crnlist = gr.Read<listmodel>().ToList<listmodel>();             }             return crnlist;         } AJAX Script in View   < script > function get_crn_data(data) {         $.ajax({             type: “POST”,             url: “get_crn_term”,             dataType: “json”,             data: “{ term: ‘” + data.value+ “‘}”,             contentType: “application/json; charset=utf-8”,             success: function (data) {                 $(“.crn”).empty();                 var optionhtml1 = ‘<option value=”‘ +                  0 + ‘”>’ + “–Select State–” + ‘</option>’;                 $(“.crn”).append(optionhtml1);                 $.each(data, function (i) {                     var optionhtml = ‘<option value=”‘ +                 data[i].txtval+ ‘”>’ +data[i].txtdesc+ ‘</option>’;                     $(“.crn”).append(optionhtml);                 }); […]

» Read more

Please refer my tutorials for Creating first oracle database using Developer tools without writing any codes. Just Download Oracle Devloper Tools and start Creating Database in minutes Read Entire tutorial with step by step instructions including video. Create Edit/ Delete / Update / View Controllers from Oracle Database without any codes just using entity frame work, Read Entire Tutorial including step by step instruction and Video    .

» Read more

Task : Connect to oracle DB using ODP.net and generate forms using Entity Frame Work without any coding. Pre Requisites : Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio  http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html Microsoft Visual Studio 2013 Oracle Database Instance Credentials. Entity Framework 6 Tools for Visual Studio 2012 & 2013 (http://www.microsoft.com/en-us/download/details.aspx?id=40762) Oracle Database with Required Tables Employee and Department ( Refer Part 1 of This tutorial) Complete Video Tutorial        Right Click Models –> Add –> Select ADO.net entity data model Enter name like “EmployeeModel” and press OK Click New Connection Please note if you cant find Oracle database ODP.net managed Driver , then please install ODP.net driver from following link before you proceed further. http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html   Now before you proceed further please build solution to make sure all is WELL upto this stage. If you can see above image means then your configuration for ODP.net is fine . Now stop the instance using Shift+F5 and go ahead with adding Controllers Now Add the two controllers (Employee and Departments) using Entity frame work     Follow the above same procedure and create another model for department.   Now open Layout.cshtml from the view/shared folder and add […]

» Read more

Pre Requisites: Oracle SQL Developer Oracle Database Instance Login Details Complete Video Tutorial Step 1: Install Oracle SQL Developer http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Please note that in order to install Developer Tool you must have JDK 7 or above in your PC. If you do not have please download JDK from following link prior to downloading to SQL Developer tool. http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html   Step 2: Please make sure you have following details of Oracle DB is handy with you. Hostname : Username : Password : Service Name : Port No : Step 3 : Extract the Downloaded SQL Developer tools to a folder and open the file SQL Developer       This will Open Developer Now Import Data Dictionary as shown Enter the Oracle DB Details Select Schema Dont select any DB Tables as we are going to create new Tables     Now click Insert Table. Drag workspace to new table , enter table Name it as Employee and Click OK Now Create Columns as Shown Similarly create second table : department   Now Create Foreign Key as shown to link Department Id from Employee table to Department Table Please note that Developer tool will not create the table automatically. We need […]

» Read more