public GetEmployeeById_ResultSet GetEmployeeById(GetEmployeeById_Input input)
{
var db = new StoredProcContext();
var employeeById = db.GeEmployeeById.CallStoredProc(input).ToList <GetEmployeeById_ResultSet>().FirstOrDefault();
return(employeeById);
}
public GetDepartment_ResultSet GetDepartmentById(GetDepartmentById_Input input)
{
var db = new StoredProcContext();
var projectById = db.GetDepartmentById.CallStoredProc(input).ToList <GetDepartment_ResultSet>().FirstOrDefault();
return(projectById);
}
public List <GetEmployee_ResultSet> GetEmployee()
{
var db = new StoredProcContext();
List <GetEmployee_ResultSet> employeeslist = db.GetEmployee.CallStoredProc().ToList <GetEmployee_ResultSet>();
return(employeeslist);
}
public List <GetDepartment_ResultSet> GetDepartment()
{
var db = new StoredProcContext();
List <GetDepartment_ResultSet> departmentslist = db.GetDepartment.CallStoredProc().ToList <GetDepartment_ResultSet>();
return(departmentslist);
}
public GetUser_ResultSet GetUserById(GetUser_Input input)
{
var db = new StoredProcContext();
var user = db.GetUserById.CallStoredProc(input).ToList <GetUser_ResultSet>().FirstOrDefault();
return(user);
}
public List <GetUser_ResultSet> GetAllUsers()
{
var db = new StoredProcContext();
List <GetUser_ResultSet> users = db.GetAllUser.CallStoredProc().ToList <GetUser_ResultSet>();
return(users);
}
public List <GetRole_ResultSet> GetAllRoles()
{
var db = new StoredProcContext();
List <GetRole_ResultSet> roles = db.GetAllRoles.CallStoredProc().ToList <GetRole_ResultSet>();
return(roles);
}
public List <GetRoleAssignedToUser_ResultSet> GetRolesAssginedToUser(GetUser_Input input)
{
var db = new StoredProcContext();
List <GetRoleAssignedToUser_ResultSet> assignedRoles = db.GetRolesAssignedToUser.CallStoredProc(input).ToList <GetRoleAssignedToUser_ResultSet>();
return(assignedRoles);
}
public ActionResult UpdateUser(User model)
{
StoredProcContext db = new StoredProcContext();
User inputparams = new User
{
Id = model.Id,
UserName = model.UserName,
FirstName = model.FirstName,
LastName = model.LastName,
Email = model.Email
};
db.GetUpdateAspNetUserProc.CallStoredProc(inputparams);
//new UserRoleDal().GetUpdateUser(model);
return(RedirectToAction("Index", model));
}
public void UpdateUserRole(int userId, string roleId)
{
var db = new StoredProcContext();
try
{
UpdateUserRole_Input inputParams = new UpdateUserRole_Input()
{
MsgText = "",
MsgType = "",
UserId = userId,
RolesCSV = roleId
};
db.updateUserRole.CallStoredProc(inputParams);
var msg = inputParams.MsgText;
}
catch (Exception ex)
{
var msg = ex.InnerException.Message;
}
}
public void UpdateEmployee(Employee_Input employeeInput)
{
var db = new StoredProcContext();
db.EmployeeUpdate.CallStoredProc(employeeInput);
}
public void UpdateDepartment(Department_Input departmentInput)
{
var db = new StoredProcContext();
db.DepartmentUpdate.CallStoredProc(departmentInput);
}
public void DeleteEmployee(EmployeeDelete_Input input)
{
var db = new StoredProcContext();
db.EmployeeDelete.CallStoredProc(input);
}
public void DeleteDepartment(DepartmentDelete_Input input)
{
var db = new StoredProcContext();
db.DepartmentDelete.CallStoredProc(input);
}
// added by ram
public void CreateUser(User_Input input)
{
var db = new StoredProcContext();
db.UserCreate.CallStoredProc(input);
}
public void DeleteUser(GetUserDelete_Input input)
{
var db = new StoredProcContext();
db.UserDelete.CallStoredProc(input);
}
public void UpdateUser(User_Update input)
{
var db = new StoredProcContext();
db.UserUpdate.CallStoredProc(input);
}
