C#

UInt16

ushort DATA_TYPE = (ushort)row.Field<UInt16> ( "DATA_TYPE" );

public async Task<CompanyEntity> GetCompany(int id)
{
    using (var db = new JayhawkDB())
    {
        CompanyEntity results = null;

        try
        {
            var query = from x in db.Companies
                        where x.Id == id
                        select x;

            var record = query.FirstOrDefault<Company>();

            results = new CompanyEntity
            {
                Id = record.Id,
                CreatedById = record.CreatedById,
                CreatedDT = record.CreatedDt,
                DeletedById = record.DeletedById.GetValueOrDefault(),
                DeletedDT = record.DeletedDt.GetValueOrDefault(),
                CompanyName = record.CompanyName,
                Abbreviation = record.Abbreviation,
                Notes = record.Notes
            };
        }
        catch (Exception e)
        {
            throw;
        }

        return results;
    }
}

List<Key> PressedKeys = new List<Key>();

private void Window_KeyDown(object sender, KeyEventArgs e)
{
    //If key is pressed this stop resending
    if (!PressedKeys.Contains(e.Key))
    {
        PressedKeys.Add(e.Key);
        txtKeysDown.Text = String.Join(", ", PressedKeys);
    }

}

private void Window_KeyUp(object sender, KeyEventArgs e)
{
    PressedKeys.Remove(e.Key);
    txtKeysDown.Text = String.Join(", ", PressedKeys);
}

[DllImport("user32.dll", EntryPoint = "GetKeyboardState", SetLastError = true)]
private static extern bool NativeGetKeyboardState([Out] byte[] keyStates);

        private static bool GetKeyboardState(byte[] keyStates)
        {
            if (keyStates == null)
                throw new ArgumentNullException("keyState");
            if (keyStates.Length != 256)
                throw new ArgumentException("The buffer must be 256 bytes long.", "keyState");
            return NativeGetKeyboardState(keyStates);
        }

        private static byte[] GetKeyboardState()
        {
            byte[] keyStates = new byte[256];
            if (!GetKeyboardState(keyStates))
                throw new Win32Exception(Marshal.GetLastWin32Error());
            return keyStates;
        }

        private static bool AnyKeyPressed()
        {
            byte[] keyState = GetKeyboardState();
            // skip the mouse buttons
            return keyState.Skip(8).Any(state => (state & 0x80) != 0);
        }
    }

bool MyIsKeyDown(Key key)
{

    return (((byte)GetKeyboardState()[(int)key] & 0x80) & 0x80)>0;
}

private void Window_KeyDown(object sender, KeyEventArgs e)
{

    foreach (Key item in Enum.GetValues(typeof(Key)))
    {
        if (MyIsKeyDown(item))
        {
            if (!PressedKeys.Contains(e.Key))
            {
                PressedKeys.Add(e.Key);
                txtKeysDown.Text = String.Join(", ", PressedKeys);
            }
        }
    }

    ////If key is pressed this stop resending
    //if (!PressedKeys.Contains(e.Key))
    //{
    //    PressedKeys.Add(e.Key);
    //    txtKeysDown.Text = String.Join(", ", PressedKeys);
    //}

}

private void DoGraph(string Title)
        {

            string ConString = CString;
            string CmdString = string.Empty;
            using (SqlConnection con = new SqlConnection(ConString))
            {
                dataGridViewYears.DataSource = null;


                CmdString = " SELECT *" +
                " FROM(" +
                    " SELECT" +
                        " year(Date) as [year], left(datename(month, date), 3) as [month]," +
                        " SalesCatRoom as YearSales" +
                    " FROM tblBudgetMaster" +
                    " WHERE DATEPART(yy, date) >= 2015 AND DATEPART(yy, date) <= 2017" +
                " ) as s" +
                " PIVOT" +
                " (" +
                    " SUM(YearSales)" +
                    " FOR[month] IN(jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec)" +
                " )AS pvt";


                SqlCommand cmd = new SqlCommand(CmdString, con);
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable("Years");
                
                dt.Dispose();

                sda.Fill(dt);
                dataGridViewYears.DataSource = dt.DefaultView;
                dataGridViewYears.AutoResizeColumns();
                
                
                con.Close();
                chart1.Titles.Clear();
                                            
                ChartArea chartArea1 = new ChartArea();
                chartArea1.AxisX.MajorGrid.LineColor = Color.LightGray;
                chartArea1.AxisY.MajorGrid.LineColor = Color.LightGray;
               
                chartArea1.AxisX.LabelStyle.Font = new Font("Arial", 8);
                chartArea1.AxisY.LabelStyle.Font = new Font("Arial", 8);
                chart1.ChartAreas.Add(chartArea1);



                chart1.Series.Add(new Series());



                chart1.Series[0].XValueMember = dataGridViewYears.Columns[0].DataPropertyName;
                chart1.Series[1].XValueMember = dataGridViewYears.Columns[0].DataPropertyName;
                chart1.Series[0].YValueMembers = dataGridViewYears.Columns[2].DataPropertyName;
                chart1.Series[1].YValueMembers = dataGridViewYears.Columns[3].DataPropertyName;
                chart1.DataSource = dataGridViewYears.DataSource;

               
                chart1.Series[0].Name = "Budget";
                chart1.Series[1].Name = "Actual";
                chart1.Series[0].Label ="#VALY"; //"Y = #VALY\nX = #VALX";
                chart1.Series[0].SmartLabelStyle.Enabled = true;
                chart1.Series[1].Label = "#VALY"; //"Y = #VALY\nX = #VALX";
                chart1.Series[1].SmartLabelStyle.Enabled = true;
                 chart1.Size = new Size(1000, 450);
                chart1.Titles.Add(Title);
                chartArea1.Position.Height = 80;
            }
        }
    }