using System;
using System.Collections.Generic;
using System.Linq;
using BWPMModels;
using BlazorApp.Helper;
using Newtonsoft.Json;
using System.Data;
using Microsoft.AspNetCore.Mvc;

namespace BlazorApp.Controller

{

    public class AnsprechpartnerController : ControllerBase
    {
        public static List<Ansprechpartner> GetAllData()
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabledata("Select * from Ansprechpartner", false, true);
            return dbh.ConvertDataTable<Ansprechpartner>(dbh.dsdaten.Tables[0]);
        }

        public static List<ViewAnsprechpartner> GetAllAktivData()
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabledata("SELECT ID, FirmaID, name + ' ' + vorname AS Ansprechpartner FROM dbo.Ansprechpartner WHERE aktiv = 1 ORDER BY Ansprechpartner", false, true);
            return dbh.ConvertDataTable<ViewAnsprechpartner>(dbh.dsdaten.Tables[0]);
        }
        public static List<Ansprechpartner> GetByID(int ID)
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabledata("Select * from Ansprechpartner where id=" + ID.ToString(), false, true);
            return dbh.ConvertDataTable<Ansprechpartner>(dbh.dsdaten.Tables[0]);
        }
        public static List<Ansprechpartner> GetByFirmaID(int ID)
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabledata("Select * from Ansprechpartner where aktiv=1 and firmaid=" + ID.ToString(), false, true);
            return dbh.ConvertDataTable<Ansprechpartner>(dbh.dsdaten.Tables[0]);
        }

        public static List<Ansprechpartner> GetAllAktivDataByFirmaID(int firmaid)
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabledata("SELECT * from Ansprechpartner WHERE aktiv = 1 and firmaid=" + firmaid.ToString() + " ORDER BY Name, Vorname", false, true);
            return dbh.ConvertDataTable<Ansprechpartner>(dbh.dsdaten.Tables[0]);
        }


        public static List<Ansprechpartner> GetLast()
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabledata("Select top 1 * from Ansprechpartner order by mutiert_am desc", false, true);
            return dbh.ConvertDataTable<Ansprechpartner>(dbh.dsdaten.Tables[0]);
        }
        public static List<Ansprechpartner> GetLastByMutierer(string Mutierer)
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabledata("Select top 1 * from Ansprechpartner where mutierer='" + Mutierer + "' order by mutiert_am desc", false, true);
            return dbh.ConvertDataTable<Ansprechpartner>(dbh.dsdaten.Tables[0]);
        }

        public static List<Ansprechpartner> GetbyUserSQL(string SQL)
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabledata(SQL, false, true);
            return dbh.ConvertDataTable<Ansprechpartner>(dbh.dsdaten.Tables[0]);
        }

        public static int POST(Ansprechpartner Ansprechpartnerdata)
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabeldata_for_Update("Select top 1 * from [Ansprechpartner] where id=-1", false, true);
            DataRow dr = dbh.dsdaten.Tables[0].NewRow();
            Ansprechpartnerdata.GetType().GetProperties().ToList().ForEach(f =>
            {
                try
                {
                    if (f.PropertyType == typeof(DateTime))
                    {
                        dr[f.Name] = (DateTime)f.GetValue(Ansprechpartnerdata, null);

                    }
                    else
                    {
                        dr[f.Name] = f.GetValue(Ansprechpartnerdata, null);
                    }
                }
                catch (Exception ex) { string s = ex.Message; }
            });
            dbh.dsdaten.Tables[0].Rows.Add(dr);
            dbh.Update_Tabeldata();
            List<Ansprechpartner> tmplst = GetLastByMutierer(Ansprechpartnerdata.mutierer);
            return tmplst.First<Ansprechpartner>().ID;
        }

        public static void PUT(Ansprechpartner Ansprechpartnerdata)
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabeldata_for_Update("Select top 1 * from [Ansprechpartner] where id=" + Ansprechpartnerdata.ID.ToString(), false, true);
            DataRow dr = dbh.dsdaten.Tables[0].Rows[0];
            Ansprechpartnerdata.GetType().GetProperties().ToList().ForEach(f =>
            {
                try
                {
                    if (f.PropertyType == typeof(DateTime))
                    {
                        dr[f.Name] = (DateTime)f.GetValue(Ansprechpartnerdata, null);
                    }
                    else
                    {
                        dr[f.Name] = f.GetValue(Ansprechpartnerdata, null);
                    }
                }
                catch (Exception ex) { string s = ex.Message; }
            });
            dbh.Update_Tabeldata();

        }

        public static void DELETE(Ansprechpartner Ansprechpartnerdata)
        {
            dbhelper dbh = new dbhelper();
            dbh.Get_Tabeldata_for_Update("delete from [Ansprechpartner] where id=" + Ansprechpartnerdata.ID.ToString(), false, true);
        }
    }

    public class ViewAnsprechpartner
    {

    }



}