public void GetSaveCoords(int id, string lat, string lng) { double pLat = 0; double pLng = 0; string strLat = StringHelper.FixDecimalSeparator(lat); string strLng = StringHelper.FixDecimalSeparator(lng); if (!double.TryParse(strLat, out pLat)) { return; } if (!double.TryParse(strLng, out pLng)) { return; } using (var context = new BusProjectEntities()) { var st = context.tblStudents.FirstOrDefault(z => z.pk == id); if (st != null) { st.Lat = pLat; st.Lng = pLng; try { context.SaveChanges(); } catch (DbEntityValidationException e) { Console.WriteLine(e); } } } }
public static void SetSettingValue(string ns, string key, string value) { using (var context = new BusProjectEntities()) { var entity = context.tblSystems.FirstOrDefault( z => z.strNamespace.ToLower() == ns.ToLower() && z.strKey.ToLower() == key.ToLower()); if (entity != null) { entity.strValue = value; entity.LastModify = DateTime.UtcNow; if (AccountManager.LoginInfo != null) { entity.ModifedBy = AccountManager.LoginInfo.UserId; } } else { entity = new tblSystem() { strNamespace = ns, strKey = key, strValue = value, LastModify = DateTime.UtcNow }; if (AccountManager.LoginInfo != null) { entity.ModifedBy = AccountManager.LoginInfo.UserId; } context.tblSystems.Add(entity); } context.SaveChanges(); } }
public static void create(tblAlertsQueue c) { try { BusProjectEntities db = new BusProjectEntities(); c.id = 9999; db.SaveChanges(); } catch { } }