private void MessageView_Load(object sender, EventArgs e) { using (var db = new ICMServer.Models.ICMDBContext()) { /** * Query modify item **/ var query = from zz in db.Publishinfoes where zz.id == m_MsgId select zz; foreach (var Msg in query) { textBox.Visible = false; pictureBox.Visible = true; textBoxTitle.Text = Msg.title; textBoxTime.Text = Msg.time.ToString(); if (Msg.type == 1) { textBoxType.Text = "Image"; } else { textBoxType.Text = "Text"; } textBoxAddress.Text = DevicesAddressConverter.RoToChStr(Msg.dstaddr); string picPath = Path.GetAppExeFolderPath() + @"\" + Msg.filepath; pictureBox.Image = new Bitmap(picPath); } } }
public static bool DatabaseExists() { using (var db = new ICMDBContext()) { return(db.Database.Exists()); } }
public static Device GetDeviceByAddress(string DeviceAddress) { using (var db = new ICMDBContext()) { var result = (from Device in db.Devices where Device.roomid == DeviceAddress select Device).FirstOrDefault(); return(result); } }
public static user GetUserByName(string name) { using (var db = new ICMDBContext()) { var result = (from user in db.Users where user.C_username == name select user).FirstOrDefault(); return(result); } }
private void BtnOK_Click(object sender, EventArgs e) { using (var db = new ICMServer.Models.ICMDBContext()) { holderinfo ResidentIndfo = new holderinfo(); ResidentIndfo.C_name = textBoxName.Text; ResidentIndfo.C_roomid = textBoxRoomID.Text; ResidentIndfo.C_sex = ComboBoxSex.SelectedIndex; ResidentIndfo.C_isholder = ComboBoxIsResident.SelectedIndex; ResidentIndfo.C_phoneno = textBoxPhone.Text; //ResidentIndfo.birth = dateTimePickerBirth.Value; //ResidentIndfo.PID = textBoxPID.Text; db.Holderinfoes.Add(ResidentIndfo); db.SaveChanges(); } this.Close(); }
public static void AddDevices(AddrList addrList, IProgress <int> progress = null) { Stopwatch stopwatch = Stopwatch.StartNew(); using (var db = new ICMDBContext()) { db.Database.ExecuteSqlCommand("DELETE FROM Device"); db.Database.ExecuteSqlCommand("ALTER TABLE Device AUTO_INCREMENT = 1"); int processCount = 0; int reportedProgressPercentage = -1; foreach (var d in addrList.dev) { Device dev = new Device { ip = d.ip, roomid = d.ro, Alias = (d.IsaliasNull()) ? null : d.alias, group = (d.IsgroupNull()) ? null : d.group, mac = (d.IsmcNull()) ? null : d.mc, type = d.ty, sm = d.sm, gw = d.gw, cameraid = (d.IsidNull()) ? null : d.id, camerapw = (d.IspwNull()) ? null : d.pw }; db.Devices.Add(dev); processCount++; if (progress != null) { int currentProgressPercentage = (processCount * 99 / addrList.dev.Count); if (reportedProgressPercentage != currentProgressPercentage) { reportedProgressPercentage = currentProgressPercentage; progress.Report(reportedProgressPercentage); } } } db.SaveChanges(); if (progress != null) { progress.Report(100); } } stopwatch.Stop(); //DebugLog.TraceMessage(string.Format("done: {0}", stopwatch.Elapsed)); }