private async Task <List <Settings> > InitializeSettingsAsync() { using (var dbFactory = new SQLiteDAL()) { var settings = new List <Settings> { new Settings { TitleLabel = "Wireless Network (SSID)", HelpLabel = "Enter your Wireless Network or SSID", Value = string.Empty, SettingsFieldType = FieldType.Text }, new Settings { TitleLabel = "Wireless Network Password", HelpLabel = "Password for your Wireless Network", Value = string.Empty, SettingsFieldType = FieldType.Password } }; await dbFactory.Settings.AddRangeAsync(settings); await dbFactory.SaveChangesAsync(); return(settings); } }
public async void InitializePlatform() { using (var db = new SQLiteDAL()) { await db.Database.MigrateAsync(); } }
public async Task <List <SensorNodes> > GetSensorNodes() { using (var db = new SQLiteDAL()) { return(await db.SensorNodes.Where(a => a.Active).ToListAsync()); } }
protected T getData <T>() { using (var db = new SQLiteDAL()) { var data = db.Dashboard.FirstOrDefault(a => a.DashboardName == GetName()); if (data == null) { return(default(T)); } return((T)JsonConvert.DeserializeObject(data.JSON)); } }
public async void AddSensorNode(string location) { using (var db = new SQLiteDAL()) { var item = new SensorNodes { Location = location }; await db.SensorNodes.AddAsync(item); await db.SaveChangesAsync(); } }
public override int XuLyTuWSSangCSDL( object obj,DataTable tb,SQLiteDAL DAL) { int result = 0; DM_CSKCB dm = (DM_CSKCB)obj; clsDM_CSKCB kcb = new clsDM_CSKCB(dm); string str = String.Format("MACSKCB = '" + kcb.MaCSKCB + "'"); if (tb!=null&&tb.Select(str).Length > 0) { result = kcb.Update(DAL); } else { result = kcb.Insert(DAL); } return result; }
public override int XuLyTuWSSangCSDL(object obj, DataTable tb, SQLiteDAL DAL) { int result = 0; DM_MauVaChePhamCSKCB dm = (DM_MauVaChePhamCSKCB)obj; clsDM_Mau kcb = null;// new clsDM_Mau(dm); //kcb.Delete(); string str = String.Format("MaMauVaChePhamMau = '" + kcb.MaMauVaChePhamMau + "'"); if (tb != null && tb.Select(str).Length > 0) { result = kcb.Update(DAL); } else { result = kcb.Insert(DAL); } return result; }
public async Task <List <SettingsListingResponseItem> > LoadSettingsAsync() { using (var dbFactory = new SQLiteDAL()) { var result = await dbFactory.Settings.ToListAsync(); if (!result.Any() || result.Count != SETTINGS_COUNT) { result = await InitializeSettingsAsync(); } return(result.Select(a => new SettingsListingResponseItem { Description = a.HelpLabel, Label = a.TitleLabel, SettingValue = a.Value, ID = a.ID }).ToList()); } }
public async Task <bool> SaveSettingsAsync(List <SettingsListingResponseItem> settings) { using (var dbFactory = new SQLiteDAL()) { foreach (var setting in settings) { var dbItem = dbFactory.Settings.FirstOrDefault(a => a.ID == setting.ID); if (dbItem == null) { continue; } dbItem.Value = setting.SettingValue; } await dbFactory.SaveChangesAsync(); return(true); } }
private void InsertDanhMucOnline() { //btnLamMoi.Enabled = false; //btnThem.Enabled = false; //btnXoa.Enabled = false; //btnLamMoi.Enabled = false; //btnGetDM.Enabled = false; //btnSua.Enabled = false; string service = ConfigurationManager.AppSettings["WebService"]; string param = "GetAccessToken/abc/123"; string URL = service + "/" + param; string response = HttpRequest.WSRequest(URL, "GET", string.Empty); string token = XMLUtils.DeSerializeToObject<string>(response); if (!string.IsNullOrEmpty(token)) { string URL1 = service + "/" +clsGetMa.GetTenThamSoWS(); string response1 = HttpRequest.WSRequest(URL1, "GET", string.Empty, token); //string str = XMLUtils.DeSerializeToObject<string>(response); List<object> lstDMThuoc = clsGetMa.LayDanhSachFromWS(response1);// XMLUtils.DeSerializeToList<DM_CSKCB>(response1); int tongRecord = lstDMThuoc.Count; // "Có " + tongRecord + " danh mục thuốc. Bạn có muốn tải về?" if (MessageBox.Show(clsGetMa .ShowMessageGetDuLieu(tongRecord), "Thông báo", MessageBoxButtons.YesNo) == DialogResult.No) { return; } SQLiteDAL DAL = new SQLiteDAL(); DAL.BeginTransaction(); foreach (object t in lstDMThuoc) { int result= clsGetMa.XuLyTuWSSangCSDL(t,dtDM,DAL); if (result == 0) { DAL.RollbackTransaction(); return; } } // Close & Commit Trans DAL.CommitTransaction(); LoadGridview(); //btnLamMoi.Enabled = true; //btnThem.Enabled = true; //btnXoa.Enabled = true; //btnLamMoi.Enabled = true; //btnGetDM.Enabled = true; //btnSua.Enabled = true; } else { // "Access token is empty."; } }
public virtual int XuLyTuWSSangCSDL(object obj, DataTable tb, SQLiteDAL DAL) { return 0; }