Esempio n. 1
0
        public int InsertUserRole(UserRoles userRoles)
        {
            var parameters = new List <SqlParameter>();

            parameters.Add(baseRepo.CreateParameter("@RoleDescription", 20, userRoles.RoleDescription, DbType.String));
            parameters.Add(baseRepo.CreateParameter("@RoleNumber", userRoles.RoleNumber, DbType.Int32));
            parameters.Add(baseRepo.CreateParameter("@CreatedDate", userRoles.CreatedDate, DbType.Date));
            parameters.Add(baseRepo.CreateParameter("@ModifiedDate", userRoles.ModifiedDate, DbType.Date));
            parameters.Add(baseRepo.CreateParameter("@RoleIsActive", userRoles.RoleIsActive, DbType.Boolean));
            baseRepo.Insert("[dbo].[InsertUserRoles]", CommandType.StoredProcedure, parameters.ToArray(), out int lastid);
            return(lastid);
        }