public void Setup()
{
_dbm = new DbManagement(true);
_dbm.DetachAllDbs();
_unitUnderTest = (Db)_dbm.CreateDb(DbRootDir, TestDbName);
_unitUnderTest.DeleteAllMeasurements();
}
public static KendoSiteInputMapping GetAllSite()
{
// AddUpdateSiteAsync("https://acpol2.army.mil/vacancy/vacancy_list.asp", 24);
var siteElems = DbManagement.SiteAllRow();
return(new KendoSiteInputMapping(siteElems.ToList()));
}
public void Deserialize()
{
_unitUnderTest.CreateDb(DbRootDir, TestDbName);
var secondManagement = new DbManagement(true);
secondManagement.GetDbNames().Count.Should().Be(1);
}
public void MultipleAbsoluteHumidityTableGroups()
{
var db = new DbManagement().GetDb("f*x");
var result =
db.GetTable <float>("Innen.(?<g>.*).(?<k>Temperatur|Feuchtigkeit)$", "time > now() - 1M")
.Transform(g => g.Group(i => i.ByTime.Hours(1).ExpandTimeRangeByFactor(7).Aggregate(o => o.Mean())))
.GroupSeries().Transform(t => t.AbsoluteHumidity("Temperatur", "Feuchtigkeit")).MergeTables();
}
public void DewPointTest()
{
var db = new DbManagement().GetDb("f*x");
var queryTable = db.GetTable <float>("Aussen.Wetterstation.(?<k>.*?)$", "time > now() - 1y");
var result = queryTable
.Transform(i => i.GroupByHours(1, o => o.Mean()))
.DewPoint("Temperatur", "Feuchtigkeit", "Taupunkt");
}
public void MultipleTableGroups()
{
var db = new DbManagement().GetDb("f*x");
var queryTable = db.GetTable <float>("Innen.(?<g>.*).(?<k>Temperatur|Feuchtigkeit)$", "time > now() - 1M");
var result = queryTable
.Transform(i => i.GroupByHours(1, o => o.Mean()))
.ZipToNew("Sum", t => t.Temperatur + t.Feuchtigkeit);
}
private void btn_LoadData_Click(object sender, RoutedEventArgs e)
{
var db = new DbManagement();
string sdate = start_date.SelectedDate.Value.ToShortDateString();
string edate = end_date.SelectedDate.Value.ToShortDateString();
grid_History_stock.ItemsSource = db.GetDataHistoryStock(sdate, edate).DefaultView;
}
//update stock quantity
private void updateStockQuant()
{
var db = new DbManagement();
for (int i = 0; i < db.searchCart(txt_transaction.Text).Rows.Count; i++)
{
db.UpdateQuantStock(db.searchCart(txt_transaction.Text).Rows[i][2].ToString(), Convert.ToInt32(db.searchCart(txt_transaction.Text).Rows[i][4].ToString()));
}
}
public void DynamicTableInScript()
{
var db = new DbManagement().GetDb("f*x");
var result =
new ScriptingEngine(db,
@"db.GetTable<float>(""Aussen.Wetterstation.(?<k>[TF]).*?$"", ""time > now() - 1M"")
.Transform(i => i.GroupByHours(1, o => o.Mean()))
.ZipAndAdd(""Sum"", t => t.T + t.F)").Execute();
}
public void AddAliasesTest()
{
var dbm = new DbManagement();
var db = dbm.GetDb("Haus");
var sw = Stopwatch.StartNew();
db.AddAliasToMeasurements("OpenHAB.out.(.*).state", "$1");
sw.Stop();
}
private void DoWork(object state)
{
if (lastDay != DateTime.Now.Day)
{
lastDay = DateTime.Now.Day;
lottoData.downloadAllLotto();
DbManagement.DsSiteLoad();
}
PingMe();//if i don't do it the sise go down
}
// POST api/values
public void Post(User user)
{
try
{
DbManagement.InsertNewUser(user);
}
catch (Exception)
{
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occurred"));
}
}
public void RecreateFuxDb()
{
var dbm = new DbManagement();
var dbName = "f*x";
if (dbm.GetDbNames().Contains(dbName))
{
dbm.DeleteDb(dbName);
}
dbm.CreateDb(@"c:\DBs\SharpTsdb", dbName);
}
public void AllMeasurementNamesTest()
{
var dbm = new DbManagement();
var db = dbm.GetDb("Haus");
var sw = Stopwatch.StartNew();
var measurements = db.GetMeasurements(".*");
var names = measurements.SelectMany(i => i.NameAndAliases).OrderBy(i => i).ToList();
var nameString = string.Join("\r\n", names);
var measurement = db.GetMeasurement("HmWetterstationSunshineduration");
sw.Stop();
}
public void GetMeasurementsTest()
{
var dbm = new DbManagement();
var db = dbm.GetDb("Haus");
var sw = Stopwatch.StartNew();
for (int i = 0; i < 100; i++)
{
var ms = db.GetMeasurements("a");
}
sw.Stop();
}
public void FixFromTo()
{
var dbm = new DbManagement();
var db = dbm.GetDb("f*x");
var sw = Stopwatch.StartNew();
var mix = db.Collect(db.GetSerie <float>("Aussen.Wetterstation.Temperatur", "time > now() - 2d")
.GroupBy("6h", a => a.Mean()),
db.GetTable <float>(".*Feuchtigkeit", "time > now() - 2d"));
sw.Stop();
}
public void MovingAverage()
{
var db = new DbManagement().GetDb("f*x");
var time = "time < now() - 14d and time > now() - 21d";
var serie = db.GetSerie <float>("Aussen.Wetterstation.Temperatur", time)
.Group(
g =>
g.ByTime.Minutes(10)
.TimeStampIsMiddle()
.ExpandTimeRangeByFactor(20)
.Aggregate(a => a.MeanByTime()));
}
public void MeasurementExistingInSecondInstance()
{
_unitUnderTest.CreateMeasurement(TestMeasName, typeof(float));
var measurement = _unitUnderTest.GetMeasurement(TestMeasName);
var binName = measurement.BinaryFilePath;
var dbm = new DbManagement(true);
var db = dbm.GetDb(TestDbName);
var m = db.GetMeasurement(TestMeasName);
m.BinaryFilePath.Should().Be(binName);
}
public void AllCalcTempValuesTest()
{
var db = new DbManagement().GetDb("f*x");
var queryTable = db.GetTable <float>("Aussen.Wetterstation.(?<k>.*?)$", "time > now() - 1M");
var result = queryTable
.Transform(i => i.GroupByHours(1, o => o.Mean()))
.AddDewPoint("Temperatur", "Feuchtigkeit")
.AddAbsoluteHumidity("Temperatur", "Feuchtigkeit")
.AddHumidex("Temperatur", "Feuchtigkeit")
.AddHeatIndex("Temperatur", "Feuchtigkeit")
.AddSleetLine("Temperatur", "Feuchtigkeit", 440)
.AddSnowLine("Temperatur", "Feuchtigkeit", 440)
.RemoveSerie("Feuchtigkeit");
}
public void DynamicWithRealDb()
{
var db = new DbManagement().GetDb("f*x");
var queryTable = db.GetTable <float>("Aussen.Wetterstation.(?<k>[TF]).*?$", "time > now() - 1M");
var result = queryTable
.Group(g => g.ByTime.Hours(1).Aggregate(o => o.Mean()))
.Calc(t => t.Sum = t.T + t.F);
result.Series.Count().Should().Be(3);
result = result.RemoveDbSeries();
result.Series.Count().Should().Be(1);
}
public static bool AddSite(SiteInputMapping elem)
{
try
{
SiteRow row = DbManagement.DsSiteData_newRow(elem);
DbManagement.LottoDs_addRow(row);
DbManagement.SiteAllRow();
return(true);
}
catch (Exception EX)
{
throw EX;
}
}
public App()
{
diContainer = BuildContainer();
dbManagement = DbManagement.CreateAsSingleton();
logger = diContainer.Resolve <ILogger>();
InitializeComponent();
MainPage = new NavigationPage(new MainPage())
{
BarBackgroundColor = Color.LightGray,
BarTextColor = Color.Black
};
}
private void ListDescrip()
{
var db = new DbManagement();
list_descrption.Items.Clear();
list_discount.Items.Clear();
list_price.Items.Clear();
list_quant.Items.Clear();
for (int i = 0; i < db.getCartProductName(tranId).Rows.Count; i++)
{
list_descrption.Items.Add(db.getCartProductName(tranId).Rows[i][1].ToString());
list_price.Items.Add(db.getCartProductName(tranId).Rows[i][2].ToString());
list_discount.Items.Add(db.getCartProductName(tranId).Rows[i][3].ToString());
list_quant.Items.Add(db.getCartProductName(tranId).Rows[i][4].ToString());
}
}
//login data
private void login()
{
var db = new DbManagement();
//db.checkConnect();
//this.;
db.Login(txt_User_login.Text, HasScrip(txt_password_login.Password));
// MessageBox.Show(db.CheckLogin()+"");
if (db.CheckLogin() == true)
{
// Application.Current.Shutdown();
this.Dispatcher.BeginInvoke(new Action(() => {
this.Close();
}));
}
}
private void btn_restor_data_Click(object sender, RoutedEventArgs e)
{
try
{
var db = new DbManagement();
db.InsertStock(sid, cateId, proId, unit, date, quantity, emid, bal);
db.RemoveHistoryStock(sid);
notify.Title = "Stock Management Form";
notify.Message = "Restore Products Successful...";
notify.ShowNotfySucess();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "");
}
}
private void getPname()
{
try
{
// MessageBox.Show(pId,tranNO);
var db = new DbManagement();
var Pname = db.getSearchProductName(pId).Rows[0][2].ToString();
string p = db.getSearchProductName(pId).Rows[0][7].ToString();
txt_product_name.Text = Pname;
price = Convert.ToDouble(p);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "Not find Product Id");
this.Dispatcher.BeginInvoke((Action)(() => { this.Close(); }));
}
}
private void getImageUser()
{
try
{
var db = new DbManagement();
if (string.IsNullOrEmpty(db.getIconUser()))
{
}
else
{
image_user.Source = new BitmapImage(new Uri(db.getIconUser().ToString()));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.GetType().Name + "");
}
}
private void LoadDatarefresh()
{
try
{
// grid_cart.ItemsSource = "";
DbManagement db = new DbManagement();
if (grid_cart != null)
{
grid_cart.ItemsSource = db.DataCart().DefaultView;
}
//grid_cart.DataContext = db.BrandData().ToList<BrandEntry>();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "Grid");
}
}
private void checkStock()
{
var db = new DbManagement();
int quantStock = db.numnerQutStock(pId);
if (quantStock <= 10)
{
MessageBox.Show("this Product quantity min....");
}
if (quantStock == 0)
{
MessageBox.Show("Not Product in Stock");
}
else
{
SaveOrderCart();
}
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
if (string.IsNullOrEmpty(_therapist.SqlbackupFolder))
{
return;
}
var loaderFrm = new UI.Globals.Loader("Attendere il salvataggio del database");
loaderFrm.Show();
var file = Path.Combine(_therapist.SqlbackupFolder, $"pisioHelp_{DateTime.Today.ToString("yyyyMMdd")}.sql");
DbManagement.PostgreSqlDump(file);
DriveManagement.DeleteInFolder("Database_Backup", DataModels.Enums.FileType.sql, 7);
DriveManagement.InsertFile(file, new List <string> {
"Database_Backup"
}, DataModels.Enums.FileType.sql);
}
