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); }