public ActionResult Edit(int Id)
{
DdContextDataContext _db = new DdContextDataContext();
var edit = _db.UserInfos.Where(x => x.ID == Id).FirstOrDefault();
return(View(edit));
}
public ActionResult Save(model model)
{
if (ModelState.IsValid)
{
DdContextDataContext _db = new DdContextDataContext();
UserInfo obj = _db.UserInfos.Where(x => x.ID == model.ID).FirstOrDefault();
if (obj != null)
{
obj.Name = model.Name;
obj.ActiveUser = model.ActiveUser;
obj.Phone = model.Phone;
obj.Address = model.Address;
obj.Email = model.Email;
obj.CreateDate = DateTime.Now;
_db.SubmitChanges();
ViewBag.msg = "System Msg: Save Changes";
}
else
{
obj = new UserInfo();
obj.Name = model.Name;
obj.ActiveUser = model.ActiveUser;
obj.Phone = model.Phone;
obj.Address = model.Address;
obj.Email = model.Email;
obj.CreateDate = DateTime.Now;
_db.UserInfos.InsertOnSubmit(obj);
_db.SubmitChanges();
ViewBag.msg = "System Msg: Saved";
}
}
return(View("Ind"));
}
public ActionResult Delete(int Id)
{
DdContextDataContext _db = new DdContextDataContext();
var delete = _db.UserInfos.Where(x => x.ID == Id).SingleOrDefault();
_db.UserInfos.DeleteOnSubmit(delete);
_db.SubmitChanges();
// List();
return(View("Ind"));
}
public ActionResult List(int?page)
{
int pageSize = 3;
int pageIndex = 1;
pageIndex = page.HasValue ? Convert.ToInt32(page) : 1;
DdContextDataContext _db = new DdContextDataContext();
return(View(_db.UserInfos.ToList().ToPagedList(page ?? 1, 2)));
}
public ActionResult AddEmploye(employeeModel employee)
{
if (ModelState.IsValid)
{
DdContextDataContext _db = new DdContextDataContext();
Employee obj = new Employee();
obj.EmployeeName = employee.EmployeeName;
obj.EmailAddress = employee.EmailAddress;
obj.EmployeeCode = employee.EmployeeId + "1000";
obj.Username = employee.Username;
obj.Password = employee.Password;
obj.QuestionID = employee.QuestionID;
obj.Answer = employee.Answer;
obj.CreateDate = DateTime.Now;
obj.LastUpdatedBy = employee.EmployeeName;
obj.IsActive = employee.IsActive;
_db.Employees.InsertOnSubmit(obj);
_db.SubmitChanges();
ViewBag.msg = "System Msg: Saved";
}
QuestionDropDownlistLoad();
return(View("Employee"));
}
private void QuestionDropDownlistLoad()
{
DdContextDataContext _db = new DdContextDataContext();
ViewBag.Question = new SelectList(_db.Questions, "QuestionID", "QuestionName");
}
