public ActionListViewModel GetAllActionData() { ActionFilerModel filterModel = new ActionFilerModel(); filterModel.LoggedInUserID = 1; return(_actionRepository.GetAllActionData(filterModel, base.UserId, base.OrganizationId)); }
public ActionListViewModel GetAllActionData(ActionFilerModel filterModel, int LoggedInUserId, int LoggedInOrganizationId) { DbDataReader reader = null; ActionListViewModel model = new ActionListViewModel(); try { RepositoryContext.Database.Initialize(force: false); var cmd = RepositoryContext.Database.Connection.CreateCommand(); cmd.CommandText = "SP_GetEventActionList"; cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter parm1 = new SqlParameter(); parm1.ParameterName = "@LoggedInUserId"; parm1.Value = LoggedInUserId; parm1.SqlDbType = SqlDbType.Int; SqlParameter parm2 = new SqlParameter(); parm2.ParameterName = "@OrganizationId"; parm2.Value = LoggedInOrganizationId; parm2.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(parm1); cmd.Parameters.Add(parm2); if (RepositoryContext.Database.Connection.State == ConnectionState.Closed) { RepositoryContext.Database.Connection.Open(); } reader = cmd.ExecuteReader(); model.ActionListing = (from n in ((IObjectContextAdapter)RepositoryContext) .ObjectContext.Translate <ActionList>(reader) select n).ToList(); } finally { if (reader != null) { if (!reader.IsClosed) { reader.Close(); } } if (RepositoryContext.Database.Connection.State == ConnectionState.Open) { RepositoryContext.Database.Connection.Close(); RepositoryContext.Database.Connection.Dispose(); } } return(model); }