public static void deleteRecord(int id) { try { using (JsonDatEntities context = new JsonDatEntities()) { var obj = context.Students.FirstOrDefault(r => r.Id == id); context.Students.Remove(obj); context.SaveChanges(); } } catch { } }
public static string bindRecordToEdit(int id) { string data = string.Empty; try { using (JsonDatEntities context = new JsonDatEntities()) { var obj = context.Students.FirstOrDefault(r => r.Id == id); JavaScriptSerializer serializer = new JavaScriptSerializer(); data = serializer.Serialize(obj); } return(data); } catch { return(data); } }
public static string getData() { string data = string.Empty; try { using (JsonDatEntities context = new JsonDatEntities()) { var obj = (from r in context.Students select r).ToList(); JavaScriptSerializer serializer = new JavaScriptSerializer(); data = serializer.Serialize(obj); } return(data); } catch { return(data); } }
public static int updateData(string name, string email, string age, int id) { try { int status = 0; using (JsonDatEntities context = new JsonDatEntities()) { Student obj = context.Students.FirstOrDefault(r => r.Id == id); obj.Name = name; obj.Email = email; obj.Age = age; context.SaveChanges(); status = obj.Id; } return(status); } catch { return(-1); } }
public static int saveData(string name, string email, string age) { try { int status = 0; using (JsonDatEntities context = new JsonDatEntities()) { Student obj = new Student(); obj.Name = name; obj.Email = email; obj.Age = age; context.Students.Add(obj); context.SaveChanges(); status = obj.Id; } return(status); } catch { return(-1); } }