public ActionResult Create()
{
EmployeeListDTO employee = new EmployeeListDTO();
ManagerDAL objManagerDAL = new ManagerDAL();
employee.Managers = objManagerDAL.Get().Select(x => new Manager
{
ManagerId = x._id.ToString(),
ManagerName = x.ManagerName
}).ToList();
return(View(employee));
}
public ActionResult Edit(string id)
{
EmployeeDAL objDal = new EmployeeDAL();
EmployeeListDTO employee = objDal.GetById(id);
ManagerDAL objManagerDAL = new ManagerDAL();
employee.Managers = objManagerDAL.Get().Select(x => new Manager
{
ManagerId = x._id.ToString(),
ManagerName = x.ManagerName
}).ToList();
return(View(employee));
}
public void Insert(EmployeeListDTO _Obj)
{
try
{
server.Connect();
MongoCollection <EmployeeListDTO> Collection_ = Database_.GetCollection <EmployeeListDTO>("employee");
Collection_.Insert(_Obj);
}
catch
{
throw;
}
finally
{
server.Disconnect();
}
}
public ActionResult Edit(EmployeeListDTO obj)
{
EmployeeDAL objDal = new EmployeeDAL();
ManagerDAL objManagerDAL = new ManagerDAL();
obj.Manager = objManagerDAL.Get().
Where(x => x._id.ToString() == obj.ManagerId).
Select(x => new Manager
{
ManagerId = x._id.ToString(),
ManagerName = x.ManagerName
}).First();
objDal.UpdateById(obj);
return(RedirectToAction("Detail", new { id = obj._id.ToString() }));
}
public ActionResult Create(EmployeeListDTO obj)
{
ManagerDAL objManagerDAL = new ManagerDAL();
obj.Manager = objManagerDAL.Get().
Where(x => x._id.ToString() == obj.ManagerId).
Select(x => new Manager
{
ManagerId = x._id.ToString(),
ManagerName = x.ManagerName
}).First();
EmployeeDAL objDal = new EmployeeDAL();
objDal.Insert(obj);
return(RedirectToAction("Get"));
}
public void UpdateById(EmployeeListDTO obj)
{
try
{
server.Connect();
MongoCollection <EmployeeListDTO> Collection_ = Database_.GetCollection <EmployeeListDTO>("employee");
var query_id = Query.EQ("_id", ObjectId.Parse(obj._id.ToString()));
Collection_.Save <EmployeeListDTO>(obj);
}
catch
{
throw;
}
finally
{
server.Disconnect();
}
}
public EmployeeListDTO GetById(string id)
{
EmployeeListDTO employee = new EmployeeListDTO();
try
{
server.Connect();
MongoCollection <EmployeeListDTO> Collection_ = Database_.GetCollection <EmployeeListDTO>("employee");
var query_id = Query.EQ("_id", ObjectId.Parse(id));
employee = Collection_.FindOne(query_id);
}
catch
{
throw;
}
finally
{
server.Disconnect();
}
return(employee);
}
