public bool Update(Student student, out string msg)
{
msg = "Not Saved";
var saved = false;
try
{
db = new NitisDBDataContext();
Student std = db.Students.SingleOrDefault(i => i.StudentID == student.StudentID);
std.Name = student.Name;
std.Email = student.Email;
std.Class = student.Class;
std.EnrollYear = student.EnrollYear;
std.City = student.City;
std.Country = student.Country;
db.SubmitChanges();
msg = "Updated";
saved = false;
}
catch (Exception ex)
{
saved = true;
throw ex;
}
return(saved);
}
public bool Create(tblApplicant applicant, out string msg)
{
msg = "Not Saved";
var hasError = false;
try
{
db.tblApplicants.InsertOnSubmit(applicant);
db.SubmitChanges();
msg = "Saved";
}
catch (Exception ex)
{
hasError = true;
}
return(hasError);
}
public bool Save(MVCDemoNew.Entity.Student student, out string msg)
{
msg = "Not Saved";
var saved = false;
try
{
db.Students.InsertOnSubmit(student);
db.SubmitChanges();
msg = "Saved";
saved = false;
}
catch (Exception ex)
{
saved = true;
throw ex;
}
return(saved);
}
public bool Update(tblApplicant applicant, out string msg)
{
msg = "Not Saved";
var hasError = false;
try
{
db = new NitisDBDataContext();
tblApplicant objApplicant = db.tblApplicants.SingleOrDefault(i => i.ID == applicant.ID);
objApplicant.Name = applicant.Name;
objApplicant.Email = applicant.Email;
objApplicant.City = applicant.City;
objApplicant.Phone = applicant.Phone;
db.SubmitChanges();
msg = "Updated";
}
catch (Exception ex)
{
hasError = true;
throw ex;
}
return(hasError);
}
