public ActionResult Add(detail post)
{
if (ModelState.IsValid)
{
using (SLKDatabaseEntities db = new SLKDatabaseEntities())
{
db.details.Add(new detail
{
FirstName = post.FirstName,
MiddleName = post.MiddleName,
LastName = post.LastName,
PhoneNumber = post.PhoneNumber,
Gender = post.Gender,
DateOfBirth = post.DateOfBirth,
EmailID = post.EmailID,
Address = post.Address,
City = post.City,
ZipCode = post.ZipCode,
State = post.State,
Country = post.Country,
Department = post.Department,
TenthBoard = post.TenthBoard,
TenthMarks = post.TenthMarks,
TwelfthBoard = post.TwelfthBoard,
TwelfthMarks = post.TwelfthMarks,
});
db.SaveChanges();
}
ModelState.Clear();
}
return(View());
}
//update
//[HttpPut]
public IHttpActionResult PutAnEmployee(DataViewModel s)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid data"));
}
using (var ctx = new SLKDatabaseEntities())
{
var existingStudent = ctx.registrations.Where(m => m.SlNo == s.SlNo).FirstOrDefault <registration>();
if (existingStudent != null)
{
existingStudent.UserName = s.UserName;
existingStudent.EmailId = s.EmailId;
existingStudent.Password = s.Password;
existingStudent.ConfirmPassword = s.ConfirmPassword;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public ActionResult Edit(int UserId)
{
detail Post = new detail();
using (SLKDatabaseEntities db = new SLKDatabaseEntities())
{
Post = db.details.Where(r => r.UserId == UserId).FirstOrDefault();
}
return(View(Post));
}
public ActionResult Delete(detail Post)
{
if (ModelState.IsValid)
{
using (SLKDatabaseEntities db = new SLKDatabaseEntities())
{
db.Entry(Post).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(RedirectToAction("Home", "Home"));
}
}
return(View(Post));
}
public IHttpActionResult GetAllStudents(bool includeDetail = false)
{
IList <DataViewModel> students = null;
using (var ctx = new SLKDatabaseEntities())
{
students = ctx.registrations
.Select(s => new DataViewModel()
{
SlNo = s.SlNo,
UserName = s.UserName,
EmailId = s.EmailId,
Password = s.Password,
ConfirmPassword = s.ConfirmPassword,
//Detail = s.details == null || includeDetail == false ? null : new DetailViewModel()
//{
// UserId = s.details.UserId,
// FirstName = s.details.FirstName,
// MiddleName = s.details.MiddleName,
// LastName = s.details.LastName,
// PhoneNumber = s.details.PhoneNumber,
// Gender = s.details.Gender,
// DateOfBirth = s.details.DateOfBirth,
// EmailID = s.details.EmailID,
// Address = s.details.Address,
// City = s.details.City,
// ZipCode = s.details.ZipCode,
// State = s.details.State,
// Country = s.details.Country,
// Department = s.details.Department,
// TenthBoard = s.details.TenthBoard,
// TenthMarks = s.details.TenthMarks,
// TwelfthBoard = s.details.TwelfthBoard,
// TwelfthMarks = s.details.TwelfthMarks,
//}
}).ToList <DataViewModel>();
}
if (students.Count == 0)
{
return(NotFound());
}
return(Ok(students));
}
public IHttpActionResult DeleteEmployee(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid student id"));
}
using (var ctx = new SLKDatabaseEntities())
{
var student = ctx.registrations
.Where(s => s.SlNo == id)
.FirstOrDefault();
ctx.Entry(student).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewEmployee(DataViewModel s)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new SLKDatabaseEntities())
{
ctx.registrations.Add(new registration()
{
UserName = s.UserName,
EmailId = s.EmailId,
Password = s.Password,
ConfirmPassword = s.ConfirmPassword
});
ctx.SaveChanges();
}
return(Ok());
}
//[AcceptVerbs("POST")]
public IHttpActionResult Post1(DataViewModel student)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new SLKDatabaseEntities())
{
ctx.registrations.Add(new registration()
{
SlNo = student.SlNo,
UserName = student.UserName,
EmailId = student.EmailId,
Password = student.Password,
ConfirmPassword = student.ConfirmPassword,
});
ctx.SaveChanges();
}
return(Ok());
}
public ActionResult Home()
{
detail model = new detail();
using (SLKDatabaseEntities db = new SLKDatabaseEntities())
{
var data = db.details.ToList();
List <detail> jobpos = new List <detail>();
foreach (var item in data)
{
detail obj = new detail();
obj.UserId = item.UserId;
obj.FirstName = item.FirstName;
obj.MiddleName = item.MiddleName;
obj.LastName = item.LastName;
obj.PhoneNumber = item.PhoneNumber;
obj.Gender = item.Gender;
obj.DateOfBirth = item.DateOfBirth;
obj.EmailID = item.EmailID;
obj.Address = item.Address;
obj.City = item.City;
obj.ZipCode = item.ZipCode;
obj.State = item.State;
obj.Country = item.Country;
obj.Department = item.Department;
obj.TenthBoard = item.TenthBoard;
obj.TenthMarks = item.TenthMarks;
obj.TwelfthBoard = item.TwelfthBoard;
obj.TwelfthMarks = item.TwelfthMarks;
jobpos.Add(obj);
}
ViewBag.list = jobpos;
}
return(View());
}
public IHttpActionResult GetAllEmployees()
{
IList <DataViewModel> students = null;
using (var ctx = new SLKDatabaseEntities())
{
students = ctx.registrations
.Select(s => new DataViewModel()
{
SlNo = s.SlNo,
UserName = s.UserName,
EmailId = s.EmailId,
Password = s.Password,
ConfirmPassword = s.ConfirmPassword
}).ToList <DataViewModel>();
}
if (students.Count == 0)
{
return(NotFound());
}
return(Ok(students));
}
