ASP.NET

Hi All,

Please provide source code in MVC to display 3 Tabs and display the details in each tab.
For example I need like Emp, Dept, Mgr details. If I click on Emp Tab then Employee details should display, similarly Dept details should display after clicking 
on Dept Tab and Manager details should display on click on Mgr tab. All details should display from database.

Please suggest.

Thanks,
SagarPallavi

<pre><script>


    //Jquery
    $(function () {
        CriarEventosCalendario();
    });

    //function CriarEventosCalendario() {
    function CriarEventosCalendario() {
    var events = @Json.Serialize(ViewBag.ListaEventos);
        //var events = [];


        @{
            foreach(var item in (List<AgendaModel>)ViewBag.ListaEventos)
                   {<text>events.push({
                     'id': @item.Id,
                     'title': '@item.Title',
                     'start': '@item.Start',
                     'end': '@item.End',
                     'allDay': false,
                     'color': '@item.Color',
                     'textColor': '@item.TextColor'
                   });</text>

            }

        }






        var calendarEl = document.getElementById('calendar');

        var calendar = new FullCalendar.Calendar(calendarEl, {
            plugins: ['interaction', 'dayGrid'],
            header: {
                left: 'prevYear,prev,next,nextYear today',
                center: 'title',
                right: 'dayGridMonth, dayGridWeek, dayGridDay'
            },
            eventClick: function () {

            },
            navlinks: true,
            editable: true,
            eventLimit: true,
            selectable: false,

           eventClick: function (evenObj, jsEvent, view) {

                   alert('Event: ' );


            },
          events: events,

        });

        calendar.render();
    }
</script>

static void PDF2Image()
{
    List<string> listOfFiles = new List<string>();
    System.Drawing.Bitmap finalImage = null;
    int pgs = 0;
    System.Drawing.Image img;
    string xFile = string.Empty;
    FileStream stream;

        try
        {
            string path = @"c:\temp\pdf2Image\";
            PdfDocument documemt = new PdfDocument();
            documemt.LoadFromFile(@"c:\temp\pdf2Image\DDDDDD.pdf");
            pgs = documemt.Pages.Count;
            for (int i = 0; i < pgs; i++)
            {
                img = documemt.SaveAsImage(i, 600, 600);
                img.Save(@"c:\temp\pdf2Image\DDDDDD" + "_" + i + ".jpg");

                xFile = @"c:\temp\pdf2Image\DDDDDD" + "_" + i + ".jpg";

                listOfFiles.Add(xFile);

                img.Dispose();
            }
            documemt.Close();
        }
        catch (Exception ex)
        {
            throw;
        }
    Image2Merge(listOfFiles);
}

