#include "fearmonger.h"
 
#include <CtrlLib/CtrlLib.h>
 
using namespace Upp;

struct DateIntConvertCls : Convert {
    virtual Value Format(const Value& q) const;
    virtual Value Scan(const Value& text) const;
    virtual int Filter(int chr) const;
};
 
Value DateIntConvertCls::Format(const Value& q) const
{
    return IsNull(q) ? String() : ::Format(Date(1970, 1, 1) + (int)q);
}
 
Value DateIntConvertCls::Scan(const Value& text) const
{
    String txt = text;
    if(IsNull(txt))
        return Null;
    Date d;
    if(StrToDate(d, txt))
        return d - Date(1970, 1, 1);
    return ErrorValue("Invalid date!");
}
 
int DateIntConvertCls::Filter(int chr) const
{
    return CharFilterDate(chr);
}
 
Convert& DateIntConvert()
{
    return Single<DateIntConvertCls>();
}
struct WinDlg : public WithWin10Layout<TopWindow>  {
    Button button;
    SqlCtrls ctrls;
    EditInt myid;
    EditDate mydate;
    EditString myloc;
   
    typedef WinDlg CLASSNAME;
   
    void exec4() {
    SqlBool where;
    SqlBool where2;
    WinDlg dlg;
   
 // SQL * Select(dlg.ctrls).From(SCHEDULE).Where(ID == 3);
    disturbed.Query();
   
 }
   
    WinDlg() {
        
    CtrlLayout(*this, "computer");
    
    Title("My application with menu").Sizeable();
       
    Add(button.LeftPos(10, 100).TopPos(10, 30));  
	disturbed.SetTable(SCHEDULE);
    disturbed.AddKey(ID);
    disturbed.AddColumn(ID,"ID").Edit(myid);
    disturbed.AddColumn(LOCATION,"loc").Edit(myloc);
    disturbed.AddColumn(START_DATE, "START_DATE").SetConvert(DateIntConvert());   
    disturbed.Appending().Inserting().Removing();
    button <<= THISBACK(exec4);
    }  
  };
    
void Cyborg::SqArray(){
	
  WinDlg dlg;
  dlg.Run();
 //  menu.Set(THISBACK(WinDlg());  

	
}