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