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;
}
