TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
secerka secerovic
NA
12
11.8k
Drop down lis and search in MVC # database first
Aug 2 2011 10:38 AM
I'm begginer and This my First Large MVC3 App using Entity Framework Model.
This is a image of the .EDMX Model that I am using
I create Candidate and Skill Controler,strongli tipe view for edit, detail, and delete.
public class CandidateController : Controller
{
private Models.CandidatEntities data;
public CandidateController()
{
data = new CandidatEntities();
}
public ActionResult Index()
{
var candidates = data.Candidate.ToList();
return View(candidates);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Candidate candidate)
{
if (!ModelState.IsValid)
{
return View(candidate);
}
data.Candidate.AddObject(candidate);
data.SaveChanges();
return RedirectToAction("Index");
}
public ActionResult Details(int id)
{
var candidate = data.Candidate.Where(c => c.CandidateID == id).First();
return View(candidate);
}
public ActionResult Edit(int id)
{
var candidate = data.Candidate.Where(c => c.CandidateID == id).First();
return View(candidate);
}
[HttpPost]
public ActionResult Edit(Candidate candidate)
{
var candidateToEdit = data.Candidate.Where(c => c.CandidateID == candidate.CandidateID).First();
candidateToEdit.FirstName = candidate.FirstName;
candidateToEdit.LastName = candidate.LastName;
candidateToEdit.Email = candidate.Email;
data.SaveChanges();
return RedirectToAction("Index");
}
public ActionResult Delete(int id)
{
var candidate = data.Candidate.Where(c => c.CandidateID == id).First();
return View(candidate);
}
[HttpPost]
public ActionResult Delete(Candidate candidate)
{
var candidateToDelete = data.Candidate.Where(c => c.CandidateID == candidate.CandidateID).First();
data.DeleteObject(candidateToDelete.FirstName);
data.DeleteObject(candidateToDelete.LastName);
data.DeleteObject(candidateToDelete.Email);
data.SaveChanges();
return RedirectToAction("Index");
}
For this method I have problem:
Sequence contains no elements
I need to add drop down list for skill and add a text box for entering a skillLevel and a button search wich return list of candidate for selected Skill and skillLevel.
I really do appriciate for any help.
Reply
Answers (
0
)
Create Power Point Control in C# .net
asp: Bound Field