public static System.Drawing.Bitmap Image2Merge(List<string> listOfFiles)
{
    string imgPath = @"c:\temp\pdf2Image\";
    string imgType = "*.jpg";
    List<System.Drawing.Bitmap> images = new List<System.Drawing.Bitmap>();
    System.Drawing.Bitmap finalImage = null;
    int width = 0;
    int height = 0;

    try
    {
        foreach (string image in Directory.GetFiles(imgPath, imgType))
        {
            System.Drawing.Bitmap bitmap = new System.Drawing.Bitmap(image);

            //update the size of the final bitmap
            width += bitmap.Width;
            height = bitmap.Height > height ? bitmap.Height : height;

            images.Add(bitmap);
        }

        //bitmap canvas to hold the combined image
        finalImage = new System.Drawing.Bitmap(5000, height);

        using (System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(finalImage))
        {
            //go through each image and draw it on the final image
            int offset = 0;
            foreach (System.Drawing.Bitmap image in images)
            {
                image.SetResolution(72, 72);
                g.DrawImage(image, new System.Drawing.Rectangle(offset, 0, image.Width, image.Height));
                offset += image.Width;

                image.Dispose();
            }
        }
        return finalImage;
    }
    catch (Exception ex)
    {
        if (finalImage != null)
            finalImage.Dispose();
        throw;
    }
    finally
    {
        finalImage.Save(@"c:\temp\pdf2Image\DDDDDD.jpg", ImageFormat.Jpeg);
        foreach (string xFile in listOfFiles)
        {
            //if (File.Exists(xFile))  File.Delete(xFile);
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.Data.SqlClient;
using Microsoft.JSInterop.Infrastructure;
using Microsoft.AspNetCore.Hosting.Server;
using System.Threading.Tasks;


namespace AirHeaterControlSystem.Models
{
    public class Measurement
    {
        public string Timestamp { get; set;}
        public string MeasurementValue { get; set; }
        public string ControlValue { get; set; }

        public List<Measurement> GetMeasurementParameters()
        {
            List<Measurement> measurmentParameterList = new List<Measurement>();
            string connectionString = "DATA SOURCE=LAPTOP-1T8PALVT\\CITADEL;UID=LAPTOP-1T8PALVT\\AdisP;DATABASE=MEASUREMENTDATA;Integrated Security = True;" ;
            SqlConnection con = new SqlConnection(connectionString);
            string sqlQuery = "Select Timestamp,MeasurementValue,ControlValue from MEASUREMENTDATA";
            con.Open();

            SqlCommand cmd = new SqlCommand(sqlQuery, con);

            SqlDataReader dr = cmd.ExecuteReader();

            if (dr != null)
            {
                while (dr.Read())
                {
                    /*Measurement ChartValues = new Measurement();
                    ChartValues.ChartYvalue= Convert.ToDouble(dr[])*/

                    
                    Measurement measurementParameter = new Measurement();
                    
                    measurementParameter.Timestamp = dr["TimeStamp"].ToString();

                    measurementParameter.MeasurementValue = dr["MeasurementValue"].ToString();
                    measurementParameter.ControlValue = dr["ControlValue"].ToString();

                    measurmentParameterList.Add(measurementParameter);                  

                }
            }

            return measurmentParameterList;       
        }

    }
}

@page
@model AirHeaterControlSystem.Pages.MeasurementModel
@{
    ViewData["Title"] = "Measurement Parameters";


}
<div>

    <h1> Airheater temperature measurement</h1>

    <table class="table">
        <thead>
            <tr>
                <th>Timestamp</th>
                <th>MeasurementValue</th>
                <th>ControlValue</th>
            </tr>
        </thead>
        <tbody>
            @foreach (var measurement in Model.measurmentParameterList)
            {
                <tr>
                    <td> "measurement.Timestamp</td>
                    <td> "measurement.MeasurementValue</td>
                    <td> "measurement.ControlValue</td>

                </tr>

            }
        </tbody>

    </table>
</div>

public class City
{
        public int Id { get; set; }        
        public string CityName { get; set; }
        public virtual List<Zone> Zones { get; set; } = new List<Zone>();
}

public class Zone
 {
        public int Id { get; set; }
        public string ZoneName { get; set; }

        public int CityId { get; set; }
        public virtual City City { get; set; }
}

public class SettingsModel
    {
        public City NewCity { get; set; }
        public List<City> CurrentCities { get; set; }
    }

<form method="post" action="/Administration/UpdateCity">
...
<input type="hidden" id="CurrentCities_0__Id" name="CurrentCities[0].Id" value="7">
<input type="text"  id="CurrentCities_0__CityName" name="CurrentCities[0].CityName" value="Austin">
...
</form>
...
<form method="post" action="/Administration/UpdateCity">
...
<input type="hidden" id="CurrentCities_1__Id" name="CurrentCities[1].Id" value="4">
<input type="text"  id="CurrentCities_1__CityName" name="CurrentCities[1].CityName" value="Dallas">
...
</form>

public IActionResult UpdateCity([Bind(Prefix = "CurrentCities")]List<City> myCity) 
{
...
}

<input type="text" id="CurrentCities_0__Zones_0__ZoneName" name="CurrentCities[0].Zones[0].ZoneName" value="Austin Metro Area">
...
<input type="text" id="CurrentCities_1__Zones_0__ZoneName" name="CurrentCities[1].Zones[0].ZoneName" value="San Antonio Metro Area">